PostgreSQL Database Administrator_3+ Years

Zorba AI; Gurugram District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Zorba AI in Gurugram is seeking a skilled PostgreSQL Database Administrator to manage PostgreSQL deployments, optimize performance, and support production workloads.

You will install, monitor, and tune databases, implement backups and replication, automate tasks with Bash or Python, and collaborate with DevOps and cloud teams to ensure reliability and security.

Ideal candidates have 3–4 years of hands-on PostgreSQL experience and a solid foundation in SQL, indexing, and database administration.

Qualifications

• 3–4 years of PostgreSQL DBA experience.
• Strong SQL, indexing, and execution-plan analysis.
• PostgreSQL backup, recovery, PITR, and replication.
• Production support and troubleshooting.
• Linux/Unix administration basics.
• Scripting in Bash or Python.

Responsibilities

• Install, configure, upgrade, patch, and maintain PostgreSQL databases.
• Monitor, troubleshoot, and tune performance.
• Optimize queries, indexes, and schemas.
• Manage backup, recovery, PITR, and disaster recovery.
• Configure streaming and logical replication.
• Perform VACUUM, ANALYZE, and health checks.
• Handle production incidents and escalations.
• Manage security, roles, permissions, and auditing.
• Support migrations and environment refreshes.
• Automate DBA tasks using Bash, Python, Ansible, Terraform.
• Collaborate with application, infrastructure, cloud, and DevOps teams.

Skills

PostgreSQL DBA

SQL

Indexing

Execution plans

Backup & PITR

Performance tuning

VACUUM/ANALYZE

Linux basics

Bash or Python

Cloud exposure

CI/CD

MongoDB

Oracle/MySQL

Tools

MongoDB

Oracle

MySQL

Terraform

Ansible

Job description

We are looking for a skilled PostgreSQL Database Administrator with 3–4 years of hands‑on experience in database management, performance optimization, backup and recovery, replication, and production support. The ideal candidate should have strong PostgreSQL troubleshooting skills and working knowledge of Linux and database automation.

Key Responsibilities

• Install, configure, upgrade, patch, and maintain PostgreSQL databases.
• Perform database monitoring, troubleshooting, and performance tuning.
• Optimize SQL queries, indexes, execution plans, and database schemas.
• Manage database backup, recovery, Point‑in‑Time Recovery (PITR), and disaster recovery.
• Configure and maintain streaming and logical replication.
• Perform VACUUM, ANALYZE, database health checks, and capacity monitoring.
• Handle production incidents, RTB (Run the Business), and BTB (Build the Business) activities.
• Manage database security, roles, permissions, access controls, and auditing.
• Support database migrations, version upgrades, and environment refreshes.
• Automate routine DBA tasks using Bash, Python, Ansible, Terraform, or similar tools.
• Collaborate with application, infrastructure, cloud, and DevOps teams.

Mandatory Skills

• 3–4 years of hands‑on PostgreSQL DBA experience.
• Strong SQL, indexing, query optimization, and execution‑plan analysis.
• PostgreSQL backup, recovery, PITR, and replication.
• Performance tuning, VACUUM, and ANALYZE.
• Production support and troubleshooting.
• Linux/Unix administration basics.
• Scripting and automation using Bash or Python.

Good to Have

• Exposure to AWS, Azure, or GCP.
• Knowledge of CI/CD and infrastructure automation.
• Experience with MongoDB administration.
• Exposure to Oracle or MySQL.
• Database monitoring and observability tools.

Skills: gcp,linux,mongodb,postgresql,mysql,python,sql,ci/cd,aws,azure