Job Title: Senior SQL Server Developer
Location: Remote
This is a hands-on role focused on analyzing and rewriting SQL for performance. It’s ideal for experienced developers who understand how to write highly efficient SQL and are familiar with the internals of SQL Server—particularly around query optimization, execution plans, and performance bottlenecks.
You’ll collaborate with a SQL Server performance SME who spent over a decade at Microsoft, so strong fundamentals and real-world experience are key.
Key Responsibilities :
SQL Performance Optimization: Analyze and optimize SQL queries for performance, ensuring high efficiency and scalability. Identify slow-running queries and suggest appropriate optimizations.
Rewriting Complex SQL Queries: Refactor and rewrite poorly performing SQL queries into efficient, scalable, and optimized code. Expert-level knowledge of SQL optimizer with proven performance rewrites.
Knowledge of Database Architecture Design: Detailed understanding of the design and implementation of robust and scalable database architectures for high-performance systems.
Identify and Fix Inefficient Code: Act as a Subject Matter Expert to find suboptimal queries and rewrite them for performance without affecting business logic.
Required Experience :
7+ years of SQL Server development and administration
5+ years focused on SQL Server performance tuning and internals
Strong experience with SQL Server Optimizer, execution plans, indexing strategies, and diagnosing latching/blocking issues
Proven ability to work in high-parallel query execution environments
Knowledge of the SQL SOS (operating systems), thread scheduler and of how the statistics based optimizer works
Tools & Technologies:
Microsoft SQL Server, SSMS
Query execution plan analysis
SQL Profiler, Extended Events
Dynamic Management Views (DMVs)
Performance monitoring tools (PerfMon, Redgate, etc.)
Job Type : Contract
Work Location: Remote
Similar jobs

Senior SQL Server Developer

Apply Now
Back to search page