MySQL-focused Performance Engineer at Chess.com
We thought we needed a DBA. We thought we needed more DevOps. What we realize is that we need is you, our MySQL Performance Engineer. You will work closely with Ops to tune the server; build data-access tools with DevOps; polish our schema with the data lords; and create standards and processes so that all application queries are good queries. We've got tens of billions of records and we're redesigning their home to use the best MySQL scaling practices, NoSQL-inspired pragmatism, and zero-downtime global redundancy. Join us.

REQUIREMENTS:
- MySQL 5.7 mastery, with a focus on performance — both for the applications using the DB and the developers building it
- Deep understanding of multi-master, failover, and replication over non-local networks
-Troubleshoot slow logs, schema improprieties, and load issues like you were born to it
- Above average programming chops (PHP/Java/Python), and a deep understanding of ORMs (Doctrine, *Batis)

Things we like — show us examples!
- Big data is your friend, and metadata about big data is your sustenance
- You have bridged a data-layer between multiple datacenters and AWS
- You can make MySQL, Redis, Redis Streams, Kafka, and other event queues sing in harmony

This is a REMOTE, FULL-TIME position. You can learn more about us here:
https://www.chess.com/blog/erik/how-chess-com-s-100-person-virtual-team-works-together
https://www.chess.com/about

What is your name? *
Your answer
What is your email address? *
Your answer
What country do you live in? (This role is open to anyone, but this helps us get to know you better.) *
Your answer
What is your Chess.com username? (It's OK if you don't have one yet!)
Your answer
Please paste in your resume (or a link). *
Your answer
What makes you interested in this job? *
Your answer
Tell us how you feel your background qualifies you for this role. *
Your answer
Please tell us about the largest cluster you have managed. *
Your answer
Please tell us about non-deterministic query replication and how those affect alters. How would you work around or avoid any issues? *
Your answer
Please tell us about your experience scaling/altering multi-billion record tables. *
Your answer
Please tell us about your experience using MySQL query optimizer and indexes. *
Your answer
Please tell us about your experience with JSON blobs. *
Your answer
Please tell us about your experience with sharding. *
Your answer
What questions do you have for us? *
Your answer
Submit
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service