Job Description
Role: Data/DB Engineer Lead (AWS / 9+ years of experience)
nLocation: Ahmedabad, Pune
nYears of Experience: 9 to 15 yrs
nNotice: Looking for 0-30 Days Joiner
n

nIntroduction
nOur 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.
n

nKey Responsibilities
n
- n
- High-availability data pipeline design: AWS MSK (Kafka), end-to-end data streaming architecture design and operation using Logstashn
- Storage optimization and sharding strategies: Optimizing large-scale search performance through OpenSearch's index design, sharding, and lifecycle (ISM) managementn
- Data Modeling and Partitioning: Table partitioning and data modeling in PostgreSQL/MySQL, architecture guide for productive queryingn
- Performance Tuning and Guidance:



Leading SQL optimization across services and spreading technical best practices to backend development teamsn
- 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.n
- Infrastructure automation: DB schema versioning (such as Flyway) and deployment process automation systemsn

n

nRequirements
n
- n
- Over 7 years of experience in data engineering or related backend developmentn
- Extensive experience in operating infrastructure handling large-scale traffic in AWS cloud environmentsn
- Strong capabilities in building real-time data pipelines and troubleshooting using Kafkan
- Experience in OpenSearch (Elasticsearch) cluster design and sharding optimization is essential.n
- Deep understanding of the internal structure of RDBMS (PostgreSQL/MySQL) and ability to tune complex querie

📌 Database Team Lead (India)
🏢 eInfochips (An Arrow
📍 India