Description
**Job Title:** WordPress Performance & MySQL Database Optimization Specialist We're looking for an experienced WordPress performance expert to optimize our website's MySQL database and significantly improve page load speed and overall user experience. ### Project Overview Our website is built on WordPress with WooCommerce and serves a large product catalog. We're looking for someone who can identify performance bottlenecks, optimize the database, and improve frontend and backend performance without breaking existing functionality. ### Responsibilities * Analyze and optimize the MySQL database for maximum performance. * Identify and remove unnecessary database overhead (revisions, transients, orphaned data, etc.). * Optimize slow SQL queries and improve query execution times. * Review and optimize WordPress database indexes where appropriate. * Audit plugins and identify database-intensive operations. * Improve WordPress backend responsiveness. * Optimize page load times and Core Web Vitals. * Implement caching strategies (database, object cache, page cache) when appropriate. * Optimize WooCommerce performance for large product catalogs. * Review server configuration and recommend improvements if needed. * Ensure all optimizations are safe, documented, and reversible. ### Required Skills * Advanced MySQL optimization. * Strong WordPress and WooCommerce experience. * Experience profiling slow queries using tools such as Query Monitor, MySQL EXPLAIN, or similar. * Knowledge of R