Purpose of the role
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
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.
Desired Skills:
- Agile
- CUSTOMER CENTRIC
- EXECUTES WITH EXCELLENCE
- SELF MASTERY
- Leadership
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Diploma