Database Team Lead

Location: Sabarmati

Role:
Data/DB Engineer Lead (AWS / 9+ years of experience)

Location:

Ahmedabad, Pune
Years of

Experience:

9 to 15 yrs
Notice:
Looking for 0-30 Days Joiner

Introduction
Our team builds a data platform that reliably collects, processes, and retrieves large-scale IoT data based on AWS. We are seeking Lead/Senior engineer who can design unobstructed flow even among billions of data records, push data storage performance to the limit, and technically lead service growth.

Key Responsibilities
High-availability data pipeline design:  AWS MSK (Kafka), end-to-end data streaming architecture design and operation using Logstash
Storage optimization and sharding strategies:  Optimizing large-scale search performance through  Open Search's index design, sharding, and lifecycle (ISM) management
Data Modeling and Partitioning:  Table partitioning and data modeling   in PostgreSQL/MySQL, architecture guide for efficient querying
Performance Tuning and Guidance:  Leading SQL optimization across services and spreading technical best practices to backend development teams
Release Management:  Be the gatekeeper during key database / data pipeline release activities, create review checklist, review deployment details and validates details before deployment to ensure zero-error deployments without roll back needs.
Infrastructure automation:  DB   schema versioning (such as Flyway) and deployment process automation systems

Requirements
Over 7 years of experience in data engineering or related backend development
Extensive experience in operating infrastructure handling large-scale traffic in AWS cloud environments
Strong capabilities in building real-time data pipelines and troubleshooting   using  Kafka
Experience in Open Search (Elasticsearch) cluster design and sharding optimization  is essential.
Deep understanding  of the   internal structure of  RDBMS (PostgreSQL/MySQL)  and ability to tune complex queries

Preferred Qualifications
Seamless technical collaboration capabilities:  Communication   skills to discuss infrastructure optimization with Dev Ops engineers and provide efficient data modeling and query guides to backend developers
Global collaboration skills:  Able to   share technical documents with engineers across the globe and conduct work via video conferences during collaborative work sessions
IoT Domain

Experience:

Experience in   handling large-scale device messages and building data pipelines
Ensuring data stability:  Experience in designing logic to prevent data loss during failures and ensure consistency verification
Nice to have è IaC Proficiency:  Nice to have Experience coding and automated operations of data infrastructure using Terraform, Ansible, and others
4 years of bachelor’s degree or higher in Computer Science or equivalent discipline

What We Offer:

Competitive Salary
Work Life Balance
Professional Development
Innovative Work Environment.
Recognition and Rewards