Innovations technological

Role: Sr. SQL Developer

Location:- Columbia - SC

Duration: 3+ Months

 

Interview: Phone hire

 

Need senior candidate. No OPT

 

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 Summary Details Candidates Notes 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. 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 (RANK IN ORDER OF IMPORTANCE): 

• Six 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 (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




--
Regards,
Vishal
cyberThink Inc.
Tel:-877-223-7153 x 561
Vishal.Vaghela@cyberthink.com

--
You received this message because you are subscribed to the Google Groups "softwarejobs_US" group.
To post to this group, send email to softwarejobs_us@googlegroups.com.
To unsubscribe from this group, send email to softwarejobs_us+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/softwarejobs_us?hl=en.