2 days ago
Base Salary
$166k - $204k/yr
Responsibilities
- Design, develop, optimize, and modernize large-scale Microsoft SQL Server databases and data platforms.
- Analyze and refactor complex T-SQL, stored procedures, functions, schemas, and database logic.
- Resolve performance bottlenecks through execution-plan analysis, indexing, query optimization, and database tuning.
- Develop migration strategies and automation that preserve data integrity and minimize disruption to business-critical systems.
- Implement replication, synchronization, Change Data Capture, outbox, and event-publishing patterns.
- Build data pipelines and integration patterns across SQL Server, PostgreSQL, Snowflake, and cloud data services for OLTP and OLAP environments.
- Apply AI coding assistants and develop AI-enabled tooling involving embeddings, vector databases, semantic search, retrieval systems, and agentic workflows.
- Lead complex database engineering initiatives from problem definition through production implementation.
- Diagnose and resolve high-impact production issues using logs, database metrics, resource utilization, execution plans, and observability data.
- Provide technical guidance through code reviews and design discussions, mentor engineers, and improve database engineering practices.
Requirements
- At least 15 years of experience in database engineering, data platform engineering, software engineering, or a related technical discipline.
- Deep hands-on experience with Microsoft SQL Server and T-SQL, including stored procedures, query optimization, execution-plan analysis, indexing, and performance tuning.
- Experience modernizing or refactoring legacy database systems and supporting large-scale, high-volume, business-critical databases.
- Strong programming skills in Python, C#, or a similar language for automation, tooling, and data processing.
- Experience with data pipelines, ETL/ELT, data integration, batch processing, and/or event-driven architectures.
- Strong understanding of database internals, transaction management, concurrency, locking, and performance optimization.
- Experience independently driving complex technical initiatives across engineering teams.
- Experience using AI coding assistants such as Cursor, GitHub Copilot, Claude Code, Augment, or similar tools.
- Familiarity with embeddings, vector databases, semantic search, RAG concepts, and AI-enabled data tooling.
- Experience or exposure to PostgreSQL, Snowflake, Azure SQL, Cosmos DB, AWS data services, or similar platforms.
- Experience with infrastructure-as-code such as Terraform, ARM, Bicep, or similar technologies, plus database migrations, schema versioning, deployment automation, CI/CD, and source control.
- Experience with Kafka is a plus, and familiarity with NoSQL and document databases is a plus.
- Preferred experience includes payments, financial services, healthcare, benefits, regulated environments, highly available customer-facing systems, Oracle PL/SQL, RAG, semantic search, vector databases, AI-agent data infrastructure, or internal AI engineering tools.
Benefits
- Health, dental, and vision insurance.
- Retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, and disability insurance.
- Tuition reimbursement and additional comprehensive benefits.
- Non-sales roles are typically eligible for a quarterly or annual bonus under the applicable plan.
Tech Stack
Categories
Data Engineering
About WEX
WEX is a public financial technology company that provides corporate payment solutions to fleets, healthcare/benefits administrators, and travel businesses. Its products include fuel and mobility cards, virtual card payments, and platforms for HSAs/FSAs/HRAs, with revenue from payment processing and software/service fees. Founded in 1983 and headquartered in Portland, Maine, WEX trades on the NYSE under WEX and was formerly known as Wright Express.
