Wordpress and WooCommerce Consultant. Software Engineer with a focus on Wordpress. Plugin development and Architectural decisions. Make the right choice for your Business.
Manu is a Software Engineer with a focus on Wordpress. He has been in the industry for the past 8 years. His experience goes from Architectural decisions to Plugin Development. Also experienced on WooCommerce. Manu is also member of Toptal (Top 3% Freelance Talent). He definitely can help you making the right decision for your business.
It really depends, what do you want to manage and who is gonna build the custom theme? Depending on your requirements you can prepare the theme to be more or less flexible and therefore you can get more or less control of it. I'm happy to go into details if you specify what exactly want to achieve.
If you are short on coding stuff, you need to go probably to themeforest or similar and find a theme that will match your requirements. The downside is, normally, those commercial plugins underperform, but maybe you can beat 90 score with a good hosting and few performance plugins.
I would advise for such a monster DB to keep it external to wordpress. Use elasticsearch for the DB and create an external service/api to be accesible from the WP site.