- Experience assessing and scoping SQL Server → PostgreSQL migrations (not necessarily having executed a full migration).
- Experience working in environments where legacy and modern systems coexist in production during a transition.
- Comfort working with Specification-Driven Development (SDD) frameworks such as OpenSpec, or similar structured requirements/traceability approaches.
- Ability to produce clear, prioritised, business-readable recommendations for non-DBA stakeholders.
- Work from the European Union region and a work permit are required.
Tasks
Review the current SQL Server database design, indexes, queries and operational practices. Identify performance issues, technical debt, risks and areas that are already working well. Recommend and prioritise pragmatic improvements. Assess the feasibility of migrating from SQL Server to PostgreSQL — identifying compatibility issues, risks, expected effort and possible migration approaches. Define and implement robust database observability and performance monitoring, including performance baselines, query-level diagnostics, wait statistics, blocking/deadlock detection, capacity trends and actionable alerting.
Work within an AI-native engineering environment, using Specification-Driven Development (SDD) frameworks such as OpenSpec to structure requirements, implementation plans, validation and traceability.