Database Administrator - Bryanston, South Africa - Eskom Pension and Provident Fund
Description
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.
- 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 oncall support as needed.
2. 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 frontend users
- Map out the conceptual design for a planned database
- Consider both backend organisation of data and frontend accessibility for endusers
- 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
3. 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 backup and recovery plans
- Work closely with IT project managers, database and business analysts
- Manage the security and disaster recovery aspects of the database.
TECHNICAL COMPETENCY REQUIREMENTS
- 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 jobrelated 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.
More jobs from Eskom Pension and Provident Fund
-
IT Desktop Support
Bryanston, South Africa - 1 week ago
-
Private Markets Analyst
Bryanston, South Africa - 1 week ago
-
Junior Performance Analyst
Bryanston, South Africa - 1 week ago
-
Retirement Fund Consultant
Bryanston, South Africa - 1 week ago
-
Fund Administrator
Bryanston, South Africa - 1 week ago
-
Investment Risk Specialist and Quant Research
Bryanston, South Africa - 1 week ago