Database Administration

Perform Installation, coordination and upgrading of databases and database servers, performance monitoring and troubleshooting. This includes monitoring user access to database and optimisation of database performance, planning for backup and recovery, archived data maintenance and reporting

Type

Domain

Competency Area

Operations and User Support

Levels

Conduct basic installation, configuration and upgrade of databases and servers

Conduct basic installation, configuration and upgrade of databases and servers according to standard guidelines and methodologies

Perform simple maintenance as well as data storage, updates and extraction, using appropriate database management system software and tools

Grant user access to database based on the appropriate levels of access given to users

Utilise basic system software and tools to track and consolidate performance statistics of databases

Perform routine data backup and recovery activities

Document upcoming and completed data back- ups and archiving activities

Monitor and maintain databases, and troubleshoot database errors faced

Perform installation, configuration and upgrading of large or complex databases and data servers as required

Maintain databases, in ensuring that data is updated, stored and extracted accurately and according to set protocols

Troubleshoot database errors or problems faced in database administration activities

Monitor user access to databases to ensure that users have the appropriate levels of access based on security clearance, organisational guidelines and business needs

Analyse performance statistics and highlight potential areas of improvements to the database

Conduct data backup and recovery activities for internal or external customers, based on the business requirement

Implement regular data maintenance or archiving to inform relevant stakeholders

Plan for installation, configuration and upgrading of databases and oversee troubleshooting

Assess the business need and plan for installation, configuration and upgrading of databases

Determine appropriate database management tools and system software to be used, in ensuring they are fit for organisational purposes

Manage database maintenance, monitoring and troubleshooting to resolve complex or unforeseen problems

Develop a user access roadmap in collaboration with other key stakeholders, assigning appropriate levels of database access based on the role of users, data security and privacy policies

Evaluate database performance statistics and user feedback, and recommend ways to optimise database performance in line with business requirements and cost considerations

Develop an action plan for data backup and recovery procedures, archived data maintenance and reporting for a range of databases, in ensuring appropriate levels of frequency, storage capacity and system availability.

Establish strategy and guidelines for database management and administration and optimise IT investments

Develop organisational standards and guidelines for the installation, configuration and upgrading of databases, in line with business requirements

Establish strategy and plan processes for maintenance, monitoring and troubleshooting of databases

Review database user access roadmap in line with the privacy and security policies of the organisation

Review recommendations and direct data-related processes, resources and IT investments to optimise database performance, based on business needs and industry best practices

Establish an organisation-wide strategy for data backup and recovery, archived data maintenance and reporting procedures for databases, balancing business demands with financial and operational costs.