Oracle EBS PL/SQL Developer

Job Summary

The Business Systems Analyst – ERP & MES is responsible for supporting, enhancing, and maintaining the Oracle E-Business Suite (EBS), Manufacturing Execution Systems (MES) , and Oracle APEX applications. This role acts as a liaison between IT, business functions and operations to ensure efficient business processes and system functionality across manufacturing, supply chain, quality and finance.

Essential Functions

• Provide functional and technical support for Oracle EBS modules (Manufacturing, SCM, Finance).
• Collaborate with business users to gather requirements and design solutions in ERP and MES systems.
• Create, develop, and maintain applications using Oracle APEX in support of ERP, Labelling and MES extensions.
• Cookyware with vendors and internal teams for MES system enhancements and support.
• Create functional specifications and support system configuration and testing.
• Conduct root cause analysis for production issues and implement permanent solutions.
• Ensure Data integrity and Regulatory compliance in ERP, MES, and APEX-based applications.

Additional Responsibilities

• Collaborate with cross-functional teams to ensure alignment between business systems and operational needs.
• Provide/Facilitate user training and create system documentation.
• Support compliance with IT policies, procedures, and regulatory requirements.
• Aid with software upgrades, patching, and testing activities.
• Participate in IT projects and system implementations.
• Troubleshoot and resolve escalated issues in a timely manner.
• Perform other duties as assigned.

Job Specifications

• Bachelor’s degree in computer science, Information Systems, Business, or a related field (or equivalent experience)
• At least 7 to 10 years of experience supporting and configuring Oracle E-Business Suite (EBS) and Manufacturing Execution Systems (MES)
• Strong development background with hands-on experience in Oracle SQL/PL-SQL, T-SQL, JavaScript, REST APIs, and HTML for enterprise solutions
• Strong understanding of business processes in manufacturing, supply chain, finance, and operations
• Hands-on experience with ERP workflows, data integrity, testing, and support
• Familiarity with change control, system documentation, and user acceptance testing (UAT)
• Strong analytical and problem-solving skills with attention to detail
• Experience working in cross-functional teams and communicating with business and technical stakeholders
• Familiarity with regulatory and compliance standards such as 21 CFR Part 11, ISO 27001, and NIST
• Desirable Certifications such as Oracle Certified Professional (OCP), Six Sigma, or PMP
• Experience with: MES platforms and integration with ERP systems, Report writing and BI tools (e.g., APEX, Power BI, Oracle BI), ITSM tools and processes, and Change management, Working in a validated environment with CSV principles, Application lifecycle and low-code development, Basic CRM knowledge, SugarCRM preferably, Seagull Scientific Bartender Suite, Microsoft Visual FoxPro with Web Connection (Legacy Application platform).
• Ability to work cross-functionally with application, infrastructure, and support teams

Physical Requirements

• Must be able to lift 50 lbs, bend, and climb stairs as needed.
• Ability to travel Internationally to company sites as required.