Solution Architect

Caixa Mágica Software; Lisboa; On-site; EUR 65,000 - 90,000; Full time

Benefits offered by this job

Health and Life Insurance

Social events and team buildings

Training in latest technologies

Coffee, fruits, snacks and welcoming a

Personal smartphone and SIM card

Job summary

A Caixa Mágica Software procura um(a) Solution Architect com experiência em desempenho e estabilidade de SQL Server para avaliar uma plataforma crítica e propor evoluções estratégicas. O papel envolve identificar limitações estruturais, definir um roadmap de melhoria e garantir estabilidade a longo prazo.

O candidato ideal traz conhecimento profundo em clusters, alta disponibilidade, monitorização de recursos, wait statistics e otimização de queries, com capacidade de trabalhar com equipas APS,

Qualifications

• Experiência sólida em identificar causas de degradação de desempenho em SQL Server.
• Capacidade de analisar caches, memória, I/O e estatísticas de wait.
• Conhecimento de clustering, alta disponibilidade e configurações de SQL Server.

Responsibilities

• Avaliar o desempenho e a estabilidade de ambientes SQL Server críticos.
• Definir roteiro de melhoria com ações de curto, médio e longo prazo.
• Conduzir monitorização de 4 a 8 semanas para entender o comportamento do platforma.
• Conduzir transferências de conhecimento para equipas APS, DBAs e aplicação.

Skills

SQL Server performance

Stability analysis

Cluster HA architectures

Infrastructure analysis

Root cause analysis

Tools

SQL Server health checks

Job description

Solution Architect

Empresa : Caixa Mágica Software Tipo de Emprego : Periodo Integral Lisbon, Portugal

Descrição do Emprego - Solution Architect

Overview

We are looking for an experienced SQL Server Performance & Stability Consultant to assess and improve a critical database platform, combining deep technical analysis with a long-term evolution strategy.

The role will focus on identifying the structural causes behind recurring performance degradation, defining a clear improvement roadmap, and ensuring sustainable platform stability through infrastructure, SQL Server, database and application‑level analysis.

What will you do?

• Relate current performance and stability issues to the platform’s long-term evolution strategy.
• Identify structural limitations of the existing platform and define an improvement roadmap.
• Perform a comprehensive assessment covering:
  • SQL clusters and high availability configurations.
  • Storage, network and operating system.
  • SQL Server health and instance configuration.
  • Resource utilization, Wait Statistics, blocking and deadlocks.
  • Memory pressure and I/O bottlenecks.
  • Fragmentation and statistics.
  • Database growth, logical architecture, indexes and capacity.
  • Critical queries, Stored Procedures and Jobs.
• Monitor the platform for 4 to 8 weeks to understand its behaviour over time and identify progressive degradation.
• Investigate issues such as:
  • Memory leaks.
  • Cache pollution.
  • Parameter sniffing.
  • Temporary object growth.
  • Fragmentation and other cumulative performance issues.
• Shadow operational activities, including:
  • Hourly platform monitoring.
  • Recovery procedures.
  • Periodic cluster failovers.
  • Incident and alert analysis.
• Identify risks, constraints, root causes and technically supported hypotheses.
• Define a remediation plan divided into:
  • Quick Wins – up to 2 weeks.
  • Medium Term – approximately 2 months.
  • Long Term – architectural evolution.
• Define a roadmap to ensure sustainable platform stability over the next 18 months.
• Recommend tools, configurations and monitoring improvements to anticipate potential issues more effectively.
• Deliver knowledge transfer sessions to APS, DBA and Application teams.

What are we looking for?

• Strong experience assessing and troubleshooting critical SQL Server environments.
• Deep expertise in SQL Server performance and stability analysis.
• Strong knowledge of SQL Server clusters and high availability architectures.
• Experience analysing storage, network and operating system dependencies affecting database performance.
• Strong knowledge of:
  • Wait Statistics.
  • Blocking and deadlocks.
  • Memory management and memory pressure.
  • I/O bottlenecks.
  • Database fragmentation and statistics.
  • Database growth and capacity planning.
  • Index optimization.
  • Critical queries and Stored Procedures.
• Experience diagnosing complex and progressive performance degradation across infrastructure, database and application layers.
• Ability to perform root cause analysis and distinguish between infrastructure, SQL Server and application‑related issues.
• Experience defining technical remediation plans and long‑term architectural roadmaps.
• Strong analytical skills and the ability to translate technical findings into clear, actionable recommendations.
• Experience working closely with APS, DBA and Application teams and providing technical knowledge transfer.

What can you expect from us?

• A permanent job contract for a long term project;
• Tech equipment + SIM Card + personal smartphone;
• Health and Life Insurance;
• Social events and team buildings;
• The commitment of letting you grow with us, and be rewarded accordingly;
• A dynamic and young team that will be always there to support you;
• Training in the latest technologies;
• Coffee, fruits, snacks and a warm welcoming when you pass by the office.