Role: Oracle DBA Lead

Experience: 7-12 years experience

Location: Chennai

Apply only if you are available on Saturday(15th Nov) for face to face interview.

ORACL DBA & RAC

Expert Troubleshooting & Resolution: Act as the final escalation point (L3/L4) for all

critical, complex, and high-impact production issues related to Oracle Database, Oracle

RAC, ASM, and Data Guard. Perform root cause analysis (RCA) and implement

permanent solutions.

High Availability & Disaster Recovery (HA/DR):

Design, implement, and manage complex HA/DR solutions using Oracle RAC,

Data Guard (Physical and Logical), and Active Data Guard.

Perform multi-node cluster configuration, maintenance, and advanced

troubleshooting for Oracle RAC.

Lead disaster recovery planning, testing, and execution.

Performance Tuning & Optimization:

Perform advanced SQL and PL/SQL tuning, query optimization, and

application-level performance analysis.

Proactively monitor and tune database parameters, memory structures (SGA/PGA),

and I/O to ensure peak performance for VLDBs (Very Large Databases).

Utilize tools like AWR, ASH, and OEM for in-depth performance diagnostics.

Database Management & Strategy:

Lead major database upgrade and migration projects (e.g., cross-platform,

version upgrades).

Develop and enforce database security policies (e.g., encryption, auditing,

user/role management).

Design and implement capacity planning and storage strategies for future growth.

Mentorship & Automation: Mentor L1/L2 DBA teams. Drive the automation of complex

and routine DBA tasks using scripting (Shell, Python, Ansible) and Oracle management

tools.

Architecture & Design: Collaborate with Solution Architects and Development teams on

new database deployments and architectural standards.

Oracle Team Lead