PostgreSQL DBA
Job Description
PostgreSQL DBA
Job Title: PostgreSQL DBA / Senior PostgreSQL DBA
Experience: 6–10 Years
Location: Bangalore / Hyderabad / Chennai / Noida / Pune / Gurgaon / Visakhapatnam
Work Mode: Hybrid
Shift Timing: EST Shift (5:30 PM IST – 2:30 AM IST)
Notice Period: Immediate to 30 Days
Job Summary
We are seeking an experienced PostgreSQL DBA to manage and optimize high-volume, mission-critical PostgreSQL databases. The ideal candidate will have strong expertise in database administration, performance tuning, high availability, disaster recovery, and cloud-based PostgreSQL environments. Experience working with large-scale healthcare or HIPAA-compliant systems will be an added advantage.
Key Responsibilities
Database Administration & Performance
Administer, monitor, and maintain PostgreSQL databases.
Perform database performance tuning and query optimization.
Design and implement indexing, partitioning, and archival strategies for large datasets (10–20 TB).
Ensure database availability, scalability, and reliability.
High Availability & Disaster Recovery
Manage replication, failover, and disaster recovery solutions.
Implement and maintain HA/DR architectures using technologies such as Patroni, pgPool, replication, and related tools.
Support backup, recovery, and business continuity requirements.
Security & Compliance
Implement encryption, data masking, and auditing mechanisms.
Ensure compliance with HIPAA and other regulatory requirements.
Maintain database security best practices and access controls.
Database Engineering & Collaboration
Collaborate with Database Engineers and application teams on database modeling and optimization.
Establish and enforce database best practices and standards.
Mentor junior DBAs and provide technical guidance.
Automation & Version Control
Automate database backup, monitoring, patching, and maintenance tasks.
Manage schema versioning and database deployments using tools such as Liquibase or Flyway.
Support migration activities across on-premises and AWS environments.
Required Skills
Strong expertise in PostgreSQL Database Administration.
Experience with query optimization and performance tuning.
Hands-on experience with replication, logical decoding, CDC (Change Data Capture), and database monitoring.
Experience with PostgreSQL on AWS (RDS/Aurora) and on-premises environments.
Knowledge of database backup, recovery, and disaster recovery planning.
Familiarity with Liquibase or Flyway.
Strong troubleshooting and problem-solving abilities.
Preferred Qualifications
8+ years of PostgreSQL DBA experience.
Experience with RDS, Aurora PostgreSQL, and on-prem database environments.
Expertise in HA/DR technologies such as Patroni, pgPool, AlwaysOn, and replication.
Experience managing databases larger than 10 TB.
Exposure to healthcare, EHR, or HIPAA-compliant systems.
Experience with CDC, indexing strategies, and database partitioning.
Contact Information
Email: Shanmukh.Varma@infinite.com
