Database Administrator (DBA) at Major Japanese Bank

Overview

Hybrid
$68+
Contract - W2
Contract - 1 Year(s)

Skills

Microsoft SQL Server
Query Optimization
AlwaysON

Job Details

***Only candidates who are in NC will be considered***

 

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.

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.