Oracle Team Lead

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.