Specialist - System Management (PostgreSQL DBA)

Vivantify Technology Solutions India Pvt. Ltd.; India; On-site; INR 900,000 - 1,400,000; Full time

Benefits offered by this job

Competitive salary and benefits

Opportunities for professional growth

Collaborative and inclusive work环境

Work on exciting projects with leading

Job summary

Vivantify Technology Solutions India Pvt. Ltd. in Bengaluru is seeking a PostgreSQL Database Administrator with 3-6 years of production support experience.

The role emphasizes PostgreSQL administration, performance tuning, replication, and incident management to ensure database reliability and availability. The candidate will provide L1/L2 production support, manage backups and upgrades, monitor health with Grafana/Prometheus, and collaborate with development and infrastructure teams to ensure

Qualifications

• 3-6 years of hands-on PostgreSQL DBA experience in production support.
• Strong knowledge of PostgreSQL architecture, replication, indexing, and performance tuning.
• Experience with backups and restores using pg_dump, pg_basebackup, WAL backups, pgBackRest or Barman.
• Familiarity with Grafana and Prometheus for monitoring.
• Linux system administration related to database operations.
• Strong SQL skills and query optimization.
• Production incident troubleshooting and resolution.
• Experience with high availability and disaster recovery.

Responsibilities

• Provide L1/L2 production support for PostgreSQL databases, including monitoring and incident resolution.
• Perform backups, restores, patching, upgrades, replication management, and capacity planning.
• Monitor database health and performance using Grafana and Prometheus.
• Troubleshoot slow queries, locking, deadlocks, indexing issues, and performance bottlenecks.
• Manage database users, roles, and permissions.
• Support high availability, streaming replication, failover, and disaster recovery strategies.
• Collaborate with development teams on schema changes, migrations, and query reviews.
• Create and maintain runbooks, SOPs, troubleshooting guides, and production documentation.

Skills

PostgreSQL administration

Performance tuning

Query optimization

Linux administration

Incident troubleshooting

Production support

Replication management

Tools

Grafana

Prometheus

pgBackRest

pg_basebackup

Barman

pg_dump

Job description

Location: Bengaluru Experience: 5-7 Years

About the Role

We are seeking a PostgreSQL Database Administrator with hands-on experience supporting production database environments. The role focuses on PostgreSQL administration, performance tuning, monitoring, backup and recovery, replication, and production incident management , with a strong emphasis on database reliability and availability.

Job Description

The role involves providing L1/L2 production support for PostgreSQL environments, including database monitoring, troubleshooting, maintenance, and incident resolution. You will perform routine DBA activities such as backups, restores, patching, upgrades, replication management, and capacity planning. You will also monitor database health using Grafana and Prometheus or similar tools , investigate performance issues, optimize queries and indexes, and support high-availability and disaster-recovery environments. The position requires close collaboration with development, infrastructure, and on-call teams.

Key Responsibilities

• Provide L1/L2 production support for PostgreSQL databases, including monitoring and incident resolution.
• Perform backups, restores, patching, upgrades, replication management, and capacity planning.
• Monitor database health and performance using Grafana, Prometheus, or similar tools.
• Troubleshoot slow queries, locking, deadlocks, indexing issues, and other performance bottlenecks.
• Manage database users, roles, and permissions according to security best practices.
• Support high availability, streaming replication, failover, and disaster recovery strategies.
• Collaborate with development teams on schema changes, migrations, and query reviews.
• Create and maintain runbooks, SOPs, troubleshooting guides, and production documentation.

Required Skills

• PostgreSQL Database Administration - 3-6 years of hands-on PostgreSQL DBA experience in production support environments.
• Strong understanding of PostgreSQL architecture, replication, indexing, and performance tuning.
• Backup and recovery using pg_dump, pg_basebackup, WAL-based backups, pgBackRest, or Barman.
• Grafana and Prometheus or similar database monitoring tools.
• Linux system administration relevant to database operations.
• Strong SQL skills, including query review and optimization.
• Production incident troubleshooting and resolution.
• High availability and disaster recovery concepts.

Preferred / Good to Have

• Citus distributed PostgreSQL extension for sharding and horizontal scaling.
• Python for automation scripts, monitoring tools, or maintenance utilities.
• Cloud-managed PostgreSQL services such as AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP Cloud SQL.
• Infrastructure as Code tools such as Terraform or Ansible.
• Connection pooling tools such as PgBouncer or Pgpool-II.
• ITIL or incident management processes.

Mandatory Skills

• DB2-DB Administration.
• PostgreSQL-DB Administration.

Candidate Profile

The ideal candidate should have 3-6 years of production PostgreSQL DBA experience with strong expertise in database administration, performance tuning, monitoring, replication, and recovery . The candidate should be proactive, detail-oriented, and comfortable working with engineering, infrastructure, and on-call teams in a fast-paced production support environment.

Benefits Package

• Competitive salary and benefits package
• Opportunities for professional growth and development
• A collaborative and inclusive work environment
• The opportunity to work on exciting and challenging projects with leading clients