Database Administrator
- Johannesburg, Gauteng
- Permanent
- Full-time
Key Responsibilities:1. Database Design and Management:· Design, create, and maintain databases to meet the organizations requirements.
· Ensure data integrity and efficient data structures.
· Establish and manage data factory pipelines to support Power BI reporting needs.2. Database Performance Tuning and Optimisation:· Monitor and enhance database performance through query optimization and
indexing.
· Implement best practices for optimizing database performance.3. Data Backup and Recovery:· Set up and manage backup and recovery processes to safeguard data integrity.4. Security and Access Control:· Enforce security protocols to protect sensitive data.
· Manage user access permissions and roles.5. Database Software Installation and Configuration:· Install, configure, and upgrade database software as required.6. Monitoring and Troubleshooting Database Issues:· Proactively monitor database systems for issues and troubleshoot as needed.
· Implement solutions to prevent recurrence of problems.7. Collaborating with Developers and BI Developers:· Work closely with application developers and business intelligence developers to ensure seamless integration with the database systems.8. Database Documentation:· Maintain comprehensive documentation of database schemas, configurations, and processes.Qualifications and Skills:· Bachelors degree in computer science or a related field. (advantageous)
· Minimum of 2-3 years of experience as a Database Administrator.
· Relevant certifications, such as Microsoft Certified: Azure Database Administrator. (advantageous)
· In-depth knowledge of specific database management systems, particularly SQL Server.
· Proficiency in SQL and expertise in database query optimization.
· Familiarity with best practices for database security.
· Strong problem-solving and troubleshooting skills.
· Effective communication and teamwork abilities.