Job Description : PostgreSQL Database Administrator
Position Title : PostgreSQL DBA
Role Overview :
We are seeking a highly experienced PostgreSQL Database Administrator (DBA) with 5 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.(ref : hirist.tech)