Wikimedia Foundation, Inc.

**Summary**

  


Wikimedia's goal is to provide every single person with the sum of all human knowledge and MariaDB/MySQL is how we store most of it. You will be joining a small mission driven team of talented highly experienced engineers.  As one of the most highly trafficked sites, there is literally nowhere else serving as many page views per engineer. As a Database Administrator at the Wikimedia Foundation, you will be responsible for the wellbeing of our relational data and the database systems they reside on, including the availability and performance.  You should be able to troubleshoot, benchmark and test new builds of MariaDB and MySQL, plan for disaster recovery, and improve and maintain backups. This is a unique opportunity to have a huge impact. Our work is important, and it's used by hundreds of millions of people.

  


 ** **Responsibilities****

  


  

  * Implementation, maintenance and troubleshooting of relational database systems in production and staging environments
  

  * Database performance tuning, high availability, replication, backups, and general optimization
  

  * Support the development and deployment of new services and systems
  

  * Handling configuration management, (Debian) package maintenance, patching and building, working with upstream on bug identification and resolution
  

  * Improving observability (alerting, metrics, monitoring) of database infrastructure
  

  * Multi-datacenter design, capacity and infrastructure planning
  

  * Take part in incident response, diagnosis and follow-up on system outages or alerts across Wikimedia's production infrastructure
  

  * Share our [values](https://wikimediafoundation.org/wiki/Values) and work in accordance with them
  

  


 ** **Qualifications****

  


  

  * Solid knowledge of relational database concepts and working experience with storage systems and architectures
  

  * Advanced level of experience with MariaDB or MySQL database administration and replication topologies at scale
  

  * Proficiency in SQL
  

  * Decent programming language/scripting skills and experience managing software using relational databases at large scale
  

  * 3+ years experience in an DBA/SRE/Operations/DevOps role as part of a team
  

  * Experience with high traffic and highly available website architectures and operations
  

  * Advanced knowledge of Linux and IO/data storage concepts, internals and troubleshooting
  

  * Experience with Open Source configuration management and orchestration tools (Puppet, Ansible, Chef, SaltStack, etc.), as well as modern observability infrastructure (Prometheus, Grafana, Graphite, Logstash/Kibana, Icinga/Nagios, etc.)
  

  * Experience with managing remotely both bare-metal servers and virtualized environments
  

  * Strong English language skills
  

  * Ability to work independently in a fast paced environment, as an effective part of a globally distributed team, including ticket tracking systems and asynchronous communication tools
  

  * B.S. or M.S. in Computer Science or equivalent work experience
  

  


 ** **Optional qualifications****

  


  

  * Experience with LAMP stack technologies (PHP/HHVM, memcached/Redis, MySQL) - MediaWiki experience is a definite plus
  

  * Experience with advanced distributed storage and database systems (Swift, Ceph, Cassandra, etc.) or graph databases (Titan, Blazegraph, etc.) is a **big** plus
  

  * Experience in architecture, design, and implementation of persistent data storage & query infrastructure
  

  * Strong track record of open source contributions is a major plus
  

  


  **U.S. Benefits & Perks***

  


  

  * Fully paid medical, dental and vision coverage for employees and their eligible families (yes, fully paid premiums!)
  

  * The Wellness Program provides reimbursement for mind, body and soul activities such as fitness memberships, baby sitting, continuing education and much more
  

  * The 401(k) retirement plan offers matched contributions at 4% of annual salary
  

  * Flexible and generous time off - vacation, sick and volunteer days, plus 19 paid holidays - including the last week of the year.
  

  * Family friendly! 100% paid new parent leave for seven weeks plus an additional five weeks for pregnancy, flexible options to phase back in after leave, fully equipped lactation room.
  

  * For those emergency moments - long and short term disability, life insurance (2x salary) and an employee assistance program
  

  * Pre-tax savings plans for health care, child care, elder care, public transportation and parking expenses
  

  * Telecommuting and flexible work schedules available
  

  * Appropriate fuel for thinking and coding (aka, a pantry full of treats) and monthly massages to help staff relax
  

  * Great colleagues - diverse staff and contractors speaking dozens of languages from around the world, fantastic intellectual discourse, mission-driven and intensely passionate people
  

  


 _ ***Eligible international workers' benefits are specific to their location and dependent on their employer of record**_

  


 **More information**

  


 **[WMF](https://wikimediafoundation.org/)**  
 **[Blog  
](https://wikimediafoundation.org/news/)[Wikimedia 2030  
](https://meta.wikimedia.org/wiki/Strategy/Wikimedia_movement/2017)[Wikimedia Medium Term Plan  
](https://meta.wikimedia.org/wiki/Wikimedia_Foundation_Medium-term_plan_2019)[Diversity and inclusion information for Wikimedia workers, by the numbers](https://wikimediafoundation.org/news/2019/10/01/wikimedia-foundation-diversity-and-inclusion-information-about-our-workers-2019-by-the-numbers/)[  
Wikimania 2019  
](https://meta.wikimedia.org/wiki/Wikimania_2019)[Annual Report - 2017](https://annual.wikimedia.org/2017/) **  
 **[This is Wikimedia Foundation](https://www.youtube.com/watch?v=OQzZI0l3IOw)   
** **[Facts Matter  
](https://www.youtube.com/watch?v=xQ4ba28-oGs)** **[Our Projects  
](https://wikimediafoundation.org/wiki/Our_projects)[Fundraising Report](https://meta.wikimedia.org/wiki/Fundraising/2018-19_Report)**

Database Administrator at Wikimedia Foundation, Inc. () (allows remote)

**Summary**

  


Wikimedia's goal is to provide every single person with the sum of all human knowledge and MariaDB/MySQL is how we store it. You will be joining a small mission driven team of talented highly experienced engineers.  As one of the most highly trafficked sites, there is literally nowhere else serving as many page views per engineer. As a Database Architect at the Wikimedia Foundation, you will be responsible for the architecture, design, availability and performance of our database infrastructure in a globally distributed infrastructure. You will work together with our developers and SREs on optimizing queries, schema design and coming up with a data strategy. This is a unique opportunity to have a huge impact.  Our work is important, and it's used by hundreds of millions of people.

  


 ** **Responsibilities****

  


  

  * Drive research, architecture, design, and implementation of Wikimedia persistent data storage & query infrastructure
  

  * Coordinate and consult with and communicate with other members of the Wikimedia engineering teams on data and query design for MediaWiki & associated services and projects
  

  * Be part of the team that is responsible for database performance tuning, high availability, backups, and general optimization.
  

  * Lead internal documentation efforts, mentor other staff in various aspects of Wikimedia infrastructure and services and lead by setting the example
  

  * Lead incident response, diagnosis and follow-up on system outages or alerts across Wikimedia's production infrastructure
  

  * Share our [values](https://wikimediafoundation.org/wiki/Values) and work in accordance with them
  

  


 ** **Qualifications****

  


  

  * Deep knowledge of database storage concepts and working experience with storage systems, architectures and concepts
  

  * Advanced level of experience with MariaDB or MySQL database administration and replication topologies at scale
  

  * In-depth knowledge of SQL and optimization of queries
  

  * Strong programming language skills and experience designing and developing software using relational databases at large scale
  

  * 5+ years experience in an DBA/SRE/Operations/DevOps role as part of a team
  

  * Advanced knowledge of Linux and IO/data storage internals and troubleshooting
  

  * Experience with managing geographically distributed, highly available, high traffic infrastructure based on Linux
  

  * Experience with Open Source configuration management and orchestration tools (Puppet, Ansible, Chef, SaltStack, etc.), as well as modern observability infrastructure (Prometheus, Grafana, Graphite, Logstash/Kibana, Icinga/Nagios, etc.)
  

  * Experience with managing remotely both bare-metal servers and virtualized environments
  

  * Strong English language skills
  

  * Ability to work independently, as an effective part of a globally distributed team, including ticket tracking systems and asynchronous communication tools
  

  * B.S. or M.S. in Computer Science or equivalent in work experience
  

  


 ** **Optional qualifications****

  


  

  * Experience with LAMP stack technologies (PHP/HHVM, memcached/Redis, MySQL) - MediaWiki experience is a definite plus
  

  * Experience with advanced distributed storage and database systems (Swift, Ceph, Cassandra, etc.) or graph databases (Titan, Blazegraph, etc.) is a **big** plus
  

  * Strong track record of open source contributions is a major plus
  

  


 **The Wikimedia Foundation is...  **

  


...the nonprofit organization that hosts and operates Wikipedia and the other Wikimedia free knowledge projects. Our vision is a world in which every single human can freely share in the sum of all knowledge. We believe that everyone has the potential to contribute something to our shared knowledge, and that everyone should be able to access that knowledge, free of interference. We host the Wikimedia projects, build software experiences for reading, contributing, and sharing Wikimedia content, support the volunteer communities and partners who make Wikimedia possible, and advocate for policies that enable Wikimedia and free knowledge to thrive. The Wikimedia Foundation is a charitable, not-for-profit organization that relies on donations. We receive financial support from millions of individuals around the world, with an average donation of about $15. We also receive donations through institutional grants and gifts. The Wikimedia Foundation is a United States 501(c)(3) tax-exempt organization with offices in San Francisco, California, USA.

  


 _The Wikimedia Foundation is an equal opportunity employer, and we encourage people with a diverse range of backgrounds to apply_

  


 **U.S. Benefits & Perks***

  


  

  * Fully paid medical, dental and vision coverage for employees and their eligible families (yes, fully paid premiums!)
  

  * The Wellness Program provides reimbursement for mind, body and soul activities such as fitness memberships, baby sitting, continuing education and much more
  

  * The 401(k) retirement plan offers matched contributions at 4% of annual salary
  

  * Flexible and generous time off - vacation, sick and volunteer days, plus 19 paid holidays - including the last week of the year.
  

  * Family friendly! 100% paid new parent leave for seven weeks plus an additional five weeks for pregnancy, flexible options to phase back in after leave, fully equipped lactation room.
  

  * For those emergency moments - long and short term disability, life insurance (2x salary) and an employee assistance program
  

  * Pre-tax savings plans for health care, child care, elder care, public transportation and parking expenses
  

  * Telecommuting and flexible work schedules available
  

  * Appropriate fuel for thinking and coding (aka, a pantry full of treats) and monthly massages to help staff relax
  

  * Great colleagues - diverse staff and contractors speaking dozens of languages from around the world, fantastic intellectual discourse, mission-driven and intensely passionate people
  

  


 _ ***Eligible international workers' benefits are specific to their location and dependent on their employer of record**_

  


 **More information**

  


[Wikimedia Foundation website](https://wikimediafoundation.org/)

  


[Wikimedia Foundation blog](https://blog.wikimedia.org/)

  


[Annual Report - 2017](https://annual.wikimedia.org/2017/)

  


[Wikimedia 2030](https://meta.wikimedia.org/wiki/Strategy/Wikimedia_movement/2017)

Database Architect at Wikimedia Foundation, Inc. () (allows remote)

**Summary**

  


We are looking for a Site Reliability Engineer! Would you like to join the highly dynamic team responsible for the reliability and performance of a global top-10 website -- Wikipedia? You would join the Search Team, where we build the infrastructure for search and discovery of Wikipedia content. We are working on Open Source, JVM / Linux based stacks (Elasticsearch, Wikidata Query Service).

  


We are searching for people with a drive to explore, experiment, and learn new technologies. Do you enjoy eliminating boring things from your daily workflow by automating them? Are you comfortable working in a highly collaborative, consensus-oriented, open environment and as part of a globally-distributed team? Then you might be just the person we need.

  


 **Responsibilities**

  


  

  * Performing day-to-day operational and DevOps tasks on Wikimedia's public facing infrastructure (deployment, maintenance, configuration, troubleshooting)
  

  * Implementing and utilizing configuration management and deployment tools (Puppet, Kubernetes)
  

  * Assisting in the architectural design of new services and making them operate, at scale
  

  * Monitoring of systems, services and service clusters, optimization of performance and resource utilization
  

  * Assisting in or leading incident responses, diagnosis and follow-up on system outages or alerts across Wikimedia's production infrastructure
  

  * Sharing our values and working in accordance with them
  

  


 **Qualifications**

  


  

  * 3+ years experience in an SRE/Operations/DevOps role as part of a team
  

  * Experience with managing geographically distributed, highly available, high-traffic infrastructure based on JVM / Linux
  

  * Working understanding of garbage collection, Java logging frameworks and JMX
  

  * Comfortable with Open Source configuration management and orchestration tools (Puppet, Ansible, Chef, SaltStack, etc.)
  

  * Experience with the use, and configuration of, monitoring, metrics and logging infrastructure (Icinga/Nagios, Prometheus, Grafana, Graphite, Logstash/Kibana, etc.)
  

  * Comfortable with shell and scripting languages used in an SRE/Operations engineering context (Python, Go, Bash, Ruby, etc.)
  

  * Comfortable with managing remotely bare-metal servers and virtualized environments
  

  * Aptitude for automation and streamlining of tasks
  

  * Strong English-language skills and ability to work independently, as an effective part of a globally distributed team
  

  * B.S. or M.S. in Computer Science or equivalent work experience
  

  


 **Pluses**

  


  

  * Track record of open source contributions is a major plus
  

  * Experience with Elasticsearch
  

  * Experience with graph databases
  

  * Low level systems troubleshooting and debugging (CPU/memory profiling, C/C++ experience, in-depth Linux knowledge)
  

  * Example projects
  

  


 **These are some of our upcoming projects you might be working on soon …**

  


  

  * Upgrade a multi-terabyte Elasticsearch cluster to the next version of software, without any impact to our users (or uptime)
  

  * Scale our graph database (Wikidata Query Service) to more than 10 billion triples
  

  * Help define a hardware procurement strategy to grow our Elasticsearch clusters
  

  
  
  


 **U.S. Benefits & Perks***

  


  

  * Fully paid medical, dental and vision coverage for employees and their eligible families (yes, fully paid premiums!)
  

  * The Wellness Program provides reimbursement for mind, body and soul activities such as fitness memberships, baby sitting, continuing education and much more
  

  * The 401(k) retirement plan offers matched contributions at 4% of annual salary
  

  * Flexible and generous time off - vacation, sick and volunteer days, plus 19 paid holidays - including the last week of the year.
  

  * Family friendly! 100% paid new parent leave for seven weeks plus an additional five weeks for pregnancy, flexible options to phase back in after leave, fully equipped lactation room.
  

  * For those emergency moments - long and short term disability, life insurance (2x salary) and an employee assistance program
  

  * Pre-tax savings plans for health care, child care, elder care, public transportation and parking expenses
  

  * Telecommuting and flexible work schedules available
  

  * Appropriate fuel for thinking and coding (aka, a pantry full of treats) and monthly massages to help staff relax
  

  * Great colleagues - diverse staff and contractors speaking dozens of languages from around the world, fantastic intellectual discourse, mission-driven and intensely passionate people
  

  


 _ ***Eligible international workers' benefits are specific to their location and dependent on their employer of record**_

  


 **More information**

  


[ **WMF  
**](https://wikimediafoundation.org/)[ **Blog  
**](https://wikimediafoundation.org/news/)[ **Wikimedia 2030  
**](https://meta.wikimedia.org/wiki/Strategy/Wikimedia_movement/2017)[ **Wikimedia Medium Term Plan  
**](https://meta.wikimedia.org/wiki/Wikimedia_Foundation_Medium-term_plan_2019)[ **Diversity and inclusion information for Wikimedia workers, by the numbers  
**](https://wikimediafoundation.org/2018/08/30/diversity-inclusion-numbers/)[ **Wikimania 2019  
**](https://meta.wikimedia.org/wiki/Wikimania_2019)[ **Annual Report - 2017**](https://annual.wikimedia.org/2017/)

graphite Jobs

1 month ago

Wikimedia Foundation, Inc.

Database Administrator

B.S.

2 months ago

Wikimedia Foundation, Inc.

Database Architect

San Francisco

Wikimedia Foundation, Inc.

Site Reliability Engineer (166)