Location: COLUMBIA SC (In Person Interview required)
Duration: 6 months
Positions: 1
SCOPE OF THE PROJECT: 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.
DAILY DUTIES / RESPONSIBILITIES:
1. Under the direction of the SLICE Project Manager maintain the data
design documents and data stores for SLICE.
2. Work with SLICE Project Manager to develop ETL procedures for any
data sources to be loaded into SLICE.
3. Using SQL Reporting Services and SQL Analysis Services to develop
scripts to generate report output from the Longitudinal Data Warehouse.
4. Work with the SLDS team to design data models and develop content
for the data warehouse.
5. Coordinate with other DBAs on staff to ensure SLICE data models are
in sync with data models for SCEDS II.
6. At the direction of the SLICE Project Manager, work with the EEDA
Data Manager.
7. Work with the SLDS Data Warehouse Core Team on all tasks as
assigned by the SLICE Project Manager.
8. Maintain up-to-date documentation on all data stores assigned.
9. Provide status reports as defined by the SLICE Project Manager.
10. Work not to exceed 40 hours per week per consultant.
11. The work performed will be primarily conducted at SCDE facilities
located in Columbia, S. C.
12. Knowledge of SQL versions 2003 – 2008 is expected.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
It is expected this person has 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.
Knowledge of SharePoint will be essential for this consultant to work on SLICE as well as knowledge and experience with XML.
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE): Knowledge of public education and South Carolina Department of Education's mission, programs and objectives as well as FERPA compliance is helpful.
REQUIRED EDUCATION: Bachelor’s Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
First round interviews will be by phone, but finalist will be expected to interview in person for second round of interviews. Travel expenses will not be paid.
No comments:
Post a Comment