About the Role
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-8 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.
Here’s 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 (Noida office only): 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.
Creche Facility for children (India offices): Say goodbye to worries and hello to a convenient and reliable creche facility that puts your child's well-being first.
Location and Work Environment
Our Noida office is situated in a posh techspace, equipped with various amenities to support our work environment. Here, we follow a five-day work schedule, allowing us to efficiently carry out our tasks and collaborate effectively within our team.
Innovaccer is an equal opportunity employer committed to fostering an inclusive and diverse workplace where all employees feel valued and empowered regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, marital status, or veteran status.
Innovaccer does not charge fees or require payment from individuals or agencies for securing employment. They caution against fraud and advise reporting suspicious requests for payment or personal information to their HR department.
About Innovaccer
Innovaccer Inc. is the data platform that accelerates innovation by unifying patient data across systems and care settings and empowering healthcare organizations with scalable, modern applications that improve clinical, financial, operational, and experiential outcomes. They have deployed solutions across more than 1,600 hospitals and clinics in the US, serving over 96,000 clinicians and enabling care delivery transformation. The platform has unified health records for over 54 million people and generated over $1.5 billion in cumulative cost savings. It is recognized as the #1 rated Best-in-KLAS data and analytics platform by KLAS and the #1 rated population health technology platform by Black Book.