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

📌 Postgresql Database Administrator (Pune)
🏢 Tata Consultancy Services
📍 Pune