Preferred skills The following is an indication of the preferred skills of the SQL Database Administrator.
- Relevant Qualification / National Diploma in Information Technology/Computer science (NQF 6/7).
- Minimum 5 years experience in SQL Database Administration.
- Preferably 1 year supervisory or specialist DBA related experience.
- A successful track record of supporting and managing SQL Server and associated databases, including High Availability.
- Experience supporting and working with cross-functional teams in a dynamic environment.
- Advantageous certification: SQL Server related certification.
Administration - Develop and maintain technical and implementation plans.
- Update technical documentation on a regular basis to ensure it is current and up to date.
- Maintain technical configurations in accordance with related policies and procedures.
- Ensure all database change and release management tasks are completed in accordance with the policies and procedures.
- Contribute and manage database related
- changes through its lifecycle.
- Contribute to the knowledge base for database administration staff.
- Create end-user-friendly documentation that adheres to standard operating procedures
- (SOP) and best practices.
- Create and maintain high-level activity plans with scheduling timelines for project tasks and activities.
- Participate in planning sessions to gather and develop database requirements.
- Participate in business and technical discussions related to database solutions.
- Formulate reports of project technical activities.
- Ensure that all pertinent documentation is kept up to date.
- Database Security
- Manage database security, including user access control, data encryption, and implementing security policies to protect the database from unauthorized access and data breaches.
- Identify, report, and manage database security issues, audit trails, and forensics.
Database High Availability, Backup and Recovery - Configure and manage high availability solutions like SQL Server Always-On Availability
Group, ensuring database availability and data protection in the event of failures. - Develop and implement backup and recovery plans to ensure that data is protected and
can be restored in the event of a failure or disaster. Ensure database backup/restore
strategy meets the businesss Recovery Point Objectives (RPO) and Recovery Time
Objectives (RTO). - Regularly schedule, monitor, and report on full and incremental backups.
- Conduct the backup and recovery test procedures periodically.
Performance Monitoring and Tuning - Monitor database performance, identify bottlenecks, optimize, and enhance database performance through query optimization, index tuning, and other techniques.
- Refine and automate regular repeatable, mundane database tasks.
- Define and implement event triggers that will alert on potential database performance.