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