Database Administrator

SUMMARY:
To ensure performance, integrity and security of the Funds database, involvement in the design, development and integrity of the database, as well as in data mining and day to day operation and maintenance of the database

POSITION INFO:

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.

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.