Intermediate DBA - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 07-11-2021 1:38:16 PM
02-01-2022 1:38:16 PM
he core of th company is data…BIG data. The DBA team focuses on ensuring our many Microsoft SQL Server environments remain optimally configured, responsive and highly available. We verify the integrity of the data being stored and ensure data is in the right location to facilitate the effective operation of the applications built on top of it.

We push the boundaries of what is possible from tools like SQL Replication, and we leverage availability options like SQL Always On to ensure we can recover from any type of failure, including complete loss of storage. We have also recently started working with a NoSQL based solution, and have focused our skills on MongoDB, with dedicated specialists working on it.
Purpose:
We are looking for a dynamic highly skilled candidate to join our Database Administrator team who is passionate about data. Our team looks after a large geographically distributed Microsoft SQL Environment that utilizes many of the latest SQL functionality, and constantly seeks to leverage new features as they become available to enhance performance and reduce latency between our systems. Our business is fast paced and requires data that is real time, accurate and responsive. To accomplish this, the team works closely with our Development and Business Intelligence departments to not only provide data, but supply input into best practices to ensure we meet the business expectations. Come join our team and advance your SQL skills to new heights.
Duties will include, but not limited to:
Administer Microsoft SQL Server database environments
T-SQL Scripting and development on both new and existing functions
Troubleshoot and resolve server, database and data issues
Security maintenance of server and database
Maintenance and monitoring of SQL environment
Provide debugging assistance to development staff with DBMS
Monitoring and completion of all DBA related Servicedesk calls
Backup setup and monitoring
Participates in providing 7-day/24 hour on-call support.
Essential Requirements:
5 + years’ experience in SQL database administration
Relevant SQL certification / degree / diploma would be advantageous
Microsoft SQL Server 2008 / 2012 / 2014 / 2016/ 2017 /2019 experience with database administration, including installation and troubleshooting issues
Install and configure Reporting services, Power BI, SSIS and Cubes
T-SQL Scripting experience
Database Security
Have in depth SQL internal knowledge
Backup and recovery experience
Performance tuning on SQL
Windows Server and Windows firewall knowledge to support SQL server environment
Always on Experience would be advantageous
Failover clustering Experience would be advantageous
Advantageous Requirements:
Replication experience
Partitioning Experience
SSIS experience advantageous
Support machine learning on SQL to run Python and R on relational databases
Microsoft Azure SQL Database knowledge and exposure
Service Broker exposure will be advantageous
Exposure to Kafka/K SQL will be advantageous
Personal Competencies:
Accountability and Execution
Innovation
Self-Awareness
Planning & Organising
Interpersonal Skills
Problem Solving
Time Management
Technical Knowledge
Stress Tolerance