Oracle Database Administrator L2/L3

As an Oracle Database Administrator (L3), you will be responsible for the design, implementation, performance tuning, high availability, backup/recovery, and advanced troubleshooting of Oracle databases in mission-critical environments. This senior-level position requires deep technical expertise, handling escalations, and close collaboration with application, infrastructure, and security teams.

Key Responsibilities:

• Provide L3 support for Oracle databases (11g, 12c, 19c, and newer).
• Perform database installation, configuration, upgrades, patching, and migrations.
• Manage backup, recovery, and disaster recovery solutions using RMAN, Data Guard, and GoldenGate.
• Perform database performance tuning including SQL tuning, AWR, ASH, partitioning, and indexing strategies.
• Ensure database security, auditing, and compliance with enterprise policies.
• Design and manage high availability solutions including RAC, ASM, Data Guard, and clustering.
• Implement and maintain database monitoring, capacity planning, and automation.
• Troubleshoot and resolve complex database issues escalated from L1/L2 teams.
• Collaborate with developers, application owners, and system admins to optimize database usage.
• Create and maintain SOPs, technical documentation, and knowledge base articles.
• Participate in on-call support rotation and provide RCA (Root Cause Analysis) for P1/P2 incidents.

Required Skills & Experience:

• 7-12+ years of experience in Oracle Database Administration.
• Expertise in Oracle RAC, ASM, Data Guard, GoldenGate, and RMAN.
• Strong knowledge of SQL, PL/SQL, partitioning, indexing, and performance tuning.
• Hands-on experience with Oracle Enterprise Manager (OEM) Cloud Control.
• Proficiency in Linux/Unix environments and shell scripting for automation.
• Experience with database security, encryption, auditing, and compliance frameworks.
• Familiarity with cloud-based Oracle DB solutions (OCI, AWS RDS for Oracle, Azure) is a plus.
• Strong troubleshooting, root cause analysis, and problem-solving skills.
• Willingness to work in rotational shifts (shift cab allowances provided).

Preferred Qualifications:

• Oracle Certified Professional (OCP) or higher.
• Experience in large enterprise environments with mission-critical databases.
• Knowledge of hybrid cloud database administration.

Soft Skills:

• Analytical thinking and problem-solving mindset.
• Ability to manage escalations under pressure.
• Professional documentation and reporting skills.
• Mentoring and knowledge-sharing capability.