Job title: SQL Database Administrator
Company: SET Consulting
Job description: SQL Database AdministratorR360k per annumCape TownA 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)
Expected salary: R360000 per year
Location: Cape Town, Western Cape
Job date: Fri, 22 Mar 2024 07:15:44 GMT
Apply for the job now!