Postgresql DBA

Role Overview:

The PostgreSQL Database L3 Engg is responsible for upgrades, managing, maintaining and optimizing PostgreSQL database environments in production systems. This role acts as the second level escalation point for incidents, ensures database availability and supports performance tuning, security and reliability.

Key Responsibilities:

Database Administration

• Install, configure and upgrade PostgreSQL databases across environments
• Manage database objects: schemas, tables, indexes, triggers and maintain database schema integrity
• Perform performance tuning, query optimization and capacity planning

Incident / Problem Management

• Act as L2 escalation for database-related incidents and service requests
• Troubleshoot and resolve issues related to replication, backup failures and performance bottlenecks

Backup / Recovery

• Implement and monitor backup strategies using native tools pgdump, pgbasebackup
• Perform disaster recovery drills and ensure compliance with RPO/RTO objectives