Senior SQL Server Database Administrator

UDR Consulting Inc•Charleston, WV

5d•Onsite

About The Position

UDR is seeking qualified candidates for a Senior SQL Server Database Administrator opportunity in Charleston, West Virginia. This role involves architecting, configuring, and installing scalable Microsoft SQL Server database modules, data models, and process flows. The position requires advanced query optimization, indexing strategies, and database performance baseline tuning. Additionally, the role includes designing and implementing robust backup/restore strategies and high-availability solutions like Always On Availability Groups. The Senior SQL Server Database Administrator will also maintain cloud-based database environments, specifically Azure SQL Managed Instances, Azure Storage, and hybrid database environments. Responsibilities also encompass establishing secure data access controls, administering encryption, conducting compliance audits, and writing scripts (PowerShell, Python, or T-SQL) to automate routine administrative tasks and system patching. Collaboration with application developers, infrastructure teams, and project managers, often within Agile/Scrum frameworks, is expected, along with mentoring junior database technicians.

Requirements

Microsoft SQL Server (multiple versions) and Azure SQL/Managed Instance.
Expert level knowledge of Execution Plans, Profiler, Extended Events, and DMVs.
Deep familiarity with Windows Server, Storage Area Networks (SAN), and active directory security concepts.
High proficiency in T-SQL, PowerShell, and shell scripting.
Minimum of five years of experience with the operation, maintenance, and implementation of Microsoft SQL Server database (SQL Server 2008 and higher).
Proficiency in T-SQL and package creation (stored procedures) and utilization.
Minimum of five years of experience with the creation of databases and database primary objects in SQL Server.
Minimum of five years of experience migrating prior versions of SQL Server to SQL Server 2012 on Windows servers, including the conversion of DTS packages to SSIS.
Minimum of five years of experience installing, implementing, and monitoring SSIS and SSAS for SQL Server 2008.
Minimum of five years of experience in command line Data Definition Language (DDL) operations and scripting.
Minimum of five years of experience in backup and recovery of SQL Server databases.

Nice To Haves

Python scripting is highly preferred.
Developing ETL workflows using SQL Server Integration Services (SSIS) or Azure Data Factory.
Creating dashboards and monitoring metrics via Power BI or SQL Server Reporting Services (SSRS).
Experience integrating data platforms with CI/CD pipelines and utilizing Infrastructure as Code (IaC).
Microsoft Certified: Azure Database Administrator Associate or legacy MCSE Data Management and Analytics.

Responsibilities

Architecting, configuring, and installing scalable Microsoft SQL Server database modules, data models, and process flows.
Conducting advanced query optimization, indexing strategies, and database performance baseline tuning.
Designing and implementing robust backup/restore strategies and high-availability solutions like Always On Availability Groups.
Maintaining cloud-based database environments, specifically Azure SQL Managed Instances, Azure Storage, and hybrid database environments.
Establishing secure data access controls, administering encryption, and conducting compliance audits.
Writing PowerShell, Python, or T-SQL scripts to automate routine administrative tasks and system patching.
Partnering with application developers, infrastructure teams, and project managers—frequently within Agile/Scrum delivery structures—while mentoring junior database technicians.