Postgresql Database Administrator

Role: PostgreSQL Database Admin

Experience: 5 to 8 years

Location: Pune

Key Responsibilities:

• Administer, monitor, and maintain PostgreSQL database environments
• Perform PostgreSQL installation, configuration, upgrades, and migrations
• Execute PostgreSQL major and minor version upgrades
• Configure and manage Streaming Replication and High Availability environments
• Perform backup, recovery, PITR, and disaster recovery activities
• Monitor database performance and conduct proactive health checks
• Analyze and optimize slow-running SQL queries using execution plans
• Troubleshoot locks, deadlocks, blocking sessions, and long-running transactions
• Monitor database growth, storage utilization, and capacity planning
• Perform VACUUM, VACUUM FULL, ANALYZE, and REINDEX activities
• Manage PostgreSQL parameters and configuration tuning
• Troubleshoot replication lag, failover, and availability issues
• Implement database security, user management, and auditing controls
• Support production deployments, release activities, and change requests
• Perform RCA for critical incidents and recurring issues
• Collaborate with application, infrastructure, and cloud teams

Required Skills:

• PostgreSQL Database Administration
• PostgreSQL Major & Minor Version Upgrades
• Streaming Replication & High Availability
• Backup, Recovery & PITR
• Performance Tuning & Query Optimization
• VACUUM, ANALYZE, REINDEX
• Linux (RHEL) Administration

Preferred Skills:

• AWS RDS PostgreSQL Administration
• CloudWatch and Performance Insights
• pgAdmin, PgBouncer, pgBadger
• Shell Scripting (Bash)
• Database Migration Experience

Primary Skills:

PostgreSQL DBA | Replication | High Availability | PITR | Performance Tuning | Query Optimization | Database Upgrades | Linux Administration | Production Support