Oracle APEX Developer
*This is an onsite position
*We are not considering Corp-to-Corp (C2C) arrangements for this position
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.
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.
Preferred Skills/Knowledge/Experience:
- 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.
Required Skills/Knowledge/Experience:
- 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
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!
#AC