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.