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.
One additional task is to change from PHP MySQL to using MySQLi