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 SecurityManage 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 RecoveryConfigure 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.
