About the position
ENVIRONMENT:
PLAY a pivotal role in ensuring the efficient management, security, and optimisation of the SQL Server databases of a cutting-edge Tech company in Durban wanting you as its next Mid-Tier DBA. Your expertise in database management, SSAS, scripting, automation, performance tuning, and data security compliance is instrumental in maintaining a high-performing database environment. You will collaborate with cross-functional teams to meet data requirements and document best practices.
DUTIES:
Database Management –
- Manage and maintain the organisation’s SQL Server databases, ensuring high performance, availability, and security.
- Perform database upgrades, migrations, and patches as required.
- Monitor and optimise database performance, resolving any issues to ensure optimal performance of SSAS.
- Manage and co-ordinate scheduled jobs and related ETL processes to ensure on time daily completion.
- Ensure daily backups are scheduled and successful and be available to restore or support the backup process as required.
SSAS Expertise –
- Design, develop, and maintain SQL Server Analysis Services cubes and data models.
- Optimise SSAS queries and calculations for efficient and fast data retrieval.
- Troubleshoot and resolve issues related to SSAS cube processing and data refresh.
Scripting and Automation –
- Develop and maintain scripts for automating database administration tasks.
- Create and optimise T-SQL scripts for data manipulation, ETL processes, and reporting purposes.
Performance Tuning –
- Identify and resolve performance bottlenecks in SQL Server databases and SSAS cubes.
- Implement indexing strategies, query optimisation techniques, and caching mechanisms for improved performance.
Security and Compliance –
- Implement and maintain database security policies, access control, and data encryption.
- Ensure compliance with industry standards and regulations related to data security and privacy.
Desired Skills:
- Database Administration
- SQL
- Transact-SQL (T-SQL)
About The Employer:
A cutting-edge Tech company in Durban
