Senior Database Architect
Core
Lead the modernization of complex legacy SQL Server stored procedures while architecting vector databases and semantic models for AI-native applications.
Role type
Senior Database Architect (AI & Legacy Modernization)
Builds
Modernized data layers, vector database solutions for RAG, and AI-consumable artifacts
Domain
Enterprise Data Engineering & AI Infrastructure
Deliverable
production ML models | product features | infrastructure
Required skills
SQL Server (T-SQL, stored procedure refactoring), Vector databases (Pinecone, Weaviate, pgvector), Event-driven patterns (CDC, Kafka, CQRS), Domain-driven design, Cloud data platforms (Azure, Snowflake), Backend programming (C#, Java, Python), Infrastructure-as-code (Terraform)
Preferred skills
Healthcare/benefits/payments domain knowledge, Knowledge graph experience (Neo4j), RAG system development, Open-source contributions
Technologies
SQL Server, PostgreSQL, MongoDB, Cosmos DB, Snowflake, Pinecone, Weaviate, Kafka, Azure AI Search, Terraform
Responsibilities
Decompose large stored procedures and migrate business logic to application services, Design semantic data models and vector database architectures for AI retrieval, Implement event-driven data flows and data platform infrastructure, Build AI-powered tools for database engineering and schema documentation, Mentor engineers on database design and AI data infrastructure
Seniority
Senior, hands-on IC with leadership responsibilities
