Database Administrator - Expert

Provide a short description of the Position

This position is for a Database Administrator - Expert level who provides technical and operational support for NYS agencies with job duties such as installing, patching and upgrading SQL Server; providing operational support; implementing backups and recovery; performing resource planning and performance tuning etc.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate: 1. Install, configure, administer, and manage MS SQL Server databases including high availability and disaster recovery configurations. 2. Assist in Developing and implementing appropriate high availability and disaster recovery solutions. 3. Perform regular backups and ensure recovery solutions are in place and regularly kept updated utilizing approved ITS/MSSQL team approved backup tools. 4. Monitor performance of database servers, listeners and other related processes, optimize performance of databases, tune applications, server resources – CPU, memory, storage, network, etc. 5. Ensure appropriate security protocols in line with ITS guidelines and known best practices are in place, patches are applied on all database environments 6. Perform capacity planning and storage space management. 7. Create and maintain documentation for all major installation and implementation 8. Explore, actively support and work on new technology initiatives, much beyond the database world that may be of interest to the Organization 9. Actively participate and contribute in troubleshooting and alleviating any issues that group may have. 10. Actively take a lead in analyzing SQL database performance issues. 11. Provide production support including off hour support and help application debugging 12. Interact with database vendors for Support and resolution of issues