Information Technology - SQL Server Database Administrator 130-2067

About the role

The SQL Server Database Administrator is responsible for managing, securing, optimizing, and modernizing a hybrid Microsoft data platform, supporting SQL Server running on virtual machines, Azure SQL Managed Instance, and Azure SQL Database.

Responsibilities

• Administer SQL Server environments hosted on virtual machines, Azure SQL Managed Instance, and Azure SQL Database across production and nonproduction workloads.
• Install, configure, patch, upgrade, and maintain SQL Server instances and related database services.
• Design, implement, test, and document backup, restore, high-availability, and disaster-recovery solutions aligned with business recovery objectives.
• Monitor database health, capacity, availability, and performance; troubleshoot blocking, deadlocks, query regressions, resource contention, and connectivity issues.
• Optimize queries, indexes, statistics, execution plans, storage, compute, and service tiers to improve performance and control cost.
• Implement database security controls, including least-privilege access, role-based permissions, encryption, auditing, vulnerability remediation, and secrets management.
• Automate recurring administration, monitoring, deployment, and maintenance tasks using T-SQL, PowerShell, Azure Automation, or equivalent tools.
• Plan and execute database migrations and modernization initiatives among SQL Server on Azure virtual machines, Azure SQL Managed Instance, and Azure SQL Database.
• Partner with application, cloud infrastructure, security, data governance, data engineering, and business intelligence teams on solution design, release planning, incident response, and capacity forecasting.
• Maintain operational documentation, runbooks, architecture diagrams, standards, and change records; participate in an on-call support rotation as required.
• Perform other job-related duties as required or assigned.

Requirements

• Working knowledge of SQL Server 2025 AI features including semantic search, RAG, NLP, and SSMS CoPilot.
• Demonstrated knowledge with SQL Server on virtual machines, Azure SQL Managed Instance, and Azure SQL Database.
• Advanced proficiency in T-SQL, database performance tuning, indexing, backup and recovery, high availability, disaster recovery, security, monitoring, capacity management, and maintenance of SQL Server and related services in virtual machine environments.
• Ability to support business-critical production databases and lead complex incident troubleshooting through resolution.
• Strong written and verbal communication skills, sound change-management practices, and the ability to collaborate across technical and business teams.
• Successful completion of Health Care Sanctions background check.

Qualifications

• Bachelor’s degree in information technology, computer science, or business information systems.
• A current Azure Database Administrator Associate certification.
• A minimum of seven years of professional database administration experience in enterprise environments.
• A minimum of three years of hands-on experience administering SQL Server data platforms in Microsoft Azure.
• Experience operating and supporting data integration solutions with Azure Data Factory preferred.
• Experience with Azure Synapse Analytics, including dedicated or serverless SQL workloads preferred.
• Experience with Microsoft Fabric, including OneLake, lakehouses, and Fabric Data Warehouse preferred.
• Experience administering Power BI environments, including gateways, semantic models, refresh schedules, access controls, capacity, monitoring, and governance preferred.
• Experience with infrastructure as code, source control, CI/CD pipelines, and automated database deployment practices preferred.
• Experience supporting regulated, security-sensitive, or highly available enterprise environments and industries such as Healthcare, Financial Services, or Oil and Gas preferred.
• Experience with other RDBMS platforms such as Oracle, PostgreSQL, or MongoDB preferred.