Main tasks:
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 conditions:
- Implementing 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 maintain 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 Functionsetc..)
- Root cause analysis skills
- Experience with SQL perfomance tunning partitioning and indexing
- Experience with C#
- Experience with Power BI
- Experience with Master Data Services
- ITIL
- DevOps (CI/CD)
- Monitoring tools (e.g. Dynatrace ELK Zabbix)
Language skills:
Remote Work :
No
Employment Type :
Full-time