MYSQL DB Index Optimisation – Large data joins

We need an expert My SQL DBA to help optimize a stored procedure query.

You must be an expert in BOTH MYSQL Optimisation and AWS RDS

The same has been optimised in in the past and was running in 1 second but now after latest data load it seems we have missed something and it is now taking about 1-2 mins to run and hence needs to be checked.

Only apply if you can get on a shared screen call where we can talk through this.

The tables that this stored proc calls and has joins on are
27 Million records + 15 Million and a smaller table.

This is wrapped in a Spring boot API call which is then called from the UI. We use AWS RDS for the MYSQL server

ONLY apply if you are an SUPER STAR as we don’t have days to solve this. need someone who can help with this in a few hours.