<p><p><b>Description :</b> </p><p><br/></p><p>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 :</b></p><br/><p>- Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high levels of performance, availability and security</p><br/><p>- Troubleshoot and resolve performance issues</p><br/><p>- SQL Server performance tuning, including analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies</p><br/><p>- Database backup management and recovery</p><br/><p>- Database administration related projects, as needed</p><br/><p>- 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</p><br/><p>- Create requested database objects and assist with production releases</p><br/><p><b>Qualifications :</b></p><br/><p>- 4-6 years SQL Server experience, with 2+ years SQL Server development experience, 3+ years in Database Administration</p><br/><p>- Bachelors degree in Computer Science or related major</p><br/><p>- SQL Server 2016 and 2019 experience required.</p><br/><p>- Experience with Azure</p><br/><p>- Extensive experience writing SQL queries and stored procedures</p><br/><p>- Experience optimizing queries and database objects, including advanced skills in index design and maintenance</p><br/><p>- Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups</p><br/><p>- Experience with encryption including TDE and Always Encrypted</p><br/><p>- Experience with monitoring tools such as SQL Monitor, Zabbix, SolarWinds, Idera, System Center</p><br/><p>- Excellent problem solving and effective research skills</p><br/><p>- Dedication and willingness to work some alternative schedules as necessary</p><br/><p>- Effective verbal and written communication skills</p><br/><p>- Self-motivated with the ability to work as part of a team or independently</p><br/><p>- Experience supporting enterprise level production systems in a fast-paced, high availability server environment</p><br/><p><b>Desired Qualifications :</b></p><br/><p>- Experience in PostgreSQL is a plus</p><br/></p> (ref:hirist.tech)