Find Jobs
Hire Freelancers

Data Warehouse Design

$750-1500 USD

Closed
Posted about 9 years ago

$750-1500 USD

Paid on delivery
Our company has a large data warehouse with 10 tables each over 15 Gb in size. We have the database implemented in MySQL. However, we are not able to create the proper indexes and keys due to missing data in some tables and very long run times that we are experiencing with our queries. We require an expert in database design and implementation to review the current structure of the database and to provide an alternative design and instructions for implementation based on the queries and reports that the database is used to support. The database is used to support a small number of queries and reports that are run repeatedly by our company with slightly different parameters each time. In addition to providing advice on database design improvement and instructions for implementation, we would like the expert to review the queries that we use to generate our reports and help us to optimize them if necessary.
Project ID: 7254410

About the project

27 proposals
Remote project
Active 9 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
27 freelancers are bidding on average $1,280 USD for this job
User Avatar
Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, Asmcmd, Asmca, Tkprof I Can do your work easily. Let me know when we can discuss.
$1,500 USD in 15 days
4.0 (38 reviews)
5.8
5.8
User Avatar
Hi Employer, I have read your description and been interested in your project. Please give me more details of your MySQL database and queries. I'm ready to discuss and start to work on it now ========================================== PLEASE DISCUSS BEFORE AWARDING THE PROJECT
$1,052 USD in 20 days
4.1 (18 reviews)
5.6
5.6
User Avatar
Hello, im very good with databases of any kind. If you are interested take a look at my feedbacks and let me know. I would like to help you.
$800 USD in 7 days
5.0 (25 reviews)
4.7
4.7
User Avatar
Hi. I am database/datawarehouse developer. Currently working for one american company. I am also report developer so I can make your sql work faster. Thanks
$777 USD in 10 days
5.0 (12 reviews)
3.8
3.8
User Avatar
Hi, I am a database modeler and have been working with mysql data for a long time and in lots of projects. I have read your problem statement and am interested in resolving them. The database needs to be normalized and missing indexes replaced such that queries stop thrashing the database in search of deleted tables via foreign keys - if such a thing is possible, The query execution times can be reduced by creating indexes to make searches faster on one hand and reducing the use of JOINS that can be avoided on the other. How and what exactly is to be done cannot be specified at this time without analyzing the database tables. I prefer to work at an hourly rate ($14/15) which is reasonable. Please contact me if you need my services. Thanks Deb
$1,250 USD in 30 days
4.5 (4 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$1,250 USD in 20 days
5.0 (9 reviews)
2.5
2.5
User Avatar
I am a private freelancer thats why I have no reviews because I usually got my clients from other freelancers company such as craigslist, easyoutsource, onlinejobs, warrior forum.. Somebody told me to try my luck here at freelancers since ive been working online since 2005.. 10 years experience in development and implementation of powerful, user-friendly web applications. I have extensive experience with in web design and development including eCommerce website design & Development, web portal development in PHP, Magento Ecommerce Solutions, Wordpress Development and custom web solutions in PHP I would like to apply for the said job. I have been working as a freelancer for over 9 years and counting. Web design. mobile developer, Virtual Asssistant, SEO and programmer are my forte. Here are the things I can guarantee when you are going to hire me. - ensure I understand requirements - estimate accurately - communicate well and regularly - produce quality code - do so quickly and efficiently - finish on time The following are my fields of specializations: - Website Design - Mobile Website Design - Mobile App Design (iphone, ipad, Android..) - software developer - UI /UX - Logo Design - Graphic Design - Banner Ads (static and animated) - Corporate Identity, Branding - Illustrations -Landing Pages -Squeeze Pages -Sales Page -VSL -VA -SEO -internet marketer
$750 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello i have a lot of experience in B.I. i have to analyze the actual structure and desing the proper solution. may be it is necesary to separate OLTP databases and the OLAP database in order to improve the performance and mantain it despite growing of the data. feel free to write to my email in order to know more about me and discuss about the project. Thanks for your time.
$750 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am admin of several huge instances, one of them over 50GB, and was a lead developer of largest Croatian yellow pages / dictionary http://imenik.hr. I have strong skills in database design and optimisation, and have successfully transfered some quite large MSSQL and Oracle databases to MySQL.
$750 USD in 7 days
0.0 (2 reviews)
0.0
0.0
User Avatar
Hello I am a trusted BI expert with 20+ years in large DataBase design and systems architecture and specifcly in all aspects of data warehouse design. I have worked as expert advisor for to many companies, and build and consulted on dozens of warehouse of all shapes and sizes (including multi-Terabyte). Your project description suggests: 1) Review the current structure 2) Provide an alternative design 3) Instructions for implementation 4) Optimize queries My assumption is no 'true' data will be exchanged. However, missing, dirty and sparse data can cause havoc in database design. We would need some conversations on the missing data (and therefore indexes) and its business reasoning. Alternate designs come after this. As there is a need for significant communication please do not accept my proposal without a chance for us to talk over the phone to determine if we are a match. I proposed a 15 duration days because of dual availibilty and may decrease. If in fact you wish a full day of hands on expert design 'collaboration', we can price accordingly. Note: New design will likely require you to reload, and new problems may occur therein. Sparse/Dirty data can be a significant unknown and this proposal does *not* include the ETL component of this project. I would be happy to be on call for a week or 2 (included) for additional short conference calls. Newbee to freelancer, not to BI and I am in US East Coast Time.
$2,505 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
System analysis can be done for free if the client gives read only id to theirs db. Will read through the business case and will recoment the flavour db should be used. Data flow diagram and ER diagrams will be enhanced. All tables index will be created. Data will be populated from old system. Will integrated with the application Tuning will be carried out Will monior the system for 2 or 3 weeks Back and recovery polycy will be created/enhanced
$5,555 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We could discuss further on the approach, at your convenient time. ***Approach -1 (a) Based on the reports generated, I can create new data model and remove the redundant data (b) Create new scripts to load the data into the new tables, from the existing tables. (c) Check the existing scripts for generation of reports (d) Optimisation of queries to improve the performance ***Approach-2 Consider purging the data which does not have matching keys OR moving these redundant data to other tables, for further analysis / cleanup.
$1,250 USD in 18 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I first need to analyze and understand the table structure and their purpose. After that l will look in to each table in detail and work on creating proper indexes, constraints and keys for the appropriate columns. In the last I will look into the queries that is used in place if it can be optimized. If yes then I will provide the details of modification that has to be done.
$1,333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$1,250 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$1,111 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8+ Years of Database development experience and working as Technical Architect , Database Expert in Software Industry.
$1,000 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi recently I optimize a system of bank profitability with 1500000 customers and achieve excellent response times
$750 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$1,250 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm a Sr Mysql DBA with more than 8 years experience. I have also more than 12 years experience with Data warehouse and query optimization. I also have experience with column base database for fast reporting (usually twice to 10x faster than Mysql). I am very interested in helping you optimize your database and propose a scalable solution. I can provide you reference upon request. I believe I can accomplish your project in 12 to 15 hours. PS: I just completed a project on Freelancer about optimizing a Mysql database. Sincerely, Franck
$833 USD in 10 days
0.0 (0 reviews)
3.5
3.5
User Avatar
I will review your existing design and identify the relational issues. I need table list including column, Row volumes of each table. I need information about use case (business operating systems), which data entry most (volume transaction), extraction frequency (if data comes from multiple sources) and duration. I need to think on logical issues. I will test first my design the I will submit you. My basic plan for your project Review and Analyse Existing Data Schema New Schema Design and Performance Plan (including calculation) Discuss with my Professor Dr. Peter Lake (Famous RDBS Schema designer in UK) Testing performance and make final plan Report Submission and convert database as per new design
$1,111 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Vancouver, Canada
4.9
3
Payment method verified
Member since Jan 24, 2012

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.