SQL Server Architect

Description

Job Summary: We are seeking an experienced Microsoft SQL Server professional to manage and optimize critical environments, with a focus on high availability, performance, and advanced tuning. Key Highlights: 1. Management and optimization of critical SQL Server Enterprise environments 2. Development and maintenance of Always On Availability Groups solutions 3. Advanced performance tuning and diagnosis of complex issues **What You Will Do:** * Manage and optimize SQL Server Enterprise environments, ensuring high availability and performance. * Design, implement, and maintain Always On Availability Groups and Windows Failover Cluster solutions. * Perform advanced performance tuning, troubleshooting, and optimization for critical SQL Server platforms. * Analyze SQL Internals, Memory Management, TempDB configuration, and Wait Statistics to diagnose and resolve complex issues. * Use Query Store and Extended Events for proactive monitoring and performance diagnostics. * Execute comprehensive capacity planning to ensure scalability and reliability of the SQL Server infrastructure. **What We Are Looking For:** At Aubay, we seek professionals who combine solid technical skills with the right attitude: * Minimum of 10 years of proven professional experience with Microsoft SQL Server, specifically in mission-critical environments. * Demonstrated experience with SQL Server Enterprise features, including Always On Availability Groups and Windows Failover Cluster. * In-depth knowledge of performance tuning, SQL Internals, Memory Management, and TempDB optimization. * Experience using Wait Statistics, Query Store, and Extended Events for advanced performance troubleshooting. * Strong experience in capacity planning for large-scale and complex SQL Server environments. * Mandatory fluency in English, both written and spoken. * We value individuals who identify with our culture and act with integrity and ethics. * We prioritize customer orientation, teamwork, task prioritization, and daily commitment. **What We Offer You:** At Aubay, we invest in your development and well-being: * Continuous growth through our Training Academy, offering technical and behavioral training, mentoring, technology communities, workshops, and in-person tech meetups; * Close support with regular feedback sessions and a structured career progression model; * Comprehensive health insurance, including dental coverage, as well as access to a mental health platform and wellness initiatives; * A team-oriented environment with events and initiatives promoting closeness and team spirit; * Support for your personal and family life, from your children's birth through their academic journey; * Access to a language platform offering conversation classes in multiple languages; * Flexible work model aligned with the project: hybrid (one day per week onsite). **What You Will Find Here:** * A close-knit and informal environment where communication is direct and people are valued; * Recognition of your contributions through initiatives marking important milestones; * Freedom to be authentic, without unnecessary formalities; * Teams that share knowledge, collaborate, and grow together. Personal data collected by AUBAY PORTUGAL SA regarding candidate identification, contact details, and qualifications — as the data controller and co-controller involved in this process — will be used solely for application purposes and integration into our team, given that such data serves the execution of pre-contractual steps requested by the data subject; Data submitted via this application, held by AUBAY, will be retained throughout the ongoing recruitment process and stored for the stated purposes as long as they remain up-to-date (two years). Collected data may be shared or subject to other processing activities, following notification to the respective data subject, as part of the normal recruitment and selection process; such data may also be retained to comply with applicable legal obligations, for the duration stipulated by relevant legislation. To exercise any rights related to personal data protection, please contact AUBAY PORTUGAL at its registered office located at Avenida Duque D'Ávila, nº46, Lisbon, or the Data Protection Officer via email at dpo@aubay.pt; you may also exercise your rights before the competent National Data Protection Authority — www.cnpd.pt. (\*Do not include data concerning racial or ethnic origin, political opinions, religious or philosophical beliefs, trade union membership, genetic data, biometric data, health-related data, data concerning sex life or sexual orientation, or data relating to criminal convictions and offences)