Job Title

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.