Oracle Database Administrator

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.
• Good incident management, analytical, troubleshooting, and communication skills.
• Ability to work in a 24x7 production support environment and meet defined SLAs.