MySQL Backend System Development

Job ID: 40185868

Budget: ₹100 – ₹400 INR

I’m building a dedicated database-driven layer and need you to handle every part of the MySQL side: schema design, indexing strategy, query optimisation, and a clean set of migration scripts. The goal is a robust Database Management System that plugs neatly into the rest of the stack through a well-documented connection pool and clear credentials management.

You’ll start by reviewing the current data requirements, map out an ERD, then set up the MySQL instance (self-hosted or managed, whichever you recommend for reliability and scaling). Solid transaction handling, role-based access control, and backup routines must be in place before we move to production.

Deliverables:
• Normalised MySQL schema and ER diagram
• Reproducible migration/seed scripts (SQL or preferred tool)
• Performance benchmarks with query plans and tuning notes
• Brief hand-off document covering deployment steps, security settings, and daily/weekly maintenance tasks

If you’ve previously optimised large MySQL datasets or migrated from another engine, mention that—those insights will help us hit the ground running.