SQL Database and Windows Specialist

Boardroom Appointments; Johannesburg; On-site; ZAR 600,000 - 1,000,000; Part time

Job summary

Boardroom Appointments seeks a SQL Database and Windows Specialist for a 5-month contract in Johannesburg, South Africa. You will manage Active Directory, SQL Server and Windows Server environments, optimize performance, implement backups, and ensure security and compliance across the data stack.

You should have a Bachelors degree in computer science or related field, 3–5 years of SQL DBA and Windows experience, and strong problem-solving, communication, and collaboration skills with ICT teams.

Qualifications

• Required: Bachelor's degree in CS or related field and 3–5 years SQL DBA/Windows Server experience.
• Strong knowledge of SQL and database management, AD and group policies.
• Experience with backup, recovery, security, and high availability strategies.

Responsibilities

• Active Directory: manage domain controllers and group policies.
• Server and Database Management: install/configure/maintain Windows Server and databases (MS SQL Server, MySQL).
• Monitor and optimise database performance and resource utilisation.
• Implement backup and recovery strategies for data integrity.
• Ensure database security, user access, encryption, and access controls.
• Troubleshoot connectivity, performance, and data integrity issues.
• Capacity planning for growth and hardware/storage needs.
• Set up high availability solutions (clustering, replication, mirroring).
• Collaborate with developers on database design and schema optimization.
• Apply patches and security fixes; manage patching cycles.
• Prepare reports and dashboards per business needs.

Skills

SQL DBA

Windows Server

Active Directory

PowerShell

Scripting

Networking concepts

Data management

PowerBI

Education

Bachelor's degree in CS or Information Security

Matric (Grade 12)

Tools

Microsoft SQL Server

MySQL

Job description

About the job SQL Database and Windows Specialist

SQL Database and Windows Specialist - 5 MonthContract

MinimumRequirements:

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