Staff Database Administrator

Wikimedia

United States

United States

Ähnliche Jobs finden

Über

divh2Staff Database Administrator/h2pstrongSummary/strong/ppWere hiring a Staff Database Administrator to support and protect the sum of all human knowledge, shared by Wikipedia and its sister projects. Much of that knowledge is stored using MariaDB, and therefore were looking for someone with a strong expertise in designing, operating and optimizing relational (SQL) database infrastructure at large scale (MariaDB and other MySQL derivatives in particular), to support and scale the technology behind Wikipedia and its sister projectssome of the most visited websites on the internet./ppstrongYou are responsible for:/strong/pulliEnsure the health and performance of Wikimedias production relational database systems, and the structural integrity of its data./liliDeploy, maintain and troubleshoot relational database systems in production, development and staging environments/liliDesign, implement, manage and automate (multi-site) replication topologies/liliConsult in the design of database schemas and queries, and implement/oversee database schema changes in production/liliMonitor, debug and optimize database query performance/liliImprove observability (alerting, metrics, monitoring) of database infrastructure/liliCapacity and infrastructure planning, including (on-prem) bare-metal hardware/liliContribute to the automation of common database management workflows/liliEnable the reliable generation and timely restoration of database backups/liliMaintain relationships with the MariaDB upstream projects/organizations, and working with upstream developers on bug identification and resolution/liliParticipate 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 Wikimedias production infrastructure./li/ulpstrongYou share our values and work in accordance with them/strong/ppstrongSkills and Experience:/strong/pulliAdvanced level of experience with MariaDB or MySQL database administration as the primary production database, including complex replication topologies at scale/liliAdvanced proficiency in SQL and query/schema optimization/liliExperience with debugging query performance and schema design/liliExperience with high traffic and highly available website architectures and operations/liliExperience with MySQL high availability and replication management tooling/liliKnowledge of Linux and IO/data storage concepts, internals and troubleshooting (we run Linux in production exclusively)/lili6+ years experience in a hands-on DBA role as part of a team/liliSolid English language skills/liliAbility to travel 1-2 times a year/liliAbility 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/liliB.Sc. or M.Sc. in Computer Science, or equivalent work experience/li/ulpstrongAdditionally, wed love it if you have:/strong/pulliProficiency at automation/programming/scripting (Python) and standard software development practices/liliExperience with SRE practices and tooling, including configuration management orchestration strongly preferred./liliExperience with LAMP stack technologies (PHP/HHVM, memcached/Redis) - MediaWiki experience is a definite plus/liliExperience with other advanced distributed storage and database systems (Swift, Ceph, Cassandra, etc.) is a plus/liliStrong track record of open source contributions is a major plus/li/ul/div

United States

Sprachkenntnisse

English

Hinweis für Nutzer

Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.

Ähnliche Jobs finden