Oracle APEX Technical Lead

Kloeckner Metals - Americas•Alpharetta, GA
•Hybrid

About The Position

The Oracle APEX Technical Lead owns 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 technical direction to developers in the United States and Mexico and leads the introduction of AI-assisted development by piloting AI coding tools and establishing standards for safe and effective use. The team also supports, maintains, and develops the Custom ERP, including break-fix work, enhancements, and new or redesigned modules and reports. The role is hybrid, working at the Alpharetta headquarters three days a week. The ideal candidate is a seasoned, hands-on Oracle APEX and PL/SQL developer with experience leading code reviews and mentoring developers. The Technical Lead defines and maintains APEX development standards, reusable components, theming, and security practices; directs and mentors developers; plans work with the Mexico team in Agile sprints; and leads AI-assisted development practices. The role includes complex APEX development, SQL and PL/SQL performance tuning, REST integrations, technical delivery for Custom ERP support and projects, production incident escalation and root cause analysis, and oversight of legacy Oracle Forms conversion and converted-module acceptance.

Requirements

  • 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 experience 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 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 such as Claude Code, Codex, or GitHub Copilot, or strong interest in leading their introduction.
  • Experience with Git, CI pipelines, code review, automated testing such as utPLSQL or Playwright, and Agile delivery using 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.

Nice To Haves

  • Experience with Oracle Forms modernization and 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.

Responsibilities

  • Define and maintain Oracle APEX development standards, reusable components, theming, and security models, including Microsoft Entra ID SSO authentication and authorization.
  • Provide technical direction, conduct code reviews, and mentor APEX developers in the United States and Mexico, including on responsible AI use.
  • Plan and prioritize APEX work with the Mexico team in Agile sprints.
  • Evaluate and pilot AI-assisted development tools; define approved tools, agent instruction files such as 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 using APEXlang, VS Code with the SQL Developer extension, SQLcl, and Git.
  • Measure AI pilot impacts on cycle time and defect rates, and expand use where it adds value.
  • Set and enforce safe AI-use practices, including using approved tools only and excluding credentials and production data from prompts.
  • Design and develop complex Oracle APEX applications for core ERP business processes.
  • 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.
  • Use approved AI coding agents to help write, refactor, test, and document SQL, PL/SQL, APEX, and JavaScript.
  • 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.
  • Serve as the final technical escalation point for production incidents and lead root cause analysis.
  • Ensure changes follow the Company's change management process and balance support and project work across US and Mexico teams.
  • 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service