Microsoft SSAS, SQL Administrator, SQL DBA

 

Recruiter:

PBT Group

Job Ref:

PBT4029301312

Date posted:

Monday, May 24, 2021

Location:

Johannesburg, South Africa

Salary:

Market Related


SUMMARY:
PBT Group has an opportunity for a SSAS Administrator. The SSAS Administrator will be responsible for providing the overall SSAS environment administration and support.

POSITION INFO:

PBT Group has an opportunity for a SSAS Administrator. The SSAS Administrator will be responsible for providing the overall SSAS environment administration and support.

 

Duties:

  • Manage and support environment installations, patching, upgrades and migrations to ensure that the SSAS environment is always at the latest release.
  • Implement and manage security aspects pertaining to sensitive data.
  • Provide development standards and guidelines for all SSAS development to ensure that best practices are implemented and adhered to.
  • Integrate performance metrics of cubes into the big data platform for reporting.
  • Provide usage adoption reports. Data should be integrated into the big data platform.
  • Monitoring and performance tuning of existing SSAS environment and cubes.
  • Perform server-level administrative functions including creating databases and setting server-level properties.
  • Document all standards and architecture for the SSAS environment on the Wiki also maintain up to date documentation for all implemented SSAS cubes.
  • Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements.
  • Engage with Microsoft to resolve issues that cannot be resolved internally.
  • Standardize cube deployment architecture.
  • Continually evaluate and improve development, test and production promotion standards.
  • Design, develop and maintain existing and new SSAS cubes according to best practices.

 

Experience:

  • Strong knowledge of Microsoft SQL Server and Analysis Services Server.
  • Experience in performing administrative tasks on Microsoft SQL Server Analysis Services (SSAS) - Installation, configuration, security configuration, configuring logging, deployment and performance monitoring.
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
  • Good experience in writing MDX queries while creating and customizing cubes using SSAS.
  • Highly proficient in SQL.
  • Experience in tabular and dimensional data modelling.
  • Extensive knowledge in SSAS storage and partitions.
  • Knowledge of Microsoft operating systems and power shell scripting.
  • The candidate must have sound knowledge of ETL.
  • Worked in environments with large data volumes.
  • Experience required with version control software such as SVN or GIT.
  • Excellent written and spoken English.
  • Needs to be self-driven.
  • Telecommunications industry experience would be beneficial.

 

 

Qualifications/ Certification:

  • Education: a 3-year diploma or higher

 



 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

BI Specialist
Location: Johannesburg
Salary:
Where Data Becomes Direction. If you believe data should do more than sit in tables, this role speaks your language. Step into a space where insights move leaders, automation improves processes, and analytics shape the future of financial services. This is your opportunity to design BI solutions that don’t just report the story… They change it.
18 days ago


BI Specialist
Location: Johannesburg
Salary:
Our client is seeking a highly skilled and analytical BI Specialist who has a fundamental desire to transform complex financial data into actionable intelligence that drives business success. In this pivotal role, you will be the bridge between raw data and strategic decision-making, creating optimized BI solutions that empower our executive leadership and management. If you are an expert in the M...
20 days ago


Create a free job alert for Microsoft SSAS, SQL Administrator, SQL DBA in Johannesburg

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions