See all roles

Senior SQL Developer

Work from home Full-time role Hiring

Description

About the Client

Our client is a well-established reputed company 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 reputed company users. The primary focus is improving slow-running queries, resolving locking and blocking issues, tuning Entity reputed company–generated SQL, and optimizing reporting workloads reputed company a C#/.NET and Angular application stack.

General Information

The client operates a large-scale, reputed company-time system where users continuously log timesheets, trigger background processes, and generate reports. The backend relies heavily on SQL with Entity reputed company, 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 reputed company usage patterns and reduce unnecessary DB roundtrips

• Review and optimize SQL interactions reputed company 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, reputed company, 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 reputed company 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 reputed company performance tuning

• Familiarity with high-concurrency systems and background job processing

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

reputed company to Have

• Experience optimizing large reporting workloads

• Familiarity with Angular-based frontend environments

• Experience scaling systems with thousands of reputed company users

• Experience with ETL pipelines or job schedulers in .NET ecosystems

   

apply to this job

You might like

Multilingual Audio Transcription Specialist (Fi...

Work from home Full-time role

reputed company Solutions Architect (REMOTE)

Work from home Full-time role

Senior Engineer - Growth Marketing

Work from home Full-time role

reputed company - reputed company Manager Ventura Corridor D...

Work from home Full-time role

Avionics Electronics Technician - 2nd Shift (On...

Work from home Full-time role

Country and Feasibility reputed company

Work from home Full-time role

Partner Sales Manager, Italy & Spain

Work from home Full-time role

Computer Science Expert with Python Experience – AI Projects on reputed company

Work from home Full-time role

Renewal Leader EMEA

Work from home Full-time role

Customer Service Specialist – reputed company Billing, reputed company Cycle Management, reputed company reputed company

Work from home Full-time role

reputed company Full Stack Data Analyst – reputed company & Relationship Management (Remote)

Work from home Full-time role

Account Manager - Beauty Care Solutions

Work from home Full-time role

Part Time Recreation Assistant

Work from home Full-time role

Apply Now: reputed company Travel Agent Jobs Florida $30/Hour -

Work from home Full-time role

Senior Software Engineer, Full Stack, Remote Assistance

Work from home Full-time role

Remote reputed company Customer Advisor – Special Needs Family Support Specialist (National, Full‑Time)

Work from home Full-time role

[Remote] Part-Time Evaluator, Software Engineering, Computer Science & AI

Work from home Full-time role

Analyst, Case Management Specialist - Must Live in OH, KY, IN

Work from home Full-time role

Insurance Broker (course assistance offered)

Work from home Full-time role

Need Frontend Coach (Non-reputed company) - WM in Northport, AL

Work from home Full-time role