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
- Good understanding of SQL and the ability to review/optimize queries

## Good to Have

- Experience with Citus (distributed PostgreSQL extension) for sharding and horizontal scaling
- Working knowledge of Python for writing automation scripts, monitoring tools, or maintenance utilities
- Exposure to cloud-managed PostgreSQL services (AWS RDS/Aurora, Azure Database for PostgreSQL, GCP Cloud SQL)
- Familiarity with infrastructure-as-code tools (Terraform, Ansible)
- Experience with connection pooling tools (PgBouncer, Pgpool-II)
- ITIL or incident management process familiarity

## What We're Looking For

- A proactive, detail-oriented problem solver who takes ownership of database reliability
- Strong communication skills to work across engineering, infra, and on-call teams
- Comfort working in a fast-paced support environment with shifting priorities
- Willingness to participate in on-call/rotational shift support as needed

## Nice-to-Have Soft Skills

- Ability to write transparent documentation and runbooks
- Collaborative mindset for cross-functional troubleshooting
- Calm, methodical approach during production incidents

Can share our resume to [email protected]

📌 PostgreSQL DBA, CITUS/production support) -Immediate or 15 days (Bengaluru)
🏢 Kairos Technologies
📍 Bengaluru