Senior Oracle APEX / EBS Technical Consultant

Work set-up: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Minimum of 5 years experience in Oracle APEX development (version 21 or higher)., Extensive experience with AJAX, PL/SQL, and Oracle E-Business Suite (EBS) 12.2+., Strong knowledge of cloud integration technologies such as AWS, Azure, Oracle Integration Cloud, or Boomi., Experience with enterprise application systems, middleware, and database security..

Key responsibilities:

  • Design, develop, and implement modernized safety management solutions.
  • Integrate ESMS with Oracle EBS and support authentication configurations.
  • Participate in architecture design, database migration, and support post-go-live activities.
  • Collaborate with cross-functional teams and create technical documentation.

Numentica LLC logo
Numentica LLC SME https://www.numentica.com/
201 - 500 Employees
See all jobs

Job description



Project: Enterprise Safety Management System (ESMS) – Modernization & Migration
Location: Remote with occasional onsite presence in Los Angeles, CA
Work Hours: PST business hours (Part time 20 hours per week OR Full time 40 hours per week either is fine)




Job Summary:

We are seeking a highly skilled and experienced Oracle APEX / EBS Technical Consultant to support the design, development, migration, and implementation of new Enterprise Safety Management System (ESMS). This role is ideal for a seasoned consultant with a strong background in Oracle technologies, cloud environments (AWS or Azure), enterprise application integration, and safety management systems.



Key Responsibilities:
  • Analyze, design, develop, and implement modernized solutions replacing legacy Safety Management Systems (VAMS, TransitSafe, and SAFE7).

  • Develop custom applications using Oracle APEX v21+ with PL/SQL and AJAX to support case management, approval workflows, notifications, and dashboards.

  • Integrate ESMS with Oracle E-Business Suite (EBS) 12.2+ including workflows and WebADI modules.

  • Configure and support authentication using EBS user authentication and Single Sign-On (SSO).

  • Participate in architecture design, database migration to Oracle Exadata Cloud@Customer, and implement enterprise modules like Document Management, Audit Trail, and BI dashboards.

  • Collaborate with cross-functional teams including Metro’s Corporate Safety, ITS, and Project Management teams.

  • Create technical documentation, training materials, and support user adoption.

  • Provide post-go-live support and participate in critical on-site phases as required.



Minimum Qualifications:

Each consultant must individually meet the following qualifications:

  • 5+ years of experience in Oracle APEX development (version 21 or higher)

  • 5+ years of experience with AJAX for interactive UI components

  • 5+ years of experience with PL/SQL development

  • 5+ years of experience with Oracle E-Business Suite (EBS) 12.2+, including:

    • Oracle Workflows

    • WebADI (Web Applications Desktop Integrator)

    • EBS user authentication configuration

  • Experience in cloud-based integration technologies such as Oracle Integration Cloud, Boomi, AWS, or Azure

  • Strong knowledge of database security, backup/restore, disaster recovery, and replication

  • Experience in enterprise application systems and middleware technologies

  • Hands-on development experience with React, WebLogic, Oracle Forms and Reports

  • Familiarity with SQLNet and communication protocols across networks



Preferred Skills:
  • Experience with:

    • Oracle Exadata (on-prem and Exadata Cloud@Customer)

    • Microsoft SQL Server 2016+

    • Azure/AWS cloud platforms

  • Strong understanding of enterprise safety or case management systems

  • Prior experience with:

    • Role-based access control (RBAC)

    • Case lifecycle management

    • Dynamic form creation and workflow-driven processes

  • Excellent communication skills, stakeholder management, and documentation skills



Other Requirements:
  • Must be authorized to work in the U.S.

  • Willingness to work remotely and be present onsite at LA Metro offices during:

    • Go-live and production cutover phases

    • Major system releases or deployments



How to Apply:

Please submit your resume along with a brief summary highlighting your relevant experience with Oracle APEX, Oracle EBS, and cloud integration technologies. Include project examples related to enterprise system modernization, safety or case management systems, and data migration to Exadata/Azure/AWS environments.



Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Communication

Consultant Related jobs