APEX Developer/Programmer- Expert

DatamanUSA has an exciting opportunity for a talented APEX Developer/Programmer-Expert to work with one of our direct Clients North Carolina Department of Public Instruction (NCDPI), to work in Raleigh, NC (Onsite) We love referrals! Please refer us to your friends, family and colleagues for this opportunity. DatamanUSA gives referral bonuses if they get selected and perform well for our clients.

Job Details:

Job ID: 775546

Title: APEX Developer/Programmer- Expert

Client: North Carolina Department of Public Instruction (NCDPI)

Duration: 6+ Months (with high possibility of extension)

Location: Raleigh, NC

Agency Interview Type: In Person Only

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


Complete Description:

*) 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 maintain ability, 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

Qualifications

*) 6+ 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.


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

Skill Required/Desired/Amount of Experience:

*) Enterprise Oracle APEX development experience required 6Years

*) Expert proficiency in SQL and PL/SQL with a focus on secure, performant coding. Required 6Years

*) Deep knowledge of Oracle Database (12c/19c or higher) Required 6Years

*) Experience with advanced APEX components (Interactive Grids, REST-enabled SQL, dynamic actions, plug-ins, responsive design, JavaScript integration) Required 6Years

*) Strong expertise in integrating APEX with RESTful services, JSON, AJAX, and JavaScript Required 6Years

*) Strong knowledge of application security frameworks, encryption, and compliance best practices Required 6Years

*) Proven experience with SSO integrations, specifically Entra ID (Azure Active Directory) Required 6Years

*) High experience with GitHub, GitOps, and DevOps-driven automation Required 6Years

*) Excellent client-facing communication skills to support iterative development with stakeholders Required