APEX Developer/Programmer- Expert

Title: APEX Developer/Programmer- Expert

Location: Raleigh, NC (Onsite)

Duration: 6 Months

Interview Type: In Person Only

NCDPI is looking for two highly experienced Senior Oracle APEX Developer with 6 years of hands-on experience in Oracle Application Express (APEX) and Oracle Database development.

Overview

• We are looking for a highly experienced Senior Oracle APEX Developer with 6 years of hands-on experience in Oracle Application Express (APEX) and Oracle Database development.
• The successful candidate will be responsible for the design, development, and deployment of secure, modular, and responsive applications while ensuring database integrity, performance, scalability, and security.
• This role requires expert-level hands-on PL/SQL and APEX development, a security-first build philosophy, and proven experience implementing Single Sign-On (SSO) with Entra ID (Azure Active Directory) and OCID.
• Experience in guiding development standards, knowledge transfer, modular/reusable design practices, and high experience with GitHub/GitOps-driven workflows is a must.

Key Responsibilities

• Lead the design, development, and deployment of Oracle APEX applications with a security-first mindset.
• Develop complex and efficient PL/SQL procedures, functions, packages, and triggers to support business logic.
• Design and optimize database objects (tables, views, indexes, materialized views, constraints).
• Collaborate directly with business analysts and clients in iterative, client-facing solution design sessions.
• Drive performance tuning, SQL/PLSQL optimization, and security hardening.
• Integrate APEX applications with external systems using REST APIs, JSON/XML, and secure data exchange methods.
• Utilize and establish standards for modularity, reusability, and maintainability; support code reviews and documentation.
• Contribute to OCI (ExaCC) migration efforts as needed and support upgrades, patches, and new feature adoption.
• Serve as escalation point for complex production issues, with focus on authentication and security.
• Support GitHub-based workflows and GitOps practices to improve automation, code management, and secure deployments.
• Promote knowledge transfer within the team as technical subject matter expert and through collaboration.
• Implement and maintain SSO authentication/authorization with Entra ID (Azure Active Directory) and OCID.

Qualifications

• 6 years of enterprise Oracle APEX development experience.
• Expert proficiency in SQL and PL/SQL with focus on secure, performant coding.
• Deep knowledge of Oracle Database (12c/19c or higher).
• Extensive experience with advanced APEX components (Interactive Grids, REST-enabled SQL, dynamic actions, plug-ins, responsive design, JavaScript integration).
• Strong expertise integrating APEX with RESTful services, JSON, AJAX, and JavaScript.
• Strong knowledge of application security frameworks, encryption, and compliance best practices.
• Proven experience with SSO integrations, specifically Entra ID (Azure Active Directory).
• High experience with GitHub, GitOps, and DevOps-driven automation.
• Excellent client-facing communication skills to support iterative development with stakeholders.

Preferred Skills

• Experience with Oracle Cloud Infrastructure (OCI), particularly ExaCC.
• Hands-on expertise with GitHub, GitOps, and CI/CD pipelines for enterprise application delivery.
• Proven track record of performance tuning for enterprise APEX applications.
• Experience developing or extending custom APEX plug-ins; knowledge of Oracle BI Publisher or Oracle Analytics Cloud.
• Familiarity with compliance frameworks (CIPA, FERPA, HIPAA, etc).