Senior SQL Developer

Walter

New York, New York, United States Hybrid permanent

Posted: March 19, 2026

Required Skills

Job Description

About the Client

Our client is a well-established healthcare technology and services organization specializing in workforce management, payroll, and compliance solutions for regulated environments.

We are seeking a Senior SQL Developer (Performance Optimization) to diagnose, optimize, and stabilize a high-volume SQL environment supporting thousands of concurrent users. The primary focus is improving slow-running queries, resolving locking and blocking issues, tuning Entity Framework–generated SQL, and optimizing reporting workloads within a C#/.NET and Angular application stack.

General Information

The client operates a large-scale, real-time system where users continuously log timesheets, trigger background processes, and generate reports. The backend relies heavily on SQL with Entity Framework, while multiple background jobs and reporting workflows run concurrently throughout the day.

Due to growing data volume and concurrency, several SQL queries, stored procedures, and EF-generated queries are performing slowly or causing locks. The goal is to bring in an expert who can conduct a full performance audit, rewrite or tune problematic queries, and improve system reliability and responsiveness.

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

Additional Details

• 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

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

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.