
Postgres DBA
4 hours ago
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.
-
Senior Database Engineer
4 weeks ago
Jaipur, Rajasthan, India Cozzera Full timeJob Title: Postgre SQL DBA cum Developer Location: Jaipur (Onsite) Experience: Minimum 8+ Years Employment Type: Full-time Job Summary: We are looking for an experienced Postgre SQL DBA cum Developer with strong expertise in managing, developing, and optimizing Postgre SQL databases in Linux / open SUSE environments.The ideal candidate will have hands-on...
-
Postgres Dba
2 days ago
Jaipur, Rajasthan, India ABEX Excellence Pvt Ltd Full time**Brief Job Description**: **Key Result Areas**: Install, configure, and maintain Postgres databases Configure and handle multi-replication Develop and implement database backup and recovery procedures Monitor database performance and tune database parameters for optimal performance Manage database security and access control Plan and implement database...