Deskripsi pekerjaan
What you will Do
- Design and Architect: design and architecture of MySQL, MongoDB, and PostgreSQL databases to meet scalability and performance requirements for complex applications.
- Advanced Troubleshooting: Utilize advanced troubleshooting skills to resolve database issues, including performance bottlenecks and data integrity problems.
- High Availability: Implement and manage high-availability and disaster recovery solutions for MySQL, MongoDB, and PostgreSQL, including replication, clustering, and failover strategies.
- Capacity Planning: Conduct in-depth capacity planning and forecasting to ensure database resources meet future growth and performance demands.
- Automation: Develop and maintain automation scripts and tools for database management tasks, including backups, monitoring, and provisioning.
- Performance Tuning: Perform comprehensive performance tuning, including query optimization, indexing strategies, and resource utilization adjustments.
- Security Management: Oversee database security, including access controls, encryption, and vulnerability assessments, ensuring compliance with industry standards and regulations.
- Documentation: Maintain detailed documentation for database configurations, procedures, and troubleshooting guides to support operational excellence.
- Collaboration: Collaborate with application developers, system administrators, and other stakeholders to ensure seamless integration and performance of databases.
- Mentorship: Provide guidance and mentorship to junior DBAs and other team members, sharing expertise and best practices for database management.
What you need to have ?
- Education: A Bachelor's degree in Computer Science, IT, or a related field; a Master鈥檚 degree is highly desirable.
- Experience: 6+ years of experience working with databases, including MySQL, MongoDB, and PostgreSQL, with a proven track record in a senior or lead DBA role.
- Advanced Skills: Expertise in advanced SQL query writing, performance tuning, and database optimization techniques for MySQL and PostgreSQL.
- Cloud Proficiency: In-depth experience with cloud environments (Google Cloud) and database services such Google Cloud SQL etc.
- Programming Knowledge: Proficiency in a programming language such as Bash and Python, with the ability to develop custom scripts and automation tools.
- Database Technologies: Extensive experience with MySQL, MongoDB, PostgreSQL, and familiarity with other NoSQL databases like Redis, Apache Cassandra is a plus.
- Leadership: Demonstrated leadership skills, including the ability to manage complex projects, drive initiatives, and mentor junior staff.
- Communication: Excellent communication skills with the ability to articulate technical concepts to non-technical stakeholders and lead cross-functional teams.
Desired Attributes:
- Problem-Solving: Strong analytical and problem-solving abilities to address complex database challenges.
- Innovation: A proactive approach to adopting new technologies and methodologies to improve database management practices.
- Teamwork: A reliable team player with a collaborative mindset and a strong desire to contribute to the team鈥檚 success and continuous improvement.
