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

Nico

United States

I speak English

Senior SQL Server and Oracle Database Developer

Users are impatient: most won't wait more than 8 seconds for a page to load. I make slow systems fast. 23 years as a .NET and database developer and architect in healthcare, banking and payments. I'v...
Read More
About this Gig

Is your app slow, are reports timing out, or does a stored procedure take minutes to run? I'll find out why and fix it.


I'm a senior database and .NET developer with 23 years of experience in healthcare, banking and payments, including tuning a 2 TB Oracle database. I don't guess. I read the execution plan, find the real bottleneck, and give you a fix you can run right away.


What I do:

- Rewrite slow or broken queries and stored procedures (T-SQL, PL/SQL, MySQL, PostgreSQL)

- Design the right indexes and remove unused or duplicate ones

- Fix deadlocks, timeouts, and parameter sniffing problems

- Tune queries generated by Entity Framework, Dapper, or other ORMs

- Design or redesign schemas for performance and future growth


What you get:

- Optimized SQL scripts ready to run, with rollback scripts

- Before and after timing so you can see the improvement

- A plain-English explanation of what changed and why


Your data stays safe. I work on a copy or a staging database, or from scripts and execution plans you send me. I never need production access.


Not sure which package fits? Send me your query and I'll tell you before you order.

Read More
optimize slow sql queries for sql server, oracle, mysql, postgresql
Full Screen
optimize slow sql queries for sql server, oracle, mysql, postgresql

Database type:

Centralized database

•

Relational database

Platform:

MS SQL

•

Oracle

•

PL/SQL

•

SQL Server

Expertise:

Data structure

•

Design

•

SQL

•

Performance

Related tags