AI-First Database Architect: Legacy to Vector AI

WEX, Inc.

Dallas (TX)

On-site

USD 150,000 - 230,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

WEX, Inc. is seeking a Senior Database Architect to unify legacy SQL Server systems with AI-ready data infrastructure. Lead the decomposition of complex stored procedures while shaping vector databases, embeddings, and semantic models for AI agents and workflows.

You will drive AI-first modernization, leveraging AI tools to accelerate analysis, migration, and schema documentation, and design the data layer that powers AI-native applications.

Qualifications

  • Deep expertise in SQL Server including T-SQL optimization and indexing.
  • Experience decomposing large stored procedures and migrating logic to services.
  • Experience across relational and NoSQL platforms (SQL Server, PostgreSQL, MongoDB/Cosmos, Snowflake).
  • Knowledge of event-driven patterns, CDC, outbox, and CQRS.
  • Ability to design semantic models and vector DB strategies for AI retrieval.
  • Familiarity with data governance and domain-driven design concepts.

Responsibilities

  • Analyze and decompose large SQL Server stored procedures and create migration plans.
  • Design patterns to separate business logic from data access.
  • Lead refactoring aligning DB structures with domain-driven design.
  • Implement event-driven patterns and modern data architectures.
  • Design vector databases and embedding pipelines for AI agents.
  • Collaborate with AI/ML teams to support RAG and semantic data models.

Skills

SQL Server
T-SQL
Stored procedures
Data architecture
Event-driven
Data modeling

Tools

Pinecone
Weaviate
pgvector
Cosmos DB
Snowflake

Job description

WEX, Inc. is seeking a Senior Database Architect to unify legacy SQL Server systems with AI-ready data infrastructure. Lead the decomposition of complex stored procedures while shaping vector databases, embeddings, and semantic models for AI agents and workflows.

You will drive AI-first modernization, leveraging AI tools to accelerate analysis, migration, and schema documentation, and design the data layer that powers AI-native applications.

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
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 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
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 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