Durban: Database Administrator – Mid Tier posted by K2 Recruit

As a Mid-Tier Database Administrator, you play a pivotal role in ensuring the efficient management, security, and optimisation of the organisations SQL Server database environments. Your expertise in database management, SQL Server Analysis Services (SSAS), scripting, automation, performance tuning, and data security compliance is critical to maintaining a stable, high-performing data platform.

You will collaborate closely with cross-functional teams to meet business data requirements, ensure operational excellence, and document best practices. Your in-depth knowledge and hands-on experience in database engineering contribute directly to the organisations reliability, scalability, and data-driven decision-making capabilities.

Key Deliverables

Database Management

Manage and maintain SQL Server databases, ensuring high performance, availability, and security.

Perform database upgrades, migrations, and patching as required.

Monitor and optimise database performance, resolving issues to ensure optimal SSAS performance.

Manage and coordinate scheduled jobs and related ETL processes to ensure on-time daily completion.

Ensure daily backups are scheduled and completed successfully, and provide restore support when required.

SSAS Expertise

Design, develop, and maintain SQL Server Analysis Services (SSAS) cubes and data models.

Optimise SSAS queries and calculations to ensure efficient and fast data retrieval.

Troubleshoot and resolve issues related to SSAS cube processing and data refresh cycles.

Scripting and Automation

Develop and maintain scripts to automate routine database administration tasks.

Create, maintain, and optimise T-SQL scripts for data manipulation, ETL processes, and reporting.

Performance Tuning

Identify and resolve performance bottlenecks across SQL Server databases and SSAS cubes.

Implement effective indexing strategies, query optimisation techniques, and caching mechanisms to improve system performance.

Security and Compliance

Implement and maintain database security policies, access controls, and data encryption standards.

Ensure compliance with relevant industry standards and regulations related to data security and data privacy.

Qualifications & Experience

o Bachelors degree in Computer Science, Information Systems, or related field (preferred).

o 35 years experience in a database administration role.

o Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional, or similar certifications preferred.

o Experience in both on-premises and cloud database environments is advantageous.