Senior DB Architect: AI-First Modernization & Vector Data

WEX

Maine

On-site

USD 140,000 - 190,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 in Maine seeks a Senior Database Architect to modernize legacy SQL Server systems while architecting AI-native data infrastructure, including vector databases and embedding pipelines. You will decompose stored procedures, move logic to services, and define patterns for CQRS, CDC, and event sourcing.

You'll design semantic models and knowledge graphs to power AI agents, build scalable data platforms across SQL and NoSQL stores, and coach teams on data architecture for AI-enabled workflows.

Qualifications

  • Proven experience with large-scale SQL Server environments and stored procedures.
  • Strong data modeling and semantic modeling skills for AI-enabled retrieval.
  • Hands-on with event-driven patterns, CDC, and CQRS in production.

Responsibilities

  • Analyze and decompose large SQL Server stored procedures with embedded logic and create migration strategies.
  • Lead refactoring to align database structures with domain-driven design and event-driven patterns.
  • Design vector databases, embedding pipelines, and semantic models for AI retrieval.
  • Architect data platforms across SQL/NoSQL and analytical stores, with scalable data flows.
  • Develop AI-ready artifacts and tooling to accelerate modernization efforts.
  • Collaborate with AI/ML teams to support agent requirements and domain-driven design.

Skills

SQL Server
T-SQL
Stored procedures
Performance tuning
Data modeling
Event-driven design
CDC
Kafka
CQRS
Knowledge graphs

Tools

Pinecone
Weaviate
pgvector
Azure AI Search
Snowflake
Cosmos DB
MongoDB
PostgreSQL
Kafka

Job description

WEX in Maine seeks a Senior Database Architect to modernize legacy SQL Server systems while architecting AI-native data infrastructure, including vector databases and embedding pipelines. You will decompose stored procedures, move logic to services, and define patterns for CQRS, CDC, and event sourcing.

You'll design semantic models and knowledge graphs to power AI agents, build scalable data platforms across SQL and NoSQL stores, and coach teams on data architecture for AI-enabled workflows.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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 Data Architect for Legacy Modernization
AI-First Data Architect for Legacy Modernization

WEX Inc. • United States

On-site
USD 150,000 - 230,000
Senior AI-First Database Architect
Senior AI-First Database Architect

WEX, Inc. • Chicago (IL)

On-site
USD 140,000 - 210,000
AI-Driven Database Architect for Legacy Modernization
AI-Driven Database Architect for Legacy Modernization

WEX • Chicago (IL)

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
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
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 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 DB Engineer: AI-Enabled Data Platforms
Senior Staff DB Engineer: AI-Enabled Data Platforms

WEX • Maine

On-site
USD 166,000 - 204,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