Senior Oracle APEX Architect

Description:

• 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;

Requirements:

• 5-8 years of hands-on experience in Oracle APEX development
• Bachelor or Master's degree
• 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

Benefits: