Tasks and Deliverables

Conduct a full performance audit of existing SQL queries, stored procedures, and reporting pipelines
Optimize slow-performing queries, multi-table joins, window functions, and EF-generated SQL.
Diagnose and resolve locking, blocking, and deadlock conditions
Improve indexing strategy, query plans, and concurrency handling
Optimize Entity Framework usage patterns and reduce unnecessary DB roundtrips
Review and optimize SQL interactions within API calls and background jobs
Implement monitoring to track query health, performance regressions, and long-running jobs
Provide documentation and knowledge transfer to internal engineering leadership

Required Experience

Expert-level SQL skills with proven experience optimizing complex queries at scale
Strong experience with locks, blocking, deadlocks, and concurrency patterns
Hands-on experience tuning stored procedures, CTEs, and window functions
Experience with C#/.NET and Entity Framework performance tuning
Familiarity with high-concurrency systems and background job processing
Experience working with SQL performance tools (Query Store, Profiler, Execution Plans)

Nice to Have

Senior SQL Developer

Key skills