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
- AI
- API
- Automation
- AWS
- Azure
- Bicep
- CI/CD
- Claude Code
- Cloud
- Cosmos Db
- C#
- Data Engineering
- ELT
- Embeddings
- ETL
- Event Driven Architecture
- GitHub
- Github Copilot
- Infrastructure as Code
- Kafka
- Milvus
- MongoDB
- NoSQL
- pgvector
- Pinecone
- PostgreSQL
- Python
- RAG
- RDBMS
- Semantic Search
- Snowflake
- SQL
- SQL Server
- Terraform
- Vector Databases
- Vector Search
- Weaviate
Sign in to read and join the discussion.