SQL Server Architect

Description

Summary: Seeking an experienced SQL Server expert to assess, monitor, and optimize critical platforms, ensuring stability, performance, and scalability through advanced troubleshooting and tuning. Highlights: 1. Opportunity to work on critical SQL Server environments 2. Engage in advanced troubleshooting and performance tuning 3. Be part of a tech start-up with career path management **ABOUT WELVAART** On a daily basis, we assume **commitments** and present solutions to our stakeholders in order to create a structure of human values, based on **professionalism**, **honesty** and **rigor**. With a management based on **Human Centered Design**, we take care of our professionals with consistent **career plans**, but flexible with their needs and expectations of evolution. Our management team guarantees an **empathetic** and present **leadership** that will provide superior **technological engagement** and delivery to our clients' projects and products. **Project** The objective is to perform a full assessment of the SQL Server platform, ensuring stability, performance, resilience, and long‑term scalability. The professional must have deep experience in critical environments (minimum 10 years) and advanced expertise in SQL Server Enterprise, Always On, Performance Tuning, and internals. The project includes a diagnostic phase, an extended observation and shadowing phase of daily operations, and concludes with the delivery of reports, remediation plans, and knowledge‑transfer sessions. **Responsibilities** * Monitor platform behavior over time. * Correlate events and identify progressive degradation. * Identify memory leaks, cache pollution, parameter sniffing, temporary object growth, fragmentation, and cumulative phenomena. * Follow the team’s hourly monitoring routines. * Review recovery procedures. * Accompany periodic cluster failovers. * Analyze incidents and alerts. * Ensure a real understanding of the platform’s behavior, avoiding diagnoses based solely on snapshots. * Minimum 10 years of experience in critical platforms. * Strong experience in advanced troubleshooting and tuning of high‑availability environments. **Requirements** Proven experience in: * SQL Server Enterprise * Always On Availability Groups * Windows Failover Cluster * Performance Tuning * SQL Internals * Memory Management * TempDB * Wait Statistics * Query Store * Extended Events * Capacity Planning **What you can discover with us?** * Be part of a tech start\-up * Different scopes of project in different sectors * Structure of fairness and equity salary (Consultant Profile) * Training \& Certification * Career Path management * More than 30 Partnerships * Welvaart Ambassador Program **UNLEASH THE POWER OF YOUR CAREER** Pagamento: Até 2 800,00€ por mês Localização do trabalho: Trabalho remoto híbrido em Lisboa