Senior SQL Server Database Administrator

udrconsultingincorporated; Charleston (WV); On-site; USD 110,000 - 140,000; Full time

Job summary

UDR Consulting, INC in Charleston, West Virginia, seeks a Senior SQL Server Database Administrator to lead architecture, design, and administration of SQL Server environments.

Responsibilities include performance tuning, high availability planning (Always On), cloud/hybrid management (Azure SQL Managed Instance), security and automation with PowerShell, Python, and T-SQL. You will mentor junior DB technicians and collaborate with Agile teams to deliver reliable data platforms.

Qualifications

• 5+ years of experience in SQL Server administration.
• Proficient in T-SQL and stored procedures.
• Experience migrating SQL Server across versions and DTS to SSIS.
• Experience with SSIS/SSAS/SSRS.
• Backup and recovery expertise.

Responsibilities

• Architect and design scalable SQL Server database modules.
• Optimize queries and indexing for performance.
• Design and implement HADR backups and high availability.
• Manage Azure SQL Managed Instances and hybrid environments.
• Automate tasks with PowerShell, Python, or T-SQL.
• Mentor junior DB technicians and coordinate with Agile teams.

Skills

SQL Server

Azure SQL

PowerShell

T-SQL

Python

Shell scripting

Tools

SSIS

SSAS

SSRS

Azure Data Factory

SQL Server Management Studio

Job description

Senior SQL Server Database Administrator - Charleston, West Virginia

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

Description

• 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

• 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.

Core 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. We offer multiple individual and family benefit options including paid time off, medical, dental, life, vision, and disability insurance, and a pre-tax 401 (k) retirement account with Company matching contributions and 100% vesting for eligible participants beginning DAY 1.