Oracle APEX Technical Lead

Kloeckner Metals Corporation
Alpharetta, GA, United States
2 days ago
Apply on www.jofdav.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours
Languages
English
Job source

Tech stack

JavaScript (Programming Language) Artificial Intelligence HTML5 Automation of Tests Cascading Style Sheets (CSS) Software Code Optimization Code Review Databases Continuous Integration Relational Databases Software Debugging JasperReports
+22 more
JSON Microsoft Office Operational Databases Oracle (Applications) Oracle Forms Performance Tuning Scrum Methodology Azure Active Directory Oracle Apex Software Engineering PL-SQL SQL Databases Apex Code GitHub Copilot Claude Code AI Coding Agents Git Information Technology Playwright Restful APIs Oracle Cloud Infrastructure Code Restructuring

Job description

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., 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.

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 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.jofdav.com
Prepare application

Good distractions

Loading talks and stories from around this role…