Find Jobs
Hire Freelancers

SQL Optimisation

min £36 GBP / hour

Cerrado
Publicado hace más de 5 años

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 del proyecto: 17261588

Información sobre el proyecto

34 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
34 freelancers están ofertando un promedio de £40 GBP /hora por este trabajo
Avatar del usuario
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 en 40 días
5,0 (84 comentarios)
7,7
7,7
Avatar del usuario
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 en 40 días
5,0 (15 comentarios)
7,3
7,3
Avatar del usuario
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 en 40 días
5,0 (52 comentarios)
6,8
6,8
Avatar del usuario
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 en 40 días
5,0 (24 comentarios)
6,0
6,0
Avatar del usuario
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 en 40 días
4,9 (37 comentarios)
6,1
6,1
Avatar del usuario
Hi. Iam expertise in etls and optimizations and currently i am working and we maintain 2tb data i
£44 GBP en 3 días
4,9 (21 comentarios)
4,5
4,5
Avatar del usuario
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 en 40 días
5,0 (3 comentarios)
4,1
4,1
Avatar del usuario
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 en 40 días
5,0 (24 comentarios)
4,2
4,2
Avatar del usuario
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 en 30 días
5,0 (13 comentarios)
3,4
3,4
Avatar del usuario
I have experience with Oracle, SQL Server and MySQL. Share with me scripts and table structures and I will check them.
£36 GBP en 40 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 36 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
• 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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am good at SQL & SSIS. I have worked many projects under these technologies. My experience & expertise will definitely solve your problem.
£40 GBP en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
0,0
0
Miembro desde jun 29, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.