Senior Database Architect (SQL Server & PostgreSQL)
⚲ Bucharest
Do uzgodnienia
Wymagania
- Database Administration (DBA)
- Database design
- ERP
- Microsoft SQL Server
- PostgreSQL
- SQL
- Artificial Intelligence (AI)
- billing
- Microsoft Platform
- Transition
Opis stanowiska
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:
The Senior Database Architect will ensure the integrity and performance of the 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 like OpenSpec to structure requirements and implementation plans.
Key Requirements:
• Strong, hands-on SQL Server expertise (design, indexing, query optimization, 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/monitoring.
• A pragmatic, risk-aware approach that balances improvement efforts with migration costs and business risks.
Nice to Have:
• Experience in assessing and scoping SQL Server to PostgreSQL migrations.
• Experience in environments with both legacy and modern systems in production.
• 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, C2
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:
The Senior Database Architect will ensure the integrity and performance of the 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 like OpenSpec to structure requirements and implementation plans.
Key Requirements:
• Strong, hands-on SQL Server expertise (design, indexing, query optimization, 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/monitoring.
• A pragmatic, risk-aware approach that balances improvement efforts with migration costs and business risks.
Nice to Have:
• Experience in assessing and scoping SQL Server to PostgreSQL migrations.
• Experience in environments with both legacy and modern systems in production.
• 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, C2
🔍 Dekoder Ogłoszenia
🔴
modernize the database landscape of a critical ERP system while maintaining its operational capabilities during a transition from legacy technologies to a modern platform
Będziesz pracować nad starym, krytycznym systemem, który musi działać bez przerwy podczas jego przebudowy.
🟡
Identify performance issues, technical debt, risks, and areas that are performing well.
Oczekuje się, że znajdziesz problemy, ale też będziesz musiał zidentyfikować, co działa dobrze, co może być stratą czasu.
🟡
Recommend and prioritize pragmatic improvements.
Twoje sugestie mogą być ignorowane lub priorytetyzowane w sposób, który niekoniecznie jest optymalny z technicznego punktu widzenia.
🔴
Work within an AI-native engineering environment using Specification-Driven Development (SDD) frameworks like OpenSpec to structure requirements and implementation plans.
Będziesz musiał nauczyć się i stosować nowe, być może niedojrzałe narzędzia i metodyki, które mogą spowolnić pracę.
🔴
Proven experience optimizing query and index performance in production environments.
Oczekuje się, że będziesz w stanie natychmiast rozwiązywać problemy z wydajnością bez czasu na naukę specyfiki systemu.