SQL Developer in SOUTH AFRICA

Job brief:

This role will run and maintain all databases and relevant information systems efficiently, allowing for the seamless flow of information throughout the organisation, considering the back-end data structure and frontend accessibility for end-users. They would need to advise on best practices within the database and data environments, ensuring that end users have accurate and timely data at their disposal.

The SQL Developer will play a critical role in the design of new web-based systems with database integration and troubleshooting existing database architecture.

This key role will also serve as a thought leader for technical discussions, assisting in the design and development of new systems by understanding the requirements of the business.

Inherent requirements of the position:

• Relevant degree or equivalent in database management (Bachelor’s degree in computer science, Information Technology, or equivalent combination of work experience and education)
• 6 – 10 years’ experience in a similar role
• In-depth knowledge of data backup, recovery, security, integrity, and SQL is critical
• In-depth knowledge of windows server is critical
• Knowledge of IIS would be an advantage
• In-depth understanding and grasp of relational database management systems (RDBMS), and XML database management systems
• A thorough understanding Microsoft Azure and cloud based technologies
• A thorough understanding of version control e.g. Git
• A thorough understanding of PowerShell and python scripting
• Proven work experience with database software and web applications
• Excellent problem-solving skills and recording troubleshooting issues
• Strong attention to detail and great level of accuracy
• Ability to cope in a highly pressurized environment
• Excellent communication skills, both written and verbal
• Good command of the English language
• Good understanding and related experience in database architecture and design
• Good Teamwork and collaboration ability
• Valid drivers’ licence and own reliable vehicle
• Experience in the Healthcare Industry beneficial

Duties and Responsibilities include but not limited to:

General Database administration: ensure that all Databases remain online in good health

o  Ensure best practices are followed appropriate to the environment

o Ensure the application of industry standard/best practice database security conforming to any applicable regulatory requirements

o  Apply required patches and software updates

o  Manage Backups and transaction log shipping as required

o  Database refresh as required in QA, DEV and reporting (MIS) environments

o  Manage Reporting Services on the MIS server

o  Perform and monitor migration of data between servers

Production support: manage incidents related to database servers and applications

o  Performance monitoring, optimisation, index creation and maintenance

o  Capacity monitoring and planning

o  Create SQL Agent tasks (Azure Runbooks) and automation as required

o  Monitor SQL Agent tasks (Azure Runbooks) and resolve and document any errors or issues

o  Design, write, and deploy SQL Server code as part of development cycles

o  Resolve general database server issues

o  Monitoring user access and unauthorised access attempts to systems

o  PowerShell and Python scripting in support of new and existing azure automation objects

Coding support / development

o  Assist in understanding the business requirements for system development and assist in writing specification documentation.

o  Provide T-SQL support to developers and write stored procedures to specification

o  Streamline resource intensive stored procedures

o  SSRS – design, create and deploy reports

o  SSIS – implement data transformation / ETL

o  Document all new features implemented, and bugs resolved

o  Use Git to keep track of all code changes.

Please take note of the following before submitting an application:

• Ensure that you meet all of the requirements of the position (educational, inherent requirements as well as required experience)
• Unless otherwise stated CareWorks will not pay relocation costs for candidates who wish to take up a position in another town or province

Please note:

• CareWorks reserves the right not to fill this vacancy and to withdraw the advertisement for this position at any stage during the recruitment process
• Due to high volumes of applications, only shortlisted candidates will be contacted
• We are committed to transformation. Meeting our employment equity goals will be taken into account in our recruitment decisions

Submit your application to jobs@careworks.co.za

• Your application must contain ALL of the following:
• A cover letter motivating your application
• Your salary expectation
• Submit your up-to-date CV all supporting documents and relevant certificates
• Closing Date: Monday, 13^th May 2024