MS-SQL Database Administrator

Job Description

Responsibilities: Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high levels of performance, availability and security Troubleshoot and resolve performance issues SQL Server performance tuning, including analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies Database backup management and recovery Respond to critical and non-critical production alerts, and availability to be on an on-call rotation schedule to provide production support when critical issues arise will be required Create requested database objects and assist with production releases Qualifications: 4-6 years of experience as SQL DBA SQL Server 2016 and 2019 experience required. Extensive experience writing SQL queries and stored procedures Experience optimizing queries and database objects, including advanced skills in index design and maintenance Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups Experience with encryption including TDE and Always Encrypted Experience with monitoring tools such as SQL Monitor, Zabbix, SolarWinds, Idera, System Center