Senior SQL Database Administrator

Xcede Group; Cape Town; On-site; ZAR 650,000 - 950,000; Full time

Job summary

Xcede Group, a leading data and technology consultancy in South Africa, is seeking a Senior SQL DBA to join their team within the financial services sector. The role focuses on managing SQL database systems, ensuring reliability, performance, and security while leveraging MsSQL, SSIS, SSRS, SSAS, and general DBMS expertise.

You will design robust backup and recovery strategies, optimize queries and indexes, and work with cross-functional teams to translate business requirements into scalable

Qualifications

• Bachelor’s degree or diploma in CS/IS or related field.
• Experience as a SQL Database Administrator with MsSQL, SSIS, SSRS and SSAS.
• Strong knowledge of database architecture, performance tuning and optimization.
• Proficient in writing complex SQL queries, stored procedures and functions.
• Experience with backup and recovery strategies.
• Familiarity with database security and access controls.

Responsibilities

• Manage and maintain SQL database systems with high availability, performance and security.
• Monitor performance and proactively identify and resolve issues.
• Design and implement backup and recovery strategies for critical data.
• Collaborate with cross-functional teams to translate business requirements into database solutions.
• Develop and optimize SQL queries, stored procedures and functions for apps and reporting.
• Perform database tuning, index optimization and query optimization for perf improvements.
• Implement and manage database security measures to protect data.
• Stay updated on SQL database trends and recommend process improvements.

Skills

MsSQL

SSIS

SSRS

SSAS

DBMS

Education

National Diploma or Bachelor's degree in Computer Science/Information Systems

Job description

Senior SQL DBA

One of our clients is seeking a highly experienced and skilled Senior SQL DBA to join their dynamic team within the financial services industry. As a Senior SQL DBA, you will play a crucial role in managing our database systems, ensuring their reliability, performance, and security. Your expertise in MsSQL, SSIS, SSRS, SSAS, and DBMS will be instrumental in maintaining and optimizing our data infrastructure.

Responsibilities:

1. Manage and maintain our SQL database systems, ensuring high availability, performance, and security.
2. Monitor database performance and proactively identify and resolve any issues.
3. Design and implement effective backup and recovery strategies to safeguard critical data.
4. Collaborate with cross-functional teams to analyze and translate business requirements into database solutions.
5. Develop and optimize SQL queries, stored procedures, and functions to support application development and reporting needs.
6. Perform database tuning, index optimization, and query optimization to enhance system performance.
7. Implement and manage database security measures to protect sensitive data.
8. Stay up to date with the latest industry trends and technologies related to SQL databases and provide recommendations for process improvements.

Requirements:

1. National Diploma or Bachelor's degree in Computer Science, Information Systems, or a related field.
2. Proven experience as a SQL Database Administrator, specifically with MsSQL, SSIS, SSRS, SSAS, and DBMS.
3. Strong understanding of database architecture, performance tuning, and optimization techniques.
4. Proficiency in writing complex SQL queries, stored procedures, and functions.
5. Experience with database backup and recovery strategies.
6. Familiarity with database security and access controls.
7. Excellent problem-solving and troubleshooting skills.
8. Strong communication and collaboration abilities to work effectively with cross-functional teams.
9. Prior experience within the financial services industry is a plus.

If you are a highly skilled and motivated SQL DBA seeking a challenging opportunity within the financial services industry, we would love to hear from you. Join this team and make a significant impact on their database systems, contributing to the success of their organization.