We are looking for a long term, full time person to work with the system architect to create and maintain MySQL stored procedures, views and triggers. Our system is a normalized database design. It has over 500 tables and 1,000's of stored procedures. We provide the user interface team with the stored procedures to allow them to build their pages. All the updates are done using SQL script files.
We are a large and growing company in the United States. We are looking for a few more developers to help us grow.
You are not required to work on USA time. Each day you will meet with the system architect and be given an assignment. If all assignments for the week are completed timely and correct there will be a bonus at the end of the week.
There will be initial training with the system architect to understand how our system is built. You will be asked to demonstrate your understanding after the training has been completed.
Here are sample questions that you will receive training on. Please don't apply if these are concepts you don't understand at all.
Use MySQL Workbench version 6.3.6 and used normalized design techniques.
product_id product_name brand_name
1 Monitor Apple
2 Monitor Samsung
3 Scanner HP
4 Head phone JBL