Browse categories
English
$
USD
Connect to your AI
I will optimize and fix your slow sql queries
Data Engineer Python, SQL, AWS, Databricks ETL, APIs and Automation
Hi! I'm Vadym, a data engineer with 5+ years of experience building data pipelines, automations and analytics for e-commerce, hospitality and marketing teams.
I help startups and small teams get thei...
About this Gig
Slow dashboards, reports timing out, an app that hangs on one page? Usually it's a few bad queries, and they can be fixed without new hardware.
I've optimized analytical and production SQL for e-commerce, hospitality and marketing platforms: multi-table joins, CTE-heavy reports, large fact tables and incremental models.
What I do:
- Analyze execution plans (EXPLAIN / EXPLAIN ANALYZE or query profile)
- Rewrite queries for speed while keeping results identical
- Suggest indexes, partitioning or clustering
- Remove duplicate work: unnecessary subqueries, joins and full scans
What you get:
- Optimized SQL, verified to return the same results
- Before/after timings
- Plain-English notes on what was slow and why it's fixed
Works with PostgreSQL, MySQL, Snowflake, BigQuery, Databricks SQL and ClickHouse.
Send me the query and table sizes before ordering, and I'll tell you what's realistic.
Platform:
BigQuery
•
Elasticsearch
•
MongoDB
•
PostgreSQL
Expertise:
SQL
•
NoSQL
•
Big data
•
Query optimization
FAQ
What do you need from me?
The query, approximate table sizes, and ideally the execution plan (EXPLAIN ANALYZE output). Read-only access helps but isn’t always needed.
Will the results change?
No. I verify that the optimized query returns exactly the same data as the original.
Do you need write access to my database?
No. I recommend read-only access. Index changes are delivered as scripts for you to review and apply.
What if my query can’t be made faster?
I’ll tell you before you order. If the issue is the data model or hardware, I’ll explain what would actually help.
