- Design, install, configure and maintain database systems, including monitoring, tuning and troubleshooting issues.
- Provide a seamless flow of information by keeping the database running smoothly.
- Ensure data security and integrity, including implementation of access controls, backups and recovery plans.
- Develop and maintain database documentation, including data standards, procedures and definitions for data elements and tables in the company.
- Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
- Optimise database performance and efficiency by evaluating and recommending new database technologies.
- Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
- Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.
- Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
- Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
x
