Job Description

ID: 356 | 10-15 yrs | Jaipur | careers

: PostgreSQL Database Administrator

Position Title:

PostgreSQL DBA

Experience:

10-15 years

Location:

Jaipur

Role Overview

We are seeking a highly experienced

PostgreSQL Database Administrator (DBA)

with 10-15 years of expertise in designing, implementing, and managing large-scale PostgreSQL environments. The ideal candidate will be a hands-on database leader, responsible for ensuring high availability, scalability, and performance of mission-critical systems, while also mentoring junior DBAs and collaborating with engineering teams.

Key Responsibilities

Database Architecture & Strategy

Design and implement highly available PostgreSQL architectures (replication, clustering, sharding, partitioning). Define database roadmaps, standards, and best practices for enterprise deployments.

Performance & Optimization

Lead query optimization, indexing strategies, and capacity planning for large datasets. Troubleshoot and resolve complex performance issues.

Operations & Maintenance

Oversee installation, configuration, upgrades, and patching. Ensure robust backup/recovery strategies and disaster recovery solutions. Manage database security, compliance, and auditing.

Automation & Monitoring

Implement monitoring, alerting, and automation for proactive issue resolution. Develop scripts and tools to streamline DBA operations.

Collaboration & Leadership

Work closely with application architects and developers to optimize database usage. Mentor and guide junior DBAs and engineers. Provide database expertise in solution design and code reviews.

Support

Own production database uptime, incident response, and root cause analysis. Participate in on-call rotations and provide escalation support.

Required Skills & Qualifications

10-15 years

of experience in database administration, with at least

5+ years in PostgreSQL

. Proven expertise in

PostgreSQL performance tuning, replication, and clustering

. Strong knowledge of

SQL, PL/pgSQL, and query optimization

. Hands-on experience with

high availability solutions

(Patroni, Pgpool-II, repmgr, etc.). Deep understanding of

backup/recovery tools and disaster recovery strategies

. Experience in

large-scale production environments

with high transaction volumes. Desirable - Strong background in

Linux/Unix systems administration

. Proficiency in

scripting/automation (Bash, Python, Ansible, etc.)

. Desirable - Exposure to

cloud-native databases

(AWS RDS/Aurora, Azure, GCP Cloud SQL). Desirable - Solid grasp of

security, encryption, and compliance frameworks (e.g., GDPR, PCI-DSS)

.

Nice-to-Have Skills

Experience with

multi-cloud or hybrid cloud deployments

. Familiarity with

containerized databases (Docker, Kubernetes)

. Exposure to

NoSQL databases

(MongoDB, Redis) for polyglot persistence. Knowledge of

DevOps, CI/CD pipelines

, and Infrastructure as Code. * Open-source contributions to the PostgreSQL community.