Lead Oracle Engineer

About the role

The Lead Oracle Engineer plays a pivotal role in the firm's Oracle Cloud ecosystem, focusing on the design, development, and maintenance of advanced Oracle APEX applications and integrations.

Responsibilities

• Design, develop, and maintain advanced Oracle APEX applications supporting Finance, Accounting, Procurement, and operational business processes.
• Maintain and enhance ETL and data pipelines processes that support APEX applications, reporting, data synchronization, and downstream business processes.
• Review existing custom applications and data flows to identify opportunities for simplification, performance improvement, automation, and automation.
• Lead the design and development of integrations between Oracle Fusion Cloud ERP and internal or external systems using Oracle Integration Cloud.
• Create, maintain, and optimize SQL and PL/SQL packages, procedures, functions, views, triggers, and data validation logic, applying performance tuning practices.
• Partner with business users and cross-functional teams to gather requirements, perform fit-gap analysis, and translate business needs into scalable, well-documented Oracle Cloud solutions.
• Support end-to-end testing, including unit testing, system integration testing, UAT, and regression testing.
• Support Oracle quarterly updates by reviewing release notes, assessing potential impact, testing integrations, validating custom applications, validating critical business processes, and resolving post-upgrade issues.
• Provide technical guidance to developers and consultants on Oracle APEX, OIC, Oracle Fusion integration, and development best practices.
• Explore AI-enabled tools, Oracle Process Automation, and emerging Oracle Cloud capabilities to identify and implement automation opportunities.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance Technology, or a related field, or equivalent professional experience.
• 8+ years of hands-on experience with Oracle technologies, including Oracle Cloud ERP, Oracle APEX, ODI, OIC, SQL, and PL/SQL.
• 8+ years of experience designing and developing Oracle APEX applications in an enterprise environment.
• 5+ years of experience with Oracle Integration Cloud, including ERP adapters, REST/SOAP APIs, scheduled integrations, file-based integrations, and error handling.
• Strong experience supporting Oracle Fusion Cloud ERP, preferably within Financials, Procurement, Expenses, or related finance applications.
• Advanced SQL and PL/SQL development experience, including performance tuning, complex queries, stored procedures, packages, functions, and data validation logic.
• Strong understanding of Oracle Fusion integration methods including FBDI, ADFDI, ESS jobs, BI Publisher, OTBI, REST APIs, SOAP services, and business events.
• Experience with JSON, XML, XSLT, web services, API authentication, SFTP, and secure data transmission practices.

Qualifications

• Strong communication skills with the ability to work directly with business stakeholders, IT teams, vendors, and senior leadership.
• Builds strong, collaborative working relationships across Finance, Accounting, IT, and vendor teams, bringing a dependable and solution-focused approach to every engagement.
• Takes full ownership of complex technical problems, following through with clear root cause analysis and sustainable long-term remediation rather than quick fixes.
• Adapts readily to shifting priorities, Oracle quarterly updates, and evolving business requirements without losing focus or momentum.
• Demonstrates a continuous improvement mindset—actively seeking opportunities to simplify, automate, and elevate the Oracle ecosystem over time.