Years of Experience 3 to 6years

Any Project specific Prerequisite skills- PostgreSQL DBA & CITUS

Detailed JD Detailed JD:

Key Responsibilities
- Provide L1/L2 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 (slow queries, locking, deadlocks, index tuning, query optimization)
- Manage user access, roles, and permissions in line with security best practices
- Support high availability and disaster recovery setups (streaming replication, failover, 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, or third-party tools like 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
- Valuable understanding of SQL and the ability to review/optimize queries
Good to Have
- Experience with **Citus** (distributed PostgreSQL e

📌 PostgreSQL DBA, CITUS (Bengaluru)
🏢 Kairos Technologies
📍 Bengaluru