Find Jobs
Hire Freelancers

Database Validation

$250-750 CAD

Closed
Posted almost 9 years ago

$250-750 CAD

Paid on delivery
A large database needs to be customized, validated and parts of it exported in a flat database to be used in MS-Access. Requires extensive DBA skills. Please do not respond if you have any doubts regarding your skills!? Here is some info to give you more idea: - Import zipped and divided large (20, 38 Gig) database in to Oracle in Linux or Windows environment. Say this is the database "a" - Run series of SQL commands to provide me with what field names exist in the database "a" and some sample data for those fields in .csv format, - Run SQL commands to extract data from specified fields as per requirements, in to blank database "b" which will have fields with a different naming conventions so that we can create the custom database we need. Now we have a new, smaller database with x number of records in database "b", - Validate data database "b" against existing another database "c" both ways. At this point we do not know which database information is the correct one but at least we know that there are records with fields that contain wrong spelling or other problems. - Figure out + how many more records database "b" has over database "c" ? + Extract those extra and/or faulty records in database "b" over database "c" to be validated. This new database will be the database "d" to be validated against another database we will have and keep "the database "d" in Oracle for that future work. Validation of this is not part of this project. This work will be repeated quarterly, perhaps another similar project will be added periodically which bring the DBA we are looking for extra revenue. For data security reasons, as well as our commitment to our customers, we keep some level of data security procedures in place. None disclosure agreement must be signed and the work must be don on our machine and on our premises in person - each and every time. The location is Don Mills and Sheppard area in North York, Ontario.
Project ID: 8163625

About the project

5 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
5 freelancers are bidding on average $627 CAD for this job
User Avatar
Hi, I'm certified Oracle DBA and Oracle developer since 2000. You can contact with me at any moment to discuss your task.
$745 CAD in 10 days
5.0 (2 reviews)
2.9
2.9
User Avatar
i m oracle dba and having more then 5 yrs of experience . i have very ggod experience in database maintenance and scripting also
$555 CAD in 10 days
5.0 (1 review)
2.4
2.4
User Avatar
Oracle Certified Professional (OCP) 7+ years of total industry experiance. Works on Oracle, SQL server, My SQL, MongoDB Also free hand on AngularJs, Mean Stack, Lamp Stack. Good in C language, R programming & python programming. ALso have basic knowledge of Latex. Worked in Financial(Banking, Share Accounting) and Theatrical Distribution Domain. I can certainly provide you the requirement satisfaction. Please come online for further discuss
$723 CAD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 CAD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 CAD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
North York, Canada
5.0
9
Payment method verified
Member since Jul 22, 2015

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.