The Microsoft SQL Server Database Administrator role requires over 6 years of hands-on experience to support and manage SQL Server environments on-premises and within Microsoft Azure. Core responsibilities include daily database operations, performance tuning, backup and recovery, security management, patching, migrations, and process automation.
Required Technical Skills
- Administration of Microsoft SQL Server 2016, 2019, 2022, and 2025.
- Support for Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual machines.
- Proficiency with SSMS, T-SQL, PowerShell, SQL Server Agent, Query Store, DMVs, Extended Events, execution plans, and performance troubleshooting.
- Management of Always On Availability Groups, Windows clustering, log shipping, replication, backups, restore, disaster recovery, and database refreshes.
- Execution of SQL Server installations, configurations, patching, version upgrades, and migrations (both side-by-side and to the cloud).
- Implementation of database security, TDE, access management, auditing, vulnerability remediation, and operational controls.
- Use of monitoring and observability tools like Foglight alongside native SQL Server monitoring.
- Working knowledge of ServiceNow processes, including incident, request, change, problem, CMDB, and asset management.
- Automation experience utilizing PowerShell, T-SQL, Ansible, and Azure tooling.
Additional Requirements
- Strong skills in troubleshooting, documentation, and communication.
- Ability to work independently while collaborating with global technical and application teams.
- Capacity to support US business hours and participate in on-call or after-hours coverage schedules.
- Preference for candidates with experience in financial services or other regulated environments.
- Advantageous to have basic knowledge of other database platforms like Azure Cosmos DB.