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)
Desired Skills:
- .Net
- Administration
- Database Administration
- Extract Transform Load (ETL)
- Microsoft SQL
- SQL
- SQL Server Integration Services (SSIS)
About The Employer:
Medium-Sized International Financial Services firm.