Responsibilities:

- Install, configure, upgrade, and maintain PostgreSQL database environments across development, testing, and production systems.

- Monitor database performance, identify bottlenecks, and perform tuning to ensure high availability and optimal response times.

- Manage backup, recovery, disaster recovery (DR), and replication solutions to ensure data integrity and business continuity.

- Implement and maintain database security, including user access management, encryption, auditing, and compliance controls.

- Perform database migrations, upgrades, patching, and capacity planning activities.

- Troubleshoot complex database issues and provide root cause analysis (RCA) for production incidents.

- Design and maintain high-availability architectures using PostgreSQL Replication, Failover, Streaming Replication, and Clustering technologies.

- Collaborate with application development, DevOps, and infrastructure teams to optimize database performance and reliability.





- Develop and maintain scripts for automation, monitoring, and administrative tasks using Shell Scripting, Python, or SQL.

- Support cloud-based PostgreSQL deployments on platforms such as AWS RDS, Azure Database for PostgreSQL, or Google Cloud SQL.

- Ensure adherence to database administration best practices, change management processes, and operational standards.

- Prepare and maintain technical documentation, SOPs, and operational runbooks.

Preferred Skills

- PostgreSQL 12/13/14/15/16 Administration

- Performance Tuning & Query Optimization

- Backup & Recovery (pgBackRest, Barman)

- Replication & High Availability (Patroni, Pgpool-II, Repmgr)

- Linux/Unix Administration

- AWS/Azure/GCP Database Services

- Shell Scripting / Python

- Monitoring Tools (Prometheus, Grafana, Zabbix)

📌 Postgres Database Administrator (Pune)
🏢 Orcapod Consulting Services
📍 Pune