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 to design, develop, and deploy secure, modular, and responsive applications while ensuring database integrity, performance, scalability, and security.
Requirements
- 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).
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).
- 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.
- Implement and maintain SSO authentication/authorization with Entra ID (Azure Active Directory) and OCID.
Other
- Collaborate directly with business analysts and clients in iterative, client-facing solution design sessions.
- 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.
- Excellent client-facing communication skills to support iterative development with stakeholders.
