We are seeking a skilled and experienced PostgreSQL Database Administrator (DBA) to join our team.
This PostgreSQL DBA will be responsible for the performance, integrity, and security of our PostgreSQL database systems. The ideal candidate will have hands-on experience with PostgreSQL database management in production environments, including setup, configuration, maintenance, and optimization. This role also involves ensuring high availability, data consistency, backup strategies, and disaster recovery planning.
PostgreSQL DBA | 6-10 Y | Hybrid | HYD | Bangalore | Chennai | Pune | Mumbai | Delhi | Kolkata
Type of Work : Contract 12 M
Mode of Work : Hybrid (Anyone Location as above)
Interview Process : 2 Virtual Session + 1 F2F (If required)
Key Responsibilities :
Database Installation & Configuration :
- Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.
- Implement replication (physical / logical) and clustering solutions for high availability and scalability.
Performance Tuning & Optimization :
Monitor database performance and identify bottlenecks.Analyze slow queries, recommend indexing strategies, and optimize SQL queries.Security & Compliance :
Ensure database security, including user authentication, access control, and data encryption.Manage roles, permissions, and audit logs.Ensure compliance with industry standards and data protection regulations (e.g., GDPR, HIPAA).Backup & Recovery :
Implement and manage backup and disaster recovery procedures.Use tools like pgBackRest, Barman, or native PostgreSQL backup methods.Conduct regular restore testing and audits.Database Maintenance :
Perform routine database maintenance tasks such as vacuuming, reindexing, and partitioning.Apply patches and upgrades to the PostgreSQL engine and associated tools.Monitoring & Alerting :
Implement monitoring tools (e.g., pgAdmin, Prometheus, Grafana, Nagios) to proactively detect issues.Set up alerts for critical metrics and thresholds.Collaboration & Support :
Work closely with DevOps, development, and QA teams to support application deployments and releases.Troubleshoot database-related application issues.Documentation & Automation :
Maintain comprehensive documentation for database configurations and procedures.Automate routine tasks using shell scripts, Ansible, or other automation frameworks.Required Skills and Qualifications :
Bachelor's degree in computer science, Information Technology, or related field.4+ years of hands-on experience as a PostgreSQL DBA in a production environment.Strong knowledge of PostgreSQL architecture, internals, and extensions (e.g., PostGIS, pg_stat_statements).Proficient in performance tuning, query optimization, and indexing.Experience with HA / DR solutions like Patroni, PgBouncer, Streaming Replication.Familiarity with cloud platforms (AWS RDS / Aurora, GCP Cloud SQL, or Azure Database for PostgreSQL).Experience with Linux / Unix system administration and scripting (bash, python).Understanding of CI / CD, DevOps, and Infrastructure as Code concepts.Strong analytical and problem-solving skills.Excellent verbal and written communication skills.ref : hirist.tech)
