Job Purpose

The Senior Oracle Developer plays a key role in the Digital Solutions & Oracle Operations department, focusing on implementing, optimizing, and integrating enterprise resource planning (Oracle ERP) systems and digital solutions. This role supports the Digital Solutions & Oracle Operations Manager in executing strategic initiatives and ensuring the efficient functioning of digital systems and processes.

Key Responsibilities

Solutions Analysis

• Identify and evaluate complex solutions against business needs.
• Recommend the most effective approaches based on established criteria.

Data Management

• Work within established data management systems and procedures to deliver expected outcomes.

Customer Management (Internal)

• Support internal customers by ensuring their ERP and digital solution needs are met effectively.

Improvement/Innovation

• Identify process, system, or procedural shortcomings and implement change management programs to address them.

Technical Tasks

Reports Development

• Develop and manage reports using Oracle Reports 10g/11g and BI Publisher.
• Utilize XML and XSL programming for reporting purposes.

Interfaces Development

• Use Oracle Open Interface tables and Public APIs to integrate systems.
• Develop high-performing custom PL/SQL programs for batch and real-time integrations.

System Extensions

• Extend and personalize Oracle EBS functionality using custom APIs, alerts, and user hooks.
• Create new workflows and extend seeded workflows.
• Develop new forms using Forms 10g and/or Oracle Application Framework (OAF).

Database Maintenance

• Perform Oracle database installation, configuration, upgrades, patching, and backup/recovery.
• Proactively monitor database performance and capacity, providing trend analysis.
• Administer database security, tuning, and optimization to ensure availability and data integrity.
• Use Oracle Enterprise Manager (OEM) to monitor databases and hosted environments.

Integration Support

• Assist in integrating ERP systems with other business applications.
• Collaborate with integration teams to define requirements and develop interfaces.
• Support testing and validation efforts to ensure reliable data exchanges.
• Troubleshoot and resolve technical integration issues.

Behavioral Competencies

• Technical Savvy: Anticipate and adopt innovative business-building technologies.
• Manages Complexity: Effectively analyze complex issues, identify root causes, and solve problems.
• Collaboration: Build partnerships to meet shared objectives and communicate effectively with stakeholders.
• Situational Adaptability: Adjust approaches and priorities to match shifting demands.

Qualifications and Experience

Education

• Bachelor’s degree in Computer Science, Information Systems, Business Administration, or a related field.

Experience

• 3–5 years of experience in digital solutions, ERP operations, or related fields.
• Strong understanding of ERP systems like SAP, Oracle EBS R12, or Microsoft Dynamics.
• Experience in implementing and upgrading Oracle EBS R12.
• Proficiency in integration technologies and methodologies.
• Hands-on experience with SQL, PL/SQL programming, and Oracle EBS development standards.
• Knowledge of RDBMS concepts, Linux/Unix OS programming, and Oracle Application Developer Framework.
• Experience troubleshooting hardware issues is a plus.

Technical Tools

• TOAD, PL/SQL Developer
• Workflow Builder, Forms Builder
• Oracle EBS Financials or SCM/Manufacturing modules

Certifications (Preferred)

• Oracle Certified Professional (OCP)
• Relevant certifications in ERP systems or project management