PostgresSQL DBA

Job Role - PostgreSQL DBAExperience Range: 5 to 10 yearsJob Location: Mumbai, Pune, Delhi, Kolkata, Hyderabad, BangaloreJob DescriptionMust Have: 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.