Senior Database Administrator

 Responsibilities

• Implementation, maintenance and troubleshooting of relational database systems in production and staging environments
• Handling database version upgrades, testing and working with upstream on bug identification and resolution
• Configuring replication, designing schema optimizations and running schema changes
• Monitoring, debugging and improving query performance
• Improving observability (alerting, metrics, monitoring) of database infrastructure
• Multi-datacenter replication topology design, capacity and infrastructure planning
• Taking part in incident response, diagnosis and follow-up on system outages or alerts across Wikimedia’s production infrastructure and participating in an on call rotation
• Sharing our values and work in accordance with them

Qualifications

• Advanced level of experience with MariaDB or MySQL database administration as the primary production database as well as replication topologies at scale
• Knowledge of Linux and IO/data storage concepts, internals and troubleshooting (we run Linux in production exclusively)
• Proficiency in SQL
• Experience with debugging query performance and schema design
• Experience with MySQL high availability and replication management tooling
• Experience with remotely managing bare-metal servers
• 5+ years experience in a hands-on DBA role as part of a team
• Experience with high traffic and highly available website architectures and operations
• 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.Sc. or M.Sc. in Computer Science or equivalent work experience

Optional qualifications

• Proficient at automation/programming/scripting skills
• Experience with LAMP stack technologies (PHP/HHVM, memcached/Redis) - MediaWiki experience is a definite plus
• Experience with advanced distributed storage and database systems (Swift, Ceph, Cassandra, 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