Job Title:
Oracle Team Lead
Company: Confidential
Location: Republic Of India
Created: 2025-11-19
Job Type: Full Time
Job Description:
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.