I will optimize sql server performance

United States

I speak English

SoftwareDevelopment

AI Engineer and Principal Software Engineer with over 20 years of experience building high-performance, scalable systems. Specializes in local-first AI applications, Retrieval-Augmented Generation (RA...
About this Gig

If you're dealing with slow queries, timeouts, high CPU usage, or poorly designed databases, I can help you turn your system into a fast, scalable, high-performance solution.


I'm a senior-level Microsoft developer with deep experience in:

  • High-volume, high-transaction systems
  • Large datasets (millions to billions of rows)
  • Real-world production performance tuning


Performance Tuning

  • Fix slow queries and long-running reports
  • Analyze execution plans and eliminate bottlenecks
  • Reduce CPU, memory, and IO usage


Query Optimization

  • Rewrite inefficient T-SQL queries
  • Optimize joins, subqueries, and aggregations
  • Improve stored procedures and functions


Database Design

  • Design scalable schemas for performance and growth
  • Normalize / denormalize where appropriate
  • Optimize indexing strategies


Troubleshooting

  • Deadlocks, blocking, and locking issues
  • TempDB and concurrency problems
  • Parameter sniffing and plan cache issues

Database type:

Centralized database

Distributed database

Platform:

MS SQL

MySQL

PostgreSQL

SQLite

Expertise:

Big data

Data structure

Performance

Query optimization

My Portfolio