Can you: 1) Write sql code in your sleep? 2) Deliver a project on time - no extensions? 3) Ask questions when you are unsure? 4) Respond to emails within 24 hours? 5) Chat on IM/Skype? 6) See the overall picture, not just one piece of the puzzle? I'm looking for a honest, responsive and reliable coder to use for MANY projects. Right now I need someone to do 5 tasks: 1) figure out the fastest way of importing large data files (up to 13+ gig) into a mysql database. eg: -> using LOAD DATA LOCAL INFILE -> reviewing a perl script (already written but useless as it takes too long) -> piping data from a zip file into memory, then into the database -> using sed and unix scripting 2) Moving data across multiple tables depending variables. 3) Writing approx 6 basic php pages to display the data 4) Ensure the data is available for processing and "processed data" is saved back to the database. 5) Being proactive and making changes to the database to meet the requirements. I need someone because I don't have the time to do this myself. I have a technical background so if you don't know what you are doing, don't bid! An experienced DBA should finish this in 3-4 days max. Before You Bid -------------- Please answer these questions: 1. If you have NOT been invited to bid, then you MUST explain why I should choose you. 2. DONT BID if you: * Have an average rating less than 9 * Have completed less than 5 jobs * Cannot speak AND read English fluently 3. Explain similar projects that you have done. 4. Rate your experience out of 10. 1/10 = horrible. 10/10 = guru mysql / 10 perl / 10 php / 10 linux / 10 sed - unix scripting / 10 5. What is the date you can start and finish? Next Steps ---------- * If your response to this job meets these requirements I will send you a non-disclosure agreement to sign, scan in and return. * Once this is filled out I will give you a highly detailed document with everything you need. This will help you in finalising your bid.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) You will need to sign and agree to a non-disclosure (confidentiality agreement) before starting work.
5) Your code must be clean, well documented and easy to understand.
6) You must provide progress updates (via RAC) every 3 days. This gives me an indication that your working and allows me to give you feedback, so you are on the right track.
7) Examples of your previous work would be highly regarded.
8) Your bid must include an estimate on the time it will take you to deliver this project.
9) You must be willing to make reasonable changes to your work.
10) If you need FTP access, your access to our server will be monitored. 11) The buyer (me) owns all the copyright to the work. You may not reproduce it.
## Platform
Linux, PHP, mysql, perl, sed, unix scripting