Database Administrator - Business Intelligence

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 hands-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.

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

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