Job Summary:
The Open-Source DBA Manager will lead database management, optimization, and strategy for open-source databases, such as PostgreSQL, MySQL, and MariaDB, in a production environment. The role includes overseeing a team of DBAs, ensuring high database performance, security, and reliability, and collaborating with engineering and DevOps teams. The ideal candidate will be both technically skilled and experienced in leadership, capable of driving best practices and fostering innovation in database management.
Key Responsibilities:
- Database Management: Lead, manage, and optimize open-source databases, including PostgreSQL, MySQL, MariaDB, and others, ensuring high availability, scalability, and performance.
- Team Leadership: Supervise and mentor a team of DBAs, providing guidance on best practices, troubleshooting, and career development.
- Database Architecture & Design: Collaborate with application development teams to design and implement database architectures, including schema design, indexing strategies, and partitioning.
- Performance Tuning & Optimization: Proactively monitor and fine-tune database performance, identifying bottlenecks and applying optimizations to improve query execution times and system responsiveness.
- Backup & Recovery: Oversee backup strategies and disaster recovery planning to ensure business continuity and data integrity.
- Automation & Scripting: Develop and implement automation scripts for database maintenance, backups, and monitoring using open-source tools.
- Security & Compliance: Implement and enforce database security policies, including encryption, access control, and auditing, to meet compliance and regulatory standards.
- Incident Management & Troubleshooting: Lead the response to production database issues, ensuring quick resolution and minimal downtime.
- Collaboration: Work closely with engineering, DevOps, and other teams to ensure seamless integration between database systems and applications.
- Research & Innovation: Stay updated with the latest trends and technologies in open-source databases, and recommend new tools or methodologies to improve system performance and capabilities.
Required Qualifications:
- Experience: 5+ years of hands-on experience with open-source databases (PostgreSQL, MySQL, MariaDB, etc.) in a production environment.
- Leadership: At least 2 years of experience managing a team of database administrators or engineers.
- Database Optimization: Deep knowledge of database performance tuning, query optimization, and storage management.
- Backup & Recovery: Experience designing and implementing backup strategies and disaster recovery plans.
- Automation: Proficiency in automation tools (e.g., Ansible, Puppet) or custom scripting in Python, Bash.
- Security & Compliance: Familiarity with database security practices, including encryption, user access control, and compliance standards.
- Cloud & Virtualization: Hands-on experience with databases on cloud platforms like AWS, GCP, or Azure is a plus.
- Problem-Solving: Strong analytical and troubleshooting skills in high-pressure environments.
- Collaboration & Communication: Excellent communication skills and the ability to work effectively across teams.