Support engineer for Business Intelligence (BI) Platform
Davidson consulting
Dubai,Dubai ,UAE
منذ 16 ساعات
source : drjobs.ae

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

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    قدِّم طلب ترشيحك
    أضف الى المفضلات
    إزالة من الإشارات المرجعية
    قدِّم طلب ترشيحك
    بريدي الالكتروني
    بالضغط على "واصل" ، أعطي موافقة نيوفو على معالجة بياناتي وإرسال تنبيهات إلي بالبريد الإلكتروني ، على النحو المفصل في سياسة خصوصية لـ نيوفو . يجوز لي سحب موافقتي أو إلغاء الاشتراك في أي وقت.
    واصل
    استمارة الطلب