Senior Database Architect (SQL Server & PostgreSQL)

Location: Remote

Company

hirify.global is engaging a Senior Database Architect / Database Modernization Consultant for an international client.

What you will do

• Review SQL Server database design, indexes, queries, and operational practices.
• Identify performance issues, technical debt, risks, and areas that are already working well.
• Recommend and prioritize pragmatic improvements.
• Assess migration feasibility from SQL Server to PostgreSQL, including compatibility issues, risks, effort, and migration approaches.
• Define and implement database observability and performance monitoring, including performance baselines, query-level diagnostics, wait statistics, blocking and deadlock detection, capacity trends, and actionable alerting.
• Use Specification-Driven Development frameworks such as OpenSpec to structure requirements, implementation plans, validation, and traceability in an AI-native engineering environment.

Requirements

• Strong SQL Server and PostgreSQL expertise.
• Experience optimizing indexes and query performance.
• Experience modernizing databases behind legacy applications.
• Experience setting up database observability and performance monitoring.
• A pragmatic approach that balances improvements with migration costs and risks.
• Comfort working with Specification-Driven Development tooling such as OpenSpec.

Culture & Benefits

• Remote engagement in an AI-native engineering environment.

Hiring process

• Begin with a brief, non-technical conversation about background, career aspirations, communication, teamwork, and decision-making.
• Complete a 60–90-minute technical interview focused on the client’s requirements.
• Meet the client for a final technical discussion, followed by an offer if the evaluation is successful.