Job
Description
For an international project in Washington, we are urgently looking for a Senior Oracle APEX Developer to lead the design, development, and optimization of complex Oracle APEX applications in a fast-paced enterprise environment. Candidates need to have at least 8 years of hands-on experience in Oracle APEX development. We are looking for a contractor, who is able to work 2 hours US (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 end-to-end development lifecycle, from gathering requirements to deployment and maintenance. 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 degree; +8 years of hands-on experience in Oracle APEX development; 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 JETCharts; 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; Fluent in English; Preferred Qualifications: Experience with APEX Plugin Development for extended functionality; 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); Show more Show less
