Senior Oracle APEX Developer

The Senior Oracle APEX Developer is responsible for leading the design, development, and deployment of scalable, enterprise-grade web applications using Oracle Application Express (APEX). Working closely with IT leadership, this role requires deep expertise in both front-end and back-end technologies, including Oracle PL/SQL, JavaScript, RESTful APIs, and cloud-based solutions. The Senior APEX Developer will lead complex development projects, optimize performance, ensure security compliance, and drive innovation in APEX applications. This role also involves mentoring junior developers, defining best practices, and collaborating with IT leadership and cross-functional teams to align development strategies with business objectives and ensure technology initiatives support organizational growth.

PRINCIPAL DUTIES AND RESPONSIBILITIES

• Lead the design and development of complex Oracle APEX applications, ensuring scalability and performance.
• Oversee the migration of legacy systems to Oracle APEX, optimizing database structures and business logic.
• Architect enterprise-grade solutions for on-premise, Oracle Cloud (OCI), and third-party platforms.
• Optimize SQL and PL/SQL performance through indexing, query tuning, and partitioning strategies.
• Implement robust authentication, authorization, and data security frameworks for APEX applications.
• Design and develop advanced interactive dashboards, reports, and business intelligence tools using APEX components.
• Manage APEX workspace configurations, application version control, and automated deployment strategies.
• Develop and maintain RESTful and SOAP APIs for seamless system integration.
• Establish best practices for UI/UX in APEX applications, leveraging Oracle JET, JavaScript, and CSS frameworks.
• Conduct performance testing, debugging, and SQL analysis using tools like Explain Plan, SQL Trace, and APEX Debugging.
• Implement and maintain CI/CD pipelines, version control, and automated deployment processes.
• Lead Agile development practices, including code reviews and continuous improvement processes.
• Provide mentorship and technical leadership to junior and mid-level developers.
• Collaborate with database administrators, security teams, and cloud architects on application deployment and maintenance.
• Stay updated with the latest APEX features and Oracle Cloud advancements, driving innovation in application development.

EDUCATION SKILLS AND EXPERIENCE

• Bachelor’s degree in Information Technology, Information Systems, or related field (or equivalent extensive experience).
• 7 years of hands-on experience in Oracle APEX development (version 24 preferred) with enterprise-scale project delivery.
• Advanced expertise in Oracle PL/SQL, stored procedures, triggers, and query optimization.
• Strong proficiency in JavaScript, jQuery, HTML5, CSS3, and Oracle JET for modern UI/UX design.
• Deep understanding of Oracle Database 19c/23c, including advanced indexing, partitioning, and performance tuning.
• Proven experience in developing and integrating RESTful and SOAP web services.
• Extensive experience in developing and managing Oracle APEX applications in on-premise environments. Experience with Oracle Cloud Infrastructure (OCI) and APEX on Autonomous Database is a plus.
• Ability to analyze complex business requirements and translate them into scalable APEX solutions.
• Excellent leadership, problem-solving, and communication skills for bridging technical and business teams.