SQL Data Architect - Direct Client Requirement - XpertTech !!!

PLEASE MAIL THE RESUMES TO DEEPTI@XPERTTECH.COM ALONG WITH CONTACTS AND RATES ASAP !!!

 

Title: SQL Data Architect

Location: Glenwood, IL

Duration: 2-3 months

 

*Must Have Skills/Experience (Basic Qual)	*Minimum Years Required	*Months since Last Used
Strong Microsoft SQL Stored Procedures and Queries skill	5	active
Must have knowledge of Star Schema	1
Knowledge of .SQL Server 2008	2	active
Knowlledge of change data capture tool, or similar functionallity	1	active
Knowledge of SSIS	1	active

 

 

The candidate is expected to work in hands-on design and development of Data transfer/refresh mechanism for a Reporting data repository

 

We currently 5have a transactional database and a reporting database, (Both of them in SQL Server 2008). The reporting database is in Star Schema.

We are looking to have an almost realtime replication and transformation from the transactional database to the reporting database. For this, we need to explore options on what is the best way to accomplish this.

 

We need someone who has

> Implemented something like this before so that we can explore the pros and cons of options and come up with an optimal solution.

> Our initial analysis says that we need to use the Change Data Capture (CDC) option of SQL server 2008. If that is the way to go, someone who has implemented CDC will be of tremendous value to plan the implementation and guide the execution.

> We need to know what are the repercussions of using CDC on

 - Load on the transactional database

 - Performance of the transactional database

 - Lag time in replication

> We have written SSIS scripts to do a onetime load from the transactional to the reporting database. We want to know how much of this can be reused to perform the realtime replication? or do we need to throw away all of this and write it from scratch.

 

Please do let me know in case of any queries.

 

 

Thanks & Regards,

Deepti Chandra

XpertTech Inc
400 W Cummings Park,
Suite#5450A
Woburn, MA-01801
Email: deepti@xperttech.com
Phone: 214-306-7707
Fax: 978-405-5040
www.xperttech.com

 

 

--

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