Sign upLog in

Oracle EBS PL/SQL Developer

Adhesives Research Inc

Glen Rock, PA

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Analysis Skills, Apex Programming Language, Application Programming Interface (API), Bartending, Business Intelligence, Business Intelligence Software, Business Operations, Business Processes, Business Solutions, Change Control, Change Management, Code of Federal Regulations, Computer Science, Cross-Functional, Customer Relationship Management (CRM), Customer/Client Research, Data Quality, Detail Oriented, Document Management, Documentation, ERP (Enterprise Resource Planning), Finance, Financial Operations, HTML (HyperText Markup Language), ISO (International Organization for Standardization), IT Service Management (ITSM), Identify Issues, Information Technology & Information Systems, JavaScript, Lift/Move 50 Pounds, Manufacturing, Manufacturing Execution Systems (MES), Manufacturing Systems, Microsoft Transact-SQL (T-SQL), Operations Management, Oracle, Oracle Applications, Oracle Certifications, Oracle Database, Oracle ERP, Oracle PL-SQL, Power BI, Problem Solving Skills, Process Management, Process Manufacturing, Project Management Professional (PMP), REST (Representational State Transfer), Regulatory Compliance, Regulatory Requirements, Reporting Skills, Requirements Management, Root Cause Analysis, Six Sigma, Software Administration, Software Development, Software Development Lifecycle (SDLC), Software Patches, Software Upgrades, Supply Chain, System Operations, System Test, Systems Administration/Management, Systems Analysis, Technical Support, Time Management, Travel Industry, U.S. National Institute of Standards and Technology (NIST), Willing to Travel
LOCATION
Glen Rock, PA
POSTED
28 days ago

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.

About the Company

A

Adhesives Research Inc