Analyse a Websites Backend Database software.

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

I can start immediately and analyze the backend db software. need to understad requirement in detail to provide exact quote. Please drscuss.

Dear Sir, Please share scope of work and project details so that we can finish this work ASAP. Hoping for your quick response.

A proposal has not yet been provided

First of all, I would like to introduce myself as the best candidate to perform this project. I am a computer engineering with more than 10 years experience developing projects in different sectors as banking, energy, insurance, health care... One of my skills is database expert, with knowledge about Oracle, SQL Server, MySQL... Using my professional experience, to face this project, I would split the project in the following tasks: 1. Identify the database used by the site. 2. Identify database as a target for importing data dump from csv file. 3. Import the data 4. Test whether query in site database gets the same results than imported database. It would be great if you provide me further information about the project. Thanks in advance

Hello Client ! , I have over 20 yrs of good amount of data analysis , data mining and database programming experience in the I.T Field. I am sure you will be satisfied with my work . If you need any clarification please feel free to communicate by posting me a message . Thanks & Cheers Sudhir Shetty.

A proposal has not yet been provided