Senior SQL Server Database Administrator

UDR Consulting; Charleston (WV); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

paid time off

medical

dental

life

vision

disability insurance

a pre-tax 401 (k) retirement account

Job summary

UDR Consulting in Charleston, West Virginia seeks a Senior SQL Server Database Administrator to design, install, and optimize Microsoft SQL Server environments, including Azure SQL Managed Instance. You’ll collaborate with developers and operations in an Agile/Scrum setting to ensure reliability and scalability.

Key duties: performance tuning, HADR, cloud/hybrid management, security, and automation with PowerShell, T-SQL, or Python.

Qualifications

• Minimum five years of experience with Microsoft SQL Server operations, maintenance, and upgrades (SQL Server 2008+).
• Proficiency in T-SQL and stored procedures.
• Experience migrating SQL Server versions and handling DTS to SSIS transitions.
• Experience installing, configuring, and monitoring SSIS/SSAS/SSRS for SQL Server 2008.
• Strong backup and recovery expertise for SQL Server environments.

Responsibilities

• Database Architecture & Design: Architecting, configuring, and installing scalable Microsoft SQL Server modules and data models.
• Performance Tuning: Advanced query optimization, indexing strategies, and baseline tuning.
• HADR: Designing robust backup/restore and high-availability solutions like Always On.
• Cloud & Hybrid Management: Managing Azure SQL Managed Instances, Azure Storage, and hybrid databases.
• Security & Compliance: Establishing data access controls, encryption, and audits.
• Automation: Writing PowerShell, Python, or T-SQL scripts to automate tasks.
• Collaboration & Leadership: Partnering with developers, infrastructure teams, and project managers in Agile/Scrum; mentoring juniors.

Skills

Microsoft SQL Server

Azure SQL/Managed Instance

Query optimization

Execution Plans

Profiler

Extended Events

DMVs

PowerShell

T-SQL

Python

Tools

SSIS

SSAS

SSRS

Azure Data Factory

CI/CD pipelines

IaC

PowerShell

Job description

UDR is seeking qualified candidates for a Senior SQL Server Database Administrator opportunity in Charleston, West Virginia.

Description

Core Responsibilities

• Database Architecture & Design: Architecting, configuring, and installing scalable Microsoft SQL Server database modules, data models, and process flows.
• Performance Tuning: Conducting advanced query optimization, indexing strategies, and database performance baseline tuning.
• High Availability & Disaster Recovery (HADR): Designing and implementing robust backup/restore strategies and high-availability solutions like Always On Availability Groups.
• Cloud & Hybrid Management: Maintaining cloud-based database environments, specifically Azure SQL Managed Instances, Azure Storage, and hybrid database environments.
• Security & Compliance: Establishing secure data access controls, administering encryption, and conducting compliance audits.
• Automation: Writing PowerShell, Python, or T-SQL scripts to automate routine administrative tasks and system patching.
• Collaboration & Leadership: Partnering with application developers, infrastructure teams, and project managers-frequently within Agile/Scrum delivery structures-while mentoring junior database technicians.

Technical Skills & Qualifications

Required Core Skills

• Database Platforms: Microsoft SQL Server (multiple versions) and Azure SQL/Managed Instance.
• Performance Optimization: Expert level knowledge of Execution Plans, Profiler, Extended Events, and DMVs.
• Infrastructure Knowledge: Deep familiarity with Windows Server, Storage Area Networks (SAN), and active directory security concepts.
• Scripting languages: High proficiency in T-SQL, PowerShell, and shell scripting (Python is highly preferred).

Preferred Experience & Tools

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

Minimum Experience Requirements

• Senior SQL Server Database Administrator must have a minimum of five years of experience with the operation, maintenance, and implementation of Microsoft SQL Server database (SQL Server 2008 and higher). This experience must include the candidate being proficient in T SQL and package creation (stored procedures) and utilization.
• Senior SQL Server Database Administrator must have a minimum of five years of experience with the creation of databases and database primary objects in SQL Server.
• Senior SQL Server Database Administrator must have a minimum of five years of experience migrating prior versions of SQL Server to SQL Server 20 I 2 on Windows servers. This must include the conversion of DTS packages to SSIS.
• Senior SQL Server Database Administrator must have a minimum of five years of experience installing, implementing, and monitoring SSIS and SSAS for SQL Server 2008.
• Senior SQL Server Database Administrator must have a minimum of five years of experience in command line Data Definition Language (DDL) operations and scripting.
• Senior SQL Server Database Administrator must have a minimum of five years of experience in backup and recovery of SQL Server databases.

UDR Consulting, INC is a Service-Disabled Veteran-Owned, Woman-Owned, Minority-Owned, Small Disadvantaged Business. An Equal Opportunity Employer that considers all qualified applicants for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, protected Veterans, or individuals with disabilities. UDR also supports a drug-free work environment.

UDR offers highly competitive salaries and employee benefit packages structured to best suit your needs.

• paid time off
• medical
• dental
• life
• vision
• disability insurance
• a pre-tax 401 (k) retirement account with Company matching contributions and 100% vesting for eligible participants beginning DAY 1