Database Analyst

Open 53d

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 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

See also