Previous Job
Previous
SQL SERVER DBA
Ref No.: 16-00032
Location: columbia, South Carolina
Position Type:Contract
Start Date / End Date: 10/17/2016 to 10/24/2016
SCOPE OF THE PROJECT:

The SC Department of Education has several projects currently running and ongoing operational work that have an immediate need for a Database Administrator with a background in SQL Server technologies (SQL Server 2008/2012/2014/2016) and SSIS and MS SQL. This position is responsible for working with SCDE's Data Management team to review and assess the quality of data, and to work with data warehouses. Prepare large and small data sets for research and evaluations. Works as part of a team to develop and implement projects to improve the operation and service delivery of the Department and to accomplish the goals and objectives of public education.

DAILY DUTIES / RESPONSIBILITIES:
1. Development and maintenance of database procedures, reports, and automated jobs. Enhancement of existing database functions based on new/changing business requirements.
2. Report, research, correct, and test defects in reports, stored procedures, and other database related functions. Accurately translate business requirements into functional implementations.
3. Evaluate data quality in databases and across the data warehouse as well as against the extract, transfer, and load (ETL) workflow. Identify, analyze, and interpret trends or patterns in complex data sets. Design, document, maintain, execute system tests and requirements around data and data quality.
4. Identify and leverage opportunities to improve data management processes, systems, and standards.
5. Other duties as assigned.
6. Report progress weekly to management and project manager.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
SQL SERVER EXPERIENCE
BACKUP / RECOVERY OPERATION
DATABASE PLANNING AND DESIGN
DATABASE MONITORING / PERFORMANCE TUNING
LOAD BALANCING
DATABASE UPGRADING
REDGATE TOOLSETS

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
FAMILIARIZATION WITH SQL TOOL SETS
SHAREPOINT SERVER KNOWLEDGE
SQL REPORTING SERVICE

REQUIRED EDUCATION/CERTIFICATIONS: NONE

PREFERRED EDUCATION/CERTIFICATIONS: MCA, MCSA, MCSE