SQL Configuration, SSIS and SSRS Help

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 dashboards via Power BI and 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

A proposal has not yet been provided

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. Relevant Skills and Experience I have done many work in Requirements analysis , Data Staging, Data Warehouse, DataBases. I am expert in developing ERD, Front-End, Backend, Security, Optimization, SSIS, SSRS. Proposed Milestones $25 USD - milestone

Please review my profile Relevant Skills and Experience I have 7.5 years experience in SQL and 4.8 years experience in SSRS and SSIS. Proposed Milestones $30 USD - Ssrs, ssis Please let me know more details and when we will start. Sky pe jikenjd

Hello Sir. Please drop me a message then we can start discuss more about your project Thank so much! Relevant Skills and Experience Hello Sir. Please drop me a message then we can start discuss more about your project Thank so much! Proposed Milestones $55 USD - 1 Hello Sir. Please drop me a message then we can start discuss more about your project Thank so much!