SQL Database and Windows Specialist

SQL Database and Windows Specialist 5 Month Contract

Minimum Requirements:

• Matric (Grade 12)
• Bachelors degree in computer science Information Security or a related field.
• 3 5 years experience in SQL DBA and Windows Server medium to enterprise organisations.
• Indepth knowledge of SQL and database management systems.
• Knowledge of Active Directory and group policies.
• Proficiency in database design and normalisation.
• Experience with database performance tuning and optimisation.
• Managing backup and recovery strategies.
• Strong knowledge of database security practices.
• Knowledge of high availability and disaster recovery solutions.
• Strong problemsolving and troubleshooting skills.
• Good communication skills to work with various other stakeholders and ICT teams.
• Relevant certifications (e.g. Microsoft Certified: Azure Database Administrator Certified Professional) can be advantageous.
• Proficiency in Windows server operating systems.
• Familiarity with networking concepts and configurations.
• Experience in system security and access controls.
• Strong troubleshooting and problemsolving skills.
• Scripting and automation skills (PowerShell batch scripting etc.).
• Understanding of virtualization technologies.
• Good communication skills for collaborating with other IT teams and stakeholders.
• Knowledge and skills in PowerBI data management and analytics can be advantageous.

Responsibilities:

• Active Directory: Manage and maintain Active Directory services including domain controllers and group policies.
• Server and Database Management: Install configure upgrade and maintain Windows server and database software (such as Microsoft SQL Server MySQL).
• Monitoring and Performance: Monitor and optimise database performance by analysing query performance indexing and system resource utilisation. Monitor system performance resource utilisation and troubleshoot issues.
• Backup and Recovery: Implement backup and recovery strategies to ensure data integrity and availability in case of failures or disasters.
• Security (User access management): Manage database security by setting up user access permissions and encryption mechanisms to protect sensitive data. Implement security measures including firewalls antivirus software and user access controls.
• Troubleshooting: Identify and resolve issues related to database connectivity performance and data integrity.
• Capacity Planning: Estimate future database growth and plan for hardware and storage requirements.
• High Availability: Set up and manage high availability solutions such as clustering replication or mirroring to minimise downtime.
• Database Design: Collaborate with application developers to design and optimise database schemas.
• Patch Management: Apply patches updates and security fixes to the database and Windows systems.
• Report writing and dashboard design per business unit requirements.