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

Einige Informationen werden in englischer Sprache angezeigt.

Vereinigte Staaten

Ich spreche Englisch

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...
Über diesen Service

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.

Datenbanktyp:

Zentralisierte Datenbank

•

Relationale Datenbank

Plattform:

MS SQL

•

Oracle

•

PL/SQL

•

SQL Server

Expertise:

Datenstruktur

•

Design

•

SQL

•

Performance