MySQL 8.4 Data Optimization & Reporting

I’m looking for someone who can dive into an existing MySQL 8.4 Community Server database, scrutinise its current structure for hidden bottlenecks and design flaws, and then re-engineer it so we can pull clean, reliable information on demand. You’ll have access to our full SRS and we’ll work together remotely—screen sharing is fine—so you can see exactly how the standalone desktop app runs today.

Once the schema review is complete, I’ll need a robust stored program (procedure or function) that joins data across several tables and builds a new view designed for aggregated statistical reports. A companion Python 3 script should automatically call that view, fetch the results, and push them straight into an Excel sheet that mirrors the layout in the diagram I’ll supply. No web front-end is involved; everything stays local on the workstation.

Deliverables
• Written assessment of current database issues and your optimisation steps
• Optimised schema changes (DDL) and the final stored program/view
• Python 3 script for automated retrieval and Excel export (xlsx)
• Sample Excel file that demonstrates the aggregated report matches the required format
• Brief hand-off notes so I can maintain or extend your work independently in the future

I’ll be available throughout for quick testing rounds, so if you love measuring execution plans, fine-tuning indexes, and wiring MySQL to Python’s mysql-connector or SQLAlchemy for seamless data pulls, let’s get started.