Overview
On Site
Full Time
Skills
Database
Storage
Query Optimization
Estimating
Management
Statistics
Concurrent Computing
Microsoft SQL Server
Replication
Job Details
We are hiring #Sr._Database_Administrator in #Charlotte NC- Hybrid.
Experience Level: Senior (10+ Years)
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 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.
#LI-AK1
Experience Level: Senior (10+ Years)
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 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.
#LI-AK1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.