Postgres DBA

3 days ago

Jaipur, Rajasthan, India Pratham Software Full time ₹ 12,00,000 - ₹ 36,00,000 per year

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

Job Description: 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.