senior sql dba daily support. ssis, ssrs

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 2012 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. Milestones 10000 at the awareness which must be also released at 25% 10000 at 50 % 10000 at 70%. 10000 at 100% 30000 Best Regards mpalgeo

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. Highly proficient with T-SQL (stored procedures, functions, triggers, views, etc). I work with T-SQL, SSRS and SSIS on almost a daily basis. Also, I am a near-native English speaker.

A proposal has not yet been provided

I have 5 years experience in SQL Server, SSIS and SSRS. please message me whenever online for further discussion.

I have been working on SQL Server since 2004. Have extensive knowledge about Performance Monitoring using SQL Profiler. Also proficient with T-SQL and advanced functionalities. Have good hold on writing Stored Procedures and Functions along with experience on CTE, Cursors etc. Also worked on Reporting Services to design reports (SSRS). The current project on which I am working has more than 200 tables, 50 views, 600+ Stored Procedures along with Indexes, Triggers. Also have experience on working with Parent-Child Data tables. For further detailing - Would be of great help if you can define the duration of support (how many days) and feasible timings.

Certified MSBI -Data Warehousing expert, working in this tool from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience MSBI, SSIS , ETL, DW, .NET

Successfully implemented and maintained fully fledged Business Intelligence system which includes extracting data from multiple sources, creating data warehouses, cubes and reports for different user groups. BI Systems where created for local and foreign companies.

I have 7+ years of experience in SQL and MSBI

very interested to work in this project. the requirements truly match to my current working profile. kindly get in touch with me if you are interested to discuss further.

I have work experience in SSIS and SSMS and I have proficiency in writing SQL queries and do my work with dedication.

performance monitoring,regular maintenance activities like index rebuild to remove fragmentation which will improve performance