Senior SQL Developer

Senior SQL Developer

Join our client, a respected healthcare technology organization, as a Senior SQL Developer. In this role, you will focus on diagnosing, optimizing, and stabilizing a high-volume SQL environment that supports thousands of users.

About the Role

You will work on improving slow-running queries, resolving locking and blocking issues, and tuning SQL within a C#/.NET and Angular application stack. Your expertise will help enhance system reliability and performance.

What You'll Do

• 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 database 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.

What We're Looking For

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

What We Offer

Location: Ramapo, New York, United States (US-based talent only)

Type: Full-time 40h/week Contract

Work model: Hybrid - 2-3 times/week in office

Duration: 3–6 months with potential extension

Authorization: Applicants must be authorized to work in the US without employer sponsorship