MySQL DBA

Company Description

Join a multibillion-dollar global company that brings together amazing technology, people, and operational scale to become a powerhouse in the memory industry. Headquartered in Rancho Cordova, California, Solidigm combines elements of an established, successful technology company with the spirit, agility, and entrepreneurial mindset of a start-up. In addition to the U.S. headquarters and other facilities in the U.S., the company has international presence in Asia, Europe, and the Americas. Solidigm will continue to lead the world in innovating new Memory technologies with aspirations to be the #1 NAND memory company in the world. At Solidigm, we view problems as opportunities to define innovative solutions that hold the power to change the world and unleash the potential technological needs that the future holds. At Solidigm, we are One Team that fosters a diverse, equitable, and inclusive culture that embraces individual uniqueness and empowers us to bring our best selves to deliver excellence in support of Solidigm's vision and mission to be the go-to partner for optimized data storage solutions. You can be part of the takeoff of an innovative business that develops cutting-edge products, delivers strong business value for customers, provides an engaging workplace for its employees, and serves a greater impact on the world. This is a golden opportunity for the right applicant to join us and help design, build, and lead Solidigm. We want a diverse team of dedicated professionals who will not just be Solidigm team members but contribute to how we shape the future of the organization. We are seeking applicants who will grow and thrive in our culture; be customer inspired, trusting, innovative, team-oriented, inclusive, results driven, collaborative, passionate, and flexible.

Job Description

Provide expertise on database management/design to drive integration of business data, functions, and systems. Establish standards, guidelines, procedures, and other infrastructure necessary to support the objective of integration of data. Resolve performance problems. Plans and schedules daily tasks, uses judgement on a variety of problems requiring deviation from standard practices. Inadequacies and erroneous decisions would cause moderate inconvenience and expense.

Job Description: Senior Certified MySQL DBA (Database Administrator)

Job Summary:
We are seeking a highly experienced and certified Senior MySQL DBA to join our dynamic IT team. The successful candidate will be responsible for managing, optimizing, and securing MySQL databases across various environments. This role involves maintaining high database performance, ensuring data integrity, and providing expert-level support for critical database operations.

Key Responsibilities:
1. Database Administration:
- Manage and maintain MySQL databases in production, staging\QA, and development environments.
- Oversee installation, configuration, and upgrading of MySQL databases and related products.
- Monitor database performance, implement optimization strategies, and resolve issues.

 2. Performance Tuning and Optimization:
- Analyze database performance and make recommendations for improvements.
- Implement index strategies, schema changes, and query optimization techniques to enhance performance.
- Troubleshoot and resolve performance bottlenecks.

 3. Security and Compliance:
- Ensure database security by implementing and maintaining encryption, user roles, access controls, and auditing procedures.
- Conduct regular security assessments and maintain compliance with internal and external security standards.

 4. Backup and Recovery:
- Design and implement database backup strategies (full, incremental, and point-in-time).
- Manage recovery solutions and perform disaster recovery testing.
- Ensure data redundancy and availability across multiple systems or data centers.

 5. High Availability and Replication:
- Set up and manage high availability (HA) solutions, including clustering, replication (master-slave, master-master), and failover mechanisms.
- Manage distributed database environments with large-scale replication architectures.

6. Automation and Scripting:
- Develop and maintain scripts to automate database management tasks, such as backups, health checks, and monitoring.
- Leverage automation tools to streamline database operations and reduce manual intervention.

 7. Database Design and Architecture:
- Collaborate with development teams to design scalable and efficient database schemas.
- Evaluate and recommend new database technologies and architectures to meet business needs.

 8. Monitoring and Reporting:
- Implement monitoring tools and alerting systems to track database health, performance, and resource utilization.
- Provide regular reporting on database status, capacity planning, and future needs.

9. Troubleshooting and Support:
- Provide on-call support for critical production systems.
- Lead root cause analysis for database-related incidents and implement long-term fixes.

10. Mentoring and Training:
- Mentor junior DBAs and provide training on database best practices.
- Share knowledge and conduct regular database training sessions for development and operations teams. 

Required Qualifications:
- Certification: MySQL Database Administration Certification (e.g., Oracle Certified MySQL Database Administrator)
- Experience: 5+ years of hands-on MySQL DBA experience in large-scale production environments.
- Expertise in MySQL: Strong knowledge of MySQL architecture, replication, clustering, and advanced database features.
- Performance Tuning: Proven experience with query optimization, indexing strategies, and database performance tuning.
- Scripting: Proficiency in automation scripting using Bash, Python, or similar languages.
- Backup & Recovery: Strong knowledge of backup and recovery techniques and disaster recovery planning.
- Security: Experience implementing database security and encryption practices.
- Tools: Familiarity with MySQL Workbench, Percona, Nagios, or other database monitoring tools.

Preferred Qualifications:
- Experience with cloud databases (e.g. Azure Database for MySQL, AWS RDS or Google Cloud SQL).
- Knowledge of other database systems (e.g. SingleStore, SQL Server, PostgreSQL, MongoDB).
- Familiarity with containerized databases (e.g. Kubernetes, Docker).

Key Competencies:
- Strong problem-solving skills and attention to detail.
- Ability to work independently and in a team environment.
- Excellent communication skills to collaborate with developers, engineers, and business stakeholders.
- Ability to prioritize tasks in a fast-paced, dynamic environment.

This job description provides an overview of the key responsibilities and qualifications required for a Senior MySQL DBA role, ensuring candidates possess both the technical and leadership skills necessary for managing complex database environments.