Senior Database Engineer - PostgreSQL

Role Overview : The ideal candidate will have hands-on experience and an SME in maintaining databases, with a primary focus on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies of PostgreSQL, Redis and MongoDB with additional expertise in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities : 1. Database Maintenance & Administration : - Perform routine maintenance tasks including backup, recovery, patching, and performance tuning. - Conduct standard database maintenance and administration tasks with attention to detail. - Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics. - Optimize database performance, plan for forecast resource needs, and recommend corrective actions. - Ensure database high availability, replication, failover, and clustering. - Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime. - Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects. - Implement disaster recovery strategies and maintain data integrity across environments. 2. Incident Management & Troubleshooting : - Handle critical escalations and complex troubleshooting for database issues. - Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues. - Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis). 3. Backup, Recovery & Disaster Recovery : - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements. 4. Containerization & Orchestration : - Manage databases using Docker and Kubernetes to ensure scalability and resilience. - Optimize containerized database solutions for performance optimization. - Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments. 5. Collaboration & Communication : - Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns. - Optimize database schema and queries for application performance improvement. - Interact with customers, suppliers, and partners to deliver effective database maintenance. 6. Documentation & Reporting : - Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides. - Prepare reports detailing system health, performance metrics, and improvement plans. Required Skills and Qualifications : - Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB. - Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases. - Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows. - Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms. (ref:hirist.tech)

Location: in, IN

Posted Date: 5/10/2025