SQL Database and Windows Specialist

About the job 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.
• In-depth 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 problem-solving 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 problem-solving skills.
• Scripting and automation skills (Power Shell, batch scripting, etc.).
• Understanding of virtualization technologies.
• Good communication skills for collaborating with other IT teams and stakeholders.
• Knowledge and skills in Power
  
  BI, 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.