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

• Ensure the integrity and performance of 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 such as OpenSpec to structure requirements and implementation plans.

Key Requirements

• Strong, hands-on SQL Server expertise in design, indexing, query optimization, and 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 and monitoring.
• Pragmatic, risk-aware approach that balances improvement efforts with migration costs and business risks.

Nice to Have

• Experience assessing and scoping SQL Server-to-PostgreSQL migrations.
• Experience in production environments containing both legacy and modern systems.
• 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, or C2.