Job Description

Job purpose

The Oracle DBA will be responsible for administering, maintaining, and optimizing Oracle E-Business Suite

environments across DEV, TEST, UAT, and PROD landscapes. The role requires strong expertise in Oracle

database management, patching, environment cloning, and security compliance including hands-on expertise in

OCI administration. The ideal candidate should have solid knowledge of OCI services, cloud operations,

security, networking, identity management, monitoring, backup, disaster recovery. In addition, the candidate

will support SQL Server administration tasks including performance tuning, backup/restore management, and

maintenance activities. The position ensures high availability, reliability, scalability, and security of enterprise

database systems supporting key business applications.

Key responsibilities

Maintain and monitor the health, performance, and stability of Oracle EBS across DEV, TEST, UAT, and PROD

environments. Support code migrations and deployments.

Apply Oracle EBS patches (application, tech stack, database) based on business, compliance, and security needs.

Identify and remediate vulnerabilities. Ensure environments remain compliant by applying R12, AD/TXK, CPU, and

PSU patches in accordance with required schedules.

Perform end-to-end environment cloning procedures. Refresh UAT and DEV environments from Production as

required.

Administer and manage Oracle Cloud Infrastructure (OCI) environments.

Provision, configure, and maintain OCI Compute, Storage, Networking, and Database services.

Configure and maintain database maintenance plans, index management, consistency checks, and apply critical

security patches.





Configure and administer Identity and Access Management (IAM), policies, compartments, and security best

practices.

Monitor cloud infrastructure using OCI Monitoring, Logging, Alarms, and Notifications.

Perform backup, recovery, disaster recovery, and business continuity planning.

Manage Object Storage, Block Volumes, File Storage, and Backup Policies.

Troubleshoot infrastructure, networking, storage, and performance-related issues.

Monitor SQL Server performance using standard tools; identify and resolve performance bottlenecks.

Administer and monitor high availability configurations such as AlwaysOn Availability Groups, log shipping, and

replication. Manage database backups and restorations.

Work closely with application teams, developers, and infrastructure teams for issue resolution and optimization.

Maintain documentation for database environments, configurations, and operational procedures.

Key competencies

- Candidates should have a B.E./B.Tech/MCA/MBA in Information Systems, Computer Science or a related field

- 6 – 9 years of hands-on experience as an Oracle Database Administrator in enterprise-level environments.

- Strong hands-on experience with Oracle Cloud Infrastructure (OCI).

- Experience with Compute Instance, Virtual Cloud Networks (VCN), Object Storage, Compartments.

- Provisioning, configuring, and administering ATP databases in OCI.





- Database lifecycle management including cloning, scaling, backup, restore, and patching

- Performance monitoring and tuning of ATP databases using OCI monitoring tools.

- User, schema, role, and privilege management.

- Oracle EBS environment management, monitoring, and troubleshooting.

- Strong experience managing Oracle E-Business Suite (EBS) environments administration.

- Oracle EBS patch management (Application, Technology Stack, Database).

- Oracle R12, AD & TXK patching, CPU/PSU patching.

- Environment cloning and refresh activities

- Oracle database performance tuning, backup/recovery, and RMAN.

- Strong understanding of Oracle architecture, WebLogic/OHS, concurrent managers, and workflow.

- SQL Server performance monitoring and tuning (Profiler, Execution Plans, DMVs, Performance Monitor).

- Experience with AlwaysOn Availability Groups, log shipping, replication.

- Backup and recovery strategy implementation & monitoring.

- Database maintenance plans, index optimization, and security patching.

- Strong analytical and troubleshooting skills.

- Ability to work in a fast-paced environment with tight deadlines.

- Exposure to financial services or enterprise performance management domains.

- Ability to manage multiple tasks and priorities effectively.

- Excellent communication skills to interact with stakeholders and provide clear updates.

- Must possess good verbal and written communication and interpersonal skills

Job Snapshot

Job ID

JOB_8019

Department

Data and Technology Services

Location

Udyog Vihar Phase II, Gurgaon, Haryana, India

Experience

6 - 9 Years

Employee Type

Permanent

📌 Delivery Lead - Oracle DBA (India)
🏢 Acuity Knowledge Partners
📍 India