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, and storage growth, and predict potential performance issues ahead of time.
• Query cost analysis and tuning of queries identified during DB performance analysis.
• Work 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 the 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 each development team and review & optimize the DB queries over some 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 sanitisation during Non-Prod DB refresh activities.
• Work on user security and handle audit activities.
• Evaluate tools and newer capabilities.
• Work on preparing best practices for development teams
Who are we looking for?
• Bachelor’s degree in computer science or equivalent practical experience.
• Experience coding in one or more of the following programming languages: Java, Python
and/or Go Lang.
• Experience in algorithms and data structures.
• Experience designing, analyzing, and troubleshooting large-scale distributed systems.
• Experience with Microservices / Distributed event-based architectures desired.
• Ability to debug, optimize code and automate routine tasks.
• Ability to systematically approach problem-solving and take initiative with a sense of
accountability.
• Must be able to work independently and enjoy working at a fast-paced start-up environment
who is adept at experimenting with new technologies.
• Must have excellent communication (verbal & written), interpersonal, leadership, and
problem-solving skills.