Database Administrator at Eskom Pension and Provident Fund

Description

 Install, upgrade, and manage database applications:

•  Install and maintain the performance of database servers.
• Responsible for maintaining the integrity and performance of the Funds databases.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Design and implement data extraction and transformation programmes and support with data mining on an as needs basis.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.

Maintain data standards and ensure data remains consistent across database

• Establish the needs of users and monitor user access and security.
• Monitor performance and manage parameters in order to provide fast responses to front-end users.
• Map out the conceptual design for a planned database.
• Consider both back-end organisation of data and front-end accessibility for end-users.
• Refine the logical design so that it can be translated into a specific data model.
• Further refining the physical design to meet system storage requirements.
• Install and test new versions of the database management system (DBMS).
• Maintain data standards, including adherence to the Data Protection Act.
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Informing end users of changes in databases and train them to utilize systems effectively.

Ensure that storage and archiving procedures are functioning correctly

• Ensure that data is stored securely and optimally by controlling access permissions and privileges.
• Develop, manage and test back-up and recovery plans.
• Work closely with IT project managers, database and business analysts
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
• Commission and install new applications and customise existing applications in order to make them fit for purpose.
• Manage the security and disaster recovery aspects of the database.

Requirements

TECHNICAL COMPETENCY REQUIREMENTS  

• In-depth knowledge of the application environment.
• Extensive knowledge of business practices and processes.
• Knowledge of developing IT related business plan and motivation.
• Commercial knowledge (budgeting, procurement etc.).
• Project lifecycle (SDLC) knowledge.
• Knowledge of Cobit and /or ITIL.
• Experience with Linux and Windows Server environments.
• Extensive experience with design, implementation and utilisation of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB).
• Business Acumen.
• Presentation skills.
• Excel Intermediate.
• Understanding and knowledge of Microsoft Applications.

REQUIRED MINIMUM EDUCATION/TRAINING

• Relevant Diploma in computer science, computer software/computer systems engineering or related discipline.  
• Database Administration certification (advantageous).

REQUIRED MINIMUM WORK EXPERIENCE

• At least 3 years job-related experience, preferably within an IT environment.
• Experience with financial/investment systems advantageous.
• Business awareness and understanding of business requirements of IT.
• An understanding of information legislation, such as the Data Protection Act.