What are the responsibilities and job description for the Database Administrator position at Mecklenburg EMS Agency?
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 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 jobs@medic911.com
Salary : $43 - $59