Senior Database Architect (SQL Server & PostgreSQL) - B2B / Freelancers

Location: Bulgaria or Poland; work from the European Union region and a work permit are required

Company

hirify.global is a global AI-first digital transformation and engineering partner delivering scalable products, platforms, data solutions, and AI services.

What you will do

• Review the SQL Server database design, indexes, queries, and operational practices of a business-critical ERP system.
• Identify performance issues, technical debt, operational risks, and areas that are already working effectively.
• Recommend and prioritise pragmatic improvements based on effort, migration cost, and business risk.
• Assess SQL Server-to-PostgreSQL migration feasibility, compatibility issues, risks, expected effort, and migration approaches.
• Define and implement observability with performance baselines, query 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 hands-on SQL Server expertise, including database design, indexing, query optimisation, and operational practices.
• Solid working knowledge of PostgreSQL and experience assessing SQL Server-to-PostgreSQL migration feasibility.
• Proven experience optimising queries and indexes in production environments.
• Experience modernising or refactoring databases behind legacy applications while legacy and modern systems coexist in production.
• Ability to produce clear, prioritised, business-readable recommendations for non-DBA stakeholders.
• Work from the European Union region and a valid work permit are required.

Nice to have

• Experience with Specification-Driven Development frameworks such as OpenSpec or similar structured requirements and traceability approaches.
• Exposure to legacy 4GL or transpiled/generated codebases.
• Familiarity with .NET or Blazor application ecosystems and database-heavy ERP systems.
• Experience with AI-assisted or AI-native engineering workflows.

Culture & Benefits

• B2B or freelance contract.
• Work in a global engineering organisation with a strong focus on technical excellence and knowledge sharing.
• Collaborate on a multi-year modernisation programme for a large business-critical ERP platform.
• Operate in an AI-native engineering environment.

Hiring process

• CV review.
• HR call followed by an interview.
• Client interview and final decision.