Columbus Technologies and Services

Oracle SW Engineer II (Onsite)

Columbus Technologies and Services • $108K — $130K *
Pasadena, CA 91104In-Person
Aerospace & Defense
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5-7 years of experience with Oracle eBS R12.13.x, specifically in Common Inventory implementations.
  • Deep functional and technical expertise in Oracle Demand Management (ODM) and Master Resource Planning (MRP).
  • Proven ability to enhance complex business processes and align them with Oracle EBS standards.
  • Expertise in inventory setup, profile options, and system parameters to ensure optimal performance.
  • Solid grasp of the ODM lifecycle, including components like BOM, Inventory, WIP, MRP, Purchasing, and Costing.
  • Strong analytical skills coupled with problem-solving capabilities.

Responsibilities

  • Collaborate with stakeholders to gather new business requirements and review existing ones.
  • Conduct fit-gap analysis and present viable options to stakeholders.
  • Map current and future state business workflows for clarity and optimization.
  • Recommend updates to Oracle configurations to improve business processes.
  • Support the implementation of new features and system changes according to functional designs.
  • Troubleshoot and resolve application issues effectively.

Benefits

  • Flexible working hours and potential for remote work.
  • Opportunity to develop and refine advanced Oracle technical skills.
  • Involvement in high-impact projects with visible outcomes.
  • Professional growth into roles with increased responsibility.
Full Job Description
JOB DESCRIPTION
  • 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.

REQUIRED SKILLS
  • 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 Columbus Technologies and Services

Columbus Technologies and Services is an information technology and professional services company that provides staffing, consulting, and project management services to government and commercial clients. The company was founded in 2007 and is headquartered in Garden Grove, California. Columbus Technologies and Services has been recognized as one of the fastest-growing private companies in the United States by Inc. Magazine.
Learn more about Columbus Technologies and Services
Size
200 employees
Industry
Information Technology
Founded
2001
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Columbus Technologies and Services

More Aerospace & Defense Jobs

Find similar Oracle SW Engineer II (Onsite) jobs:

NationwidePasadena, CA