Senior Database Architect

🔥 17 hours ago

🏄 California, Illinois, +2 more states – Remote

🏄 California – Remote 🌽 Illinois – Remote 🦞 Maine – Remote 🤠 Texas – Remote

⏰ Full Time

🟠 Senior

📀 Database Administrator

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

WEX

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

Founded 1983

🏥 Healthcare

📦 Logistics

✈️ Travel

💰 $310M Post-IPO Debt on 2020-06

Healthcare • Logistics • Travel

WEX is a global commerce platform specializing in various business solutions to address operational challenges. They provide services in managing and mobilizing fleets with their fuel card systems, offering comprehensive fleet management and analytics. Additionally, they focus on business payments solutions that streamline processes across industries, enhancing efficiency and security. WEX is also involved in employee benefits administration, helping organizations effectively manage health and reimbursement accounts. Their diverse range of services caters to numerous sectors, emphasizing innovation, sustainability, and effective solutions for business growth.

📋 Description

• Analyze and decompose large SQL Server stored procedures with embedded business logic • Create migration strategies that extract business logic into domain services • Design patterns separating business rules from data access • Lead refactoring aligned with domain-driven design, bounded contexts, aggregates, and domain events • Implement change data capture, outbox, and event-sourcing patterns where appropriate • Optimize queries, indexing strategies, and execution plans • Create migration playbooks and tooling for stored procedure modernization • Design semantic data models for AI retrieval and reasoning • Architect vector database solutions and RAG implementations • Design and implement embedding pipelines • Establish knowledge graph patterns, entity relationships, ontologies, and graph-based retrieval • Define data architectures for AI-agent context, freshness, and consistency • Design RAG evaluation frameworks for retrieval accuracy, relevance scoring, and continuous improvement • Design canonical data models and schemas across SQL Server, PostgreSQL, MongoDB/Cosmos DB, Snowflake, and vector databases • Architect Kafka-based event streaming, materialized views, CQRS, and real-time synchronization • Establish data pipelines, ETL/ELT orchestration, data quality, and observability patterns • Define data residency, partitioning, and multi-region strategies • Create reference architectures for domain teams • Leverage AI coding assistants to accelerate database modernization • Build AI-powered database engineering tools • Create AI-consumable documentation, annotated schemas, and context files • Author database architecture skills for AI-assisted development • Develop prompts, workflows, and tooling for AI-enabled modernization • Partner with AI/ML teams, domain teams, and application architects • Contribute to Enterprise Architecture Council standards • Mentor engineers on database design, optimization, semantic modeling, and AI data infrastructure

🎯 Requirements

• 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 decomposing complex stored procedures and migrating business logic to application services • Experience designing solutions across SQL Server, PostgreSQL, MongoDB, Cosmos DB, Snowflake, and data lakehouse platforms • Practical production experience with CDC, Kafka, outbox pattern, event sourcing, and CQRS • Data modeling expertise: canonical models, dimensional modeling, schema evolution, and extensibility • Hands-on experience with at least one vector database: Pinecone, Weaviate, Milvus, pgvector, Azure AI Search, or similar • Understanding of RAG architecture, embedding models, chunking strategies, retrieval optimization, hybrid search, and reranking patterns • Experience designing semantic data structures optimized for AI retrieval, knowledge representation, ontologies, or domain-specific AI schemas • Understanding of embedding pipelines, including text preprocessing, embedding generation, vector indexing, and incremental updates • Familiarity with LLM context requirements, token constraints, and context window optimization • 2+ years actively using AI coding assistants for database work, including GitHub Copilot, Cursor, or Claude Code • Experience building tools, scripts, or automation leveraging AI/LLM capabilities • Familiarity with structured artifacts for AI consumption, including documented schemas, annotated procedures, and context files • Strong programming skills in at least one backend language: C#, Java, or Python • Cloud data services experience with Azure SQL, Cosmos DB, Azure AI Search, Azure Synapse, Snowflake, or AWS equivalents • Infrastructure-as-code experience using Terraform, ARM/Bicep, or CloudFormation • Understanding of domain-driven design and bounded contexts • Familiarity with data governance, lineage, and compliance requirements including HIPAA and PCI-DSS • Preferred: background in healthcare, benefits, payments, or similarly regulated industries • Preferred: experience building RAG systems or AI-powered search/retrieval applications • Preferred: knowledge graph experience with Neo4j, Amazon Neptune, or similar graph databases • Preferred: contributions to database tooling, AI/ML data infrastructure, or open-source projects • Preferred: experience mentoring engineers or leading database/data architecture communities of practice

🏖️ Benefits

• Health, dental and vision insurances • Retirement savings plan • Paid time off • Health savings account • Flexible spending accounts • Life insurance • Disability insurance • Tuition reimbursement • Quarterly or annual bonus eligibility for non-sales roles