MS-SQL Database Administrator

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