Site Database Reliability Engineer-II

About the Role

Site Database Reliability Engineer-II

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.