Project Description
I already have the overall technical architecture for an enterprise-grade AI SaaS platform in place, but the database layer still needs a specialist’s touch. The product mixes EPM consulting intelligence, finance-transformation tools, subscription-based premium knowledge, contributor ecosystems and LLM-powered workflows. To keep the MVP on schedule and ready to scale, I need an experienced MySQL professional who can jump in immediately and refine the core data foundation.
Where you will spend most of your time
The priority is our MySQL database architecture. I need a partner who can:
• Design a clean, future-proof schema that supports multi-tenant SaaS conventions, granular content segmentation, role-based security and a growing contributor workflow.
• Optimise complex analytical queries generated by the AI/LLM layer so response times stay sub-second even as data volume rises.
• Set up reliable replication and automated backup strategies (preferably using native MySQL tools or managed services such as AWS RDS) to guarantee high availability and easy disaster recovery.
Deliverables
1. Normalised ER diagram and full DDL scripts.
2. Indexing and query-tuning recommendations with benchmarks before vs. after.
3. Replication and backup plan, including step-by-step runbooks and automated jobs.
4. Short hand-off document that explains how the schema maps to our Stripe billing, contributor workflow and security/access-control layers.
Acceptance criteria
• All tables follow naming conventions and pass automated linting checks.
• Key read queries return in <200 ms on a dataset seeded with 10× projected launch volume.
• Backups complete within the defined window and restore successfully in staging.
• Replication lag stays under 2 seconds during load testing.
If you thrive on green-field database work, enjoy performance tuning and know how to build fault-tolerant MySQL clusters, let’s talk.