My production MySQL 8.x instance is under heavy load and response times on critical UPDATE/DELETE operations have become unacceptable. I need an experienced DBA to jump in right away, examine the current workload, and squeeze every millisecond possible out of the server. The job revolves around three tightly-linked goals: • shorten query execution time, especially for write-heavy UPDATE and DELETE statements • streamline database size through proper indexing and archiving strategies • cut overall CPU, RAM and I/O consumption so the box stops spiking during peak hours You’ll get full access to the slow query log, current schema, and my.cnf. From there I expect: 1. a diagnostic report that pinpoints bottlenecks in query design, index coverage and server configuration 2. a set of actionable changes (new or altered indexes, schema tweaks, parameter tuning—key_buffer_size, innodb_buffer_pool_size, etc.) implemented on a staging clone first, then promoted to production after validation 3. clear before-and-after metrics showing improvement in query latency and resource utilisation 4. a concise hand-off document detailing every adjustment so future maintenance is painless Work can begin immediately; the sooner the fixes are live, the better.