I will write and optimize complex sql queries for mysql databases
Python and MySQL Developer for Automation, ETL and Business Software
About this Gig
A slow query costs you every single day - in server bills, in user patience, in reports nobody waits for anymore. I write and fix SQL for a living.
I am a MySQL developer who has designed and optimized databases behind real business applications. Whether you need a complex query written from scratch or an existing one made fast, I start by understanding your data structure - not by guessing.
What I deliver:
- Complex SELECT queries: multi-table JOINs, subqueries, aggregations
- - Optimization of slow queries: EXPLAIN analysis, indexes, rewrites
- - Stored procedures, views, triggers and functions
- - Report queries: turn "I need a report showing..." into working SQL
- - Clear explanation of what I changed and why
How it works: send me your table structures (CREATE statements or a plain description) and what you need. I will confirm scope before you order if anything is unclear.
Primary: MySQL and MariaDB. Also comfortable with PostgreSQL and SQLite.
Slow query emergencies welcome - the Basic package is a fast fix for one query with a before and after timing report.
Database type:
Centralized database
•
Relational database
Platform:
MariaDB
•
MySQL
•
PostgreSQL
•
SQLite
Expertise:
SQL
•
ER diagrams
•
Performance
•
Query optimization
My Portfolio
FAQ
My data is confidential. Can you still help?
Yes. I work from your table structures and row counts - actual data is rarely needed. Anonymized samples help but are not required, and your files are never shared or reused.
Will you explain the fix or just send code?
Every delivery includes a plain-English explanation of what I changed and why, plus before and after timing where relevant - so your team understands the solution, not just receives it.
