Job summary
He/She will be a technical RUN expert for all MSBI instances. As such, he/she will provide support and act as the last level of escalation point for all production support activities within the Grid team in Singapore. He/She is accountable for the overall health and stability of the technical solutions within his scope. He/She has to effectively work with technical peers such as architects, peer experts and project teams on technology road maps and projects. He/She will have control over the scope of technical activities, develop best practices, manage knowledge and ensure the necessary trainings are imparted to the team wherever applicable.

Job detailed description
An Expert has a wide spectrum of responsibilities and actions.
As an expert of his/her team, he/she:

• Assigns technical tasks and manages delegation for technical issues,
• Animates the team to encourage collaboration and sharing of best practices,
• Has a role in supporting technical skills development and provides training when required,
• Supports new technologies and leverages them to provide consistency of service across streams,
• Documents, reviews, maintains and shares relevant technical information to the team,
• Provides technical direction, supports services both proactively and reactively to maintain the availability and reliability of system infrastructure in accordance to the sla,
• Implements and develops improvements based on best practices,
• Focuses on automation and optimum use of the team to improve efficiency,
• Drives and delivers root cause for any high severity issue,
• Reviews technology changes to identify potential risks,
• Is responsible for problem management and resolution,

As an experienced professional in MSBI he/she:

Setup & Installation

• Install and test SSIS Instance
• Install and test SSAS Instance
• Install, configure and test SSRS Instance
• 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
• Is involved in Middleware Standardization
• Is involved in Capacity Planning
• Is part of Senior Admin Benchmarks Validation
• Is involved in the Client Relationship Management in DevOps mode
• Is purposing Enhancement and Improvement Roadmaps definitionsupports his/her team during diagnosis when technical issues rise in his/her scope ofexpertise, is aware of the global IT structure so that he/she anticipates interrelationships within the organization, engages with technical peer, Service managers, Architect and project teams on technology roadmap and projects, facilitates transformation projects and suggest future directions for new areas of improvement and change, guarantees the production readiness and license to operate of new projects and solutions 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 incorporating them into CACIB operations, actively assists in identifying the most technical skilled candidates for open roles. technically coach and develop partner resources to improve quality and productivity, define the technical skillset required to support technologies,

As the escalation point of contact for Clients, he/she:
. manages the daily relationship with Clients including planning, requests clarification, risks mitigation and service quality

• Job specific environment and/or organization
  Working hours will match Europe business hours
• On-call support will be expected on a rotational basis

Candidate profile
Mandatory track record
. Minimum 4-5 years of experience in MSBI with about 3-5 years of experiencein financial institutes
. Must be a bachelors/engineering graduate
. Subject matter expert on technologies MSBI
. In depth hands on knowledge/experience on system Windows and MSSQL
. In depth hands on knowledge/experience on Microsoft SQL SSAS
. In depth hands on knowledge/experience on Microsoft SQL SSIS
. In depth hands on knowledge/experience on Microsoft SQL SSRS
. In depth hands on knowledge/experience on Microsoft SQL DB Engine

. In depth hands on knowledge/experience onPowerBI Report Server
. Excellent communication, interpersonal and logical skills
. Customer service oriented and a strong team player
. Ability to work under pressure and a commitment to solving issues

Interestedapplicants, please email your resume to ShaunQuek Yew Meng.

Email: [HIDDEN TEXT]

CEI Reg No: R1660732

EA Licence No: 99C4599