PostgreSQL DBA, CITUS (L1/L2 production support) -Immediate or 15 days

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 clear documentation and runbooks
- Collaborative mindset for cross-functional troubleshooting
- Calm, methodical approach during production incidents

Can share our resume to [email removed]