Mysql database administration Jobs in India

Principal Engineer – Backend & Database | BigBasket

Are you excited about the transformative power of ecommerce in changing the landscape of grocery retail in India?

BigBasket is creating milestones in the online grocery market and has recently rehauled its supply chains across cities to fulfil many customer orders faster. The company’s operations have expanded to 30 cities in India, recording about 15 million customer orders per month.

The engineering team thrives on out-of-the-box thinking and a relentless pursuit of excellence. While we are techies at heart — we don't use technology for the sake of technology — we pride ourselves in solving customer problems in the most efficient and elegant ways.

Do customers really care about the efficient implementation of Levenshtein Distance? Well, no. But they really appreciate when their typos are pardoned and don't get in the way.

As a Principal Engineer, we are looking for developers who share our passion for building world-class software. If you are excited about the prospect of changing the way India shops for groceries and being a pioneer — then this is a great home for you. Not to mention the thrill of building products that millions use daily and using cutting-edge technology to make products customers love.

What would you be doing / Expected from this role?

• Prepare a long-term plan for smooth Database management including DB architecture to support future initiatives, multi-tenancy, scaling of infrastructure, etc.
• Monitor DB health, storage growth, and predict potential performance issues ahead of time.
• Perform query cost analysis and tuning of queries identified during DB performance analysis.
• Collaborate with the DB Managed Services vendor to proactively identify DB performance issues and mitigate them.
• Work with AWS for regular operational and performance reviews of existing databases.
• Develop and update BigBasket-specific standards and check for deviations from established best practices.
• Analyse per-DB and per-team costs and help reduce the overall cost for DB setup. Ensure timely setup and renewal of Reservations to reduce cost.
• Work with development teams to review & optimize DB queries over time.
• Plan and work on minor and major maintenance activities.
• Oversee the activities and performance of the DB Managed Services Vendor.
• Evaluate and review monitoring setup, alerts, thresholds, and alert recipients periodically.
• Perform regular database upgrades.
• Ensure database hardening is carried out periodically and vulnerabilities are eliminated.
• Work on data security requirements including encryption and data sanitization during non-prod DB refresh activities.
• Manage user security and handle audit activities.
• Evaluate tools and newer capabilities.
• Work on preparing best practices for development teams.

Who are we looking for?