SQL adjust work Prestashop

I am in need of SQL adjustments for my Prestashop website. The specific adjustments required include database optimization, query optimization, and table creation or modification. - Database optimization: I need someone who can analyze and optimize the database structure and performance to improve the overall speed and efficiency of my website. - Query optimization: I require assistance in optimizing the SQL queries used in my Prestashop website to ensure faster and more efficient data retrieval. - Table creation or modification: I need help in creating new tables or modifying existing ones to accommodate new features or functionalities on my website. I have a specific deadline for these SQL adjustments, so I am looking for someone who can work within a specified timeframe. Additionally, I may require help with other technology-related tasks for my Prestashop website, so having experience and skills in other relevant technologies would be a plus. Current error we having is below when we try to open the order page - it works on and off Oops... looks like an unexpected error occurred. Call to a member function getDateTransaction() on bool [Symfony\Component\Debug\Exception\FatalThrowableError 0]