Staff Database Administrator

September 13

Apply Now

Receive Emails with Similar Jobs

Wikimedia Foundation

WebsiteLinkedInAll Job Openings

Non-profit • Education • Media

Wikimedia Foundation is a nonprofit charitable organization dedicated to the growth, development, and distribution of free, multilingual content. It provides the essential infrastructure for free knowledge, including hosting Wikipedia, the free online encyclopedia that is created, edited, and verified by a global community of volunteers. Supported primarily through donations, Wikimedia Foundation promotes collaborative projects that aim to share knowledge reflecting human diversity and strives to protect everyone's right to access free and open knowledge.

501 - 1000 employees

Founded 2003

🤝 Non-profit

📚 Education

📱 Media

💰 $2.5M Grant on 2019-09

📋 Description

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

🎯 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

🏖️ Benefits

• See U.S. Benefits & Perks link provided • Competitive, equitable salary adjusted by location • Non-US employees hired through local third party Employer of Record (EOR)