Job Description

BASIC JOB DESCRIPTION
Install, upgrade, and manage database

• 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.

REQUIRED MINIMUM WORK EXPERIENCE AND QUALIFICATIONS

• Relevant Diploma in computer science, computer software/computer systems engineering or related discipline.
• Database Administration certification (advantageous)
• 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
• 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

JobPlacements.com