URL

http://wikimediafoundation.org

Headquarters

United States

Twitter

wikimediaatwork

Company's Other Jobs

Click to view

WARNING! This job is awaiting verification or has expired and may no longer be applicable
Category

System Administration

Posted

2013-04-17 21:46

Description

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 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

If this sounds like you then 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 your own work are essential (e.g. Github, Sourceforge, etc). We especially appreciate pointers to open source projects of which you have actively contributed to.

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.

Application Info

Please sign in with Google or GitHub to view this job's application information. This is necessary to prevent companies from receiving excessive amounts of spam.

Country

Anywhere*

Location

San Francisco or Remote

Tramcar - Toronto-Waterloo Region Corridor Jobs