Senior Database Architect: SQL Server & AI Data Infra

WEX Inc.; United States; On-site; USD 166,000 - 204,000; Full time

Benefits offered by this job

Health, dental and vision insurances

Retirement savings plan

Paid time off

Health savings account

Flexible spending accounts

Life insurance

Disability insurance

Tuition reimbursement

Job summary

WEX Inc. is seeking a Principal Database Engineer to modernize and scale our data platforms, leveraging deep SQL Server and T‑SQL expertise and applying AI-enabled approaches to data infrastructure.

You will own complex database initiatives across OLTP/OLAP, build migration automation, and collaborate with SRE, operations, architecture, and AI/ML teams to deliver reliable, enterprise-grade solutions. This role is hands-on and highly technical.

Qualifications

• 15+ years of experience in database engineering or related technical discipline.
• Deep hands-on experience with Microsoft SQL Server and T‑SQL, including complex stored procedures, query optimization, execution‑plan analysis, indexing, and performance tuning.
• Experience modernizing or refactoring legacy database systems in large-scale environments.
• Experience with data pipelines, ETL/ELT, data integration, batch processing, and/or event-driven architectures.
• Strong programming skills in Python or C# for automation and tooling.

Responsibilities

• Design, develop, optimize, and modernize large-scale SQL Server databases and data platforms.
• Analyze and refactor complex T‑SQL, stored procedures, functions, and database logic.
• Identify and resolve database performance bottlenecks through execution‑plan analysis, indexing, query optimization, and database tuning.
• Drive schema improvements and database modernization initiatives that improve scalability, maintainability, and reliability.
• Develop migration strategies and automation that maintain data integrity and minimize disruption to business‑critical systems.
• Implement and improve data replication and synchronization patterns across transactional and analytical environments.
• Apply event‑driven database patterns such as Change Data Capture (CDC), outbox patterns, and event publishing.
• Engineer solutions for large, high‑volume databases supporting critical business applications and partners.
• Work with databases containing terabytes of data and complex data relationships.
• Develop data pipelines and integration patterns across SQL Server, PostgreSQL, Snowflake, and cloud data services.
• Support both OLTP and OLAP environments and optimize data movement between systems.
• Apply strong understanding of database internals, including indexing, locking, transactions, isolation levels, concurrency, and query optimization.

Skills

SQL Server & T‑SQL

Performance tuning

Data modernization

Python automation

Data pipelines

Tools

PostgreSQL

Snowflake

Azure SQL

Cosmos DB

Job description

WEX Inc. is seeking a Principal Database Engineer to modernize and scale our data platforms, leveraging deep SQL Server and T‑SQL expertise and applying AI-enabled approaches to data infrastructure.

You will own complex database initiatives across OLTP/OLAP, build migration automation, and collaborate with SRE, operations, architecture, and AI/ML teams to deliver reliable, enterprise-grade solutions. This role is hands-on and highly technical.