Oracle APEX Developer

Intone Networks
Rossville, GA, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

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

Tech stack

JavaScript (Programming Language) Agile Methodology Artificial Intelligence HTML5 Automation of Tests Big Data Cascading Style Sheets (CSS) Static Program Analysis Code Generation Data as a Services Relational Databases Software Debugging
+30 more
JasperReports JSON Operational Databases Oracle (Applications) Oracle Forms Performance Tuning Scrum Methodology Azure Active Directory Oracle Apex Single Sign-On Software Deployment Software Engineering PL-SQL SQL Databases Systems Integration Apex Code Software Modules GitHub Copilot Claude Code Database Optimization Software Security AI Coding Agents Git Information Technology Playwright Virtual Agents Restful APIs OpenAI Codex Code Restructuring Api Management

Job description

  • The organization is modernizing its homegrown Oracle Forms-based ERP platform into a modern Oracle APEX application. The platform supports the Flat Rolled business across more than 55 locations throughout the United States and Mexico.
  • The modernization involves migrating existing Oracle Forms modules to Oracle APEX through a phased, wave-based approach over approximately 18 months. An external implementation partner will handle the initial conversion, while the internal development team will review, validate, enhance, support and ultimately own the converted applications.
  • The ideal candidate will have strong hands-on Oracle APEX, SQL and PL/SQL development experience, along with expertise in performance tuning, integrations, application security and production support. Experience with AI-assisted development tools is highly desirable., 1. Oracle APEX Development
  • Design, develop and maintain complex Oracle APEX applications supporting core ERP business processes.
  • Develop new modules, enhance existing applications and modernize legacy functionality.
  • Work with Oracle APEX 22.x or newer and leverage appropriate APEX capabilities.
  • Develop and optimize SQL queries, PL/SQL packages, procedures, functions, views and materialized views.
  • Perform database performance tuning in environments containing tables with up to 30 million records.
  • Design data models and relational database structures for new and redesigned modules.
  • Implement application authentication and authorization, including Single Sign-On (SSO) using Microsoft Entra ID.
  • Develop REST API integrations using ORDS, REST Data Sources and APEX_WEB_SERVICE.
  1. AI-Assisted Development * Use approved AI coding tools such as Claude Code, OpenAI Codex, GitHub Copilot or similar platforms to write, refactor, test and document SQL, PL/SQL, APEX and JavaScript code. * Leverage AI tools for API integrations, performance tuning, legacy code analysis and automated testing. * Review and validate AI-generated code submitted by other developers. * Contribute to business glossaries, coding standards, technical documentation and reusable development guidelines. * Develop automated tests using utPLSQL, Playwright and API testing frameworks. * Explain and justify all code changes during technical reviews, regardless of whether AI tools were used. * Follow responsible AI development practices, including using approved tools and never sharing credentials or production data in AI prompts.

  2. ERP Support, Maintenance & Enhancements * Resolve production break-fix issues across Oracle APEX, PL/SQL, ORDS, APEX Office Print and Jasper Reports. * Design and develop major enhancements to existing ERP modules and reports. * Build new modules and functionality based on business requirements. * Act as a senior escalation point for production incidents. * Perform root cause analysis and implement permanent solutions. * Gather requirements directly from business users and translate them into technical solutions. * Manage changes through Development, User Acceptance Testing (UAT) and Production environments. * Follow established change management and release procedures. * Work within Agile delivery methodologies, including Scrum and Kanban.

  3. Oracle Forms to APEX Modernization * Review Oracle Forms modules converted to Oracle APEX by the external implementation partner. * Validate converted functionality, identify defects and resolve technical gaps. * Ensure converted applications meet business requirements, performance standards and development guidelines. * Support phased application releases and stabilize modules following production deployment. * Collaborate with development teams in the United States and Mexico. * Share technical knowledge and provide guidance to other developers.

Requirements

  • Bachelor’s degree in Computer Science, Information Technology, Software Engineering or equivalent experience.
  • 5+ years of overall Oracle development experience.
  • Minimum 4+ years of hands-on Oracle APEX development experience in production environments.
  • Strong experience with Oracle APEX 22.x or newer.
  • Excellent SQL and PL/SQL programming skills.
  • Ability to independently write, debug and optimize complex SQL and PL/SQL code without AI assistance.
  • Experience with database performance tuning involving large datasets and tables containing up to 30 million records.
  • Strong understanding of data modeling and relational database design.
  • Experience implementing APEX authentication, authorization and Single Sign-On (SSO).
  • Hands-on experience with Microsoft Entra ID integration.
  • Experience with Oracle REST Data Services (ORDS), REST APIs and JSON.
  • Knowledge of HTML5, CSS3 and JavaScript.
  • Experience supporting production Oracle applications, break-fix issues and enhancements.
  • Experience working in Agile/Scrum or Kanban environments.
  • Familiarity with, or willingness to learn, modern Oracle development workflows involving APEXlang, VS Code, SQLcl and Git.
  • Strong written and verbal English communication skills.

Apply for this position

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

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…