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 

• Database administration related projects, as needed 

• 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: 

• 6-8 years SQL Server experience, with 2+ years SQL Server development experience, 3+ years in Database Administration 

• Bachelor’s degree in Computer Science or related major 

• SQL Server 2016 and 2019 experience required.  

• Experience with Azure 

• 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 

• Excellent problem solving and effective research skills 

• Dedication and willingness to work some alternative schedules as necessary 

• Effective verbal and written communication skills 

• Self-motivated with the ability to work as part of a team or independently 

• Experience supporting enterprise level production systems in a fast-paced, high availability server environment 

Desired Qualifications: 

• Experience in PostgreSQL is a plus