SQL SERVER 2008 DBA -Developer :: Job3K.com - non-stop freelance jobs roller, work from home

	SQL SERVER 2008 DBA -Developer
bid on the project		Share \|
Date posted: 15-02-2012 19:46:20
Hello Guys. I am looking for a Microsoft DBA/Developer to Construct Datamart for one of our business unit to pull data into SQL Server 2008 Server from an existing SQL SERVER 2008 Transactional Database. Below is the scenario: We have four business units across the globe and we are into health care billing and practice Management Company. All the structures of Datamart at each business unit are same and I developed stored procedures to populate the Datamart from transactional databases. What I need is someone to understand the existing stored procedures and map the appropriate columns to Datamart from the transactional system of other business units. Once you develop the procedures and load manually to the databases and after testing thoroughly you need to automate this complete job using SSIS. Also you need to create a backup plan for this Datamart. And also you need to document this complete task along with time spent for each task. In detail: 1. You need to populate around 12 dimensions and 1 fact table 2. Two management report tables. Opportunity will be given to work with other business units if completed the task ontime. Must be expert in SQL SERVER 2008 DBA MSBI (SSIS-SSAS-SSRS) Please understand the Job Requirement and bid for this project.Contractors with good experience in this type of job are only requested to apply. Thanks And Happy Bidding.
Keywords: datamart business server sql procedures units task transactional dba populate