Job Summary
A Database Administrator (DBA) is responsible for managing and maintaining an organization’s databases, ensuring that they are secure, accessible, and performing optimally.
Job Description
Database Administrator Job Description
A Database Administrator (DBA) is responsible for managing and maintaining an organization’s databases, ensuring that they are secure, accessible, and performing optimally. Their duties may include:
Database Management:
- Monitor database performance, conduct regular performance tuning, and optimize queries for maximum efficiency.
- Install, configure, and upgrade database software and related tools.
- Develop and implement database backup and recovery strategies to ensure data reliability and minimize downtime.
- Perform routine maintenance tasks, such as database backups, index rebuilding, and statistics gathering.
- Manage and optimize databases to ensure availability and reliability.
Data Security and Compliance:
- Secure access to databases and manage backup solutions to prevent data loss in the event of system failure.
- Ensure compliance with data privacy regulations and handle sensitive data ethically.
Infrastructure Enhancement:
- Design, implement, and monitor database systems.
- Ensure the ETL process run smoothly and data are properly loaded.
- Troubleshoot and resolve any issues related to database performance or functionality.
Collaboration:
- Work closely with development teams, system administrators, and other stakeholders to ensure seamless database operations.
- Help to optimize queries of other individuals for report purposes.
- Automate report requirements.
- Report/Plan the data infrastructure requirements.
- Monitor the health of the database and other MIS tools.
- Support other duties assigned by the supervisor.
Skills and Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proficiency in database management systems (e.g., PostgreSQL, Oracle, MySQL, SQL Server).
- Capable in automation of database tasks/scripts in various technologies.
- Strong problem-solving skills and attention to detail.
- Knowledge of data security best practices.
- Excellent communication and teamwork abilities.
- Knowledge of programming is an added advantage.
Education
- National Certificate: Information Technology