Find Jobs
Hire Freelancers

Database Project manager

$250-750 USD

Closed
Posted over 5 years ago

$250-750 USD

Paid on delivery
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).
Project ID: 17406140

About the project

24 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
24 freelancers are bidding on average $529 USD for this job
User Avatar
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 in 7 days
5.0 (294 reviews)
7.8
7.8
User Avatar
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 in 10 days
4.8 (21 reviews)
4.6
4.6
User Avatar
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 in 10 days
5.0 (4 reviews)
2.9
2.9
User Avatar
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 in 15 days
4.5 (5 reviews)
3.3
3.3
User Avatar
Good Experience in mysql database Relevant Skills and Experience Experience Proposed Milestones $555 USD - Manage database server
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Tenet el trabajo al dia
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ossining, United States
5.0
13
Payment method verified
Member since Sep 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.