Database Administrator

Wikimedia Foundation

(San Francisco, California)
Full Time
Job Posting Details
About Wikimedia Foundation
The Wikimedia Foundation, Inc. is a nonprofit charitable organization dedicated to encouraging the growth, development and distribution of free, multilingual, educational content, and to providing the full content of these wiki-based projects to the public free of charge. The Wikimedia Foundation operates some of the largest collaboratively edited reference projects in the world, including Wikipedia, a top-ten internet property.
Responsibilities
**Summary** Wikipedia's goal is to provide every single person with the sum of all human knowledge and MariaDB is how we store it. You will be joining a small mission driven team of talented highly experienced operations engineers. As one of the most highly trafficked sites, there is literally nowhere else serving as many page views per engineer. As a DBA with Storage Engineering expertise 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 MariaDB and MySQL, plan for disaster recovery, and implement backup systems. This is a unique opportunity to have a huge impact. Our work is important, and it’s seen by hundreds of millions of people. **Description** * Implementation and maintenance of database and other storage servers in production, staging environments, and Wikimedia Labs * Database performance tuning, high availability, backups, and general optimization. * Providing guidance and support to application developers for schema design and schema changes, code review, SQL query tuning * Handling (Debian) package maintenance, patching and building, upstream bug identification and resolution. * Expansion of the monitoring and alerting infrastructure * Multi-datacenter design, capacity and infrastructure planning * Response to system outages, monitoring key metrics * General infrastructure operations and system administration, including server installations and configuration management
Ideal Candidate
**Requirements** * Advanced level of experience with MariaDB or MySQL database internals administration * Advanced knowledge of Linux internals and file systems * Experience with Linux system administration * Deep knowledge of database storage concepts and working experience with storage systems, architectures and concepts * Experience with high traffic web site architectures and operations * Hands-on experience and eagerness to learn and try new concepts is more important than having certificates * You are a proficient English speaker * BS, MS, or PhD in Computer Science or equivalent work experience **Pluses** * Experience with NoSQL / key value stores and graph databases (e.g. Cassandra, Titan) is a big plus * Experience with software development and programming languages (e.g. C, PHP) is a plus * Experience with configuration management software (e.g. Puppet) is a plus * Experience contributing to open source projects is a major plus * Understanding of Wikimedia and the free culture movement is a plus

Questions

Answered by on
This question has not been answered
Answered by on

There are no answered questions, sign up or login to ask a question

Want to see jobs that are matched to you?

DreamHire recommends you jobs that fit your
skills, experiences, career goals, and more.