Senior Oracle Backend DBA
Washington, AR - USA
Job Summary
Job Description: Senior Oracle Backend DBA (EBS 12.2.12)
The Senior Oracle Backend DBA is responsible for the stability performance security and lifecycle management of Oracle E-Business Suite (EBS) 12.2.12 and its supporting database tiers. This role manages all backend database operationsincluding patching cloning tuning disaster recovery and high-availabilityensuring the EBS platform remains resilient and compliant as it transitions into the broader UNIFI operations framework referenced in the EBS Transformation Kick-Off Meeting.
- Administer Oracle databases supporting EBS 12.2.12 including RAC/standalone environments.
- Perform performance tuning (SQL instance memory storage indexing) to ensure optimal application responsiveness.
- Manage tablespaces partitions statistics and segment housekeeping.
- Diagnose and resolve database-level failures locking issues and performance degradation.
- Support EBS 12.2.12 backend components including database schemas (APPS APPLSYS etc.) workflow schemas concurrent processing schemas and technology stack objects.
- Collaborate with EBS Admins and technical teams to ensure backend readiness for new customizations RICEW deployments and code migrations in alignment with UNIFI operational expectations discussed in the EBS Transformation Kick-Off Meeting.
- Execute Oracle CPU/PSU/RU patching and EBS tech-stack updates (AD/TXK).
- Manage EBS 12.2 online patching (ADOP) from the backend perspective ensuring editioning objects and database components comply with EBR requirements.
- Perform environment cloning (sanitization post-clone steps application tier re-linking) across DEV/TEST/PROD.
- Develop and maintain RMAN backup strategies and retention policies.
- Implement DR solutions and participate in DR planning/testing.
- Ensure high availability via RAC DG/ADG configurations and monitoring.
- Enforce database security standardsaccess control auditing encryption (TDE) SSL patch compliance.
- Support auditing logging and data-protection requirements.
- Work with security and governance teams to maintain SoD and compliance alignment.
- Monitor database health growth performance and critical metrics.
- Support incident management including P1/P2 break-fix issues related to the DB or EBS backend.
- Provide operational readiness support consistent with the transformation goals described in the EBS Transformation Kick-Off Meeting.
- 810 years Oracle DBA experience with at least 5 years supporting Oracle EBS R12.2.x.
- Strong expertise in Oracle Database 12c/19c SQL tuning ASM OEM and RAC.
- Hands-on experience supporting EBS 12.2.12: schemas workflows concurrent managers and backend integrations.
- Deep knowledge of EBR/ADOP online patching editioned objects and patching cycles.
- Proficiency with RMAN Data Guard backup/recovery strategies and HA/DR architectures.
- Experience supporting large mission-critical ERP systems and multi-environment lifecycle management.
- Strong Linux/Unix shell scripting and automation capabilities.
- Experience with OCI-hosted EBS or hybrid cloud environments.
- Exposure to OIC-integrated environments and backend impacts of interface workloads.
- Knowledge of architecture planning for ERP modernization or large-scale EBS transformations.
Required Experience:
Senior IC