Optimise Wordpress Woocommerce Website - DB and Query side optimisation.

Hi Required asap. I am willing to fund milestones but milestones will be released on successful job completion. Only people with proven optimisation experience need to apply. Budget around $300 - $400. We have a Wordpress woo commerce based website and the website loads very slow.. its gives “Execution time out error” We are using high end VPS on hostgator and hosting company says that there is some issue with queries. The website has got nearly 650 products and some products have as high as 500 variations. In order to view the site you will need to change your host entries. We will provide site link and credentials to a suitable person. Here are some points that we have faced: - The site gives execution time out error on maximum of pages.. when you will open any category page and will go to its second page it gives execution time out error. - According to hostgator the site make a lot of queries in a single page load. We installed query monitor and do not see any such issues on our side. - When we moved the site from dev to live environment the DB size was 150MB now its has gone to 650 MB. I found on internet that it was caused by transient records and we installed a plugin to delete them.. still no help the site is still loading slow. - When we check the site on gtmetrix the site was coming in A/B grade.. still the site was not loading properly.. so we assume its some thing related with DB optimisation or query optimisation. - We will share detailed hostgator comments after we select winning bidder. Some comments are here: [login to view URL] - You need to have Wordpress, Woocommerce and php knowledge so you can write efficient queries to make the site work faster. We need the site inner pages to load fast. The website should work smooth when we open any page. Final payment will only be released once the site loads fast and is approved by hostgator and my developer. Developers with one proven record of Wordpress woo commerce site optimisation can apply. Thanks