SQL Server DBA with ETL, ODS, Analysis Services, Reporting Services, SQL Query Manager, SharePoint, FERPA and public education/Government Experience

IN4496-1

SQL Server DBA with ETL, ODS, Analysis Services, Reporting Services, SQL Query Manager, SharePoint, FERPA and public education/Government Experience

Location:Columbia, SC 

Duration: 3 months

Positions: 1

Description:

Our SLICE data warehouse relies on SQL scripts for data loads and data validation. We rely on SQL Reporting Services for much of the data presentation. An experienced DBA is needed to support this development and database management work. A Database Administrator will be provided to assist the South Carolina Department of Education’s (SCDE) programming staff with the development of operational data stores (ODS) that will be used to feed data to SLICE (South Carolina Longitudinal Information Center for Education). Development of these data stores will include designing data models for each data store as well as coding the SQL scripts that will be used to build each data store. This DBA will be expected to understand how to connect SQL scripts to SharePoint 2010. 

RESPONSIBILITIES & DUTIES: 

1.Design, implement and test data model(s) for the data warehouse.

2.Develop ETL procedures and scripts for SLICE data sources. 

3.Research and recommend ETL tools and procedures to be used to support SLICE project.

4.Maintain the data design documents and data stores for SLICE. 

5.Coordinate with Developers to ensure SLICE data models are in sync with data models elsewhere in the agency. 

REQUIRED SKILLS: 

6+ years of relational database and SQL Server experience as well equal number of years experience with development tools MS Analysis Services, MS Excel and SQL Query Manager. Five years of SQL Server 2005/2008 experience is a must. Must have current experience using SQL Server Reporting Services and SQL Server Analysis Services

PREFERRED SKILLS:

Knowledge of public education and South Carolina Department of Education's mission, programs and objectives as well as FERPA compliance is helpful

skill:

MSQL

Relational Database Experience

SQL Server

Data Modeling

Data Warehousing

Additional Skills:

ETL skills and knowledge of ETL tools

Posted via email from innoSoul's posterous