Site Reliability Engineer 2 - Database

We are looking for an experienced SRE- Database candidate with a good understanding of Linux systems who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will be responsible for orchestrating upgrades, backups, performance monitoring and provisioning of database instances for a high demand fast growing environment with tens of Terabytes of data. These are engineers who are passionate about reliability, performance, and efficiency, and with experience in building tools, services, and automation to manage and improve production services.

Responsibilities

• Provision and manage farms of multimaster MySQL/galera clusters (Linux) across geographical locations
• Ensure performance, security, and availability of databases
• Handle common database procedures, such as upgrade, backup, recovery, migration.
• Manage database changes. ( alters & other ddls )
• Manage infrastructure components outside DB systems and ensuring overall reliability of service
• Troubleshoot issues across the stack - hardware, software, application, and network
• Collaborate with other team members and stakeholders
• Participate in oncall rotation

Skills and Qualifications

• Experience in Linux is a must
• Strong proficiency in MySQL database management

- worked with large farms of db clusters 10+

- large size of db's 1TB+

• Understanding of MySQLs underlying storage engines( InnoDB) and experience with replication configuration
• Knowledge of de-facto standards and best practices in MySQL
• Ability to plan resource requirements from high level specifications
• Ability to effectively manage / augment capacity
• Familiarity with other SQL/NoSQL databases is a plus
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases is a plus
• Proficient understanding of code versioning tools like git
• Ability to mentor younger engineers