Suljettu

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

Taidot: Tietokannan hallinto, Microsoft SQL Server, MySQL, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 10 arvostelua ) ossining, United States

Projektin tunnus: #17406140

27 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 - Lisää

$400 USD 7 päivässä
(199 arvostelua)
7.4
$277 USD 1 päivässä
(35 arvostelua)
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 Lisää

$555 USD 10 päivässä
(10 arvostelua)
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 Lisää

$555 USD 10 päivässä
(13 arvostelua)
4.0
$777 USD 30 päivässä
(9 arvostelua)
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 Lisää

$255 USD 10 päivässä
(4 arvostelua)
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 Lisää

$750 USD 15 päivässä
(2 arvostelua)
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 Lisää

$722 USD 10 päivässä
(0 arvostelua)
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 ( Lisää

$555 USD 10 päivässä
(0 arvostelua)
0.0
$555 USD 10 päivässä
(0 arvostelua)
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 Lisää

$288 USD 2 päivässä
(0 arvostelua)
0.0
$777 USD 10 päivässä
(0 arvostelua)
0.0
josmarale110

Tenet el trabajo al dia

$555 USD 10 päivässä
(0 arvostelua)
0.0
$555 USD 10 päivässä
(0 arvostelua)
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 Lisää

$722 USD 10 päivässä
(0 arvostelua)
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 Lisää

$333 USD 10 päivässä
(0 arvostelua)
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 Lisää

$333 USD 10 päivässä
(0 arvostelua)
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 Lisää

$555 USD 8 päivässä
(0 arvostelua)
0.0
haithambayoud

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

$555 USD 10 päivässä
(0 arvostelua)
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 Lisää

$555 USD 14 päivässä
(0 arvostelua)
0.0