Senior SQL & PostgreSQL Database Architect for ERP

Poland and Middle-Eastern Europe; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

Xebia is sponsoring a role focused on modernising a large SQL Server database stack and migrating to PostgreSQL, ensuring production stability during a multi-year ERP upgrade. You will optimise queries, tune indexes and establish observability in a leading AI-native engineering setting.

Responsibilities include assessing migration feasibility, balancing risk vs. cost, and defining concrete improvement plans while working with SDD/OpenSpec to structure requirements and traceability.

Qualifications

• Experience migrating from SQL Server to PostgreSQL in production environments.
• Ability to design indexes, optimize queries and monitor performance in live systems.
• Familiarity with modernising legacy databases while keeping production systems stable.

Responsibilities

• Review current SQL Server design, indexes, queries and ops practices.
• Identify performance issues, technical debt and migration risks.
• Prioritise pragmatic improvements and migration approaches.
• Define robust observability/monitoring: baselines, diagnostics, wait stats, deadlock detection, alerts.
• Work within an AI-native engineering environment using OpenSpec for requirements and traceability.

Skills

SQL Server

PostgreSQL

Query optimisation

Database migrations

Observability

Migration planning

Tools

OpenSpec

Job description

Xebia is sponsoring a role focused on modernising a large SQL Server database stack and migrating to PostgreSQL, ensuring production stability during a multi-year ERP upgrade. You will optimise queries, tune indexes and establish observability in a leading AI-native engineering setting.

Responsibilities include assessing migration feasibility, balancing risk vs. cost, and defining concrete improvement plans while working with SDD/OpenSpec to structure requirements and traceability.