[Remote] Staff Database Administrator at Wikimedia Foundation

Remote

Wikimedia Foundation Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Internet, Biotechnology, SoftwareIndustries

Requirements

  • Advanced level of experience with MariaDB or MySQL database administration as the primary production database, including complex replication topologies at scale
  • Advanced proficiency in SQL and query/schema optimization
  • Experience with debugging query performance and schema design
  • Experience with high traffic and highly available website architectures and operations
  • Experience with MySQL high availability and replication management tooling
  • Knowledge of Linux and IO/data storage concepts, internals and troubleshooting
  • 6+ years experience in a hands-on DBA role as part of a team
  • Solid English language skills
  • Ability to travel 1-2 times a year
  • 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.Sc. or M.Sc. in Computer Science, or equivalent work experience

Responsibilities

  • Ensure the health and performance of Wikimedia’s production relational database systems, and the structural integrity of its data
  • Deploy, maintain and troubleshoot relational database systems in production, development and staging environments
  • Design, implement, manage and automate (multi-site) replication topologies
  • Consult in the design of database schemas and queries, and implement/oversee database schema changes in production
  • Monitor, debug and optimize database query performance
  • Improve observability (alerting, metrics, monitoring) of database infrastructure
  • Capacity and infrastructure planning, including (on-prem) bare-metal hardware
  • Contribute to the automation of common database management workflows
  • Enable the reliable generation and timely restoration of database backups
  • Maintain relationships with the MariaDB upstream projects/organizations, and working with upstream developers on bug identification and resolution
  • Participate in a 24/7 on-call rotation shared across the team - taking part in incident response, diagnosis and follow-up on system outages or alerts across Wikimedia’s production infrastructure

Skills

MariaDB
MySQL
SQL
Database Administration
Database Design
Database Optimization
Replication
Monitoring
Alerting
Capacity Planning
Backup
Troubleshooting

Wikimedia Foundation

Operates Wikipedia and free knowledge projects

About Wikimedia Foundation

The Wikimedia Foundation operates Wikipedia and other free knowledge projects, aiming to create a world where everyone can freely access and share knowledge. It provides a platform for users to read, contribute, and share content, while also supporting the volunteer communities that help maintain these projects. The foundation is funded by donations from individuals and institutions, emphasizing its nonprofit status. Unlike many other organizations, it focuses on making knowledge accessible to all without charge, advocating for policies that support free knowledge initiatives. Its goal is to empower individuals to contribute to and benefit from a collective pool of knowledge.

San Francisco, CaliforniaHeadquarters
2003Year Founded
$145.9MTotal Funding
GRANTCompany Stage
Social Impact, EducationIndustries
501-1,000Employees

Benefits

Remote Work Options

Risks

Reliance on Nvidia's AI tech may affect Wikimedia's data processing autonomy.
DSA audit could reveal vulnerabilities requiring significant resources to address.
Decentralized platforms like Mastodon may divert users from Wikipedia.

Differentiation

Wikimedia Foundation operates the world's largest free online encyclopedia, Wikipedia.
It supports a diverse range of projects like Wiktionary and Wikisource.
The Foundation is a non-profit, relying on global donations for funding.

Upsides

Nvidia's NeMo Retriever tech reduced Wikipedia processing time from 30 days to 3 days.
Holistic AI's audit under the DSA enhances Wikimedia's platform safety and accountability.
Collaboration with Open Foundation West Africa combats misinformation during Ghana's elections.

Land your dream remote job 3x faster with AI