4 days ago
In this role, your main role will be to maintain, scale, and administer our large sharded MySQL database environment (more than 100TB of DB storage! 36 primary-replica pairs, hosting 200 shards!) Help teach and encourage smart database practices. Improve automation of our various database systems to help enable self-service (when it makes sense), and implement self-healing, and resiliency. Improve automated backup and restore systems. Recommend schema improvements, and help adjust queries to better match existing indexes. Suggest new indexes, when appropriate. Improve alerting - if it alerts and isn’t actionable, it’s not an alert! If something goes wrong and we don’t get alerted, we need a new alert! Experiment and recommend new database engine upgrades, and entirely new data stores (when they make sense).