CareerPlanSign in

Senior Database Architect

Portland, ME, US💼 Full-time💰 $80,000–$100,000🗓 2026-09-03 → 2026-09-25

Core

Lead the modernization of complex legacy SQL Server stored procedures while architecting vector databases and semantic models for AI-native applications.

Role type

Senior Database Architect (AI & Legacy Modernization)

Builds

AI agent data infrastructure, modernized domain services, and semantic data models

Domain

Enterprise Data Engineering & AI Infrastructure

Deliverable

production ML models | product features | infrastructure

Required skills

SQL Server (T-SQL, stored procedures), Vector databases, RAG architecture, Event-driven patterns, Domain-driven design, Cloud data platforms, AI coding assistants, Backend programming

Preferred skills

Healthcare/regulated industry experience, Knowledge graphs, RAG system development, Engineering mentorship

Technologies

SQL Server, PostgreSQL, MongoDB, Snowflake, Pinecone, Weaviate, Kafka, Terraform, C#, Java, Python

Responsibilities

Decompose large stored procedures and migrate business logic to application services; Design semantic data models and vector database solutions for AI retrieval; Architect event-driven data flows and multi-platform data solutions; Leverage AI tools to accelerate database engineering and build AI-powered tooling; Mentor engineers on database design and AI data infrastructure.

Seniority

Senior, hands-on IC with leadership responsibilities

Sourced via workday · Listed on CareerPlan, which tracks 70,000+ jobs from 20+ sources.