3 days ago
Bengaluru, IndiaSenior / Staff+
Responsibilities
- Analyze, refactor, test, and modernize complex SQL Server stored procedures and database structures.
- Optimize queries, execution plans, indexes, locking, and transaction performance.
- Implement change data capture, outbox tables, event publishing, and other event-driven database patterns.
- Build embedding pipelines, vector database implementations, synchronization processes, semantic search features, and RAG retrieval APIs.
- Design and maintain ETL/ELT pipelines, API ingestion, event streaming, batch processing, data validation, and observability.
- Develop database provisioning and configuration automation with infrastructure-as-code.
- Support MongoDB and Cosmos DB document modeling and query optimization.
- Use AI coding assistants and develop AI-powered tooling for database analysis, documentation, migration, and automation.
- Collaborate with application and AI/ML teams, participate in code reviews and on-call support, document solutions, and mentor junior engineers.
Requirements
- 8–12 years of experience in database engineering or data platform roles, including strong SQL Server experience.
- Deep T-SQL proficiency covering complex queries, stored procedures, functions, performance tuning, and execution plan analysis.
- Hands-on experience modernizing legacy database code.
- Experience developing ETL/ELT workflows, data integrations, and batch and streaming systems.
- Programming proficiency in Python or C# for tooling, automation, and data processing.
- Experience with Azure SQL, Cosmos DB, Snowflake, or AWS data services.
- Familiarity with vector databases such as Pinecone, Weaviate, pgvector, or Azure AI Search, plus embeddings and RAG concepts.
- Understanding of database internals, event-driven patterns, infrastructure-as-code, database version control, CI/CD, and NoSQL systems.
- Preferred qualifications include regulated-industry experience, Oracle PL/SQL, hands-on RAG or semantic search development, database tooling or open-source data contributions, and data observability experience.
Tech Stack
Categories
Data Engineering
About WEX
WEX is a public financial technology company that provides corporate payment solutions to fleets, healthcare/benefits administrators, and travel businesses. Its products include fuel and mobility cards, virtual card payments, and platforms for HSAs/FSAs/HRAs, with revenue from payment processing and software/service fees. Founded in 1983 and headquartered in Portland, Maine, WEX trades on the NYSE under WEX and was formerly known as Wright Express.