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.
