MySQL Database Administrator
Wikimedia Foundation - San Francisco, CA

This job posting is no longer available on Omidyar Networks. Find similar jobs: MySQL Database Administrator jobs - Wikimedia Foundation jobs

San Francisco or Remote
Full-Time

Summary

Wikipedia's goal is to provide every single person with the sum of all human knowledge and MySQL is how we store it. As a Database Engineer at the Wikimedia Foundation, you will be responsible for the availability and performance of our database infrastructure. You should be able to optimize queries, automate anything, benchmark and test new builds of MySQL and MariaDB, plan for disaster recovery, and implement backup systems. You will be joining a small mission driven team of talented veteran operations engineers. As the 5th most trafficked site, there is literally nowhere else serving as many page views per engineer. This is a unique opportunity to have a huge impact. Our work is important, and it’s seen by hundreds of millions of people.

Responsibilities
Build and tune database servers and data migration processes
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
Performance optimization, implementation and optimization
Setup and monitor data backups
Monitor key metrics and respond to system outages
Establish database capacity planning framework
Requirements
5+ years working with RDBMS in a high volume production environment
A minimum of 2+ years as a MYSQL DBA in a LAMP environment
Network and I/O performance tuning experience
Solid knowledge of physical and logical database design
Solid knowledge in schema design principles with demonstrated aptitude to apply best practices for scalable designs and influence developers
Experience supporting MySQL in a web environment
Expert knowledge of Linux internals and various file systems
Comfortable working in a highly collaborative, consensus-oriented environments
Expertise with configuration management systems such as Puppet, Chef or cfengine
BS, MS, or PhD in Computer Science or equivalent work experience
Preferred
Able to work independently where needed, and can work remotely as part of a globally distributed team
Proficiency in a scripting language (PHP preferred)
Solid experience with LVM (Logical Volume Management) and snapshots, Perl, Nagios, Cacti, Subversion
Demonstrated contributions to open-source software projects

Show us your stuff! Please provide us with information you feel would be useful to us in gaining a better understanding of your technical your background and accomplishments. Links to GitHub, personal web pages, projects, etc. are exceptionally useful. We especially appreciate pointers to open source projects of which you are particularly proud of.

About The Wikimedia Foundation
The Wikimedia Foundation got its start in 2003 and is the non-profit organization that operates Wikipedia. Based in San Francisco California we currently employ 150 staff members globally. The Wikimedia Foundation is committed to creating a world in which every single human being can freely and easily share in the sum of all knowledge. Wikipedia and our other projects operated by the Wikimedia Foundation receive nearly 500 million unique visitors per month making them the 5th most popular web property worldwide. Wikipedia is available in 282 languages, contains more than 21 million articles contributed by a global volunteer community of more than 100,000 people. In an effort to continue our mission we are hiring talented and creative individuals to join the team. Job Location(s) San Francisco, CA, US

Website wikimediafoundation.org/wiki/Job_openings

Omidyar Networks - 20 months ago - save job - copy to clipboard