We are seeking a Senior Database Architect who combines deep expertise in legacy database systems with forward-looking vision for AI-native data architecture. You'll lead the decomposition of complex stored procedures while simultaneously designing the vector databases, embedding strategies, and semantic models that power our AI agents and workflows.
This is an AI-first role in two senses: you'll leverage AI to accelerate your own work (stored procedure analysis, migration generation, schema documentation), and you'll design the data infrastructure that AI systems depend on. If you're excited about both solving hard legacy database problems and architecting the data layer for AI-native applications, this role is for you.
What You'll Do
Legacy Database Modernization
Analyze and decompose large SQL Server stored procedures (1,000+ lines) with embedded business logic, creating migration strategies that extract logic into domain services
Design patterns for separating business rules from data access,



enabling stored procedures to become thin data-access layers while business logic moves to application services
Lead refactoring efforts that align database structures with domain-driven design: bounded contexts, aggregates, and domain events
Implement event-driven patterns that decouple systems from direct database dependencies: change data capture, outbox patterns, event sourcing where appropriate
Optimize query performance, indexing strategies, and execution plans as part of modernization efforts
Create migration playbooks and tooling that engineering teams can apply to their own stored procedure modernization
AI Data Infrastructure & Semantic Modeling
Design semantic data models that capture domain knowledge in structures optimized for AI retrieval and reasoning
Architect vector database solutions for RAG implementations: embedding strategies, chunking approaches, similarity search optimization, and hybrid retrieval patterns
Design and implement embedding pipelines that

📌 Senior Database Architect (India)
🏢 WEXWEXUS
📍 India