Br /br /afarax is looking for a freelance Solution Architect / SQL Server Expert. We need you!br /br /br /Our client in the insurance sector, is seeking an experienced Solution Architect / SQL Server Expert to strengthen their team.br /br /br / br /br /br / br /br /br /Responsibilitiesbr /br /br / br /br /br /Architecture design:br /br /br /br /Define and implement end-to-end architecture for SQL Server platforms (On-Prem, Hybrid, Cloud).br /br /Design high-performance, scalable, and secure database architectures aligned with strategic IT directions.br /br /Architect HA/DR solutions (AlwaysOn, Failover Clustering, Backup strategies) supporting business continuity.br /br /Contribute to the unification of Operational Analytical data flows and platforms.br /br /Develop and document architectural standards, operating procedures, scripts, and governance models.br /br /br /br /Technical expertise operational excellence:br /br /br /br /Act as the senior SQL Server expert for deep-dive troubleshooting, performance tuning, and optimization.br /br /Analyse performance insights (Query Store, Extended Events, SQL Sentry, Dmvs) and deliver impact assessments and improvement plans.br /br /Oversee SQL Server security (auditing, access models, AD integration).br /br /Support and optimize ETL and BI components: SSIS, SSRS, SSAS.br /br /Guide the transition toward Azure SQL components (Azure SQL Database, Managed Instance, Data Factory, Synapse Link — plus).br /br /br /br /Transformation Cloud enablement:br /br /br /br /Support SQL Server Operational Databases migration and operating model toward Cloud environments.br /br /Participate in architectural assessments and cloud readiness analyses.br /br /Recommend future-proof patterns leveraging Microsoft#39;s evolving data ecosystem.br /br /br /br /Collaboration leadership:br /br /br /br /Collaborate closely with DBAs, system engineers, architects, and business stakeholders.br /br /Coordinate SQL Server deliverables across Run and transformation teams.br /br /Provide coaching, mentoring, and technical guidance to SQL Server specialists and junior engineers.br /br /Ensure transparent communication with team leads, management, and project leadership.br /br /Support change and production releases, including outside office hours when necessary.br /br /br /br /Governance delivery:br /br /br /br /Ensure all deliverables meet scope, timing, budget, and quality expectations.br /br /Maintain a structured, methodical, and documentation-driven approach.br /br /Act as a key contributor within multidisciplinary teams and transformation initiatives.br /br /br /br / br /br /br /Is this you?br /br /br /br /Expert-level knowledge of SQL Server Database System Administration.br /br /Strong expertise in performance tuning and troubleshooting (Query Store, Extended Events, SQL Sentry, Dmvs).br /br /Deep proficiency in:br /br /br /br /SQL Server Security Auditingbr /br /T-SQLbr /br /SSIS, SSRS, SSASbr /br /PowerShell scriptingbr /br /Windows Server Active Directorybr /br /br /br /Experience with SQL Server 2019+ mandatory.br /br /Strong knowledge of high performance database design.br /br /Understanding of HA/DR methods for SQL Server.br /br /Experience with .NET/C#, WPF, Entity Framework is a plus.br /br /Knowledge of Cloud/NoSQL environments is a plus.br /br /Strong communication and interpersonal skills.br /br /Collaborative team player with coaching abilities.br /br /Analytical, solution-oriented, detail-oriented.br /br /Structured, organized, and quality-driven.br /br /Comfortable with change and transformation environments.br /br /Ability to multitask and adapt in complex, multidisciplinary settings.br /br /br /br / br /br /br /How afarax supports you?br /br /br /br /You benefit from our extensive networkbr /br /You will have access to projects that fit your expertisebr /br /We help and support you throughout your projectbr /br /We offer the possibility to build a valuable and lasting partnershipbr /