الوصف الوظيفي
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 the
Microsoft 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 Production
BI 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.
المهارات
• In-Depth knowledge and 6 to 8 years hands on experience with Microsoft Analytics Platform System (APS) and its day to day operation (Course completion certificate from Microsoft on APS platform)
• Experience in managing the SQL Server Integration Services (SSIS) development and scheduling of all ETL jobs
• Data Warehouse Administrator / ETL Specialist
• OLAP/Reporting Tool Administrator/Developer
• General knowledge and understanding of system components such
as RDBMS, operating system, hardware, ETL tools and processes, data modeling, etc.
• In- depth knowledge and experience with ETL tool (or programming language) as both a developer and administrator
• Liaison between the enterprise and the ETL tool vendor for all technical issues
• Upgrading ETL software and applying patches as necessary
• Knowledge and understanding of business intelligence/data warehouse concepts and principles
• High proficiency in understanding relational and dimensional data models
• Proficiency in SQL including the use of SQL editors, stored procedures, database triggers and optimizing SQL statements
• Familiarity with the data modeling tool and version control
• Working knowledge of and experience with the client and server operating systems
• Knowledge of and experience with XML
• Excellent written and verbal communication skills
• Strong analytical and problem solving abilities
• Working knowledge of business functions, terms and processes
• Understanding of open database connectivity (ODBC) concepts and ability to configure and troubleshoot client- to-server connectivity issues
• Experience on Windows OS Support and maintenance
• Maintaining and controlling schema definitions and meta data
• Establishing and maintaining meta data standards and Developing and maintaining technical documentation about the data
• Coordinating with the ETL specialist on data mappings and conversion rules
• Coordinating with the ETL specialist for instantiating logical schemas into physical schemas
• Identifying opportunities to optimize warehouse performance
• Projects Repository Configuration Management and Control
• Developing and Maintaining needed documents, forms and templates
تفاصيل الوظيفة
منطقة الوظيفة دبي, الإمارات العربية المتحدة
قطاع الشركة النقل بالسكك الحديدية والمترو
طبيعة عمل الشركة صاحب عمل (القطاع الخاص)
الدور الوظيفي تكنولوجيا المعلومات
نوع التوظيف دوام كامل
الراتب الشهري غير محدد
عدد الوظائف الشاغرة 2
المرشح المفضل
المستوى المهني متوسط الخبرة
عدد سنوات الخبرة الحد الأدنى: 5
منطقة الإقامة دبي,الإمارات العربية المتحدة
الشهادة بكالوريوس/ دبلوم عالي
*** تقدم على الرابط التالي : Apply on the following link ***
https://www.bayt.com/ar/uae/jobs/support-engineer-for-business-intelligence-bi-platform-4013523/