SQL Server DatabaseAdministrator

Responsibilities:

monitor the database environment and make changes to data structures, SQL, application logic or the database management system (DBMS) subsystem to optimize performance.
SQL and host language and recommend changes for optimization and enhancements for mission critical applications.
debug, implement, and maintain stored procedures, triggers, and user defined functions that are stored in the DBMS.
that only authorized users have access to data, requiring the vendor to ensure the integrity of existing application database security for production and test databases while identifying where application security infrastructure can be improved.
that databases and supporting application data are available and provide corrective measures for situations when data file pulls from other State Agencies are not provided or executed properly.
Division staff in the creation of standard operating guides outlining DBMS maintenance requirements, SQL jobs, stored procedures and debugging solutions for mission critical applications.
code development and cloud migration of the Division’s SERT Trac application.
maintenance support for the Division’s SWO Incident Tracker application.

Required Skills:

years MS SQL Server Administration experience required
Directory experience
Hosted Services Experience
with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
with backups, restores and recovery models
of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
to create SQL jobs for transfer of data across networks
working with Windows server, including Active Directory
written and verbal communication
Flexible, team player, “get-it-done” personality