MySQL Database Optimization

I'm looking for a skilled database professional to optimize my MySQL setup. The current database faces a number of issues, notably slow performance, high CPU usage, and frequent crashes.

Key tasks include:
- Analyzing existing tables and queries to identify performance bottlenecks
- Implementing appropriate indexing strategies
- Refactoring database schema to improve performance
- Recommending and implementing optimizations to reduce CPU usage
- Troubleshooting and identifying reasons for frequent crashes
- Optimizing queries to improve overall performance

Ideal skills and experience:
- Proven track record in MySQL database optimization
- Strong understanding of indexing strategies and database performance tuning
- Ability to identify and resolve performance bottlenecks
- Experience with database schema design and optimization
- Proficiency in troubleshooting and resolving crashes
- Strong SQL skills
- Excellent communication and problem-solving skills.

The current database contains 10-20 tables and has an average size of 1GB to 10GB. Please provide a brief overview of your relevant experience when bidding.