Description

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)

Key Skills
Education

Any Graduate

Back To Jobs