Database Reliability Engineer II
- Innovaccer
- 4 - 9 years
- Noida, Gurugram
- 25 days ago
- Email to a friend
- Report this job
Job Description
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: InnovaccerLocation(s): Noida, Gurugram
+ View Contact
Keyskills: Database design Postgresql MySQL Database Healthcare Troubleshooting Analytics Monitoring SQL Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Innovaccer
Innovaccer Inc. is the #1 data platform for value-based care. The Innovaccer platform unifies patient data across systems and care settings, and empowers healthcare organizations with scalable, modern applications that improve clinical, financial, operational, and experiential outcomes.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in