MySQL Database Administrator
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.
Required Skills :
- 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
- 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)