We at Innovaccer are looking for a Site Reliability Engineer Database-II to build the most amazing product experience. You ll get to work with other engineers to build delightful feature experience to understand and solve our customer s pain points

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.
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.

DataBase Reliability Engineer-II