Senior DB Architect: SQL Server & PostgreSQL Remote EU

Hidden Jobs; United States; Remote; USD 165,000 - 276,000; Full time

Job summary

Hidden Jobs is seeking a senior database consultant to lead a multi-year ERP modernization, balancing legacy stability with a modern web-based stack. The role involves auditing SQL Server performance, evaluating PostgreSQL migration feasibility, and establishing observability within an AI-native engineering workflow.

You will work closely with stakeholders to deliver prioritized improvements, define migration approaches, and ensure coexistence of legacy and new systems throughout the transition.

Qualifications

• Strong hands-on SQL Server design, indexing, query optimisation, and operations.
• Working PostgreSQL knowledge to assess migration feasibility.
• Track record of query and index optimisation in production environments.
• Experience modernising databases behind legacy applications.

Responsibilities

• Audit the current SQL Server schema, indexes, queries, and operational practices
• Identify performance issues, technical debt, risks, and prioritised improvements
• Assess SQL Server to PostgreSQL migration feasibility, including compatibility issues, effort estimates, and recommended approaches
• Define and implement database observability: baselines, query-level diagnostics, wait stats, blocking and deadlock detection, capacity trends, and alerting
• Produce business-readable recommendations for non-DBA stakeholders
• Apply Specification-Driven Development frameworks such as OpenSpec to structure requirements, plans, validation, and traceability
• Support the coexistence of legacy and modern systems throughout the transition

Skills

SQL Server

PostgreSQL

Query optimisation

Production experience

Legacy modernization

Tools

OpenSpec

Blazor

.NET

Job description

Hidden Jobs is seeking a senior database consultant to lead a multi-year ERP modernization, balancing legacy stability with a modern web-based stack. The role involves auditing SQL Server performance, evaluating PostgreSQL migration feasibility, and establishing observability within an AI-native engineering workflow.

You will work closely with stakeholders to deliver prioritized improvements, define migration approaches, and ensure coexistence of legacy and new systems throughout the transition.