Responsibility to support the various BI platform implemented for users, its integrations with other systems and the customized services built on top of it based on the agreed SLA.
Day-to-day oversight of the operational warehouse
Communicating status, issues and problems in a real-time manner
Build the capacity plan on quarterly basis based on input from Data Management section for the planned projects and the estimated data size, also by considering the inputs from theMicrosoft on PDW (Parallel Data Warehouse) performance
Monitoring the Performance of the PDW and related environment components.
Support the Technical Support team on regular Backup Process
Receive knowledge transfer and handover process for all new projects
Carry out Health Check on the Data Warehouse and Physical Model Implementation after deployment on Production Data Warehouse
Support Reporting with changes and impact analysis to insure existing Databases and Implementations are not impacted
Support BI Delivery team in Preparing SQL Scripts Packages for PDW
Candidate should be able to handle fresh installation,configuration etc. with hands on experience on migration and upgrade activity
Upgrading to the latest version approved version of Microstrategy
Deploy SQL Scripts Packages
Managing ETL sessions and load order
Maintaining, backing up and restoring the ETL repository
Make sure that file transfer to Dubai Data Establishment is run successfully to ensure compliance with the Dubai Data Law and agreements with Smart Dubai office.
Monitoring and Performance tuning of sessions with load-order logic
Support BI Delivery Team in reviewing the Integration UAT package and make sure they are ready for deployment (SSIS ETLs)
Support BI Delivery Team on the Health Check of the Integration UAT packages after deployment on production (SSIS ETLs)
Deploy Integration Packages on Production Integration Servers (SSIS ETLs)
Upgrading products and applying patches as necessary
Maintaining and modifying reports / queries on as-needed basis
Coordinating schema changes with the data modeler
Managing and supporting the security implementation
Developing and maintaining technical documentation about the implementation
Scheduling batch jobs with the IT operations staff
Review the BI Platform Reports UAT package and make sure they are ready for deployment (Microstrategy)
Health Check the BI Platform Reports UAT package after deployment on production (Microstrategy)
Report with changes and impact analysis to insure existing reports are not impacted (Microstrategy)
Troubleshooting development database connectivity issues
QA check on the MSTR deliverables of any project on SDSC environment
Monitoring and Optimizing Operational performance
Providing assistance to other technical areas as required
Build the capacity plan on quarterly bases based on input from Client (DM). Capacity planning for the planned projects and the required run time for the reports, finish this process with CART team and MSTR.
Support BI Delivery Team in Preparation of BI Platform Projects Production Packages (Microstrategy)
Support BI Delivery Team in Deployment Projects on ProductionBI Platform (Microstrategy)
Hold monthly brief awareness session for TSG and ITD stakeholders, these sessions will cover details about operations, platform status, needed actions and its status updates and findings etc.
OS support to move the environment to other platform (e.g. Linux OS) if needed.
Continuous optimization for Data Integration and Loading Time
Continuous optimization for Data Retrieval Queries
Continuous optimization for Microstrategy operation
Development of Environment related Templates and Standards to be used by different teams
User Management and Access Control
Environment Security Monitoring, Optimization and Administration
Microstrategy Administration Activities
Data Integration Jobs (ETLs ) administration and scheduling
Environment Health Check on APS Appliance, Integration Servers and Microstrategy Servers
Environment Issues investigation and Root Cause Analysis
Monitoring of environment performance and capacity consumption
Early detection of potential environment issues / risks
Communication with principle HW / SW vendors for products support issues (Microsoft, HP, Microstrategy)
Environment Upgrades ( SW / HW)
Validation and Deployment of new projects on the platform
Acting as 1st line of support for all projects deployed on the environment
Communication with Client internal teams for any platform related issues
Frequent Status Reporting to Client relevant stakeholders
Frequent Capacity Planning and Forecasting for the environment
Environment Backup as Per Client Backup Policy
Study and analyze the current situation with respect to the number and type of licenses that are installed / utilized at Client for the various BI platform modules at various business units, and submit a study on how Client can make the best benefit out of these licenses and how to optimize their usage across client in light of the actual requirements, needs and expected future growth.
Job DetailsPosted Date : 2019-08-04Job Location : Dubai, United Arab EmiratesJob Role : Information TechnologyCompany Industry : ArchitecturePreferred CandidateCareer Level : Mid CareerDegree : Bachelor's degree
أضف الى المفضلات
إزالة من الإشارات المرجعية
يجب تسجيل الدخول إلى حسابك لإضافة هذه الوظيفة إلى لائحة الوظائف المفضلة لديك. انقر فوق "متابعة" لتسجيل الدخول أو إنشاء حساب جديد. ستتمكن بعد ذلك من الوصول إلى لائحة الوظائف المفضلة من موقعنا على الويب أو من تطبيق neuvoo للجوال.