We are looking for an experienced PostgreSQL DBA who possesses exceptional SQL skills and in-depth knowledge of database administration. The ideal candidate should be highly skilled in writing, optimizing, and tuning complex SQL queries , creating efficient indexes, and handling advanced troubleshooting.
This role requires hands-on expertise in database performance tuning, high availability (HA), disaster recovery (DR), role-based access control (RBAC), and understanding of RTO / RPO strategies
Key Responsibilities :
- Write, analyze, and optimize complex SQL queries, views, and stored procedures.
- Design and implement indexing strategies for query performance improvements.
- Administer and maintain PostgreSQL clusters with HA and DR configurations.
- Manage RBAC policies ensuring secure database access and compliance.
- Monitor and troubleshoot performance issues, providing root-cause analysis and long-term solutions.
- Plan and implement database backup, recovery, and failover strategies to meet RTO / RPO objectives.
- Work closely with development and infrastructure teams to support database-related needs.
Required Skills & Experience :
Strong expertise in PostgreSQL administration and tuning.Proven experience in query optimization, performance troubleshooting, and indexing.Hands-on experience with cluster management, HA / DR configurationsKnowledge of RBAC, security best practices, and backup / recovery strategiesSolid understanding of RTO and RPO planning.5+ years of experience as a DBA, with at least 3 years in PostgreSQL.Seniority level
Mid-Senior level
Employment type
Contract
Job function
Information Technology
IT Services and IT Consulting
J-18808-Ljbffr