Improve SQL Server database performace -- 2

₹1500-12500 INR

İptal edildi

İlan edilme:

6 yıldan fazla önce

₹1500-12500 INR

Teslimde ödenir

Hi, We are looking for a database expert who can help improve the performance of SQL Server Database. We have an MSSQL database and there are more than 2 million records in it right now. The database is just getting filled right now and it will be like 5 or 10 times bigger then now it is. The application uses EntityFramework to fetch data from database. So if you have knowledge about EntityFramework and good experience with making Database respond fast to queries then this project is for you. We want someone who can help improve the performance of database when fetching data from it.

Proje No: 15367714

Proje hakkında

6 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

6 freelancer bu proje için ortalama ₹14.815 INR teklif veriyor

@mpalgeo

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

₹30.000 INR 10 gün içinde

5,0

(73 değerlendirme)

6,1

@vinaysinghh

i am sql server dba Relevant Skills and Experience sql Proposed Milestones ₹5555 INR - project

₹5.555 INR 3 gün içinde

4,8

(57 değerlendirme)

5,2

@Rohaanshinde123

Hello, I read through the job details extremely carefully and I am absolutely sure that I can help you to improve the performance of SQL Server Database. Relevant Skills and Experience LINQ, Microsoft SQL Server, MySQL, SQL Proposed Milestones ₹3000 INR - initial ₹7000 INR - final Stay tuned, I'm still working on this proposal.

₹10.000 INR 3 gün içinde

5,0

(4 değerlendirme)

1,8

@tiaratechies

Hello, we are database experts certified in Oracle corp and worked for it. We managed larger databases than the ones that you mentioned. If you are interested drop a message. Relevant Skills and Experience SQL Proposed Milestones ₹27778 INR - milestone

₹27.778 INR 1 gün içinde