SQL Server Architect
Welvaart · Lisbon, Portugal
You apply off-site, with the employer or the job board. I never handle applications.
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