Oracle Database Administrator (DBA)

Experience: 3+ Years

Location: Gurugram

Employment Type: Contract

Role Overview:

We are looking for an experienced Oracle Database Administrator (DBA) with 3+ years of hands-on experience in database administration, monitoring, troubleshooting, performance tuning, backup/recovery, patching, and production support.

Key Responsibilities:

- Perform end-to-end monitoring and health checks of Oracle databases and database environments.

- Handle Oracle database patching, PSU/RU/dot-release updates, and related activities.

- Monitor and troubleshoot Severity 1 & Severity 2 incidents, including raising and managing Service Requests (SRs).

- Perform incident triage, root-cause analysis, troubleshooting, and provide workarounds to restore services within SLA.

- Monitor database performance using AWR, session events, locks, latches, and database sessions.

- Perform database sanity checks, alert reviews, and identify potential performance or availability issues.

- Support backup, restoration, and recovery activities.

- Perform archive log management, database purging, and archival activities based on defined requirements.

- Monitor production server utilization using OS-level utilities and perform cleanup of stray Oracle processes.

- Support capacity planning, ASM disk addition, tablespace/mount-point utilization, and database availability.

- Support Standby Database creation and synchronization.

- Perform database parameter changes, invalid object checks, TNS configuration reviews,



and log collection.

- Troubleshoot database-related performance issues and provide recommendations based on Oracle best practices.

- Analyze SQL/report performance, identify bottlenecks, and implement database performance-tuning recommendations.

- Ensure database availability and minimize application service interruptions caused by database issues.

Oracle AVDF Responsibilities:

- Monitor Oracle Audit Vault and Database Firewall (AVDF) server health and status.

- Perform diagnostic checks and troubleshoot AVDF reporting issues.

- Register and manage hosts, agents, targets, and enforcement points for supported databases.

- Provide recommendations related to AVDF capacity, storage, and hardware scaling.

Required Skills:

- 2+ years of hands-on experience as an Oracle DBA.

- Strong knowledge of Oracle Database Administration and Production Support.

- Experience with Oracle Database patching and upgrades/dot-release updates.

- Good understanding of AWR, performance tuning, SQL performance, locks, latches, and session management.

- Experience with Backup & Recovery, Archive Logs, ASM, Standby/Dataguard, and database monitoring.

- Knowledge of tablespaces, initialization parameters, TNS, database health checks, and troubleshooting.

- Exposure to Oracle AVDF is preferred.

- Valuable incident management, analytical, troubleshooting, and communication skills.

- Ability to work in a 24x7 production support environment and meet defined SLAs.

📌 Oracle Database Administrator (Gurugram)
🏢 ANP Consulting Talent Solutions
📍 Gurugram