[ASP_NET_jobs] Need Sr SQL Server Database Specialist - Harrisburg, PA

Hi Partners,

 

Greetings,

 

Hope you are doing Well!!!!!!!!!!!!!!!

 

Please forward a profiles to shankar@techconsultinc.com

 

Here are the requirement details

 

Title : Sr SQL Server Database Specialist
Location – Harrisburg, PA
Start – November 19th [flexible]
Duration – 3 months+



Position to be filled: SQL Server Database Specialist

The SQL Server Database Specialist position will report to the Director of System Research. The System Research Office has technical responsibilities regarding creation, modification and execution of transformation and load packages to transport data from the fourteen universities to the data warehouse for enterprise-wide decision support.
The primary responsibility of this position is the loading of university data submissions into local database servers and resolution of load issues .
 

Statement of Work:

Need an SQL Server database specialist to migrate data from different environments into an SQL Server environment utilizing DTS package
design and SQL Server Integration Services (SSIS) in the transformation and load process.


Tasks:

• Modify and execute DTS and SSIS packages.
• Work with team members to analyze and debug design and programming anomalies as required
• Document development processes/procedures
• Interact with staff as well as other in-house technical liaisons for data problem resolution

 
MANDATORY REQUIREMENTS

• Bachelor's degree or 5 years' related experience required.
• Experience with Microsoft SQL Server database development.
• Experience with Microsoft Data Transformation Services (DTS).
• Experience with Microsoft SQL Server Integration Services (SSIS)
• 3 to 4 years of database experience preferred.
• Must have at least 3 years of experience with Microsoft SQL Server.


Requisite Skills

• Experience working with database-related technologies, including relational and dimensional database modeling.
• Experience in SQL Server Databases required.
• Additional experience on Oracle preferred.
• Experience in Higher Education working environment is a plus.

General Requirements/Deliverables/Outcomes

• Load flat file data submissions into local database servers
• Populate SQL Servers from Non- SQL Server environments, to be used for design and deliver of reporting and analysis. Monitor and validate the data submissions to the FTP or SharePoint sites or other areas of staged data storage from the universities (submission deadlines and content)
• Process all the incoming files through the edit process in preparation for loading the data into the Data Warehouse
• Load all "cleanly scrubbed" files in to the Data Warehouse
• Correspond with the data liaisons from the universities in an effort to resolve data which did not pass the edit process
• Assist in the development of data edits and load programs for decision support

--

 

 

Looking forward to hearing from you at the earliest!!!

  

Regards 

 

Shankar

Professional Recruiter

33505 State Street, Suite # 200 Farmington, MI 48335

V (248)-522-6879

F (248)-579-4454

Linkedin: www.linkedin.com/in/shkrajan

Email : Shankar@techconsultinc.com

Messanger: shankarraj001@yahoo.com

Minority Certified and Woman Owned Enterprise

TCI- Technology Consultants inc

Note: It is not a solicitation attempt!!!

 

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