I will optimize slow sql queries and fix database performance

Abhishek M.

India

I speak English

Data Engineer for PySpark, Databricks, SQL and Python

Hi, I'm Abhishek, a full-time Data Engineer at GHD working with PySpark, Databricks, SQL, Python and Azure. I help businesses and engineers with: - Building and fixing data pipelines (ETL/ELT) in PyS...
Read More
About this Gig

Is a slow SQL query holding up your dashboard, report or app? I'm a full-time Data Engineer and I'll find out why it's slow and make it fast, with measured before/after timings.


WHAT I DO:

  1. Read the execution plan and find the real bottleneck
  2. Rewrite the query: joins, subqueries, window functions, CTEs
  3. Recommend the right indexes (and which ones to drop)
  4. Fix wrong results: duplicates, NULL handling, bad joins
  5. Write complex reporting queries from your requirements

DATABASES: PostgreSQL, MySQL, SQL Server, BigQuery, Spark SQL / Databricks.


Send me the query, the table structure (CREATE TABLE statements) and approximate row counts. An execution plan helps a lot if you have it. Message me before ordering if you're unsure which package fits. No production passwords needed.

Read More
optimize slow sql queries and fix database performance
Full Screen
optimize slow sql queries and fix database performance

Database type:

Distributed database

•

Relational database

Platform:

BigQuery

•

MySQL

•

PostgreSQL

•

SQL Server

Expertise:

SQL

•

Big data

•

Performance

•

Query optimization

Related tags