MySQL Database Optimization Specialist Needed

As the owner of an existing MySQL database, I'm currently experiencing issues related to oversized databases which needs to deleted not needed files. While I'm currently unsure about the exact number of records or rows.
Ideal candidate for this project will have:

- Deep expertise and experience with MySQL databases
- Proven track record of mitigating issues related to large data volumes
- Ability to potentially develop a sustainable, long-term solution to prevent future issues
- Strong communication skills to guide me through the process

Tasks would include:

- Assessing the existing database and identifying the main areas causing high data volume
- Implementing efficient strategies to optimize the database
- Testing the database to ensure the issue is resolved

Through this project, I aim to enhance the performance and stability of my MySQL database. Looking forward to collaborating with a highly skilled freelancer to achieve this goal.

This is my oversized MySQL database(s). i need have
it reduced the size of the following MySQL databases
to 3GB or smaller.


DB: onee_dreamhosters_com, Size = 6.84 GB
Table: wp_actionscheduler_actions , Size: 3.1797 GB
Table: wp_postmeta , Size: 2.1728 GB
Table: wp_posts , Size: 0.5612 GB
Table: wp_wfknownfilelist , Size: 0.2459 GB
Table: wp_wc_product_meta_lookup , Size: 0.1160 GB
DB: onee_dreamhosters_com_1, Size = 11.88 GB
Table: wp_actionscheduler_actions , Size: 7.1939 GB
Table: wp_postmeta , Size: 2.1160 GB
Table: wp_posts , Size: 0.5836 GB
Table: wp_actionscheduler_logs , Size: 0.2880 GB
Table: wp_wc_product_meta_lookup , Size: 0.1629 GB
DB: ttwo_dreamhosters_com, Size = 6.83 GB
Table: wp_actionscheduler_actions , Size: 3.4999 GB
Table: wp_postmeta , Size: 2.1904 GB
Table: wp_posts , Size: 0.5631 GB
Table: wp_wfknownfilelist , Size: 0.2459 GB
Table: wp_wc_product_meta_lookup , Size: 0.1160 GB