DBA SQL Server

Compétences obligatoires

MS SQL (EXPERT)Database installation & configuration (CONFIRMED)Extended Event and TSQL coding (CONFIRMED)Powershell (CONFIRMED)

Compétences optionnelles:

DescriptionSecteur : tourisme 
Localisation : 92 Télétravail : full remote hormis un déplacement sur site par mois dans le 92

As a a multi-skilled Senior Database Administrator (DBA) to join our team, the ideal candidate will have expertise in MS SQL Server database management systems, along with a strong understanding of database architecture, design, and optimization principles. MAIN RESPONSIBILITIES Responsibilities within the Domain: · Install, configure, and maintain MS SQL Server database software · Develop and implement licensing and data strategy · Monitor database performance and tune databases for optimal efficiency · Develop and implement backup and recovery strategies to ensure data integrity and availability · Perform regular database maintenance tasks, such as database reorganisations, index rebuilds and disaster recovery testing · Identifies problems at the database and system level, and recommends solutions · Collaborate with developers to optimise database queries and improve application performance · Collaborate with developers during peer review processes · Implement database security best practices according to company and GDPR standards to safeguard sensitive data · Create and maintain documentation related to database configurations, procedures, and standards · Stay up to date with the latest database technologies and trends · As a senior, work with the Head of Technology to manage the team’s workload and act as a stand-in during any absences of the HT REQUIRED SKILLS · Strong ability to work independently and manage one's time · Proven expertise as a Database Administrator with MS SQL Server in a multi environment architecture · Strong knowledge of MS SQL Server database technologies with a range of versions · Strong knowledge of MS SQL core technologies: SSIS, SSRS, SSAS · Strong knowledge of computer software, such as Windows Security, Virtualization · Strong knowledge of Database installation & configuration · Strong experience in data migration and consolidation (Datacenter, SQL instances, databases) · Expertise in database security principles and techniques · Expertise in Extended Event and TSQL coding · Expertise in PowerShell (coding, DBATools, script maintenance) · Expertise in High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server · Clustering techniques such as MS SQL Server Clustering · Significant experience using database backup tools and methodologies · Good understanding of database storage management · Good knowledge of Active Directory (GMSA Account, GPO, Cluster OU, …) · Significant experience of performance tuning and query optimisation · Managing workloads within the Jira product · Experience working with Microsoft via their support processes 

QUALIFICATIONS · At least 10 years hands-on experience of database administration · Experience in the travel and tourism industry is a plus · Proven experience of managing and mentoring other database administrators is a significant advantage · Strong understanding of database management concepts, including normalization, indexing, and transaction management · Experience with database performance monitoring and tuning tools · Excellent problem-solving and troubleshooting skills · Native-speaker level French in order to work collaboratively with Business, Product Owner, Transversal IT Teams and Business Project team. · Strong communication and interpersonal skills · Relevant certifications (e.g., Microsoft Certifications, AWS Certifications) are a plus but not essential · Experience of managing databases within a cloud environment such as AWS or Azure is a plus but not essential