Database Administrator (7 Months Contract)

SUMMARY:
We are recruiting for a Database Administrator. (7 Months Contract)

POSITION INFO:
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.

• 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.

• 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 business’s 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.

• 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.