Database Indexing and Query Optimization

Hi I have been working with MSSQL for over 15 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

A proposal has not yet been provided

i have a core experience and enough good expertise in .Net technologies and SQL. I can optimize those two queries that are taking time. Just give me your database details and consider it is done. Please view my profile to gain trust in me.

Dear, we are Team of French + US. I checked your project description, and I confirm I can fix your queries. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

MCSA SQL 2012 Microsoft Certified Solution Associate. MCTS 70-515 WebApplications Development with Microsoft .net Framework 4 Hello I am sql certified and ready to start work now and give you support on your time zone kindly come here for discuss Thanks

A proposal has not yet been provided

A proposal has not yet been provided

Hi, I am a DB performance freak! ;-) I have done quite a lot of DB optimizations for both SQL and NoSQL Databases. I have done some research on various types of indexes and their benefits. I can get this requirement done in a quick time with high quality. Give me more details to start working on this project.

Ainda não foi fornecida uma proposta

I'm using SQL in every day work. I operate on Database with over 5 mln records - so I optimize queries every day.

Hi I have been in this industry for 4 years and such jobs are my daily practice.I can assure you that if you work with me once, you will always work with me for these kind of projects.

A proposal has not yet been provided

Hi, I am database developer with SQL query tuning experience. I propose to work with you in tuning the slow running queries. Kindly share more details like 1. DB schema 2. problem queries 3. Current speed and expected speed You have any queries, Please let me know. Regards Sankar

Hello, have great experience with working on Big data structure and database optimization. I had worked on big enterprise projects and have the enough experience to finish the task in time. I will be glad if you give me the chance to help you finishing your task. Thanks in advance

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss requirements and terms before awarding the project.

Hello, I'm a computer scientist specialized in BigData so optimization of databases shouldn't be a problem for me. If you could give me more information about your project that would be nice.

Hi, Greetings for the day, I can do this job please ping me to discuss the scope. We can use temp table concept, message me to discuss further. Please give me chance to develop same for you. Thanks, Mufaddal

Hello, i'm a leading developer of bi, developing etl, cdc for credit organizations in Russia , i think i can help once i made the whole extract dataprocess to cost 40 minutes instead of 7 hours

Hi, We are highly experienced in designing, developing and performance optimization on different data base systems. Please let me more details to understand and provide the solution to improve the performance of the database. Thanks Paul

I have over fifteen years of database development and administration experience and have actively been involved in tuning of databases.