Senior Oracle Backend DBA

Ampcus Inc. • Washington, DC

3d

About The Position

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 operations—including patching, cloning, tuning, disaster recovery, and high-availability—ensuring the EBS platform remains resilient and compliant as it transitions into the broader UNIFI operations framework referenced in the EBS Transformation Kick-Off Meeting.

Requirements

• 8–10 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.

Nice To Haves

• 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.

Responsibilities

• 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 standards—access 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed