Browse Jobs
For Employers
Post JobLog inGet Started

Database & Analytics Manager

SARA Group
Cairo, Egypt
Posted 5 years ago
62Applicants for1 open position
  • 31Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Key Responsibilities:

  • Lead the Reporting, Analytics and BI program
  • End to end design and development of MS Power BI dashboards from Data warehouse to Front end dashboard
  • SQL DBA for critical business systems including Dynamics AX 2012 R3
  • Work with management and IT to constantly innovate and improve using data analytics to deliver critical information to the right people at the right time
  • Responsible for all backup, recovery, and upgrading of all the SQL databases.

Job Requirements

Qualifications & Work Experience:

  • 5+ years of experience in Microsoft SQL Server environment, with thorough knowledge of SQL Server 2008/2008R2/2012/2016 databases.
  • Experience in SSIS, SSAS, SSRS components of SQL Server.
  • Experience in building ETL data flows using SSIS, creating workflows/data mapping to extract or push data from/to SQL Server - design, develop, schedule, troubleshooting, and monitoring.
  • Experience creating shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience with Azure.
  • Good working knowledge of query optimization, performance tuning of stored procedures, and use of SQL tools such as Profiler, Execution plans, Database Tuning Advisor, and related efficient coding standards.
  • Experience in key DBA functions
  • Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Database Integrity Checks, Update Database Statistics, and Re-indexing.
  • Handle Dev and Prod environments.
  • SQL High Availability mode
  • SQL server performance optimization
  • Strong experience using SQL Server Reporting Service (SSRS) with the report designer, report manager, and report server. Experience in developing Enterprise reports, drill down reports, linked reports, and charts using SSRS Report Builder.
  • Develop Cubes using SQL Server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimension, and data source views.
  • Any experience with performance monitoring tools is a plus.
  • Any experience working with Audit tools such as Netwrix, Alertlogic, etc is a plus.
  • Experience working with security tools.
  • Experience with Database on-Prem and in Azure, with data handling experience.
  • Experience with Dynamics AX 2012 (or similar) ERP [DB and Table design, management and reporting]
  • Good familiarity with developing in a Microsoft technical environment, including Windows Server admin and SQL Database administration.

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentDatabase & Analytics Manager