Source description
About the role
As an ideal candidate for this role, you will be an expert in maintaining databases, particularly focusing on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. Your deep expertise will lie in Open Database technologies such as PostgreSQL, Redis, and MongoDB, along with proficiency in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities: - 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. - 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). - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements. - 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. - 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. - 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: - Deep knowledge of PostgreSQL, Redis, and MongoDB. - Hands-on experience with Docker and Kubernetes for deploying and managing databases. - Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows. - Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms. As an ideal candidate for this role, you will be an expert in maintaining databases, particularly focusing on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. Your deep expertise will lie in Open Database technologies such as PostgreSQL, Redis, and MongoDB, along with proficiency in containerization and orchestration tools like Docker and Kubernetes. Key Responsibilities: - 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. - 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). - Design and implement backup strategies and disaster recovery plans. - Ensure data integrity, redundancy, and compliance with RPO/RTO requirements. - 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. - Work closely with application teams to ensure seamless integration and
More at Nomiso