SQL Database Administrator

R360k per annum

Cape Town

A Medium-Sized International Financial Services firm specialising in wealth management solutions is looking for a SQL Database Administrator to report to the IT Operations Manager in their Cape Town Operations department.

Key Performance Areas

Maintaining high levels of performance, availability, sustainability and security
Maintaining data quality as well as server and database security as per the user privileges set by the business units
Analysing, solving and correcting any database issues in real time
Performing scheduled maintenance and support release deployment activities
Creating database backup and recovery plans and procedures
Handling data extraction, transformation and loading
Writing optimised SQL queries for integration with other applications
Modifying existing code, adapting it to new hardware or upgrading interfaces and improving performance
Assisting developers with query tuning and schema refinement
Designing database tables with efficient structures
Consulting with staff to evaluate interface, develop specifications and performance requirements and resolve any bugs
Understanding issues related to network performance and security
Refining and automating regular processes
Performing scheduled troubleshooting
Providing ad hoc support to the business units or end users

Qualifications and Experience

4 - 5 years in the day-to-day database administration activities for operational databases and database administration of Microsoft SQL Server 2014 onwards
Hands-on experience supporting .NET (C#, VB, ASP) and VBA applications
High level of competency with data extraction, transformation and loading (ETL) disciplines and tools (SSIS) and SQL Server reporting services (SSRS)
Experience creating and deploying SSIS Packages using SSDT
Experience defining database server security, user creation, roles and permissions
Have experience in maintaining and creating stored procedures, functions and triggers to facilitate applications with data-driven dependencies
Microsoft Certification (Advantageous)