What are the responsibilities and job description for the In Person Interview Must- Oracle Apex Developer position at American Unit, Inc?
Our Client 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.
Only one Round of Interview (In person Interview is a must for this position at the client location Raleigh, NC at your own Expense.)
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).