Find Jobs
Hire Freelancers

Database Project manager

$250-750 USD

Cerrado
Publicado hace casi 6 años

$250-750 USD

Pagado a la entrega
We have a dedicated server with windows plesk hosting for a MS SQL dbf that has 44M records. We currently have 16gigs RAM. Way too slow. 250 files each having about 55K recs were used to import to1 dbf. Realized today that some of those files had the fields shifted so some data is in the wrong fields on the dbf. Our data guy is currently working to fix this. We need someone to oversee this project on a daily basis to ensure it is fixed in a timely fashion and then indexed correctly and perhaps split data between multiple dbfs to make search quicker (currently timing out).
ID del proyecto: 17406140

Información sobre el proyecto

24 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
24 freelancers están ofertando un promedio de $529 USD por este trabajo
Avatar del usuario
As an expert in ms sql server, i am very much interested to do this project. Looking forward to have a positive response from you. Thanks Relevant Skills and Experience ms sql server Proposed Milestones $200 USD - Initial $200 USD - Final
$400 USD en 7 días
5,0 (294 comentarios)
7,8
7,8
Avatar del usuario
hi I am currently manaaging the db with records like 400mill so I can assist you . please let me know your requirements and make it quick , is this server meant for warehouse or oltp prod? Relevant Skills and Experience TSQL , SQL SERVER , SSIS Proposed Milestones $555 USD - milestons
$555 USD en 10 días
4,8 (21 comentarios)
4,6
4,6
Avatar del usuario
Dear client, I read the requirement very carefully and I understand the task very well. I'm sure that I can do this project. Please feel free to discuss with me. Regards. Relevant Skills and Experience Dear client, I read the requirement very carefully and I understand the task very well. I'm sure that I can do this project. Please feel free to discuss with me. Regards. Proposed Milestones $255 USD - one
$255 USD en 10 días
5,0 (4 comentarios)
2,9
2,9
Avatar del usuario
1. Connectivity speed, if there is any surge while data get transferred. 2. Verify the code to acquire the data in staging table(if any).3. Remove all calculation or joining statement while download. Relevant Skills and Experience I am DB architect and currently working in telecom industry and this type of situation always normal for me Proposed Milestones $350 USD - verify code $400 USD - rewrite code and log files Additional Services Offered $1 USD - consultation $100 USD - CR
$750 USD en 15 días
4,5 (5 comentarios)
3,3
3,3
Avatar del usuario
Good Experience in mysql database Relevant Skills and Experience Experience Proposed Milestones $555 USD - Manage database server
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
As per your requirement. I will be perfect and suitable for this project. 6 years experience in ASP.NET and the .NET Framework using C#, HTML,MS SQL Server, ASP.NET MVC, LINQ, WCF, Window Azure . Relevant Skills and Experience .net expert Proposed Milestones $555 USD - each task
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear team, MY name is Sunil Kumar, working in IT company as a .net developer and strong hands on SQL server db engine, SSIS, SSRS. As I understand your problem, it is related to query performance, it can be optimised.i my previous organization we were dealing with large using SSIS pakage service. I am interested in your product. you can contact me on mudgilsks at Gmail
$555 USD en 14 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Split the files into Chunks . So we can handle the issued files easily and we can make use of RAM in proper way Relevant Skills and Experience Extensive experience in Data processing with SQL Server and T-SQL in constructing triggers, Tables, User Functions, Views, Indexes, CTE. Proposed Milestones $333 USD - depends
$333 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, there are several ways to fix this issue. moving data in small size may work. Frther details can be discussed once engaged. Relevant Skills and Experience Mysql database has been operating from lat 9 yrs. Proposed Milestones $555 USD - i am working as server admin, faced these type problems. resolved.
$555 USD en 8 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 5 years of experience on SQL DBA..had hand's on experience in migration involved with development Team.. and administrative support tasks. and currently working with top MNC reputed company. Relevant Skills and Experience I have 5 years of experience.... Currently working with top reputed company. And I have been working with various administrative support tasks and involved in development Team.
$333 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Tenet el trabajo al dia
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
1. need to look into the database setting currently configure 2. consolidate either index are properly created or missed. 3. Defragment the indexes which are fragmented can improve 100 % performance Relevant Skills and Experience fix : can be fixed via DB optimization Proposed Milestones $288 USD - DB Optimization
$288 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . Relevant Skills and Experience 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL), 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS. Proposed Milestones $555 USD - Complete database design and development
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Need to dive into this problem to understand the true problem. Review indexes, data structures, and data flow and identify areas to tune. Relevant Skills and Experience I have an extensive history working with databases, 10 years in SQL server. Building and improving data solutions has become a passion of mine. Proposed Milestones $722 USD - Identify problem and implement fix I have an extensive history working with databases, 10 years in SQL server. Building and improving data solutions has become a passion of mine, and I enjoy working with clients from a project's early stages to the final delivery. I take pride in my work and find that my greatest reward comes from client satisfaction. I am skilled in refactoring and identifying troublesome code. And, gain a better understanding of the underlying structure and the original designers intent through that process. My experience allows me to see past design problems and prepare my clients for the future.
$722 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
The only thing confuses me is how the fields have shifted in a database. Splitting data across multiple data files is ok but if you only have 44M records then I don't see that it will make much difference. Plus it also depends on how fast your storage is. I maybe able to help.
$555 USD en 6 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Ossining, United States
5,0
13
Forma de pago verificada
Miembro desde sept 28, 2011

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.