SQL Server Specialist (Transact-SQL)

About This Role

This opportunity is for a Senior SQL Server Specialist (T-SQL) to join a data team, participating in information consolidation projects, process optimization, and continuous improvement of databases. The role suits a professional with solid experience in SQL Server, optimizing queries, and enhancing data processes.

Responsibilities

• Develop and maintain stored procedures and complex queries in T-SQL
• Analyze and optimize queries, indexes, and processes to improve database performance
• Design and maintain ETL processes for information integration and consolidation
• Diagnose and resolve technical incidents in SQL Server environments
• Participate in the design and maintenance of data models
• Document procedures and collaborate with data and business teams to ensure information quality and efficiency

Requirements

• Solid experience with Microsoft SQL Server and advanced proficiency in T-SQL
• Experience in optimizing queries, indexes, and stored procedures
• Knowledge of ETL processes and data integration
• Experience in database modeling, both logical and physical
• Analytical skills, autonomy, and continuous improvement orientation
• Technical English

Nice to have:

• Experience with Azure Data Factory and/or Azure Synapse Analytics
• Knowledge of Git and version control

Benefits

• Flexible working hours to help reconcile professional and family life
• Stable project and professional growth
• Great team
• Flexible remuneration: gourmet vouchers, private medical insurance, transport card, childcare vouchers, training
• Monthly follow-up with your team for continuous feedback

Important Details

• Work format: 100% remote work

About the Company

Capitole Consulting continues to grow and is looking for new talent to join them.