In Progress

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

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

Skills: Database Administration, MySQL, PHP, Script Install, Software Architecture

See more: why we need data structures, why do we need data structures, why data structures are used, why data structures, weekend work, understanding data structures in c, understanding data structures, test script development, sn it, setting up a resume, self assessment test, script resume, resume for change management, real time data solutions, questions on data structures, project management resume, project management e learning, progress dba resume, production resume, problem structures, problems in data structures, problem management resume, preparing a resume, learning data structures, how to prepare a resume

About the Employer:
( 44 reviews ) Lacombe, United States

Project ID: #4133077