Bestjobs South Africa

Don't miss any news or updates from BestJobs

Not now Allow

System Administrator

R 40.000,00 monthly City of Johannesburg, Gauteng 11 June

Cover For Life Insurance

This seal certifies that the information and activity of this Recruiter has been carefully verified by BestJobs.

  • Description

  • Introduction
    A company of game changers who are freshening up the face of student accommodation with state-of-theart residences where students can thrive - socially and academically. They own, develop and manage student accommodation, which sets new standards for student living in South Africa. This company is looking for a multi-talented individual who will be responsible for administering various database components relating to the company’s MIS. The System Administrator will be reporting systems, within the parameters of IT best practice, thereby ensuring development, maintenance, and optimisation of the company business intelligence environment.

    Duties & Responsibilities
    Technical skills

    Solution architecture and design
    Data Interpretation and analysis
    Report generation - Excel and Power BI
    Power BI – Dax – must have the ability to create measures and cross link data
    Data modelling – must have the ability to create and implement
    Business analysis - understand and interpret the business requirements
    Identify the root causes and escalate the failure points
    Data centric – ability to be immersed within the data space
    Numerically literate

    Effectively and Efficiently Maintained Hi-Res Structure

    Check and configure data security of the database on Hi-Res production and UAT servers
    Onboarding of new facilities into the system including configuration of beds
    Monitor and ensure good API connectivity throughout and troubleshoot issues where required
    Monitor accuracy, completeness, and timelines of student data cycle
    Design and deploy new database structures during future builds against industry best practice
    Sustain information security and data integrity through the complete application and infrastructure stack
    Collaborate to create SQL query for database maintenance
    Maintain and improve data-warehouse structure from various data sources and destination of the solution Plan, design and implement automated database back-ups
    Collaborate to build automated workflows and data checks to constantly improve the smooth running of data, and data integrity
    Update and maintain the content on confluence for Hi-Res
    Collaborate in the management of deployments and associated change control
    Manage any tickets being logged and resolution of tickets once live

    Effectively Maintained SQL Database Server

    Run effective checks on integration points with system (API Management; Pastel; TPN; Payrate; website; mobile app)
    Build, maintain and support data integration from various unstructured data (Biometric, Meter online etc.)
    Collaborate to develop SQL script for data maintenance in the cloud
    Monitor server performance through SQL trace event
    Design, build, deploy, and maintain jobs in SQL server Agent
    Design, build and deploy (System Solution Infrastructure Standard) SSIS packages for various data integration

    Accurate Management Reports

    Plan, design, deploy and maintain data warehouse solution and its components
    Develop and maintain an automated MI framework
    Develop blended business intelligence reports using data from the major business systems using SSRS for operation, marketing, and finance department
    Maintain report automated on the server and initiate deployment on SharePoint

    Satisfied I.T. System Users

    Create SM Users, user permission level when required
    Provide training and assistance to users when required
    Provide monthly report on the users performance in different solution components (SM, Pastel and bandwidth)

    Desired Experience & Qualification

    Ability to use Microsoft 2014/2016 R8 Studio Management
    MCSA or MCSE qualification will be advantageous
    A SQL based qualification will be advantageous
    Ability to use SQL Server Integration Services (SSIS) – OLAP Cubes
    Ability to use SQL Server Analysis Services (SSAS) – Analysis and Modelling
    Ability to use SQL Server Reporting Services (SSRS) – Report Builder
    Expert knowledge of Microsoft Excel / Access 2013
    Advance knowledge of Power BI
    Advance knowledge of DAX/MDX
    Advance knowledge of MS Data Quality Service
    Intermediate knowledge of Microsoft Visual Studio
    Advanced knowledge of data management
    Knowledge on information system
    Knowledge of server file structure
    Knowledge of system life cycle
    Knowledge of MySQL Workbench
    Knowledge in data-modelling

    Generic Competencies

    Candidate must be analytical and take accountability
    Must have a strong business acumen
    Must be results oriented
    Must cooperate and work well in a team
    Excellent communication skills
    Must be creative and have the ability to innovate
    Must take initiative and be resourceful
    Must have numerical competency
    Data analytic skills are essential

    Package & Remuneration
    R40,000 per month

  • Number of vacancies: 90
  • Requirements

  • Minumun level of education: Grade 12 /N4 (Matric)
  • Language(s): English
  • Availability for travel: No
  • Availability for change of residence: No

Similar ads

Full Time - Permanent contract - R 20.000,00 monthly

2 June

Part Time - Permanent contract - R 19.000,00 monthly

Yesterday, 05:10 PM

Full Time - Permanent contract - R 18.000,00 monthly

Yesterday, 04:55 PM

Ad summary

  • System Administrator

  • Recruiter

    Cover For Life Insurance

  • Province

    City of Johannesburg, Gauteng

  • Work type

    Full Time

  • Type of contract

    Permanent contract

  • Salary

    R 40.000,00 monthly

  • Apply now

Related search