Database Reliability Engineering (DBRE)

Gurugram, Haryana, India Full-time

About Grofers:
Grofers is a low-price online supermarket that gets products across categories like grocery, beauty & wellness, household care, baby care, pet care and meats & seafood delivered to your doorstep. At Grofers we believe in improving the quality of life of our customers by providing them best products at best prices. To be able to meet customer expectations and enrich their shopping experience, we provide them with products they best relate with, help them save money on everyday purchases, and give them the spending power they need.

 

Objective of the Role:
Database Reliability Engineers (DBRE) are responsible for keeping database systems that support all internal and external services (most notably Grofers Apps & Grofers.com) and many other Grofers' production systems running smoothly 24/7/365.
They are responsible for maintaining RDBMS (notably PostgreSQL but also MySQL) clusters and also helping engineers maintain these clusters by themselves, driving good database design and maintenance practices and building tools for other engineering teams for self-serve maintenance. They are also responsible for exploring new database solutions for specific use-cases that are not best served by SQL databases.

 

Roles & Responsibilities:

  • Work on database reliability and performance aspects for all of Grofers' internal and external products from within the DBRE team as well as work on shipping solutions with different products.
  • Analyze solutions and implement best practices for our main PostgreSQL database cluster and its components.
  • Work on the observability of relevant database metrics and make sure we reach our database objectives.
  • Work with peer engineers to roll out changes to our production environment and help mitigate database-related production incidents.
  • OnCall support on rotation with the team.
  • Provide database expertise to engineering teams (for example through reviews of database migrations, queries and performance optimizations). Scale database engineering as a practice in other engineering teams.
  • Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
  • Plan the growth of Grofers' database infrastructure by evaluating novel SQL as well as NoSQL solutions specific to varying business needs.
  • Support and debug database production issues across services and levels of the stack.
  • Make monitoring and alerting alert on symptoms and not on outages.
  • Collaborate with internal and external auditors for audits and regulations and build that in our database systems

 

Desired Skills & abilities:

  • Have at least 5 years of experience running PostgreSQL in large production environments
  • Have at least 2 years of experience with infrastructure automation and configuration management (Chef, Ansible, Puppet, Terraform…)
  • Have at least 3 years of experience with any object-oriented programming language in a software engineering role
  • Have experience with Django, Flask, other Ruby and/or Python web frameworks, Java web frameworks or Go
  • Have strong programming skills
  • Have a solid understanding of SQL and PL/pgSQL
  • Have a solid understanding of the internals of PostgreSQL
  • Know your way around Linux and the Unix Shell. You live in the shell.
  • Have the ability to orchestrate and automate complex administrative tasks. Knowledge in config management systems like Ansible (the one we use)
  • Passion for stable and secure systems management practices
  • Strong data modeling and data structure design skills

 

Excited? you will definitely be, once you visit our Engineering Blog where you can deep dive into all the cool stuff that our engineers have been working on.

All candidates interested in exploring the opportunity are requested to apply with us on careers@grofers.com