caferemote

Senior SQL Developer (Performance Optimization, .NET) – Hybrid (US Only)

Toptal · United State Of America · posted 7 months ago

Senior SQL Developer (Performance Optimization, .NET) – Hybrid (US Only) at Toptal — remote job on CafeRemote
All Other Remote C# SQL Full-time Senior the United States
Toptal is a global network of top-tier developers, designers, and consultants. Leading companies trust Toptal professionals for their most critical projects.  

Our client is a leading healthcare technology company providing workforce management, payroll, and compliance solutions in highly regulated environments.  

Role Overview 

We are hiring a Senior SQL Developer to optimize and stabilize a high-volume database environment handling thousands of concurrent users. This role focuses on improving query performance, resolving locking issues, and enhancing system efficiency within a C#/.NET and Angular ecosystem.  

Key Responsibilities 

  • Perform a full audit of SQL queries, stored procedures, and reporting systems

  • Optimize complex queries, joins, and Entity Framework–generated SQL

  • Identify and resolve locking, blocking, and deadlocks

  • Improve indexing strategies and query execution plans

  • Enhance concurrency handling in high-load environments

  • Optimize database interactions in APIs and background jobs

  • Implement monitoring for query performance and system health

  • Document improvements and share knowledge with internal teams

Role Details
 

  • Location: Ramapo, New York (US only)

  • Work Model: Hybrid (2–3 days/week onsite)

  • Type: Full-time contract (40h/week)

  • Duration: 3–6 months (extendable)

Requirements
 

  • Advanced SQL expertise with performance tuning experience

  • Strong understanding of concurrency, locks, and deadlocks

  • Experience with stored procedures, CTEs, and window functions

  • Hands-on experience with C#/.NET and Entity Framework

  • Familiarity with high-traffic systems and background processing

  • Experience with performance tools (Query Store, Profiler, Execution Plans)

Nice to Have
 

  • Experience optimizing reporting workloads

  • Familiarity with Angular applications

  • Experience scaling systems with high concurrency

  • Knowledge of ETL pipelines or job schedulers

Ready to apply?

Opens the application page in a new tab.

Apply for this job

CafeRemote takes no fee and asks for no account.

Similar remote jobs

KYB/AML Analyst, Sweden

Ramp · Remote (Sweden)

Full-time SEK 770,000 – SEK 1,060,000 • Offers Equity 1d ago