WEX logo

Sr. Staff Database Engineer

WEX
NewPosted today

LOCATION

United States · Remote

EXPERIENCE

15+ Years

TYPE

FullTime

SALARY

$165.8K - $204.4K /year

SKILLS REQUIRED

SQL ServerQuery OptimizationDatabase ReplicationSQLChange Data CaptureData Modeling

Job description

Overview

Hands-on senior staff database engineering role focused on modernizing and scaling SQL Server data platforms, supporting AI-enabled applications, and owning complex database initiatives from design through production.

What you'll do

  • 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, including 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.
  • Use modern AI coding assistants such as GitHub Copilot, Cursor, Claude Code, or similar tools to accelerate development, analysis, debugging, and modernization.
  • Explore and implement AI-powered approaches for analyzing stored procedures, documenting schemas, and automating database engineering workflows.
  • Contribute to AI-native data infrastructure, including embedding pipelines, vector databases, semantic search, and retrieval systems.
  • Develop data and retrieval capabilities that support AI applications and agentic workflows.
  • Evaluate emerging AI tools and determine where they can improve engineering productivity and data platform capabilities.
  • Independently lead complex database engineering initiatives from problem definition through production implementation.
  • Serve as a technical resource for complex database and performance challenges.
  • Partner effectively with application engineering, SRE, operations, architecture, and AI/ML teams.
  • Provide technical guidance through code reviews, design discussions, and engineering standards.
  • Mentor other engineers and contribute to the development of database engineering practices.
  • Take ownership of outcomes rather than simply completing assigned tasks.
  • Participate in resolving high-impact production issues involving critical database systems.
  • Diagnose complex problems using logs, database metrics, CPU/memory utilization, execution plans, and other observability data.
  • Quickly determine root cause, coordinate with the appropriate technical teams, and drive issues through resolution.
  • Balance immediate incident resolution with longer-term improvements that prevent recurrence.

What you'll need

  • 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 complex stored procedures, query optimization, execution-plan analysis, indexing, and performance tuning.
  • Demonstrated experience modernizing or refactoring legacy database systems, not simply maintaining existing environments.
  • Experience working with large-scale, business-critical databases and high-volume data environments.
  • 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 working across engineering teams and independently driving complex technical initiatives.
  • Experience using AI coding assistants such as Cursor, GitHub Copilot, Claude Code, Augment, or similar tools.
  • Familiarity with embeddings, vector databases, semantic search, or RAG concepts.
  • Experience with or willingness to build AI-enabled data tooling and automation.
  • Exposure to technologies such as 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.
  • Experience with CI/CD, source control, database migrations, schema versioning, and deployment automation.

Nice to have

  • Experience with event streaming technologies such as Kafka.
  • Familiarity with NoSQL and document databases.
  • Experience in payments, financial services, healthcare, benefits, or other highly regulated environments.
  • Experience supporting highly available, customer-facing or business-critical systems.
  • Experience with Oracle PL/SQL in addition to SQL Server.
  • Hands-on experience with RAG, semantic search, vector databases, or AI-agent data infrastructure.
  • Experience building internal engineering tools or automation using AI.

Details

  • Location: US - Remote.
  • Base pay range: $165,800.00 - $204,400.00.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Sr. Staff Database Engineer