PostgreSQL Database Administrator

Jio; New Delhi; On-site; INR 6,00,000 - 10,00,000; Full time

Job summary

An established industry player is seeking a Senior PostgreSQL DBA to enhance their database management capabilities. This role involves ensuring optimal performance and reliability of PostgreSQL databases, troubleshooting issues, and leading efforts in database cloning and upgrades. The ideal candidate will have a minimum of 3 years of experience, showcasing strong skills in performance tuning, SQL scripting, and operational DBA tasks. Join a dynamic team that values innovation and excellence in database management, where your contributions will directly impact the success of complex web-based applications.

Qualifications

• 3+ years of experience in PostgreSQL development and support.
• Strong skills in database design, troubleshooting, and performance tuning.

Responsibilities

• Manage and optimize PostgreSQL databases for performance and reliability.
• Lead efforts in database cloning, upgrades, and automated monitoring procedures.

Skills

PostgreSQL

Database Cloning

Performance Tuning

SQL Scripting

Linux Scripting

Communication Skills

Tools

Pg_dump

Pg_restore

PgBouncer

Job description

Job Responsibilities for Senior PostgreSQL DBA

The Senior PostgreSQL DBA should have at least 3 years of experience in development and customer support, providing technical and operational support activities for Database Servers. This includes logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimization.

Key responsibilities include:

1. Database cloning using Pg_dump and Pg_Restore.
2. Reviewing PostgreSQL logs and troubleshooting issues.
3. Experience with Postgres Connection Pooling (PgBouncer).
4. Operational DBA expertise in replication, high availability, and backup/recovery.
5. Advanced performance tuning skills, including analyzing performance data and preparing reports.
6. SQL and Linux scripting skills.
7. Strong communication skills and the ability to manage escalation calls.
8. Experience working within application/development teams or as an Application DBA.
9. Managing Development, QA, Staging, and Production databases and applications, implementing future enhancements.
10. Monitoring database health, availability, reliability, performance, and capacity planning.
11. Upgrading PostgreSQL databases.
12. Ensuring uptime and monitoring all production databases.
13. Estimating database capacity and developing monitoring methods.
14. Leading efforts to develop automated monitoring procedures to minimize downtime.
15. Reviewing developer SQL code for optimization before production release.
16. Performing regular maintenance tasks like vacuuming, reindexing, and archiving.
17. Proactively remediating operational problems.
18. Participating in a 24×7 support rotation.
19. Supporting complex web-based applications.
20. Implementing automatic switchover and failover procedures.