SRE - Systems

3 Weeks ago • Upto 1 Years • Administrative

About the job

Job Description

PhonePe seeks an experienced MySQL database administrator with strong Linux skills to manage and ensure the performance, availability, and security of MySQL clusters. Responsibilities include orchestrating upgrades, backups, performance monitoring, and provisioning database instances for a high-demand environment with tens of terabytes of data. This role involves managing multimaster MySQL/Galera clusters across geographical locations, handling database procedures (upgrades, backups, recovery, migration), managing database changes, troubleshooting issues across the stack, and collaborating with stakeholders. The ideal candidate is passionate about reliability, performance, and efficiency, with experience building automation tools.
Must have:
  • Experience in Linux
  • Strong proficiency in MySQL
  • Understanding of MySQL storage engines (InnoDB)
  • Experience with replication configuration
  • Ability to plan resource requirements
Good to have:
  • Familiarity with other SQL/NoSQL databases
  • Knowledge of MySQL limitations and workarounds
  • Proficient understanding of Git
Perks:
  • Medical Insurance
  • Critical Illness Insurance
  • Accidental Insurance
  • Life Insurance
  • Employee Assistance Program
  • Maternity Benefit
  • Paternity Benefit Program
  • Adoption Assistance Program
  • Relocation benefits
  • Higher Education Assistance
  • Car Lease
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

About PhonePe Group: 

PhonePe is India’s leading digital payments company with 50 crore (500 Million) registered users and 3.7 crore (37 Million) merchants covering over 99% of the postal codes across India. On the back of its leadership in digital payments, PhonePe has expanded into financial services (Insurance, Mutual Funds, Stock Broking, and Lending) as well as adjacent tech-enabled businesses such as Pincode for hyperlocal shopping and Indus App Store which is India's first localized App Store. The PhonePe Group is a portfolio of businesses aligned with the company's vision to offer every Indian an equal opportunity to accelerate their progress by unlocking the flow of money and access to services.

Culture

At PhonePe, we take extra care to make sure you give your best at work, Everyday! And creating the right  environment for you is just one of the things we do. We empower people and trust them to do the right  thing. Here, you own your work from start to finish, right from day one. Being enthusiastic about tech is a  big part of being at PhonePe. If you like building technology that impacts millions, ideating with some of  the best minds in the country and executing on your dreams with purpose and speed, join us!

SRE - Systems

Job description
===================
We are looking for an experienced MySQL database administrator 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
o Provision and manage farms of multimaster MySQL/galera clusters (Linux) across geographical
locations
o Ensure performance, security, and availability of databases
o Handle common database procedures, such as upgrade, backup, recovery, migration.
o Manage database changes. ( alters & other ddls )
o Manage infrastructure components outside DB systems and ensuring overall reliability of service
o Troubleshoot issues across the stack - hardware, software, application, and network
o Collaborate with other team members and stakeholders
o Participate in oncall rotation

Skills and Qualifications
o Experience in Linux is a must
o Strong proficiency in MySQL database management
- worked with large farms of db clusters 10+
- large size of db's 1TB+
o Understanding of MySQL’s underlying storage engines( InnoDB) and experience with replication
configuration
o Knowledge of de-facto standards and best practices in MySQL
o Ability to plan resource requirements from high level specifications

o Ability to effectively manage / augment capacity
o Familiarity with other SQL/NoSQL databases is a plus
o Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational
databases is a plus
o Proficient understanding of code versioning tools like git
o Ability to mentor younger engineers


PhonePe Full Time Employee Benefits (Not applicable for Intern or Contract Roles)

  • Insurance Benefits - Medical Insurance, Critical Illness Insurance, Accidental Insurance, Life Insurance
  • Wellness Program - Employee Assistance Program, Onsite Medical Center, Emergency Support System
  • Parental Support - Maternity Benefit, Paternity Benefit Program, Adoption Assistance Program, Day-care Support Program
  • Mobility Benefits - Relocation benefits, Transfer Support Policy, Travel Policy
  • Retirement Benefits - Employee PF Contribution, Flexible PF Contribution, Gratuity, NPS, Leave Encashment 
  • Other Benefits - Higher Education Assistance, Car Lease, Salary Advance Policy

Working at PhonePe is a rewarding experience! Great people, a work environment that thrives on creativity, the opportunity to take on roles beyond a defined job description are just some of the reasons you should work with us. Read more about PhonePe on our blog.

Life at PhonePe

PhonePe in the news

View Full Job Description

About The Company

PhonePe was founded in December 2015 and has emerged as India’s largest payments app, enabling digital inclusion for consumers and merchants alike. With 48 crore (480 Million) registered users, one in four Indians are now on PhonePe. The company has also successfully digitized 3.6 crore (36 Million) offline merchants spread across Tier 2,3,4 and beyond, covering 99% of the postal codes across India. PhonePe is also the leader in Bharat Bill Pay System (BBPS), processing over 45% of the transactions on the BBPS platform. PhonePe forayed into financial services in 2017, providing users with safe and convenient investing options on its platform. Since then, the company has introduced several Mutual Funds and Insurance products that offer every Indian an equal opportunity to unlock the flow of money and access to services. PhonePe was recently recognized as the Most Trusted Brand for Digital Payments as per the Brand Trust Report 2023 by Trust Research Advisory (TRA).



Maharashtra, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

Karnataka, India (On-Site)

View All Jobs

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug