Job Description

The Senior Oracle Apps DBA is responsible for the architecture, implementation, maintenance, performance, and security of Gemma’s critical Oracle E-Business Suite (EBS) R12 environments and their underlying Oracle databases. The role ensures high availability, optimal performance, and robust disaster recovery across both production and non-production environments, and leads database and EBS release upgrades and patching.

This is a senior, ownership-level role: the successful candidate is expected to design and govern the database environment, not simply operate it under instruction.

Key Responsibilities

1. Administer and maintain Oracle EBS R12 application tiers and the underlying Oracle databases — installation, configuration, and day-to-day operation.
2. Plan and execute patching for both the EBS application and the database (using the AD utilities — adpatch, or adop online patching for R12.2), and lead EBS and database release upgrades.
3. Clone and refresh environments (production to test / development / UAT) using Rapid Clone and AutoConfig.
4. Monitor and tune performance at both the database and application-tier levels — SQL tuning, concurrent manager tuning, and instance parameters.
5. Design and maintain backup and recovery strategies using RMAN; implement and regularly test disaster recovery (e.g., Oracle Data Guard standby databases).
6. Implement and maintain high availability where applicable (e.g., Oracle RAC).
7. Manage database and EBS security — schema and user/responsibility administration, security patching, auditing, and access control.
8. Administer the EBS technology stack — concurrent managers, Workflow, Forms, Reports, and the application-server tier (OC4J for R12.1 / Oracle WebLogic for R12.2).
9. Maintain documentation, runbooks, and standard operating procedures; participate in on-call and incident response for production issues.
10. Coordinate with functional teams, developers, and Oracle Support (Service Requests via My Oracle Support).

Requirements

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field (or equivalent practical experience).
• [5–8]+ years of hands-on Oracle Database administration, including [3]+ years specifically as an Oracle Applications (Apps) DBA on E-Business Suite R12.
• Deep Oracle Database administration expertise (versions 11g / 12c / 19c as relevant to the R12 estate).
• Proven hands-on EBS R12 administration: patching, cloning, AutoConfig, and multi-node architecture.
• Performance tuning across both the database and application tiers.
• Backup and recovery with RMAN; disaster recovery with Oracle Data Guard.
• High availability with Oracle RAC.
• Strong Linux/UNIX administration skills, including shell scripting.
• Solid SQL and PL/SQL proficiency for diagnostics, scripting, and automation.
• Strong problem-solving, documentation, and communication skills; effective under pressure and during production incidents.

Preferred / Nice-to-Have

• Oracle Certified Professional (OCP) – Database Administrator.
• Experience with Oracle Enterprise Manager (OEM / Cloud Control) for monitoring and automation.
• Exposure to Oracle Cloud Infrastructure (OCI), or experience migrating EBS workloads to cloud.
• Prior experience supporting ERP in a manufacturing environment.
• Familiarity with ITIL service-management practices.