Database Ninja to Splice Up a Database

Database Ninja to Splice Up a Database

Closed - This job posting has been filled.

Job Description

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 open jobs by this client