Closed

Database Project manager

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).

Skills: Database Administration, Microsoft SQL Server, MySQL, SQL

See more: project management database software, database project manager job description, database manager responsibilities, bank project manager, project manager logos, celia project manager myspace, microsoft certified profile project manager, project manager part time, software project manager bogot, project manager joomla, php project manager, job project manager translation, singapore project manager database website, online project manager database ajax, project manager database open office, imagine that you are the project manager for this initiative in the north west province outline steps you would take to ensure t, it project manager meet our team, project manager meet our team

About the Employer:
( 10 reviews ) ossining, United States

Project ID: #17406140

27 freelancers are bidding on average $538 for this job

sumon355

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 - More

$400 USD in 7 days
(199 Reviews)
7.4
$277 USD in 1 day
(35 Reviews)
5.9
yangdev

Hi I see your problem and I can help you perfectly. Relevant Skills and Experience Over 10+ years, I worked as a web developer and I've designed/managed a lot of large databases for companies and businesses. For a sev More

$555 USD in 10 days
(10 Reviews)
5.2
sreenivas2903

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 Experien More

$555 USD in 10 days
(13 Reviews)
4.0
$777 USD in 30 days
(9 Reviews)
3.6
prshahbaz

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 More

$255 USD in 10 days
(4 Reviews)
2.9
OWDGroup

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 a More

$750 USD in 15 days
(2 Reviews)
3.0
SqlDataGuru

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 databas More

$722 USD in 10 days
(0 Reviews)
0.0
sunilmudunuri

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 ( More

$555 USD in 10 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
rishikeshrajesh

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 a More

$288 USD in 2 days
(0 Reviews)
0.0
$777 USD in 10 days
(0 Reviews)
0.0
josmarale110

Tenet el trabajo al dia

$555 USD in 10 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
Allatonesolution

check database issue with database. manage current database daily basis. extract the sql runing in database and tuning current queies using indexing of by making suggestion at application level Relevant Skills and Exp More

$722 USD in 10 days
(0 Reviews)
2.5
fl0473nagaraju

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 const More

$333 USD in 10 days
(0 Reviews)
0.0
sureshrangineni3

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 More

$333 USD in 10 days
(0 Reviews)
0.0
sripadaworks

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. Propos More

$555 USD in 8 days
(0 Reviews)
0.0
haithambayoud

Good Experience in mysql database Relevant Skills and Experience Experience Proposed Milestones $555 USD - Manage database server

$555 USD in 10 days
(0 Reviews)
0.0
mudgilsks

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 More

$555 USD in 14 days
(0 Reviews)
0.0