Sharp Decisions
Database Administrator (DBA) (Charlotte)
Sharp Decisions, Charlotte, North Carolina, United States, 28245
We are hiring #Sr._SQLDatabase_Administrator in #Charlotte NC- Hybrid. Need Local Folks only.
Experience Level: Senior (10+ Years)
BANKING/FINANCIAL SERVICES CLIENTS Experience is mandatory.
Pay range $55-$60/hr
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.
Experience Level: Senior (10+ Years)
BANKING/FINANCIAL SERVICES CLIENTS Experience is mandatory.
Pay range $55-$60/hr
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.