SQL DBA - hybrid
Charlotte, NC - hybrid
24 months+
Summary :
Manages and maintains SQL Server database environments for optimal performance, availability, and security.
Responsibilities : SQL Server Internals
- Deep understanding of how SQL Server processes queries, manages memory, and handles I / O.
- Familiarity with execution plans, query processor architecture, and storage engine behavior.
Query Optimization
Ability to analyze and rewrite inefficient queries.Expertise in indexing strategies, including clustered, non-clustered, filtered, and columnstore indexes.Knowledge of INCLUDE columns and their impact on query performance.Statistics and Cardinality Estimation
Understanding how SQL Server uses statistics for query planning.Experience with updating, creating, and managing statistics to improve estimator accuracy.Concurrency and Locking
Proficiency in diagnosing blocking, deadlocks, and transaction isolation levels.Ability to tune workloads for high concurrency without sacrificing performance.Experience in dealing with SQL Server Version change issues, particularly query performance.Experience in AlwaysON and other replication technologies.