Database Reliability Engineer II

Job Description

Innovaccer is seeking a Database Reliability Engineer II to enhance their product experience. This role involves collaborating with other engineers to address customer pain points and build delightful features.

Role Involves:

• Database design, model, implement and size large scale systems using Snowflake, PostgreSQL and MongoDB
• 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.

Requirements:

• 4-8 years of experience
• Experience in fast-paced environments
• Hands-on experience with SQL and Python or other scripting languages
• Experience with cloud environments like AWS, Azure, and GCP
• In-depth knowledge of MongoDB, Redis, or Elasticsearch
• Knowledge of PostgreSQL / Snowflake / MySQL is a plus
• Experience setting up high availability, replication, and incremental backups
• Knowledge of database security best practices
• Knowledge of DB design principles, partitioning/sharding, and query optimization
• Expertise in troubleshooting database performance issues
• Experience with cloud-managed and self-hosted databases
• Experience building proof of concepts and improving existing systems
• Knowledge/experience with Terraform, Jenkins, Ansible is a plus
• Knowledge of database monitoring stacks like Prometheus and Grafana
• Expertise in Docker and Kubernetes
• Proactive with the ability to solve complex technical issues

What Innovaccer Offers:

• 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