Oracle EBS PL/SQL Developer

Adhesives Research
Glen Rock, PA, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

HTML JavaScript (Programming Language) Application Lifecycle Management Computing Platforms Business Systems Software Documentation Information Systems System Configuration Data Integrity FoxPro Oracle (Applications) Oracle SQL Developer
+10 more
Power BI Oracle Apex PL-SQL SugarCRM Transact-SQL Apex Code Bi Publisher Information Technology Oracle Ebusiness Restful APIs

Job description

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., * At least 7 to 10 years of experience supporting and configuring Oracle E-Business Suite (EBS) and Manufacturing Execution Systems (MES)

Requirements

Do you have experience in Software documentation?, Do you have a Bachelor’s degree?, * Bachelor’s degree in computer science, Information Systems, Business, or a related field (or equivalent experience), * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:21 min

Projecting external HTML content using default and named slots

Rowdy Rabouw Rowdy Rabouw · WWC 2022

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

6:12 min

Streaming HTML content natively using declarative processing instructions

Chris Heilmann +2 · LIVE

4:21 min

Upcoming features and major Oracle enhancement projects

Michael Inden · LIVE

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

5:22 min

How the tokenizer and tree builder parse HTML

Niels Leenheer · LIVE

Videos

See all

Related articles

See all