Senior Oracle APEX Architect - Full Remote - Contractor in USD
Summary
Senior Oracle APEX Architect designing and leading enterprise-level Oracle APEX applications, including architecture, SQL/PL/SQL development, integrations, and mentorship. Core stack: Oracle APEX, Oracle SQL/PL/SQL, JavaScript/jQuery/AJAX, REST/SOAP APIs, ORDS, Git/CI/CD, Oracle Cloud/AWS/Azure.
For an international project in Washington, we are urgently looking for a Senior Oracle APEX Architect. The role of Oracle APEX Architect involves the design, development, and implementation of applications using Oracle's Application Express framework. The candidate will be responsible for developing architectural strategies and guiding the development team through complex projects to ensure quality and efficiency in the delivery of APEX-based solutions. Candidates need to have at least 5-8 years of hands-on experience in Oracle APEX development.
We are looking for a contractor who can work in Washington time.
This position is long-term. Candidates need to be fluent in English.
Tasks and responsibilities:
- Architect, develop, and enhance complex, enterprise-level Oracle APEX applications;
- Lead the development of scalable and efficient Oracle APEX applications;
- Design and implement robust application architecture aligned with business requirements;
- Provide technical leadership and mentorship to development teams;
- Lead the end-to-end development lifecycle, from gathering requirements to deployment and maintenance;
- Ensure adherence to best practices, coding standards, and continuous improvement processes;
- Manage the full application lifecycle from design to deployment and support;
- Write high-performance SQL & PL/SQL code, including stored procedures, triggers, and packages;
- Implement advanced APEX Dynamic Actions, Interactive Reports, and Universal Theme customizations;
- Develop and integrate RESTful APIs, SOAP services, and third-party web services within APEX applications;
- Provide technical advice and guide team to ensure APEX security best practices, including authentication, authorization, session management, and data protection;
- Optimize application performance by improving queries, indexing strategies, and UI responsiveness;
- Collaborate with business stakeholders, architects, and DevOps teams to define and implement scalable solutions;
- Lead code reviews, mentoring junior developers, and defining APEX best practices;
- Work with CI/CD pipelines, version control (Git), and deployment automation tools for efficient software delivery;
- Maintain detailed documentation on system architecture, technical specifications, and troubleshooting procedures;
Profile:
- Bachelor or Master's degree;
- +5/+8 years of hands-on experience in Oracle APEX solution architecture design;
- Proven expertise in Oracle APEX development and architecture;
- Expert-level proficiency in Oracle SQL and PL/SQL, including query tuning and optimization;
- Strong knowledge of APEX Dynamic Actions, Page Processes, Custom Themes, and Oracle JET Charts;
- In-depth experience of Oracle APEX Shared Components, including workflows, automations, security protocols, authentication/authorization schemes, and role-based access control;
- Proficiency in JavaScript, jQuery, AJAX, and CSS for advanced UI/UX customizations;
- Experience with APEX security models, authentication (OAuth, LDAP, SSO), and data encryption;
- Proven ability to integrate RESTful web services, JSON, XML, and ORDS with APEX applications;
- Deep understanding of Oracle database architecture, indexing strategies, and performance tuning;
- Experience with Git, CI/CD pipelines, DevOps tools, and cloud deployments (Oracle Cloud, AWS, or Azure);
- Strong analytical and problem-solving skills with the ability to troubleshoot complex applications;
- Excellent communication skills and ability to collaborate with cross-functional teams;
Preferred Qualifications:
- Experience with APEX Plugin Development for extended functionality;
- Prior experience leading a development team;
- Knowledge of Oracle Forms and Reports migration to APEX;
- Experience with Progressive Web Apps (PWAs) and modern front-end frameworks (React, Angular);
- Hands-on experience deploying APEX applications on Oracle Cloud Infrastructure (OCI);
- Strong problem-solving skills and analytical mindset;
- Excellent communication and interpersonal skills;