BI Data Platform DBA - SQL, ETL & Analytics

Rohloff Group; Cape Town; On-site; ZAR 420,000 - 560,000; Full time

Benefits offered by this job

Competitive salary

Bonuses

Job summary

Rohloff Group in Somerset West, South Africa, is seeking a Database Administrator (DBA) to support the BI environment, ensuring reliable, secure and high-performing database platforms for data warehouse, ETL, and reporting workloads.

The role focuses on monitoring SQL Server environments, ETL/SQL Agent job support, backup validation, security administration, and deployment governance to enable stable BI services and analytics across the organisation.

Qualifications

• 2 years of relevant database administration, BI support, data management, or IT support experience.

Responsibilities

• Monitor SQL Server availability, performance, disk space utilisation, database growth, and system health indicators.
• Track and investigate failed jobs, performance bottlenecks, and database alerts.
• Perform routine database administration activities to maintain stable and reliable environments.
• Escalate risks, recurring issues, and service-impacting incidents with clear impact assessments and supporting evidence.
• Maintain and complete daily, weekly, and monthly database health checks and monitoring activities.
• Support ETL Developers by monitoring SQL Agent jobs, SSIS executions, scheduled processes, and data refresh dependencies.
• Investigate first-line ETL and database job failures by reviewing logs, source system availability, permissions, locking issues, and load sequence dependencies.
• Assist with job reruns, validation activities, incident management, and escalation documentation.
• Support the preparation and maintenance of database objects required by ETL processes, including tables, views, and stored procedures.
• Perform routine verification of database backups and ensure successful completion according to agreed backup schedules.
• Assist with restore testing and disaster recovery validation activities under supervision.
• Maintain evidence and documentation of backup validation and recovery testing.
• Monitor database maintenance plans and highlight failed or missed maintenance activities.
• Process database access requests and permission changes in accordance with approved security procedures.
• Support periodic access reviews and audits.
• Ensure all access changes are accurately documented and approved.
• Identify and report orphaned accounts, excessive permissions, inactive users, and expired access requirements.
• Promote sound database security practices and compliance with organisational policies.
• Assist with the deployment of database scripts, stored procedures, views, and other database objects following change management processes.
• Maintain deployment records, version references, implementation notes, and rollback documentation.
• Support lower-environment refreshes, testing activities, and post-deployment validation checks.
• Participate in change implementation activities under guidance from senior team members.
• Maintain accurate database administration, support, and operational documentation.
• Ensure database configurations, procedures, environments, and support activities are appropriately documented.
• Support adherence to governance, audit, security, and operational standards.
• Contribute to the development and maintenance of standard operating procedures and knowledge base content.
• Provide support for BI-related service requests and incidents, including: Database access issues, Failed SQL Agent jobs, Database performance concerns, ETL-related database issues.
• Assist with root cause investigations and corrective actions.
• Identify recurring manual activities and opportunities for automation, optimisation, and standardisation.
• Contribute to continuous improvement initiatives within the BI and data platform environment.
• SQL Server Administration – Database management, maintenance, SQL Agent jobs, and troubleshooting.
• Backup & Recovery – Backup monitoring, restore testing, disaster recovery, and business continuity.
• Database Monitoring – Performance monitoring, disk space management, job failure analysis, and health checks.
• Performance Tuning – Query optimization, indexing, execution plans, and database performance analysis.
• Security & Access Control – User permissions, database security, governance, and audit readiness.
• ETL & Data Warehousing – SSIS, ETL support, data quality validation, and warehouse concepts.
• Power BI & Reporting Support – Dataset refreshes, report support, and BI platform operations.
• Microsoft Fabric & Cloud Technologies – Fabric, Azure SQL, Azure Data Factory, and cloud data platforms.
• Documentation & Support Operations – Runbooks, incident management, root cause analysis, and support ticket handling.

Skills

Relational databases

SQL Server administration

ETL monitoring

Power BI / Reporting

Troubleshooting

Data governance basics

Education

National Diploma

Bachelor's degree

Tools

SSIS

SSRS

SSAS

Power BI

Excel

Job description

Rohloff Group in Somerset West, South Africa, is seeking a Database Administrator (DBA) to support the BI environment, ensuring reliable, secure and high-performing database platforms for data warehouse, ETL, and reporting workloads.

The role focuses on monitoring SQL Server environments, ETL/SQL Agent job support, backup validation, security administration, and deployment governance to enable stable BI services and analytics across the organisation.