Site Database Reliability Engineer-I

About the Role

Site Database Reliability Engineer-II

A Day in the Life

• Database design, model, implement and size large scale systems using Snowflake, PostgreSQL and MongoDB
• Responsible for Provisioning, availability 24X7, reliability, performance, Security, maintenance, upgrades, and cost optimization
• Capacity planning of large-scale database clusters
• Automate DB provisioning, deployments, routine administration, maintenance and upgrades
• Address the business critical incidents P0/P1 within the SLA, identify the RCA and address the issue permanently
• Sync data between multiple data stores (eg: PostgreSQL to ES and Snowflake to ES)
• Design, document and benchmark the Snowflake or MongoDB
• DB Maintenance, Backup, Health check, alerting and Monitoring
• Create processes, best practices, and enforce
• Identify and tune the long running queries to improve DB performance and to reduce the cost.

What You Need

• Having 4+ years of experience.
• Work in a fast-paced environment with the agility to change directions as per business needs.
• Hands-on experience on SQL query writing along with Python or any other scripting language in any database environments.
• Demonstrated experience any cloud environment like AWS, Azure and GCP.
• Having in-depth knowledge on any two of MongoDB , Redis or Elasticsearch (ELK).
• Knowledge on PostgreSQL / Snowflake / MySQL is a plus.
• Setup high availability, replication and incremental backups for various datastores.
• Setup database security best practices like encryption, auditing and Role based access control.
• Knowledge on DB design principles, partitioning / shading and query optimization.
• Expert in troubleshooting database performance issues in production.
• Demonstrated experience with any cloud managed databases and self hosted databases, managing medium to large sized production.
• Experience in building proof of concepts, trying out new solutions and improving existing systems with best practices to solve business problems and support scaling.
• Having knowledge/ experience with Terraform , Jenkins , Ansible is a plus .
• Having knowledge on database monitoring stack such as Prometheus and grafana.
• Having expertise on Docker and Kubernetes is mandatory.
• Should be proactive and have the intellect to explore and come up with solutions to complex technical issues.

Heres What We Offer

• Generous Leave Benefits

  : Enjoy generous leave benefits of up to 40 days.

• Parental Leave

  : Experience one of the industry's best parental leave policies to spend time with your new addition.

• Sabbatical Leave Policy

  : Want to focus on skill development, pursue an academic career, or just take a break We've got you covered.

• Health Insurance

  : We offer health benefits and insurance to you and your family for medically related expenses related to illness, disease, or injury.

• Pet-Friendly Office

  *: Spend more time with your treasured friends, even when you're away from home. Bring your furry friends with you to the office and let your colleagues become their friends, too. *Noida office only

• Creche Facility for children

  *: Say goodbye to worries and hello to a convenient and reliable creche facility that puts your child's well-being first. *India offices