slow queries made to the databases MySQL

I am looking for a skilled professional to help resolve slow queries made to our MySQL databases. The database size is medium, ranging from 1GB to 10GB. We are experiencing slow queries, but we are not sure if they are associated with a particular function of our application. After checking the error logs on the server we have noticed that your server has ran out of memory recently: > Jun 23 08:16:15 node7114 kernel: Out of memory: Killed process 2909794 (mysqld) total-vm:2915924kB, anon-rss:1137892kB, file-rss:0kB, shmem-rss:0kB, UID:27 pgtables:2976kB oom_score_adj:0 Indicating that all the available memory on the server has been allocated, so the kernel had to terminate some processes in order to free some memory. Which suggests that the current memory on the server is insufficient for the proper operations of your projects. Once that happens the server kernel starts killing processes in order to reduce the memory usage and in this case the process of the MySQL service has been killed. The high memory usage spike had been caused by slow queries made to the databases. MySQL queries should be executed for under a second which is the regular operation of the MySQL service. If they take more than one second, that means that there is an issue with the MySQL database or its operation. When queries stack up, they create a bottleneck in the MySQL service and the server continues to invest resources in order to complete the MySQL queries in the queue. We are in need of immediate resolution for this issue, preferably within 24 hours. Skills and experience required for this project include: - Advanced knowledge of MySQL databases - Expertise in query optimization - Troubleshooting skills to identify and resolve performance issues If you have experience in resolving slow query issues and can work on this immediately, please bid on this project.