Title: Senior Oracle Backend DBA - Hybrid
Mandatory skills:
Oracle DBA, Oracle EBS R12.2.x, Oracle Database 12c/19c,
SQL tuning, ASM, OEM, RAC,
EBR, ADOP online patching, editioned objects, patching cycles,
RMAN, Data Guard, backup strategies, recovery strategies, HA/DR architectures,
Linux, Unix shell scripting, automation, ERP systems, lifecycle management,
architecture planning, ERP modernization, large-scale EBS transformations,
backend database operations, cloning, tuning, disaster recovery, broader UNIFI operations framework,
EBS Transformation, backend components, database schemas, APPS, APPLSYS,
RICEW deployments, code migrations, database components, EBR requirements, application tier re-linking,
DR solutions, DR planning, DR testing, database security standards, access control, auditing, encryption, TDE, SSL, patch compliance
Description:
Position Summary
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 .
Key Responsibilities
Database Administration & Performance
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.
EBS Application Tier & Backend Support
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.
Patching, Cloning & Lifecycle Management
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.
Backup, Recovery & High Availability
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.
Security, Compliance & Controls
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.
Monitoring & Operational Support
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.
Required Skills & Experience
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.
Preferred Qualifications
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.
Notes:
Hybrid Role (2-3 days onsite)
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Contact Details :
Account co-ordinator: Binodh Thankappan
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
|