SQL Database Administrator
SET Recruitment Consultants
- R30,000 per month
- Permanent Junior position
-
Cape Town
- Posted 16 Apr 2024 by SET Recruitment Consultants
-
Job 2561432
About the position
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.
SET Recruitment Consultants
About the agency
SET Recruitment Consultants, established in 2003, is a specialist agency focused on placing Financial, Accounting and IT professionals within five niche sectors:
Financial services
Professional services
Commerce
IT
The public sector
We have worked extensively in the 'big four' audit space; commerce and industry; and with South Africa’s major banks over the past decade. We are well-positioned to partner with clients and candidates operating and working in these markets.
SET is a future-forward company firmly rooted in SA with more than 85 years’ cumulative local and international industry experience.
We are a Platinum Supplier on the career management portal, CareerSuite offered by the South African Institute of Chartered Accountants (SAICA). Through this relationship we have access to around 34,500 CA(SA) members that are already active in the employment market.
SET is headquartered in Johannesburg, with offices in Cape Town and places professionals nationally and throughout Africa.
Receive a daily digest of all new jobs matching this job. Your information is safe with us and you can cancel any time.
EMAIL ME JOBS LIKE THIS
Job expired on 2024/04/23
Email me jobs similar to: SQL Database Administrator
Receive a daily digest of all new jobs matching this job: Senior IT Auditor. Your information is safe with us and you can cancel at any time.
