Description

You will manage database operations, serving as the primary contact for new initiatives and a key responder for outages affecting critical applications.

Responsibilities

• Manage system backups and restorations using RMAN and logical exports.
• Participate in Disaster Recovery (DR) preparation, testing, and Data Guard troubleshooting.
• Provide 24x7 support, including weekend shifts and availability during P1/P2/P3 incidents.
• Perform database tuning, performance monitoring, and execution plan analysis.
• Execute patch management for single-node and RAC (2 or 3 nodes) environments.
• Maintain documentation including SOPs, root cause analysis (RCA), and change assessments.

Required Skills

• 8+ years of experience as an Oracle DBA or in a similar role.
• Oracle Certified Professional (OCP) 12c, 19c, or 21c certification.
• Extensive experience with Oracle versions 10g through 19c.
• Hands-on expertise with Oracle RAC (2 or 3 nodes) and ASM (Active/Passive and Active-Active clusters).
• Proven experience managing heavy databases exceeding 100+ TB using Filesystem and ASM.
• Proficiency in Unix environments, including Linux, Solaris, and AIX.
• Deep understanding of RMAN (Level 0, 1, 2), point-in-time recovery, and controlfile restoration.
• Knowledge of physical database design, partitioning (Range, Hash), and indexing (Local and Global).
• Experience with MOS SR creation, TFA/OSW generation, and log analysis.

Preferred Skills

• Experience with Oracle Data Guard and archive file restoration for DR synchronization.
• Ability to perform application-level tuning and performance monitoring.

Key Skills

Education

Any Graduate