EI
Database Administrator (DBA)
eTeam Inc.
- 🇺🇸 United States
- Hybrid
- 9 months ago
- $60 – $67 / hour
9 months ago
Duration: 12 Months Contract
Location: Charlotte, NC 28202
Hybrid role – 2 to 3 days onsite/week
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 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 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.
Database Administrator (DBA) · eTeam Inc.