Database Administrator

DUTIES AND RESPONSIBILITIES

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 Job Details Description

DUTIES AND RESPONSIBILITIES

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 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 a rotating 24×7 support schedule. Qualifications & Experience 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 a rotating after‑hours support schedule.

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)

SPECIAL WORKING CONDITIONS:

This position requires participation in a rotating after‑hours support schedule to assist with scheduled maintenance windows and emergency database incidents. Employees working in an administrative role who are Medic‑certified EMT/EMT‑P may be considered essential personnel depending on circumstances. Interested applicants must ensure completion of the following steps NO LATER THAN JULY 24TH 2026 to be considered for the position. Complete the online application and upload a resume in the UKG recruitment portal.

SALARY RANGE.

$43.22 - $58.65/hr If you have any further questions please contact MEDIC Recruitment at View email address on click.appcast.io #J-18808-Ljbffr Mecklenburg EMS Agency (Medic)