Zynga is looking for a top class MySQL Database Administrator to join their growing team! The Database Administrator will work with the Engineering/Development and Operations teams to manage their database systems.
Identify and recommend tools and services for managing database infrastructure
Hardware sizing requirements for database loads based on efficient use of multi-core systems
Update and tune MySQL instances in a high volume environment
Required Skills :
5 years + RDBMS experience working in a high volume production environment.
At least 2+ years as a specific MYSQL DBA in a LAMP environment working with Centos/ Fedora/ RedHat.
Network and I/O performance tuning.
Solid experience with LVM(Logical Volume Management) and snapshots, Perl, Nagios, Cacti, Subversion.
MySQL replication (Master-Master, Master-Slave, cluster replication) and sharding.
Solid knowledge of physical and logical database design
Solid knowledge in schema design principals with demonstrated aptitude to apply best practices for scalable designs and influence developers
MySQL 5.x (InnoDB and MyISAM engines)
Proficiency in a scripting language (perl preferred)