As a L2 resource of his /her team, he /she :

- Takes up technical tasks and support day to day BAU tasks/Incidents/RFCs.

- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.

- Proposes service improvements for all MSBI services supported throughout the organization.

- Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.

- Works in line with policies based on LEAN-CA-CIB best practices.

- Actively engages during any high severity issue and drives for issue resolution.

- Reviews technology changes to identify potential risks.

- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.

- Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.

- Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.

- Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.

- Guarantees the production readiness.

- Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.

- Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.

Key Responsibilities :

Technical Expertise :

- Setup & Installation

- Install and test SSIS Instance.

- Install and test SSAS Instance.

- Install, configure and test SSRS Instance

- Install & setup Power BI.

- Install and test SCOM agents on BI Server.

- Configure Monitoring.

- Patch Management

- Applying CU, SP, HF on BI Components.

- Monitoring

- Check & Resolve errors.

- Backup of components

- Cubes.

- DTSX Files (SSIS).

- SSRS Keys.

- Monthly metric reporting

- Storage & Memory for SSAS Multidimensional Instances.

- Storage & Memory for SSAS Tabular Instances.

- Storage & Memory for SSAS Tabular Instances.

- Scheduling of SSIS package execution based CTRL-M.

- Perform applicative deliveries on BI Platform

- Perform Delivery on ASSEMBLY (automated operation by CTRL-M).

- Perform Delivery on PRE-PROD (manual operation).

- Perform Delivery on PROD (manual operation).

- Define Control-M Jobs

- Create & Configure Control-M Job for SSIS package Execution.

- Troubleshooting

- Troubleshoot issue on performance First level of assessment.

- Troubleshoot issue with MOE Second level of assessment.

- Work with DBA for DB optimization (STG, DWH, DMT).

- Identify Resources consuming queries.

- Optimization

- Optimize Instance settings.

- Perform Migration

- Organize Software Upgrade & Migration.

- Perform Middleware Standardization and Capacity Planning.

- Involved in the Client Relationship Management in DevOps mode.