PhonePe Recruitment Drive | Hiring Site Reliability Engineer – Database

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 MySQL’s 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.

Job Description:

• PhonePe is 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