Job ID: NC-775546 (98090905)
Onsite/Local Oracle APEX Developer with PL/SQL, RESTful, JSON, AJAX, Azure AD, GitHub/GitOps, OCI, ExaCC, CI/CD, Oracle BI Publisher/Analytics Cloud, CIPA, FERPA, HIPAA experience
Location: Raleigh, NC (NCDPI)
Duration: 7 Months
Position: 1 (2)
***This position is onsite full time in Raleigh, NC. In person interviews will be required.
Skills:
Enterprise Oracle APEX development experience Required 6 Years
Expert proficiency in SQL and PL/SQL with focus on secure, performant coding Required 6 Years
Deep knowledge of Oracle Database (12c/19c or higher). Required 6 Years
Experience with advanced APEX components (Interactive Grids, REST-enabled SQL, dynamic actions, plug-ins, responsive design, JavaScript integration) Required 6 Years
Strong expertise integrating APEX with RESTful services, JSON, AJAX, and JavaScript. Required 6 Years
Strong knowledge of application security frameworks, encryption, and compliance best practices. Required 6 Years
Proven experience with SSO integrations, specifically Entra ID (Azure Active Directory). Required 6 Years
High experience with GitHub, GitOps, and DevOps-driven automation. Required 6 Years
Excellent client-facing communication skills to support iterative development with stakeholders. Required
Description:
NCDPI is looking for two highly experienced Senior Oracle APEX Developers 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).