SQL Server DatabaseAdministrator - Tallahassee, United States - SGS Technologie

Description

Position Title: SQL Server DBA

Location: Tallahassee, FL

Contract: 12+ months contract

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 Divisions SERT Trac application.
• maintenance support for the Divisions 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