1 day ago
Bengaluru, IndiaSenior
Responsibilities
- Analyze, refactor, and modernize complex SQL Server stored procedures while preserving business logic and data integrity.
- Write migration scripts, optimize queries and indexes, analyze execution plans, and improve database 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 retrieval APIs.
- Develop evaluation and monitoring for RAG components, including retrieval accuracy, latency, and freshness metrics.
- Design and maintain ETL/ELT, API-based ingestion, batch-processing, streaming, data-quality, and observability workflows.
- Provision and configure databases using infrastructure-as-code and support MongoDB and Cosmos DB data models and queries.
- Use AI coding assistants and build AI-powered tooling for stored procedure analysis, schema documentation, and migration support.
- Collaborate with application and AI/ML engineers, participate in code reviews, document solutions, mentor junior engineers, and contribute to on-call support when applicable.
Requirements
- 5–8 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 through refactoring and migration.
- Experience developing ETL/ELT pipelines, data integrations, batch workflows, and streaming workflows.
- 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.
- Strong knowledge of database internals, indexing, query optimization, locking, and transaction isolation.
- Experience with event-driven patterns, infrastructure-as-code, version control, CI/CD for database changes, 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.