Intermediate Sql Administrator - East Rand

Job Masters; Gauteng; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A local South African consulting company is seeking an Intermediate SQL Administrator based in Gauteng. The role involves managing SQL Server databases, ensuring performance tuning, and implementing disaster recovery solutions. Candidates should have extensive experience with SQL Server technologies and should be able to work collaboratively with IT teams. A competitive salary range of R45K to R60K is offered.

Qualifications

• 5-10 years of experience with Microsoft SQL Server.
• 3-5 years of experience with SQL Server Reporting Services (SSRS).
• Experience in delivering integrations (internal and external).

Responsibilities

• Oversee installation and maintenance of SQL Server instances.
• Monitor database performance and implement optimizations.
• Design and manage high availability solutions.
• Enforce database security policies and manage user access.
• Collaborate with IT teams to support application development.

Skills

SQL code creation

Process analysis

Database architecture

Performance tuning

Disaster recovery

BI development

Education

Grade 12 BSc Computer Science or equivalent

Tools

Microsoft SQL Server 2019

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Power BI

Job description

Overview

Intermediate SQL Administrator East Rand

The Intermediate to Senior SQL Database Administrator (DBA) is a key technical role responsible for the management, maintenance, and optimization of SQL Server databases. This position requires advanced expertise in database architecture, performance tuning, security, and disaster recovery.

Minimum Requirements

• Grade 12 BSc Computer Science or equivalent qualification (advantageous)
• Proven SQL code creation experience
• Proven process analysis experience
• Systems understanding and test experience

Knowledge

• Knowledge of BI development
• Experience in SQL / BI solution design and development
• Familiarity with integration protocols
• Experience in delivering integrations (internal and external)
• Understanding of business operations and processes

Product Experience

• Microsoft SQL Server 2012, 2019, 2022: 5-10 years
• SQL Server Reporting Services (SSRS): 3-5 years
• SQL Server Integration Services (SSIS): 3-5 years
• SQL Server Analysis Services (SSAS Tabular): Beneficial
• Microsoft Power BI (On-premises / Premium): Beneficial

Key Responsibilities

• Database Administration and Maintenance: Oversee installation, configuration, and ongoing maintenance of SQL Server instances. Apply patching, updates, and conduct regular health checks.
• Performance Tuning and Optimization: Monitor database performance and identify bottlenecks. Implement solutions such as index optimization, query tuning, and capacity planning.
• High Availability and Disaster Recovery: Design, implement, and manage high availability solutions (AlwaysOn, replication, log shipping). Conduct backups, restores, and recovery plan testing.
• Security and Compliance: Enforce database security policies and manage user access and permissions. Ensure compliance with relevant data security standards and regulations.
• Collaboration and Support: Work closely with development, infrastructure, and IT teams. Support application development, data integration, and system upgrades.
• Troubleshooting and Issue Resolution: Proactively identify and resolve database-related incidents. Maintain performance within agreed SLAs.
• Mentorship and Guidance: Provide technical guidance to junior DBAs and team members.
• Strategic Planning: Contribute to database architecture strategies. Align database management practices with business objectives and technology roadmaps.

Salary offer: R45K R60K