Snr Specialist: SQL Database Administrator - at Liberty Group South Africa

Purpose

• As a Snr Specialist: IT Systems Support SQL Database administrator you will scrutinise information using data analysis tools.

Key Responsibilities

• Organize, manage data and keeping databases up to date.
• Troubleshooting SQL server, SSIS and SSRS and supporting applications.
• Ensuring application stability and availability through defined SLAs.
• Helping with database design and development.
• Managing database access.
• Designing maintenance procedures and putting them into operation.
• Liaising with programmers, applications/operational staff, it project managers and other technical staff.
• Managing database security/integrity and backup & restore standards and procedures.
• Implementing and maintaining security measures.

Additional Key Responsibilities

• Defining objectives through consultation with staff at all levels.
• Writing reports, documentation and operating manuals.
• Testing and modifying databases to ensure that they operate reliably.
• Providing user training, support and feedback.
• Writing disaster recovery plans.
• Archiving of data according to business requirements.
• Providing technical expertise on data storage structures, data mining, and data cleansing.
• Ensure proper controls are in place to meet Audit requirements.
• Maintain ongoing monitoring on all SQL environments to optimize for best performance.

Minimum Experience

• 3 - 5 years experience in a similar environment, of which 1 -2 years at a junior specialist level
• Cloud : Knowledge and experience with Azure SQL and/or setting up and configuring SQL clusters on AWS through RDS or similar.
• In-depth knowledge and understanding of Microsoft SQL Server.
• In-depth knowledge and understanding of Microsoft SSRS.
• Excellent understanding of how to install and configure SQL applications to best practices and standards.
• In-depth knowledge of Always-On Availability (AAG) , setup and configurations.
• High-Availability understanding, configuration and implementation.
• Excellent knowledge of CDC and log harvesting to support data replication tools.

Minimum Qualifications

• Bachelor`s Degrees and Advanced Diplomas [NQF Level 07] in Information Technology and Computer Sciences.
• Skilled in Agile methodology, Preferred - SAFe for Teams (SFT)Preferred - AWS/ MS Azure Foundation.