I will optimize slow sql queries for postgresql, sql server and oracle

Georgia

I speak English

PostgreSQL and Database Engineer

Database developer with 10 years in banking and the public sector. I work with PostgreSQL, Oracle (PL/SQL) and SQL Server every day. I can help with: - slow queries, indexes and stored procedures - d...
About this Gig

Slow queries make an app feel broken and cost money on servers. I find out why a query is slow and fix it.

I have worked with databases for 10 years in banking and the public sector, mostly Oracle PL/SQL, Microsoft SQL Server and PostgreSQL. Tuning slow reports and procedures is a big part of my daily job.

What I do:

  • read the execution plan and find the real bottleneck
  • rewrite the query, add or fix indexes, split heavy procedures
  • check that the results stay exactly the same after the change
  • explain each change in plain English so your team can keep it fast

What I need from you:

  • the slow query or procedure, and roughly how long it takes now
  • table structures (DDL) and approximate row counts
  • access to a test copy, or an export of the execution plan

I don't need access to your production data. I can work on a test or anonymized copy.

Not sure which package fits? Send me the query first and I'll tell you honestly what it needs.

Database type:

Relational database

Platform:

Oracle

•

PL/SQL

•

PostgreSQL

•

SQL Server

Expertise:

Data warehouse

•

SQL

•

Performance

•

Query optimization

Other Databases Services I Offer