Find Jobs
Hire Freelancers

SQL Optimisation

min £36 GBP / hour

Fechado
Publicado há quase 6 anos

min £36 GBP / hour

SQL (2005) Table with 5 billion rows+, indexed not partitioned. Have SSIS script to reformat and burst into daily files. Cannot cope with size of table. Need some help (couple of hours max) to get this to work in fast and effective fashion. The database is about 750GB total size. It's on a decent Azure Server. Also need comfort that are using correct tables (some basic stored procedures are behind the scenes) Just after price/ hour at this stage please.
ID do Projeto: 17261588

Sobre o projeto

34 propostas
Projeto remoto
Ativo há 6 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
34 freelancers estão ofertando em média £40 GBP/hora for esse trabalho
Avatar do Usuário
hello mate Maybe there could be better approaches than keeping 5 billion rows in a database ? Did you consider doing big data ? Thanks
£40 GBP em 40 dias
5,0 (84 avaliações)
7,7
7,7
Avatar do Usuário
Dear Sir, I have read Project Description & interested to receive database, then one of my senior DB person can look at it and give you our solution. Look forward to hearing from you. Regards, YK LEADconcept
£40 GBP em 40 dias
5,0 (15 avaliações)
7,3
7,3
Avatar do Usuário
Hello Sir, I am an expert with SQL Server and query optimization and would like to discuss this project with you. Thanks Aanvik
£40 GBP em 40 dias
5,0 (52 avaliações)
6,8
6,8
Avatar do Usuário
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and overall Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, and results oriented. I have worked in SQL Server optimisation projects before, so I think I can be helpful to deliver what you require. I currently have full time availability.
£36 GBP em 40 dias
5,0 (24 avaliações)
6,0
6,0
Avatar do Usuário
Hello, I have 10+ years of web development experience in ASP.NET Core, ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML5, CSS, jQuery, javascript, JSON and XML. I have handled similar projects. Please review my profile for more details. Link: https://www.freelancer.com/u/deepindersingh Thank You
£36 GBP em 40 dias
4,9 (37 avaliações)
6,1
6,1
Avatar do Usuário
Hi. Iam expertise in etls and optimizations and currently i am working and we maintain 2tb data i
£44 GBP em 3 dias
4,9 (21 avaliações)
4,5
4,5
Avatar do Usuário
Hi, Could you please provide access of SQL and SSIS? and can we have a quick call? I'm a Microsoft expert with 10+ Years of Development experience in Microsoft technologies and have executed the various project and skill area are Web Application, Service Layers, API Integration and Desktop application. I have developed a wide range of applications using HTML, DHTML, ASP.NET, ASP.NET MVC, C# and VB.NET along with Databases such as SQL and MSAccess. Regards, Hetal
£40 GBP em 40 dias
5,0 (3 avaliações)
4,1
4,1
Avatar do Usuário
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 6 months experience in SQL and 5 years and 9 months experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe jikenjd
£36 GBP em 40 dias
5,0 (24 avaliações)
4,2
4,2
Avatar do Usuário
Hi, I am interested in your project. Please feel free to contact me with more details about your project. I use SQL for Account, CRM, ERP task form 1996 year. I have exp on ERP & Account system include 1c: ERP and more. I am a full time programmer with 20 year exp in Russia. I have hi degree in information system in economics. Thank
£36 GBP em 30 dias
5,0 (13 avaliações)
3,4
3,4
Avatar do Usuário
I have experience with Oracle, SQL Server and MySQL. Share with me scripts and table structures and I will check them.
£36 GBP em 40 dias
5,0 (2 avaliações)
2,0
2,0
Avatar do Usuário
one of the way to look for query optimisation. there are few other options as well, for this need to analyse application and db.
£38 GBP em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have been working with data on SQL Server, I can handle with it. I'm already studying a master degree of information and communication technology.
£44 GBP em 36 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
• Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures. • Worked extensive on SSIS Package designs for Import/Export from various data source like flat file and Excel to MS SQL Server and vice versa. • Created Windows Batch Files and automated tasks as per customer requirements. • Worked extensively on SSRS reports, designed and deployed the reports into the Reporting Server and automation the e-mails to the Customer.
£36 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A dynamic, result-oriented professional with more than 10 Years of experience in Project Execution and Database Management. Possess a sound understanding of various technological concepts. A project planner with expertise in spearheading numerous projects and ensuring delivery of projects within the time & cost parameters. Acquired comprehensive exposure to various Operating Systems, Data Structure and Database Management System. Proficient in database administration involving configuration, tuning & migration of databases’. Expertise in managing IT operations with key focus on optimal utilization of resources. An effective communicator with excellent relationship building & interpersonal skills.
£40 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Actually This is the best suitable Project for me because I have resolved many issues regarding performance through out my career as MSSQL Database Administrator. I can assure we can full fill the project requirement with in the time, We have the Network which is looking to start a company so this would be the better opportunity to start on.
£36 GBP em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am good at SQL & SSIS. I have worked many projects under these technologies. My experience & expertise will definitely solve your problem.
£40 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am having good experience in both SQL Server and SSIS. I have dealt with such large volume of tables and know the techniques to optimize the queries.
£40 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
since i have more than 15 years experience with SQL server from SQL 2000 to SQL 2014 , and since your database is huge , it depends on database structure if we split it to master databases and childs or we use file-groups. regards
£38 GBP em 20 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have 10 years experience working at Microsoft as a Support Escalation Engineer, mainly focused on SQL Server performance. I have also spent the last 3 years working with SSIS, developing and troubleshooting SSIS packages. 750GB is not really a large database so the problem most likely lies in either the indexes, stored procedures, or the data flow of the package itself.
£44 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, Give me this work. I have 7+ year of experience. I will partitioned table I have 7+ year of experience in SSIS/SQL/MSBI. give me this work. Ankur
£40 GBP em 40 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
United Kingdom
0,0
0
Membro desde jun. 29, 2018

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.