DUTIES AND RESPONSIBILITIES
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
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 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)
SPECIAL WORKING CONDITIONS: After-hours availability is required for scheduled maintenance windows, emergency database incidents, and participation in the IT on-call rotation. 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 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.
If you have any further questions please contact MEDIC Recruitment at ...