APEX Developer/Programmer- Expert

Oracle APEX Developer

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 an escalation point for complex production issues, with a 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 a technical subject matter expert and through collaboration.

Implement and maintain SSO authentication/authorization with Entra ID (Azure Active Directory) and OCID.

Six or more years of enterprise Oracle APEX development experience.

Expert proficiency in SQL and PL/SQL with a 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 in 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.

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