PostgreSQL DBA

PostgreSQL DBA

Experience: Years

Location: Mumbai,Pune, Delhi, Kolkata, Hyderabad, Bangalore

Job description

•Database Administration – Install, configure, and manage PostgreSQL databases (versions 11, 12, 13, 14, 15/All Versions) in production, staging, and development environments.

•Backup & Recovery – Implement and manage backup, WAL archiving, and PITR (Point-In-Time Recovery) for data protection.

•Performance Tuning & Optimization – Use EXPLAIN ANALYZE, tuning, and indexing strategies for query optimization.

•High Availability (HA) & Replication – Configure and manage Streaming Replication, Logical Replication for HA clusters.

•Security & Compliance – Manage roles, Implement SSL/TLS encryption, role-based access control (RBAC), auditing, and GDPR/security compliance.

•Troubleshooting & Issue Resolution – Analyze logs, resolve deadlocks, replication lag, slow queries, and performance bottlenecks.

•Automation & Scripting – Develop automation scripts using for maintenance and monitoring tasks.

•Database Design & Capacity Planning – Support schema normalization, partitioning, and sharding for large-scale deployments.

•Patch Management & Version Upgrades – Apply PostgreSQL minor/major version upgrades and security patches with minimal downtime.

•Cloud & Hybrid Database Management – Manage PostgreSQL databases in on-premises/Cloud.

•Cross-Team Collaboration – Work with developers, DevOps, and system administrators to optimize database performance and reliability.