Hi ,

We are hiring for L1 PostgreSQL DBA
- Provide L1 production support for PostgreSQL database environments, including monitoring, troubleshooting, and incident resolution.
- Perform routine DBA tasks: backups, restores, patching, upgrades, replication management, and capacity planning.
- Monitor database health and performance using Grafana dashboards; configure and fine-tune alerts to proactively catch issues before they impact production.
- Investigate and resolve performance issues such as slow queries, locking, deadlocks, index tuning, and query optimization.
- Manage user access, roles, and permissions in line with security best practices.
- Support high availability and disaster recovery setups, including streaming replication, failover, and backup/restore strategy.
- Participate in on-call rotation for production incident support.
- Document runbooks, standard operating procedures, and troubleshooting guides.
- Work with development teams on schema changes, migrations, and query reviews.
- Assist in scaling initiatives, including support for Citus (distributed PostgreSQL)



environments where applicable.

Required Skills & Experience
- 3–6 years of hands-on experience as a PostgreSQL DBA in a production support environment.
- Strong understanding of PostgreSQL architecture, replication, indexing, and query performance tuning.
- Experience with backup and recovery tools:
- pg_dump
- pg_basebackup
- WAL-based backups
- pgBackRest/Barman
- Hands-on experience with Grafana and typically Prometheus or similar for database monitoring and alerting.
- Solid understanding of Linux systems administration as it relates to database operations.
- Experience troubleshooting production incidents under time pressure.
- Positive understanding of SQL and the ability to review/optimize queries.

Good to Have
- Experience with Citus for sharding and horizontal scaling.
- Working knowledge of Python for automation scripts, monitoring tools, or maintenance utilities.
- Exposure to

📌 PostgreSQL (Noida)
🏢 Giri Consultancy
📍 Noida