Mariadb Tuning for best perfomance of wordpress website.

Hello dear, I have a ecom website which build in wordpress. its run in cent os server with apache with php 7.4 and 24vCPU with 64gb ram. problem is my database taking lots of resource when wordpress front end or back end visit my website. so i need a database expert who can fine tune the db and set apache configure properly so my website get best performance.
PLease new people away from this. i need master db tuning expert.