Senior SQL Server DBA — Cloud, High Availability & Performance

DKMRBH Inc; Virginia Beach (VA); On-site; USD 120,000 - 150,000; Full time

Job summary

DKMRBH Inc. seeks a Senior MS SQL Database Administrator to manage enterprise SQL Server and cloud databases, ensuring availability, performance, and reliability.

You will troubleshoot issues, implement migrations, and optimize queries while supporting disaster recovery, high-availability configurations, and automation tooling. You will collaborate with engineering, operations, and infrastructure teams, document technical requirements, and participate in help desk tasks as needed.

Qualifications

• 6+ years of hands-on experience administering Microsoft SQL Server databases.
• Strong experience with SQL Server administration, support, and performance tuning.
• Strong knowledge of high availability, clustering, mirroring, and failover technologies.
• Strong T-SQL development and query optimization skills.
• Experience installing, upgrading, patching, and migrating SQL Server databases.
• Experience working in Windows Server environments.
• Experience supporting large/high-volume SQL Server databases.
• Experience diagnosing blocking, deadlocks, and performance issues.
• Experience with Azure or other cloud database technologies.
• Ability to communicate effectively using technical requirements and design documentation.

Responsibilities

• Administer and support enterprise Microsoft SQL Server and cloud database environments.
• Monitor databases to maintain availability, performance, and reliability.
• Troubleshoot database and application issues involving connectivity, access, security, and performance.
• Diagnose and resolve SQL Server performance issues, including long-running queries, blocking, and deadlocks.
• Perform SQL Server installation, configuration, upgrades, patching, and database migrations.
• Support SQL Server high-availability environments, including clustering, mirroring, and failover configurations.
• Write, review, and optimize complex Transact-SQL (T-SQL) queries and scripts.
• Tune database workloads and optimize indexes, queries, and resource utilization.
• Support very large databases and analyze workload performance and resource contention.
• Use tools such as Query Store, Extended Events, and wait-statistics analysis for performance troubleshooting.
• Review and improve existing database processes and maintenance procedures.
• Use operating-system scripting utilities to support database maintenance, diagnostics, and troubleshooting.
• Review existing database implementations and recommend or implement improvements.
• Apply database modeling principles to support effective database design.
• Collaborate with engineering, operations, application, and infrastructure teams.
• Create and maintain technical requirements, design artifacts, and database documentation.
• Participate in application and help desk support activities as required.

Skills

SQL Server Administration

Performance Tuning

High Availability

T-SQL Development

Windows Server

Azure Cloud

Database Migration

Query Store / Extended Events

Tools

Query Store

Extended Events

Wait-Statistic Analysis

Mirroring / Clustering

SSIS / SSAS / SSRS

Database Upgrades

Job description

DKMRBH Inc. seeks a Senior MS SQL Database Administrator to manage enterprise SQL Server and cloud databases, ensuring availability, performance, and reliability.

You will troubleshoot issues, implement migrations, and optimize queries while supporting disaster recovery, high-availability configurations, and automation tooling. You will collaborate with engineering, operations, and infrastructure teams, document technical requirements, and participate in help desk tasks as needed.