Track Manager - Oracle Administration,PostgreSQL

Oracle Database Administrator (L3) Position: Oracle Database Administrator (DBA) – L3 Experience: 6–10+ Years Location: As per business requirement Shift: Rotational / On-call Support (if applicable) Role Summary The Oracle DBA (L3) serves as the highest level of technical support for Oracle database environments, responsible for database architecture, performance optimization, high availability, disaster recovery, security, automation, and strategic database initiatives. The role involves resolving critical production issues, leading complex projects, mentoring L1/L2 teams, and ensuring robust, secure, and scalable database platforms. Key Responsibilities Database Architecture & Administration Design, implement, and maintain enterprise Oracle database environments. Lead database installation, upgrades, migrations, and patch management activities. Define database standards, best practices, and governance frameworks. Perform capacity planning and infrastructure optimization. Advanced Performance Tuning Analyze and resolve complex database performance issues. Perform SQL tuning, execution plan analysis, and index optimization. Review AWR, ASH, ADDM, and Statspack reports. Optimize Oracle database configurations for maximum performance and scalability. High Availability & Disaster Recovery Design and manage Oracle RAC environments. Implement and maintain Oracle Data Guard solutions. Lead disaster recovery planning, testing, and execution. Support business continuity initiatives and HA architectures. Backup & Recovery Management Define backup and recovery strategies using RMAN. Execute complex database recovery scenarios. Ensure recovery objectives (RTO/RPO) are met. Conduct periodic backup and recovery testing. Incident & Problem Management Act as the highest escalation point for critical production incidents. Conduct detailed Root Cause Analysis (RCA) and problem management reviews. Collaborate with Oracle Support for complex issues. Identify and implement permanent corrective and preventive actions. Database Security & Compliance Implement Oracle security best practices. Manage auditing, encryption, and access controls. Ensure compliance with internal and regulatory requirements.

Key Responsibilities

Conduct security assessments and vulnerability remediation. Automation & Continuous Improvement Develop automation scripts using Shell, Python, and Ansible. Improve operational efficiency through process automation. Drive proactive monitoring and self-healing initiatives. Lead modernization and cloud transformation projects. Leadership & Mentoring Provide technical leadership to L1 and L2 DBAs. Review and approve database implementation plans. Mentor team members and conduct knowledge-sharing sessions. Participate in hiring and skill development initiatives. Technical Skills Required Oracle Technologies Oracle Database 12c/19c/21c Administration Oracle RAC Oracle Data Guard Oracle ASM Oracle Enterprise Manager (OEM) Performance & Tuning AWR, ASH, ADDM Analysis SQL Performance Tuning Execution Plan Analysis Query Optimization Database Wait Event Analysis High Availability & DR RAC Administration Data Guard Configuration & Management Disaster Recovery Planning Switchover and Failover Management Backup & Recovery RMAN Advanced Administration Flashback Database Point-in-Time Recovery Disaster Recovery Testing Operating Systems & Automation Linux/Unix Administration Shell Scripting Python Scripting Ansible Automation Cloud & Modern Platforms Oracle Cloud Infrastructure (OCI) AWS / Azure Database Services (preferred) Hybrid Cloud Database Management Required Qualifications Bachelor\'s Degree in Computer Science, Information Technology, or related field. 6–10+ years of Oracle DBA experience in enterprise production environments. Oracle Certified Professional (OCP) required. Oracle Certified Master (OCM) preferred. Preferred Skills Oracle Exadata Administration. Oracle GoldenGate Replication. Cloud migration and modernization experience. DevOps and Infrastructure-as-Code exposure. Experience handling large-scale mission-critical databases. Soft Skills Strong leadership and decision-making abilities. Excellent troubleshooting and analytical skills. Effective stakeholder and vendor management. Strong communication and presentation skills. Ability to lead critical incident bridges and crisis management calls. Key Performance Indicators (KPIs) 99.9%+ Database Availability. Skill Requirements Critical Incidents Resolved Within SLA. Successful DR Test Execution. Reduction in Database Performance Issues. Automation and Operational Efficiency Improvements. Successful Completion of Database Upgrade/Migration Projects. Team Mentorship and Knowledge Development. Typical L3 Oracle DBA Activities Lead Oracle database architecture and design decisions. Troubleshoot severe production outages and performance degradations. Design and manage RAC, Data Guard, and Exadata environments. Execute complex database migrations, upgrades, and patching. Perform advanced SQL and database performance tuning. Develop automation for routine DBA activities. Coordinate with Oracle Support on Sev-1 incidents. Provide technical consultancy and mentorship to L1/L2 teams. Suitable Job Titles Senior Oracle DBA Lead Oracle Database Administrator Oracle Database Architect Oracle Infrastructure Lead Principal Database Administrator Oracle Production Support Lead Oracle Database SME (Subject Matter Expert) Job Description (JD) – Oracle Database Administrator (L3) Position: Oracle Database Administrator (DBA) – L3 Experience: 6–10+ Years Location: As per business requirement Shift: Rotational / On-call Support (if applicable) Role Summary The Oracle DBA (L3) serves as the highest level of technical support for Oracle database environments, responsible for database architecture, performance optimization, high availability, disaster recovery, security, automation, and strategic database initiatives. The role involves resolving critical production issues, leading complex projects, mentoring L1/L2 teams, and ensuring robust, secure, and scalable database platforms. Key Responsibilities Database Architecture & Administration Design, implement, and maintain enterprise Oracle database environments. Lead database installation, upgrades, migrations, and patch management activities. Define database standards, best practices, and governance frameworks. Perform capacity planning and infrastructure optimization. Advanced Performance Tuning Analyze and resolve complex database performance issues. Perform SQL tuning, execution plan analysis, and index optimization. Review AWR, ASH, ADDM, and Statspack reports. Optimize Oracle database configurations for maximum performance and scalability. High Availability & Disaster Recovery Design and manage Oracle RAC environments. Implement and maintain Oracle Data Guard solutions. Lead disaster recovery planning, testing, and execution. Support business continuity initiatives and HA architectures. Backup & Recovery Management Define backup and recovery strategies using RMAN. Execute complex database recovery scenarios.