Server Administrator Application

Description
Design, build, and maintain large databases. Our database is currently 10GB, growing exponentially and will reach 100GB+ within 2-3 years, if not sooner. You will optimize queries to make sure that everything runs efficiently as we grow and that backups remain plentiful.

Qualifications
BS or MS in Computer Science 3+ Years of Experience with PHP/MySQL Experience with query optimization and database schema design. Experience with apache and mysql performance tuning. Experience with MySQL Master/Slave Replication. Passion about making a great product. Availibility on all days of the month. Experience with link building and seo a plus.

Application Questions
You log in to a slave of a mysql replication server and noticed that the database is out of sync with the main server. What are the exact steps that you take in order to resync the two databases? 0 chars Please write the cron command to run a file every other day at 3:00pm 0 chars Please indicate which indices you would create to speed up the following query: SELECT P.code,U.receive_status_updates,U.email,U.username,U.first_name,U.last_name,O.parent_id,O.data,O.processed_by,O.parent_id,O.product_name FROM products P, orders O left outer join users U on U.user_id=O.user_id WHERE O.product_id = P.product_id and O.order_id='$orderId'" 0 chars A table will be exceeding 100 GB soon. Please explain your backup strategy as well as how to keep it efficient. Please be as specific as possible. 0 chars A table will be exceeding 1 TB soon. Please explain your backup strategy as well as how to keep it efficient. Please be as specific as possible. 0 chars You tried to access wlmarketing.com but it says some sort of mysql error. What do you do? 0 chars You tried to access wlmarketing.com but it is not at all responding. What do you do? 0 chars You tried to access wlmarketing.com and it says 503 forbidden. What do you do? 0 chars Please enter main resume points below (including email address & phone number). 0 chars Please enter desired salary/month (assuming 40 hours/week). 0 chars

Application Questions

You log in to a slave of a mysql replication server and noticed that the database is out of sync with the main server. What are the exact steps that you take in order to resync the two databases?

0 chars

Please write the cron command to run a file every other day at 3:00pm

0 chars

Please indicate which indices you would create to speed up the following query:
SELECT P.code,U.receive_status_updates,U.email,U.username,U.first_name,U.last_name,O.parent_id,O.data,O.processed_by,O.parent_id,O.product_name
FROM products P, orders O left outer join users U on U.user_id=O.user_id
WHERE O.product_id = P.product_id and O.order_id='$orderId'"

0 chars

A table will be exceeding 100 GB soon. Please explain your backup strategy as well as how to keep it efficient. Please be as specific as possible.

0 chars

A table will be exceeding 1 TB soon. Please explain your backup strategy as well as how to keep it efficient. Please be as specific as possible.

0 chars

You tried to access wlmarketing.com but it says some sort of mysql error. What do you do?

0 chars

You tried to access wlmarketing.com but it is not at all responding. What do you do?

0 chars

You tried to access wlmarketing.com and it says 503 forbidden. What do you do?

0 chars

Please enter main resume points below (including email address & phone number).

0 chars

Please enter desired salary/month (assuming 40 hours/week).

Online Marketing Fulfillment For Agencies, Consultants, & Webmasters

Server Administrator Application

0 chars

0 chars

0 chars

0 chars

0 chars

0 chars

0 chars

0 chars

0 chars

0 chars