Spoon

Senior SQL Developer

Spoon

contract

Posted on:

Location Type: Hybrid

Location: New York City • New York • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AngularEntity FrameworkETL.NETSQL

About the role

  • **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

Requirements

  • **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**
  • Experience optimizing large reporting workloads
  • Familiarity with Angular-based frontend environments
  • Experience scaling systems with thousands of concurrent users
  • Experience with ETL pipelines or job schedulers in .NET ecosystems
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLEntity FrameworkC#stored procedureswindow functionsCTEsperformance tuningquery optimizationETL pipelinesbackground job processing