Database Administrator (DBA)
Sharp Decisions · Charlotte, NC · 2 wk ago
Information TechnologyContract
Responsibilities
- SQL Server Internals
- Deep understanding of SQL Server query processing, memory management, and I/O handling.
- Familiarity with execution plans, query processor architecture, and storage engine behavior.
- Query Optimization
- 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 of SQL Server's use of 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 changes, particularly related to query performance.
- Experience with AlwaysON and other replication technologies.