Rohloff Group
4 weeks ago
Database Administrator - Business Intelligence
Sign up to save this job, get alerts, and apply with an optimized CV.
Company information
- Company
- Rohloff Group
- Location
- South Africa South Africa
- Posted
- 4 weeks ago
Job description
Join Our Team as a Database Administrator at KFC Rohloff Group!
The Database Administrator (DBA) is responsible for supporting the Business Intelligence (BI) environment by maintaining reliable, secure, and high-performing database platforms that enable data warehouse operations, ETL processes, reporting datasets, dashboards, and operational analytics. The role provides hand-on operational support to ensure that database environments remain stable and available for successful ETL execution. Responsibilities include monitoring Microsoft SQL Server environments, supporting SQL Agent jobs, managing database security and access controls, performing backup and recovery validation, investigating database-related incidents, maintaining database objects required for ETL processing, and providing support for BI-related service requests and incidents.
What you'll Be Cooking1. Database Health Monitoring and Administration
- 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.
2. ETL and SQL Job Support
- 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.
3. Backup, Restore and Recovery Support
- 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.
4. Security and Access Administration
- 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.
5. Database Change and Deployment Support
- 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.
6. Documentation and Governance
- 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.
7. Operational Support and Continuous Improvement
- Provide support for BI-related service requests and incidents, including:
- Database access issues
- Failed SQL Agent jobs
- Data refresh failures
- 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.
8. Learning Areas
- 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.
- National Diploma, B-Tech Degree, Bachelor's degree, or equivalent qualification
- 2 years of relevant database administration, BI support, data management, or IT support experience.
- SQL fundamentals
- Relational database concepts
- Basic database troubleshooting
- Attention to detail
- Microsoft Excel
- Exposure to SSIS, SSRS, SSAS, or Power BI
- Competitive salary and bonuses.
- Comprehensive benefits.
- Collaborative, inclusive, and flexible work environment.
Required skills
- optimization
- attention to detail
- documentation
- governance
- reporting
- competitive salary
- access controls
- power bi
- etl
- audits
- troubleshooting
- automation
- continuous improvement
- performance monitoring
- cloud technologies
- collaborative work environment
- corrective actions
- sql server
- bachelor's degree
- permissions
- data warehouse
- analytics
- national diploma
- disaster recovery
- bonuses
- incident management
- performance tuning
- standard operating procedures
- incidents
- tables
- business intelligence
- microsoft excel
- azure sql
- flexible work environment
- execution plans
- standardisation
- bi
- performance analysis
- operational support
- azure data factory
- cloud data platforms
- database administrator
- dashboards
- sql server administration
- audit readiness
- ssis
- microsoft sql server
- ssrs
- business continuity
- microsoft fabric
- backup and recovery
- security standards
- logs
- comprehensive benefits
- dba
- etl developers
- user permissions
- query optimization
- indexing
- ssas
- security procedures
- stored procedures
- views
- change implementation
- database security
- backup verification
- change management processes
- organizational policies
- operational standards
- job failures
- inclusive work environment
- support operations
- service requests
- reporting support
- operational documentation
- audit standards
- database security practices
- load sequence
- support activities
- governance standards
- runbooks
- system health
- backup & recovery
- access reviews
- validation activities
- performance bottlenecks
- sql fundamentals
- root cause investigations
- restore testing
- database objects
- relational database concepts
- database scripts
- deployment support
- recovery testing
- post-deployment validation
- knowledge base content
- data quality validation
- report support
- database configurations
- kfc rohloff group
- sql agent jobs
- disk space management
- database growth
- database alerts
- scheduled processes
- data refresh dependencies
- source system availability
- locking issues
- job reruns
- escalation documentation
- backup schedules
- backup validation
- database maintenance plans
- database access requests
- permission changes
- orphaned accounts
- excessive permissions
- inactive users
- expired access
- database change
- deployment records
- version references
- implementation notes
- rollback documentation
- lower environment refreshes
- database access issues
- data refresh failures
- database performance concerns
- etl-related database issues
- bi platform environment
- security & access control
- etl & data warehousing
- warehouse concepts
- dataset refreshes
- bi platform operations
- support ticket handling
- b-tech degree
- basic database troubleshooting
Interested in this position?
Create your free account and tailor your CV to match this job.