Senior Database Architect (SQL Server & PostgreSQL)

Summary:

The primary objective of this role is to assess and modernize the database landscape of a critical ERP system while maintaining its operational capabilities during a transition from legacy technologies to a modern platform.

Main Responsibilities:

The Senior Database Architect will ensure the integrity and performance of the database systems throughout the modernization process.

• Review the current SQL Server database design, indexes, queries, and operational practices.

• Identify performance issues, technical debt, risks, and areas that are performing well.

• Recommend and prioritize pragmatic improvements.

• Assess the feasibility of migrating from SQL Server to PostgreSQL, identifying compatibility issues, risks, expected effort, and migration approaches.

• Define and implement robust database observability and performance monitoring, including performance baselines, query diagnostics, wait statistics, blocking/deadlock detection, capacity trends, and actionable alerts.

• Work within an AI-native engineering environment using Specification-Driven Development (SDD) frameworks like OpenSpec to structure requirements and implementation plans.

Key Requirements:

• Strong, hands-on SQL Server expertise (design, indexing, query optimization, operational practices).

• Solid working knowledge of PostgreSQL to assess migration feasibility and compatibility.

• Proven experience optimizing query and index performance in production environments.

• Experience modernizing or refactoring databases behind legacy applications.

• Ability to define and implement database observability/monitoring.

• A pragmatic, risk-aware approach that balances improvement efforts with migration costs and business risks.

Nice to Have:

• Experience in assessing and scoping SQL Server to PostgreSQL migrations.

• Experience in environments with both legacy and modern systems in production.

• Comfort with Specification-Driven Development (SDD) frameworks.

• Ability to produce clear, prioritized, business-readable recommendations for non-DBA stakeholders.

Other Details:

• Work Model: Remote from Romania

• Contract duration: 17.08.2026 - 17.11.2026 (3 months)

• English Language Skills: B2, C1, C2