Database Administrator (DBA)

We are hiring #Sr.SQLDatabaseAdministrator 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.