I will fix slow sql server queries and optimize stored procedures

Nicaragua

I speak English, Spanish, French

Software engineer, dotNET and SQL Server, legacy app modernization

Software engineer from Nicaragua (B.Sc. in Software Engineering) focused on .NET and SQL Server. In my day job I modernize a university academic platform in use since 2006, moving Visual Basic desktop...
About this Gig

Is a report, screen or API timing out because of the database? I'll find out why and fix it.


I work with SQL Server in production every day as a software engineer: optimizing queries and stored procedures, reading execution plans and debugging production issues on a platform with real daily users.


What I do:

  • Rewrite slow T-SQL queries and stored procedures
  • Find missing or unused indexes, fix scans, key lookups and parameter sniffing
  • Review execution plans and explain the bottleneck in plain language
  • Deliver the optimized script plus a short before/after report


Send me the query or stored procedure, its execution plan and approximate table sizes, and I'll tell you what I can improve before you order. I also work with PostgreSQL. I speak English and Spanish.

Database type:

Relational database

Platform:

MS SQL

•

PostgreSQL

•

SQL Server

Expertise:

SQL

•

Performance

•

Query optimization