Database Administrator (DBA)

Charlotte NC - hybrid on-site

contract - potentially to hire

W2 only, no 3rd Parties please

Experience Level: Senior (10+ Years)

BANKING/FINANCIAL SERVICES CLIENTS Experience is mandatory.

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.