MySQL Database Developer
Budget: ₹75,000 – ₹150,000 INR
I need an experienced MySQL engineer who can take full ownership of our database layer. Your first job will be to review the existing schema and stored routines, then rewrite or tune anything that slows us down. Expect to dive deep into execution plans, indexes, partitioning options, and the usual locking and transaction quirks of InnoDB.
Once performance is stable, I want the database moved—or at least mirrored—onto AWS. Whether you prefer RDS or Aurora is up to you; I’m mostly interested in a production-ready configuration that handles automatic fail-over, proper parameter groups, and sensible monitoring alarms. If you’ve scripted this work before in CloudFormation, Terraform, or the AWS CLI, even better.
A solid backup and recovery strategy rounds out the engagement. Incremental logical dumps (mysqldump or mysqlpump), periodic physical snapshots, and point-in-time recovery need to be automated from a Linux host. Shell scripts should live in Git alongside the schema files so every change is traceable.
Tools already in play include MySQL Workbench for modeling and GitHub for version control, but I’m open to improvements if you have a favorite alternative. Please highlight similar projects you’ve handled, especially any involving high-traffic workloads or complex ETL pipelines, and tell me how long you’ll need for each milestone:
• Query tuning & schema review
• AWS deployment & configuration
• Backup automation & documentation
All deliverables must be reproducible from a fresh clone of the repo and a single deploy script.
Once performance is stable, I want the database moved—or at least mirrored—onto AWS. Whether you prefer RDS or Aurora is up to you; I’m mostly interested in a production-ready configuration that handles automatic fail-over, proper parameter groups, and sensible monitoring alarms. If you’ve scripted this work before in CloudFormation, Terraform, or the AWS CLI, even better.
A solid backup and recovery strategy rounds out the engagement. Incremental logical dumps (mysqldump or mysqlpump), periodic physical snapshots, and point-in-time recovery need to be automated from a Linux host. Shell scripts should live in Git alongside the schema files so every change is traceable.
Tools already in play include MySQL Workbench for modeling and GitHub for version control, but I’m open to improvements if you have a favorite alternative. Please highlight similar projects you’ve handled, especially any involving high-traffic workloads or complex ETL pipelines, and tell me how long you’ll need for each milestone:
• Query tuning & schema review
• AWS deployment & configuration
• Backup automation & documentation
All deliverables must be reproducible from a fresh clone of the repo and a single deploy script.