Open-Source DBA Manager

Role Overview: In this role, you will lead the management and optimization of open-source databases such as PostgreSQL, MySQL, MariaDB, and others. Your focus will be on ensuring high availability, scalability, and performance of the databases. Additionally, you will supervise and mentor a team of DBAs, provide guidance on best practices, troubleshooting, and career development. Key Responsibilities: - Collaborate with application development teams to design and implement database architectures, including schema design, indexing strategies, and partitioning. - Proactively monitor and fine-tune database performance, identifying bottlenecks and applying optimizations to improve query execution times and system responsiveness. - Oversee backup strategies and disaster recovery planning to ensure business continuity and data integrity. - Develop and implement automation scripts for database maintenance, backups, and monitoring using open-source tools. - Implement and enforce database security policies, including encryption, access control, and auditing, to meet compliance and regulatory standards. - Lead the response to production database issues, ensuring quick resolution and minimal downtime. - Work closely with engineering, DevOps, and other teams to ensure seamless integration between database systems and applications. - Stay updated with the latest trends and technologies in open-source databases, and recommend new tools or methodologies to improve system performance and capabilities. Qualifications Required: - 5+ years of hands-on experience with open-source databases (PostgreSQL, MySQL, MariaDB, etc.) in a production environment. - At least 2 years of experience managing a team of database administrators or engineers. - Deep knowledge of database performance tuning, query optimization, and storage management. - Experience designing and implementing backup strategies and disaster recovery plans. - Proficiency in automation tools (e.g., Ansible, Puppet) or custom scripting in Python, Bash. - Familiarity with database security practices, including encryption, user access control, and compliance standards. - Hands-on experience with databases on cloud platforms like AWS, GCP, or Azure is a plus. - Strong analytical and troubleshooting skills in high-pressure environments. - Excellent communication skills and the ability to work effectively across teams.,