About this role
Designing an implementation of database systems in the Information Systems Monitor and support critical business processes;Develop and optimize SQL queries, stores procedures, and database triggers for data manipulation and reporting;Working closely with Development teams to improve the value of business processes outcomes. Administration and maintaining databases in operational conditionsImplementing backup systems to ensure the integrity of all database data;Ensuring that backups are made in accordance with strategy defined by each business line;Provide technical support:Provide support to developers and APS teams; Intervene in the event of incidents which limit the performance of databases or access to information; Active participation in post-mortems for major and/or recurring database incidents;Technical advisory:Ensure technological monitoring to maitain the required performance and availability through visualisation tools (e.g Dynatrace, Power BI); Assess and deploy innovative solutions aiming to simply, automate and optimise database costs; Technical Skills:
Solid experience with full stack Microsoft BI - SSIS, SSRS, SSAS(Preferential Tabular Models); Solid experience with ETL processes Development, optimization and monitoring (SQL Procedures, Functions,etc..) Root cause analysis skills; Experience with SQL perfomance tunning, partitioning and indexing; Experience with C#,PowerShell, .Net; Experience with Power BI; Experience with Master Data Services; ITIL DevOps (CI/CD) Monitoring tools (e.g. Dynatrace, ELK, Zabbix)Fluent in English