Database Administrator

Mecklenburg Ems Agency
Charlotte, NC, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$89,898.0
Working hours
Regular working hours
Job source

Tech stack

Sql Server Data Tools (SSDT) Microsoft Windows Active Directory Microsoft Azure Backup Devices Information Systems Databases Continuous Integration Data Centers Data Infrastructure Database Security DevOps
+32 more
Disaster Recovery Failover Failover Clustering Liquibase Microsoft SQL Server SQL Azure Windows Servers Performance Tuning Windows PowerShell Query Optimization Azure Active Directory SQL Databases SQL Server Reporting Services SQL Server Agent SQL Server Integration Services SQL Server Analysis Services Transact-SQL Virtualization Technology Backup and Restore Diagnostic Tools System Availability Indexer Git Information Technology SolarWinds (Software) Sentry Redgate SQL Server Management Studio (SSMS) Database Monitoring Veeam Software Version Control Vmware

Job description

SQL Server Administration & Infrastructure

  • Install, configure, patch, and maintain SQL Server (2016, 2019, 2022) in a VMware-based, on-prem environment
  • Administer Failover Cluster Instances (FCI) and Always On Availability Groups
  • Partner with infrastructure teams on VM sizing, storage (VMDK/RDM), and HA/vMotion compatibility
  • Monitor system health, performance, and uptime across all environments

Performance & Capacity Management

  • Monitor and tune performance using SSMS, Query Store, Extended Events, DMVs, and execution plans
  • Troubleshoot query issues, blocking, deadlocks, and resource contention
  • Manage indexing, statistics, and maintenance plans
  • Conduct capacity planning for CPU, memory, and storage in coordination with infrastructure teams

Backup, Recovery & Disaster Recovery

  • Design and maintain backup strategies (full, differential, transaction logs) aligned with RPO/RTO
  • Perform and validate routine database restores
  • Maintain and test DR processes, including AG and FCI failover/failback
  • Coordinate SQL-aware backups with VMware snapshot tools (e.g., Veeam)

Security & Compliance

  • Implement security features (TDE, Always Encrypted, row-level security, auditing)
  • Manage access controls following least privilege principles
  • Integrate with Active Directory and Azure AD (Entra ID)
  • Ensure compliance with HIPAA, internal policies, and audit requirements
  • Remediate vulnerabilities identified through scans and audits

Automation & Job Management

  • Develop T-SQL and PowerShell scripts to automate DBA tasks
  • Manage SQL Server Agent jobs (backups, DBCC, indexing, alerts, reporting)
  • Standardize configurations across environments
  • Support database deployments via CI/CD tools (e.g., SSDT, Flyway, Liquibase)

Documentation & Collaboration

  • Maintain documentation for configurations, processes, and runbooks
  • Participate in change management and after-hours deployments
  • Collaborate with infrastructure, networking, security, and application teams
  • Provide Tier 2/3 support and participate in 24×7 on-call rotation

Requirements

Do you have experience in Windows?, * Bachelor’s degree (B.A. or B.S.) in Computer Science, Information Systems, or a related field

  • Relevant technical certification in Microsoft SQL Server or equivalent preferred
  • Minimum 5 years of hands-on Microsoft SQL Server administration in a production environment
  • Experience with Always On Availability Groups and/or Windows Server Failover Clustering
  • Experience supporting SQL Server in a VMware-virtualized environment
  • Proficiency with T-SQL, SQL Server Agent, SSMS, and performance tuning tools (Query Store, Extended Events, DMVs, execution plans)
  • Experience with backup and recovery strategies, including transaction log management
  • Working knowledge of Windows Server and Active Directory
  • Experience with PowerShell scripting for automation
  • Understanding of database security practices (user/role management, TDE, auditing)
  • Strong organizational skills with the ability to manage multiple priorities independently
  • Effective communication skills with both technical and non-technical stakeholders
  • Ability to work in a fast-paced healthcare environment and participate in an on-call rotation

SPECIALIZATION

  • Deep expertise in SQL Server performance tuning and optimization using advanced diagnostics and troubleshooting tools
  • Advanced implementation and support of high availability architectures, including Always On Availability Groups and Failover Cluster Instances
  • Hands-on experience optimizing SQL Server workloads within VMware environments, including VM sizing, storage configuration, and HA/DRS alignment
  • Advanced T-SQL development for performance-critical database objects and query optimization

CERTIFICATIONS

  • Microsoft Certified: Azure Database Administrator Associate (DP-300)
  • VMware Certified Professional - Data Center Virtualization (VCP-DCV) or equivalent certification
  • Experience with SQL Server data platform tools, including SSIS, SSRS, and SSAS
  • Experience with database monitoring tools (e.g., SolarWinds DPA, SentryOne SQL Sentry, Redgate SQL Monitor)
  • Exposure to Azure SQL Managed Instance or Azure Arc-enabled SQL Server environments
  • Experience with database DevOps and source control practices (e.g., SSDT, Git, Flyway, Liquibase)

Benefits & conditions

4425 Wilkinson Boulevard, Charlotte, NC 28208, Hybrid work From $43.22 an hour, Interested applicants must ensure completion of the following steps NO LATER THAN JUNE 11TH 2026 to be considered for the position.

  • Complete the online application and upload a resume in the UKG recruitment portal.

SALARY RANGE. Starting at $43.22/hour, with higher compensation based on experience and qualifications.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:22 min

Overview of the Sentry error and performance monitoring platform

Priscila Oliveira · WWC 2023

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

2:47 min

Exploring career opportunities and recruitment open positions

Kurt Eder · LIVE

3:21 min

Installing and configuring the Sentry JavaScript SDK for applications

Priscila Oliveira · WWC 2023

Videos

See all

Related articles

See all