PostgreSQL Admin L3

About The Job:

• Experience: 6–10+ Years
• Shift: Rotational / On-call Support (if applicable)
• 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.

Essential Job Functions:
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.
• 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.

Qualifications:
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.
• 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.