Role Overview

We are looking for an experienced Oracle Core DBA with 5–10 years of hands-on experience in Oracle Database Administration. The candidate will be responsible for database administration, monitoring, troubleshooting, backup and recovery, performance management, high availability, upgrades, migrations, and production support in a 24x7 environment.

Key Responsibilities

· Own day-to-day and complex administration of Oracle 19c databases across production and non-production.

· Administer, monitor, and troubleshoot Oracle RAC (instances, services, Clusterware/Grid, ASM).

· Administer and operate Oracle Data Guard — lag, apply issues, planned switchover, and support for failover/DR drills.

· Own RMAN backup strategy execution, restore/recovery, and recovery validation.

· Plan and execute patching, RU/PSU, upgrades, and migrations with pre-checks, rollback, and cutover notes.

· Perform hands-on performance troubleshooting using AWR, ASH, ADDM, OEM, and SQL Monitor; implement and verify fixes.

· Own L2/L3 incidents, including P1/P2 technical resolution, RCA, and corrective actions.

· Act as technical lead for junior DBAs: assign/review daily work, check change quality, support during shifts, and coach on SOP.

· Lead or moderate client technical calls — incident updates, maintenance windows, risk, and next actions.

· Prepare implementation plans and participate in change/CAB discussions for database changes.

· Manage capacity and space at database level; flag storage, FRA, and performance risks early.

· Work with application, infrastructure, and development teams on releases, performance,



and environment issues.

· Provide 24x7 production support on roster; take technical ownership during critical events.

· Keep runbooks, RCA notes, and operational documentation current.

Mandatory Technical Skills

· Strong hands-on Oracle 19c/23ai.

· Oracle RAC administration and troubleshooting.

· Oracle Data Guard administration and operational DR tasks.

· RMAN backup, restore, and recovery, including non-trivial restore scenarios.

· Database patching and upgrades; at least one real upgrade or migration.

· Hands-on performance tuning using AWR/ASH/ADDM/OEM.

· Robust Linux/Unix for DBA work (logs, storage, processes, basic networking).

· OEM for monitoring, jobs, and diagnostics.

· Ability to work independently on L3 issues and explain them to client and junior staff.

Good to Have

· OCP

· OCI / AWS / Azure database exposure

· WebLogic/EBS awareness

· Shell scripting or automation of DBA checks

· GoldenGate or other replication exposure

· Managed services / multi-client experience

Qualification

· Graduation or Post-Graduation in Computer Science, Information Technology, or a related field.

Soft Skills

· Strong communication and interpersonal skills.

· Good analytical and problem-solving abilities.

· Ability to work effectively in a team.

· Ability to handle production pressure and critical situations.

· Good spoken and written English.

· Strong ownership and customer/client handling skills.

Pay: ₹352,000.00 - ₹2,000,000.00 per year

Benefits:

- Health insurance
- Leave encashment
- Paid sick time
- Provident Fund

Work Location: In person

📌 Oracle DBA (Gurugram)
🏢 Heuristics Informatics
📍 Gurugram