Oracle EBS PL/SQL Developer at Adhesives Research Inc.

Glen Rock, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

20 Aug, 26

Salary

0.0

Posted On

22 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle EBS, PL/SQL, Oracle APEX, MES, SQL, T-SQL, JavaScript, REST APIs, HTML, ERP Workflows, Business Analysis, Functional Specifications, UAT, Root Cause Analysis, Data Integrity, Regulatory Compliance

Industry

Chemical Manufacturing

Description

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. * Design, develop, and maintain applications using Oracle APEX in support of ERP, Labelling and MES extensions. * Coordinate 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. * Assist 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 * Experience in gathering and translating business requirements into functional specifications * 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.

Responsibilities

The role is responsible for supporting, enhancing, and maintaining Oracle EBS, MES, and Oracle APEX applications. It acts as a liaison between IT and business functions to optimize processes across manufacturing, supply chain, quality, and finance.