Sn DBA Release deployment, DB table initialization, foreign key contraints - repost

IN PROGRESS
Bids
6
Avg Bid (USD)
N/A
Project Budget (USD)
$10 - $20 / hr

Project Description:
Require a senior DBA to assist with the deployment of releases. We are in a LAMP environment & using Mercurial for version control. We require the resume of the DBA. No resume; no consideration

We are using the InnoDB database engine for MySQL. Besides setting up an initialized version of the development DB for Internet production environment, we want to correct some table structures during the initialization if possible as there will be no data in the transaction tables & constraints will not be in place to prevent the changing of foreign keys

You will have SOLID understanding of foreign keys & experience in manipulating tables when creating a production DB using the development DB as the source. You will have an inherent ability to be able to quickly decipher our database table relationships. We will assist to shorten the learning curve but this will need to be something that comes naturally for you. We don’t have the time to go over every table column in detail & explain each foreign key. We will get you started & you should be able to take it from there

You will strictly adhere to our deadlines & to the delivery dates you provide. You are able to self-supervise. You can produce results quickly. You are at a level that you don’t need continuous hand holding. You will have excellent English & communication ability. You are innovative & know how to solve problems. You don’t ask us how to solve issues. You ask us questions for clarification but you are able to do the problem solving & provide solutions & where possible options. You are able to do the analysis & design. You can work independently but in collaboration with us

You understand project management & you will provide daily updates on progress without exception. When you provide a date to start the work we expect that you will be available to us FULL TIME & that there will be no holidays, family issues or any other events that will delay the progress of the project. If weekend work is required to meet a deadline then it is expected that the weekend will be worked. This is a one time commitment for this one time project. If a weekend needs to be worked to fulfill your obligations then it is expected that you will meet agreed upon timelines

The test transaction tables will be initialized as they are full of test data. Our development DB has reference tables populated with real production data e.g. Price Table, Products Tables, Province/State Table & other tables used to look up values. These will not be initialized as we don’t want to re-enter all the data

The order in which tables get created is significant because of the foreign key constraints.

You will work with us in preparing a deployment plan with respect to all of the above activities
We will not pay a 100% up front milestone. Don’t ask us for details after being awarded the project. Get the details during the bidding period. We will not agree to change the amount you bid or the delivery date if the project is awarded to you. We are negotiable during the bidding & assessment period. You must be available to work once the project is awarded. We will not wait for more than 24 hours to accept the awarded project. When responding relate your skills & experience to our specific requirements, explain your understanding of our requirements and explain why you are the best DBA for this project. Competitive bids will be given greater consideration. We will have a week prior deployment so during that week there should be 15 hours work. There will be new DB work after deployment and another release to prepare for.

Tasks are in the attached document.

Additional Project Description:
01/16/2013 at 20:37 ICT
One additional task is to change from PHP MySQL to using MySQLi

Hours of work: 15 Project Duration: 1 - 4 weeks Skills required:
Database Administration, MySQL, PHP, Script Install, Software Architecture
Additional Files: DBA+Tasks.docx
Hire Projects113
Project posted by:
Projects113 Canada
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.