Database Administrator

A leader in the financial services industry is on the lookout for a Database Administrator to join them in Cape Town.

Responsibilities:

• Implement appropriate designs for databases, data warehouses, marts, reports, and dashboards


• Specify database infrastructure requirements


• Design and implement database solutions for high performance and high availability using Microsoft SQL Always On.


• Responsible for planning and implementing database replication


• Perform query and database optimisation


• Be responsible for database maintenance


• Work with development teams to identify databases for decommissioning


• Monitoring database user access and security


• Writing database documentation, including data standards, procedures, and definitions


• Developing, managing, and testing disaster recovery processes and servers as well backup and recovery plans


• Keep abreast of new database technologies

Requirements:

• 5 years’ experience as a database administrator


• ICT-relevant diploma or degree from a recognised tertiary institution


• Relevant technical certifications


• Cloud database experience


• Able to consult on data architecture and assess the impact of project changes to data architecture


• Experience working with SQL Server 2016 and 2019 as a database administrator


• Design and development of MS SQL Server databases (DB design, optimization, tuning, ETL, stored procedures, triggers, and views)


• MCDBA certification advantageous


• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) beneficial


• Must have Microsoft SQL Always On practical experience

We cant wait to hear from you!