Kloeckner logo

Oracle APEX Technical Lead

Hiring from
United States
Work type
Hybrid
Posted

626,053 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

Position Summary

The Oracle APEX Technical Lead will own Oracle APEX standards, design, and development for the Company's ERP modernization initiative as legacy Oracle Forms modules are converted to Oracle APEX. This hands-on role provides APEX technical direction to developers in the United States and Mexico. The role will also lead the team's introduction of AI-assisted development, piloting AI coding tools and setting standards for their safe and effective use. The team also owns ongoing support, maintenance, and development of the Custom ERP, including break-fix, enhancements, and new or redesigned modules and reports.

The ideal candidate is a seasoned, hands-on Oracle APEX and PL/SQL developer who has led code reviews and mentored developers.

This is a hybrid role, working in our Alpharetta Headquarters 3 days a week.

Key Responsibilities

APEX Technical Leadership

  • Define and maintain Oracle APEX development standards, reusable components, theming, and security model, including authentication through SSO with Microsoft Entra ID, and authorization.
  • Provide technical direction, code reviews, and mentoring to APEX developers in the United States and Mexico, including effective and responsible AI use.
  • Plan and prioritize APEX work with the Mexico team in Agile sprints.

AI-Assisted Development (Emerging Practice)

  • Lead the introduction of AI-assisted development: evaluate and pilot tools, then define approved tools, agent instruction files (CLAUDE.md or AGENTS.md), APEXlang skills, and review rules.
  • Define CI quality gates and code review practices for AI-generated changes.
  • Lead adoption of the APEX 26.1 workflow: APEXlang, VS Code with the SQL Developer extension, SQLcl and Git.
  • Measure the impact of AI pilots on cycle time and defect rates, and expand use only where it adds value.
  • Set and enforce safe AI use: approved tools only, and no credentials or production data in prompts.

Hands-On Development (8+ years)

  • Design and develop complex Oracle APEX applications supporting core ERP business processes, leveraging the most appropriate Oracle APEX capabilities and features to meet business and technical requirements.
  • Develop and tune SQL and PL/SQL against tables of up to 30 million records, and build REST integrations using ORDS, REST Data Sources, and APEX_WEB_SERVICE.
  • As the team adopts AI-assisted development, use approved AI coding agents (Claude Code, Codex, GitHub Copilot or similar) to help write, refactor, test, and document SQL, PL/SQL, APEX and JavaScript.

Custom ERP Support, Maintenance & Development

  • Own technical delivery for Custom ERP support, maintenance, and development across APEX, APEX Office Print, Jasper Reports, PL/SQL database logic, and ORDS.
  • Lead technical design for projects and enhancements, including data models, major changes to existing modules and reports, and new modules.
  • Act as final technical escalation for production incidents and lead root cause analysis.
  • Ensure all changes follow the Company's change management process, and balance support and project work across the US and Mexico teams.

Conversion Oversight

  • Use AI to analyze legacy Oracle Forms and PL/SQL, extract business rules, and plan conversion validation.
  • Review and accept modules from the external conversion partner, and capture knowledge from the partner and long-tenured team members.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Software Engineering, or equivalent experience.
  • 8+ years of Oracle development experience, including 5+ years of hands-on Oracle APEX and 2+ years in a technical lead or mentoring role.
  • Expert SQL and PL/SQL skills, including performance tuning on tables of up to 30 million records, and the ability to write, debug, and optimize code without AI tools.
  • Strong data modeling and relational database design skills.
  • Experience implementing APEX authentication and authorization, including SSO with Microsoft Entra ID.
  • Strong experience with ORDS, REST APIs, JSON, HTML5, CSS3, and JavaScript.
  • Experience supporting production Oracle applications, including incident management and root cause analysis.
  • Working knowledge of AI coding agents (Claude Code, Codex, GitHub Copilot or similar), or strong interest in leading their introduction.
  • Experience with Git, CI pipelines, code review, automated testing (utPLSQL, Playwright, or similar), and Agile delivery (Scrum or Kanban).
  • Familiarity with, or willingness to learn, the APEX 26.1 workflow: APEXlang, VS Code with the SQL Developer extension, SQLcl and Git.
  • Excellent written and verbal English communication skills.

Preferred Qualifications

  • Experience with Oracle Forms modernization and with overseeing external vendors.
  • Experience in steel, metals, distribution, manufacturing, or ERP environments.
  • Experience with APEX Office Print, Jasper Reports, OCI, and distributed US and Mexico teams.

Core Competencies

  • Technical leadership and sound judgment.
  • Ownership and accountability for outcomes.
  • Coaching and developing others.

Success Measures

  • APEX and AI engineering standards adopted across the US and Mexico teams.
  • Converted modules accepted against defined quality criteria.
  • AI-assisted practices piloted and adopted where they measurably improve speed and quality.
  • Custom ERP incidents, enhancements, and project changes delivered on time.

Similar jobs

Apply for this job100% free