AI-Driven Database Architect for Legacy Modernization

WEX

Chicago (IL)

On-site

USD 140,000 - 210,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

WEX seeks a Senior Database Architect to modernize legacy SQL Server systems and architect AI-native data infrastructure. You will decompose large stored procedures, separate business logic from data access, and lead domain-driven modernization across relational, NoSQL, and analytical platforms.

You will design vector DB solutions, embedding pipelines, and knowledge graphs to support AI agents and RAG workflows, while ensuring scalable, observable data platforms and governance.

Qualifications

  • 8–12 years in database engineering and architecture, with significant experience in enterprise-scale SQL Server environments.
  • Deep SQL Server expertise: T-SQL optimization, stored procedure design and refactoring, query plan analysis, indexing strategies, and performance tuning.
  • Hands-on modernization experience: track record of decomposing complex stored procedures and migrating business logic to application services.
  • Multi-platform data architecture: experience designing solutions across relational SQL Server, PostgreSQL, NoSQL MongoDB/Cosmos DB, and analytical Snowflake/data lakehouse.
  • Event-driven data patterns: CDC, Kafka, outbox pattern, event sourcing, CQRS—practical experience implementing these in production.
  • Data modeling expertise: canonical models, dimensional modeling, schema evolution, and designing for extensibility.

Responsibilities

  • Lead legacy database modernization by analyzing and decomposing large stored procedures and creating migration strategies.
  • Design patterns to separate business rules from data access and move logic to application services.
  • Guide refactoring to align structures with domain-driven design: bounded contexts, aggregates, and domain events.
  • Architect vector database solutions for AI/NLP workflows: embedding strategies, chunking, and hybrid retrieval.
  • Develop embedding pipelines transforming domain content into vector representations for AI agents.
  • Establish knowledge graph patterns for complex domain reasoning and retrieval.
  • Define data architectures for AI agent context and ensure data freshness and governance.

Skills

SQL Server
T-SQL optimization
Stored procedures
Architecture design
Data modeling
Vector databases
Embedding pipelines
Knowledge graphs
Event-driven patterns
C#, Java, Python

Tools

SQL Server
MongoDB
Cosmos DB
Snowflake
Pinecone
Weaviate
pgvector
Azure AI Search

Job description

WEX seeks a Senior Database Architect to modernize legacy SQL Server systems and architect AI-native data infrastructure. You will decompose large stored procedures, separate business logic from data access, and lead domain-driven modernization across relational, NoSQL, and analytical platforms.

You will design vector DB solutions, embedding pipelines, and knowledge graphs to support AI agents and RAG workflows, while ensuring scalable, observable data platforms and governance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

AI-First Database Architect – Legacy Modernization
AI-First Database Architect – Legacy Modernization

WEX, Inc. • San Francisco (CA)

On-site
USD 180,000 - 260,000
Health, dental, and vision insurance
Retirement savings plan
Paid time off
+3
AI-First Data Architect for Legacy Modernization
AI-First Data Architect for Legacy Modernization

WEX Inc. • United States

On-site
USD 150,000 - 230,000
AI-First Database Architect for Modern Data & AI
AI-First Database Architect for Modern Data & AI

WEX, Inc. • Portland (ME)

On-site
USD 140,000 - 210,000
AI-First Database Architect: Legacy to Vector AI
AI-First Database Architect: Legacy to Vector AI

WEX, Inc. • Dallas (TX)

On-site
USD 150,000 - 230,000
Senior DB Architect: AI-First Modernization & Vector Data
Senior DB Architect: AI-First Modernization & Vector Data

WEX • Maine

On-site
USD 140,000 - 190,000
Lead AI-Driven Database Architect - SQL Server
Lead AI-Driven Database Architect - SQL Server

WEX Health, Inc. • Texas

Hybrid
USD 140,000 - 200,000
Senior AI-First Database Architect
Senior AI-First Database Architect

WEX, Inc. • Chicago (IL)

On-site
USD 140,000 - 210,000
Senior Staff Database Engineer: AI-Driven Modernization
Senior Staff Database Engineer: AI-Driven Modernization

WEX • United States

Remote
USD 166,000 - 204,000
Health, dental and vision insurance
401(k) plan
Paid time off
+2
Senior Staff Database Engineer: AI‑Enabled Modernization
Senior Staff Database Engineer: AI‑Enabled Modernization

WEX, Inc. • United States

On-site
USD 166,000 - 204,000
Health, dental and vision insurances
Retirement savings plan
Paid time off
+1
Senior Staff DB Engineer: AI-Enabled Data Platforms
Senior Staff DB Engineer: AI-Enabled Data Platforms

WEX • Maine

On-site
USD 166,000 - 204,000