Job Description :
SQL Server DBA (MCA/MCSA/MCSE) with backup/recovery, tuning, load balancing, upgrade, RedGate, SharePoint, DMV/DTA, PerfMon/Profiler, SAC/SSCM/SSMS and SSRS/SSAS/SSIS experience

Location: Columbia SC
Qty: 2
Duration: 9 Months

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

SCOPE OF THE PROJECT:
The SC Department 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.

Experience
Database Platforms backup/recovery Yes 8 Intermediate Within 6 Months 2 - 4 Years
Database Platforms Database Upgrades Yes 6 Intermediate Within 1 Year 2 - 4 Years
Database Platforms Load Balancing Yes 7 Intermediate Within 1 Year 2 - 4 Years
Database Platforms MS SQL Server 2012 Yes 8 Intermediate Within 6 Months 2 - 4 Years
Database Platforms RedGate Toolset Yes 6 Intermediate Within 1 Year 1 - 2 Years
Database Platforms SQL Server Yes 9 Intermediate Within 6 Months 4 - 6 Years
Database Platforms SQL Server Analysis Services ( SSAS) Yes 8 Intermediate Within 6 Months 2 - 4 Years
Database Platforms SQL Server tools: system sprocs Yes 8 Intermediate Within 6 Months 2 - 4 Years
Database Platforms SQL Tuning Yes 8 Intermediate Within 6 Months 2 - 4 Years
Database Platforms Strong background in database planning, scaling, and capacity planning activities Yes 9 Intermediate Within 6 Months 4 - 6 Years
Database Platforms MS SharePoint No 4 Entry Within 2 Years 1 - 2 Years
Database Platforms MS SQL Server 2014 No 7 Intermediate Within 6 Months 1 - 2 Years
Database Platforms Sharepoint 2010 No 5 Intermediate Within 6 Months 1 - 2 Years
Database Platforms SharePoint Server 2013 No 5 Intermediate Within 6 Months 1 - 2 Years
Database Platforms SQL Server Dynamic Management Views (DMV) No 4 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server Integration Services (SSIS) No 5 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server Reporting Services (SSRS) No 4 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: DMVs No 4 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: DTA No 4 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: PerfMon No 6 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: Profiler No 5 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: SAC No 5 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: SSCM No 5 Intermediate Within 1 Year 2 - 4 Years
Database Platforms SQL Server tools: SSMS No 5 Intermediate Within 1 Year 2 - 4 Years

Background Checks:
Criminal Record - 7 Year History Candidate Confirmation
E-Verify Candidate Confirmation
Credit Report - 7 Year History Candidate Confirmation

Client : State of South Carolina