Must Have Skills

• Setup & Installation

o Install and test SSIS Instance.

o Install and test SSAS Instance.

o Install, configure and test SSRS Instance and Power BI.

o Understand on SCOM agents on BI Server.

o Configure Monitoring.

• Patch Management

o Applying CU, SP, HF on BI Components.

• Monitoring o Check & Resolve errors.

o Backup of components - Cubes. - DTSX Files (SSIS). pg. 2 Internal - General Use - SSRS Keys.

• Monthly metric reporting

o Storage & Memory for SSAS Multidimensional Instances.

o Storage & Memory for SSAS Tabular Instances.

o Storage & Memory for SSAS Tabular Instances.

o Scheduling of SSIS package execution based CTRL-M.

• Perform applicative deliveries on BI Platform o Perform Delivery on ASSEMBLY (automated operation by CTRL-M).

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

o Perform Delivery on PROD (manual operation).

• Define Control-M Jobs

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

• Troubleshooting o Troubleshoot issue on performance > First level of assessment. o Troubleshoot issue with MOE > Second level of assessment.

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

o Identify Resources consuming queries. • Optimization

o Optimize Instance settings.

• Perform Migration

o Organize Software Upgrade & Migration.

• Perform Middleware Standardization and Capacity Planning. G

Good to Have Skills

• MSSQL DBA experience

• Involved in the Client Relationship Management in DevOps mode.