Wikimedia Foundation
Imagine a world in which every single human being can freely share in the sum of all knowledge.
Staff Database Administrator
Location
United States
Posted
1 day ago
Salary
$134.1K - $208.3K / year
Bachelor Degree6 yrs expEnglishLinuxMaria DBMy SQLSQL
Job 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.
Job 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
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development opportunities