Click to See Complete Forum and Search --> : MySQL Database Administrator


smoothdevil
September 9th, 2008, 12:55 AM
Position : MySQL Database Administrator
Type: Contract
Duration : 5-6 months (possibly will get extended beyond that)
Rate : $70-75/hr
Location: San Diego, CA


The MySQL DBA must have:

· Ability to work with others groups to design and implement distributed MySQL architecture that will support operational expectations.
· Two to three years experience supporting MySQL in a Linux/Unix environment
· Expert knowledge of SQL and writing applications that use MySQL data sources
· Methods and tools for rapidly exporting and importing to and from MySQL databases.
· Actively administered more than 10 production MySQL 5.0 servers in a high-traffic and distributed OLTP environment, with a mix of masters and slaves replication.
· Have written moderately complex Linux/Unix shell scripts utilizing bult-in shell variables, regular expressions, conditional expressions, functions.
· Working knowledge of Linux/Unix tools such as vi, su, ssh, bash/ksh/csh, perl/awk, snmp/monitoring, crontab, kickstart/netboot
· Strong knowledge and experiences in setting up and administered MySQL replication, Master/Slave and Master/Master. Ability to resolve replication delay and sychronization issues. Ability to design the process to automatically failover to one of the Slaves in the case of Master failure.
· Strong knowledge of MySQL backup, recovery and upgrade procedures.
· Experiences to use existing tools or develop scripts to monitor MySQL such as the health of the MySQL databases and replication delays.
· Strong knowledge of MySQL performance tuning at the MySQL server configuration level as well as SQL tuning.
· 24x7 production on-call support

For more information:

http://www.smoothdevil.com/index.php?page=job&job_id=596

closes: 3 Nov 2008