Database Ninja to Splice Up a Database

Web, Mobile & Software Dev Web Development Posted 2 years ago

Hourly Job

Less than 30 hrs/week
Less than 1 month

Expert Level

I am willing to pay higher rates for the most experienced freelancers


I'm looking for a top database contractor, and I'm willing to pay accordingly.

I have database with about 3 million rows and about 20 columns.

The database is in a CSV format.

The database is names and addresses along with several other fields. The names are categorized as well.  There is a "main" category and a secondary "category".

What do I need?

I need this database broken up into a bunch of different CSV databases. The database needs to be broken up into the different main categories and then broken up into the individual states.  

Let's say there are 10 main categories. I then need it broken up into the individual states. Those 500 individual databases (50 states x 10 categories) need it to be exported as a CSV file. The CSV file should be available via FTP so I can download them all at once.

This database is updated every month or two so I need to have a way to upload the whole database with 3 million rows and have it update.  Then it would export all the CSV files again.

Along with exporting the data into 500 CSV files, I need information about those CSV files exported as well.

That information would be…
Total Number of Records of that CSV file
Total Number of Addresses
Number of Unique Addresses
Total Phone Numbers
Number of Unique Phone Numbers
Total Number of Fax Numbers
Number of Unique Phone Numbers

What I need to know in your application:

What technology do you feel is best suited for this job (MySQL, etc)? What server/cloud setup would work best with your recommendation?

Why you are better than every other person applying for this project?

What is the color of an apple?

  • Other Skills:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 32

Hired: 1

About the Client

(4.88) 50 reviews

United States
Omaha 09:25 AM

167 Jobs Posted
53% Hire Rate, 2 Open Jobs

Over $30,000 Total Spent
100 Hires, 11 Active

$7.99/hr Avg Hourly Rate Paid
3,643 Hours

Member Since Oct 15, 2008