Oracle Software Engineer II

Location: Onsite in or near Pasadena, California, United States. Must be a US citizen or permanent resident.

Company

M&S Consulting delivers process and technology solutions to enterprise organizations across the United States through specialized consulting teams.

What you will do

• Review business requirements, gather stakeholder needs, and conduct fit-gap analyses with the Lead ESA.
• Map current-state and future-state workflows and recommend Oracle configuration updates.
• Support Oracle EBS feature implementations, system changes, troubleshooting, and Service Request management.
• Create and maintain functional and technical design documents and process flows.
• Develop, update, and optimize Oracle SQL/PLSQL procedures, functions, packages, triggers, interfaces, APIs, and data loaders.
• Support custom extensions, testing, user training, system debugging, and bi-weekly project status reporting.

Requirements

• US citizenship or permanent residency required.
• Experience delivering at least two Common Inventory implementations within ODM/MRP deployments using Oracle EBS R12.13.x.
• Deep functional and technical expertise in ODM, Inventory, and Oracle Master Scheduling/MRP, including setup steps, profile options, and system parameters.
• Understanding of the ODM lifecycle across BOM, Inventory, WIP, MRP, Purchasing, and Costing, including upstream and downstream integrations.
• Strong Oracle SQL, PL/SQL, Form Personalization, custom.pll, BI Publisher, and REST API skills.
• Strong analytical and problem-solving skills, with proficiency in Microsoft Office.

Nice to have

• Experience with JIRA and GitHub.
• Knowledge of Purchasing ASL functionality.
• Experience with mobile supply chain solutions.

Culture & Benefits

• Work focuses on complex enterprise environments and long-term customer success.
• Culture emphasizes approachability, helpfulness, and strong care for clients and employees.
• Equal opportunity employment practices are followed.