Site Database Reliability Engineer ...

Innovaccer is seeking a skilled Site Database Reliability Engineer - II to join our team in Noida, Uttar Pradesh, India. In this role, you will be instrumental in building and maintaining our product experience by working with fellow engineers to develop innovative features and address customer pain points.

As a Site Database Reliability Engineer, your responsibilities will include:

• Designing, modeling, implementing, and sizing large-scale systems using Snowflake, PostgreSQL, and MongoDB.
• Ensuring 24x7 provisioning, availability, reliability, performance, security, maintenance, upgrades, and cost optimization of databases.
• Conducting capacity planning for large-scale database clusters.
• Automating DB provisioning, deployments, routine administration, maintenance, and upgrades.
• Responding to business-critical P0/P1 incidents within SLAs, performing root cause analysis, and implementing permanent solutions.
• Synchronizing data between multiple data stores, such as PostgreSQL to Elasticsearch and Snowflake to Elasticsearch.
• Designing, documenting, and benchmarking Snowflake or MongoDB.
• Performing essential DB maintenance tasks, including backup, health checks, alerting, and monitoring.
• Developing and enforcing processes and best practices for database management.
• Identifying and tuning long-running queries to improve DB performance and reduce costs.

To be successful in this role, you should have:

• A minimum of 4 years of experience in database reliability engineering or a related field.
• The ability to thrive in a fast-paced environment with adaptability to changing business needs.
• Hands-on experience with SQL query writing and scripting languages like Python in database environments.
• Demonstrated experience working with cloud environments such as AWS, Azure, or GCP.
• In-depth knowledge of at least two of the following: MongoDB, Redis, or Elasticsearch.
• Knowledge of PostgreSQL, Snowflake, or MySQL is considered a plus.
• Experience setting up high availability, replication, and incremental backups for various datastores.
• Experience implementing database security best practices, including encryption, auditing, and role-based access control.
• Solid understanding of DB design principles, partitioning/sharding, and query optimization.
• Expertise in troubleshooting database performance issues in production environments.
• Demonstrated experience managing medium to large-sized production environments with both cloud-managed and self-hosted databases.
• Experience in building proof-of-concepts, evaluating new solutions, and enhancing existing systems with best practices to support business problem-solving and scaling.
• Knowledge or experience with Terraform, Jenkins, or Ansible is a plus.
• Familiarity with database monitoring stacks like Prometheus and Grafana.
• Mandatory expertise in Docker and Kubernetes.
• A proactive and intellectually curious mindset to explore and devise solutions for complex technical challenges.

Innovaccer offers a comprehensive benefits package including generous leave benefits (up to 40 days), industry-leading parental leave, a sabbatical leave policy, and health insurance for you and your family. Our Noida office is pet-friendly and includes a creche facility for children. We operate on a five-day work schedule in a collaborative and inclusive environment.

Innovaccer is an equal opportunity employer committed to fostering diversity and inclusion.