Oracle APEX Developer

Saxon Global • Dallas, TX

5h

About The Position

This role focuses on designing, developing, enhancing, and supporting enterprise-grade Oracle APEX applications. The developer will build interactive reports, forms, dashboards, workflows, and custom business applications. Responsibilities include developing responsive user interfaces using APEX Universal Theme, JavaScript, HTML, and CSS, as well as advanced APEX functionality with dynamic actions, interactive grids, plug-ins, APIs, and RESTful services. The role also involves developing and maintaining SQL and PL/SQL, integrating APEX applications with Oracle Fusion, OIC, databases, and third-party systems, troubleshooting application and database issues, performing SQL/PLSQL performance tuning, and managing APEX workspaces, deployments, upgrades, and environment promotions. Support for modernization initiatives, including Oracle Redwood adoption, is also a key aspect. Additionally, the role involves supporting development and integrations related to Oracle Fusion Order Management (OM), translating Order Management and Order-to-Cash requirements into APEX and integration solutions, and supporting sales order, orchestration, fulfillment, order status, holds, and exception processes. Troubleshooting issues across APEX, OIC, Fusion OM, and downstream systems, as well as supporting OM orchestration processes, enhancements, and modernization initiatives, are crucial. Collaboration with functional and technical teams to deliver business-aligned solutions is expected. The role also includes designing, developing, and supporting integrations using Oracle Integration Cloud (OIC), building various types of integrations (REST, SOAP, scheduled, file-based, event-driven), and working with various adapters (REST, SOAP, FTP/SFTP, Database, Kafka). Implementing error handling, logging, monitoring, and retry strategies, and supporting OIC environment configuration, deployments, security certificates, and the transition from OIC Gen 2 to Gen 3 are also part of the responsibilities.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field, or equivalent experience.
• 10+ years of overall IT/software development experience.
• 7+ years of hands-on Oracle APEX development experience.
• Strong SQL and PL/SQL development experience.
• Strong experience with JavaScript, HTML, CSS, and APEX Universal Theme.
• Experience building and consuming REST APIs and web services.
• Experience integrating APEX with Oracle Fusion and/or other enterprise systems.
• 3+ years of Oracle Integration Cloud (OIC) experience.
• Hands-on experience with Oracle Cloud/Fusion applications.
• Proven ability to work as a hands-on senior developer across the application, database, integration, and Fusion layers.

Nice To Haves

• Oracle Fusion Order Management (OM) experience.
• Experience with Order-to-Cash, order orchestration, fulfillment, and exception management.
• Experience integrating APEX with Fusion OM.
• Experience troubleshooting Fusion OM orders and orchestration issues.
• Experience with Oracle Fusion REST/SOAP APIs.
• Oracle Redwood experience.
• Experience supporting large-scale Oracle Cloud implementations.
• Experience with Kafka or other event-driven integration technologies.

Responsibilities

• Design, develop, enhance, and support enterprise-grade Oracle APEX applications.
• Build interactive reports, forms, dashboards, workflows, and custom business applications.
• Develop responsive user interfaces using APEX Universal Theme, JavaScript, HTML, and CSS.
• Develop advanced APEX functionality using dynamic actions, interactive grids, plug-ins, APIs, and RESTful services.
• Develop and maintain SQL and PL/SQL, including packages, procedures, functions, triggers, views, and optimized queries.
• Integrate APEX applications with Oracle Fusion, OIC, databases, and third-party systems using REST and SOAP APIs.
• Troubleshoot application and database issues and perform SQL/PLSQL performance tuning.
• Manage APEX workspaces, deployments, upgrades, and environment promotions.
• Support modernization initiatives, including Oracle Redwood adoption.
• Support development and integrations related to Oracle Fusion Order Management (OM).
• Translate Order Management and Order-to-Cash requirements into APEX and integration solutions.
• Support sales order, orchestration, fulfillment, order status, holds, and exception processes.
• Troubleshoot issues across APEX, OIC, Fusion OM, and downstream systems.
• Support OM orchestration processes, enhancements, and modernization initiatives.
• Work with functional and technical teams to deliver solutions aligned with business requirements.
• Design, develop, and support integrations using Oracle Integration Cloud (OIC).
• Build REST, SOAP, scheduled, file-based, and event-driven integrations.
• Work with REST, SOAP, FTP/SFTP, Database, and Kafka adapters.
• Develop integrations between APEX, Oracle Fusion/OM, and third-party systems.
• Implement error handling, logging, monitoring, and retry strategies.
• Support OIC environment configuration, deployments, security certificates, and the transition from OIC Gen 2 to Gen 3.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior