Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

WEX

NewBe an early applicant

Database Developer

Posted Updated

Description

WEX Health & Benefits is seeking an experienced Senior Database Engineer to strengthen its database and data engineering capabilities. This role combines modernization of legacy relational database systems with the development of AI-ready data infrastructure. The ideal candidate will bring deep hands-on SQL Server expertise, strong database performance-tuning skills, and practical exposure to PostgreSQL, NoSQL databases, vector search and Retrieval-Augmented Generation (RAG).


Key Responsibilities:

  • Database Modernization: Analyze, refactor and optimize complex SQL Server stored procedures; develop migration scripts; preserve data integrity; and move suitable business logic into application services.
  • Performance Engineering: Troubleshoot slow queries, review execution plans, optimize indexes and queries, and improve database reliability, scalability and performance.
  • AI & Vector Data Infrastructure: Build and maintain embedding pipelines, vector indexes, similarity-search capabilities, hybrid retrieval and semantic-search APIs to support RAG-based applications.
  • Data Engineering: Design and maintain ETL/ELT pipelines across SQL Server, PostgreSQL, Snowflake and cloud data services; support batch, streaming and API-based integrations.
  • Database Integration & Events: Implement Change Data Capture (CDC), event-driven patterns, outbox tables and data synchronization workflows; work with Kafka or similar streaming technologies.
  • NoSQL & Cloud: Support document and NoSQL databases such as MongoDB, Amazon DocumentDB and Azure Cosmos DB; contribute to database provisioning and infrastructure automation.
  • AI-Assisted Development: Use tools such as GitHub Copilot, Cursor or Claude Code to accelerate database analysis, code generation, debugging, documentation, and engineering workflows.
  • Engineering Collaboration: Partner with application and data engineers, participate in code reviews, mentor team members, document solutions and contribute to production support and on-call activities.


Requirements:

  • 8-12 years of experience in database engineering, database development or data platform engineering.
  • Strong hands-on expertise in Microsoft SQL Server and T-SQL, including complex queries, stored procedures, execution plans, indexing and performance tuning.
  • Working experience with PostgreSQL and relational database concepts; exposure to database internals and schema design.
  • Experience with NoSQL databases, preferably MongoDB or DocumentDB, and familiarity with columnar databases.
  • Practical understanding of vector databases such as Milvus, pgvector, Pinecone, Weaviate or Azure AI Search.
  • Understanding of RAG, embeddings, vector indexing, similarity search and semantic retrieval; hands-on implementation experience is an advantage.
  • Proficiency in Python or C# for scripting, automation and engineering tools.
  • Experience developing ETL/ELT pipelines and integrating data through batch, API or event-streaming patterns.
  • Knowledge of CDC, Kafka or similar messaging/streaming technologies, and CI/CD practices for database schema changes.
  • Exposure to cloud data services across Azure or AWS, plus Infrastructure as Code tools such as Terraform, ARM or Bicep.

Skills

Apply

See also

Software Engineering jobs by country — openings, pay and top skills →