Postgres DBA

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.