SQL DBA

We're seeking a Database Administrator to manage and support SQL Server databases on mission-critical high volume OLTP production systems. The ideal candidate will possess some database development background as well as current experience as a production SQL Server database administrator. The role requires a proactive and self motivated individual, who is willing to take an idea, groom it into a well defined user story, and see through the implementation. 

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