Oracle Software Engineer II

APR Consulting, Inc; Pasadena (CA); On-site; USD 55,000 - 99,000; Full time

Benefits offered by this job

PTO

Holidays

401k

Medical

Dental

Vision benefits

Job summary

APR Consulting, Inc. seeks an Oracle Software Engineer II in Pasadena, CA to design and implement Oracle EBS ODM/MRP solutions. You will analyze business requirements, map As-Is processes, and configure Oracle to align with approved designs.

The role emphasizes data workflows, performance tuning, and integration work with APIs. The position requires 4+ years of experience, U.S. citizenship or permanent residency, and a 12+ month contract with first-shift scheduling.

Qualifications

• Two or more Common Inventory implementations in ODM/Oracle EBS.
• Deep ODM/MRP functional and technical expertise.
• Ability to map As-Is to Oracle EBS standard functionality.
• Expert ODM/MRP knowledge including Inventory setup, profile options, and system parameters.
• Understanding of ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, and Costing.
• Strong understanding of upstream and downstream integration points.
• Familiarity with REST APIs.

Responsibilities

• Collaborate with the Lead ESA to review existing business requirements and gather new requirements from stakeholders.
• Conduct fit-gap analyses and present options.
• Map current-state and future-state business workflows.
• Recommend Oracle configuration updates to optimize business processes.
• Support ESA in implementing new features and/or system changes aligned with approved functional designs.
• Troubleshoot application issues through resolution.
• Log and manage Oracle Service Requests.
• Create and update functional design documents, technical design documents, and process flows.

Skills

Oracle SQL

PL/SQL

Form Personalization

custom.pll

BI Publisher

ODM/MRP

Rest APIs

Analytical thinking

MS Office

Tools

JIRA

GitHub

Job description

An Oracle Software Engineer IIposition just opened up in Pasadena, CA at the JPL/NASA facility. In this role you will support the Production Planning and Control Implementation (PPCI) project. This role will focus on functional design, business process alignment, and Common Inventory implementation within the Oracle Discrete Manufacturing suite of applications. Must have a minimum of 4+ years of experience. Must be a US Citizenship or Permanent Resident.

Location: Pasadena, CA 91109

Position: Oracle Software Engineer II

Compensation: $40.50/hour – $72.71/hour DOE

Duration: 12 months or longer

Schedule: 1st Shift 9/80

We do offer PTO, holidays, 401k, medical, dental, and vision benefits.

Responsibilities:

• Collaborate with the Lead ESA to review existing business requirements and gather new requirements from stakeholders
• Conduct fit-gap analyses and present options
• Map current-state and future-state business workflows
• Recommend Oracle configuration updates to optimize business processes
• Support ESA in implementing new features and/or system changes aligned with approved functional designs
• Troubleshoot application issues through resolution
• Log and manage Oracle Service Requests
• Create and update functional design documents, technical design documents, and process flows associated with configurations or approved customizations
• Develop scalable Oracle SQL/PLSQL code including procedures, functions, packages, and triggers
• Update existing code to meet evolving requirements
• Tune and optimize queries for performance
• Build or retrofit interfaces, APIs, and data loaders
• Support custom extensions including Form Personalization and custom.pll
• Diagnose system bottlenecks, debug functional and technical issues, and apply fixes
• Support testing and user training activities
• Perform additional duties as directed by project team
• Provide bi-weekly status reports

Requirements:

• Demonstrated experience delivering two or more Common Inventory implementations as part of broader ODM/MRP deployments in Oracle eBS R12.13.x.
• Deep functional and technical expertise in ODM, including Inventory and Oracle Master Scheduling/MRP
• Ability to map, fit, and enhance complex “As-Is” business processes into Oracle EBS standard functionality
• Expert-level knowledge of ODM/MRP including Inventory setup steps, profile options, and system parameters to optimize performance
• Comprehensive understanding of the ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, and Costing
• Strong understanding of upstream and downstream integration points
• Strong technical skills: Oracle SQL, PL/SQL, Form personalization, custom.pll, and BI Publisher reports
• Strong analytical and problem-solving skills
• Familiarity with REST APIs
• Proficient with MS Office

Desired Skills:

• Experience with JIRA and GitHub
• Knowledge of Purchasing ASL functionality
• Experience with Mobile supply chain

About our client:

Our client is a research and development lab federally funded by NASA and managed by Caltech. Manages many of NASA’s robotic missions exploring Earth, the solar system, and our universe.

This particular client is requiring that all new hires show proof of vaccination. However, accommodations may be made for those with disabilities or religious reasons who cannot obtain a vaccine.

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.