Job Purpose
Support and maintain database systems and identify potential risk to data and integrity not only on database level but also Infrastructure level. The role is responsible for planning, developing, installing, configuring, supporting, and optimising all database related systems. The role is core to executing strategy and will involve working closely with IT functional and technical areas, process owners, business and vendors. The role is operational in nature with elements of operational support, execution and design.
Responsibilities
Act as subject matter expert in an area of expertise. Maintain external accreditation's and in-depth understanding of current and emerging external regulation and industry best practices through continuing professional development, attending conferences, and reading specialist media.
Analyze specific problems and issues to find the best solutions. Solutions could be technical or professional in nature.
Work with internal GIT departments to scrutinize and provide guidance for required solutions.
Understand 3rd party solutions which makes use of SQL databases.
Interact with service providers to understand new possible technologies which can replace current solutions where deem fit.
Approve database specifications, ensuring all agreed standards and protocols are followed and data integrity is preserved.
Create standards and best practices for database systems environment.
Assist management in identifying the team's individual development needs. Plan and implement actions to build their capabilities. Provide training or coaching to others throughout the organization in own area of expertise to enable others to improve performance and fulfill personal potential.
Create and maintain technical and/or user documentation to a high standard and back up files to ensure instant recovery if problems occur.
Design distribution of complex database resources and provide physical modeling and design services to tune database applications for optimum performance.
Maintain software and hardware requirements to ensure efficient operation of the database environment.
Ensure database environment is operating at optimal efficiency.
Ensure business continuity through the use of disaster recovery and high availability solutions.
Ensure maintenance tasks and / jobs are created and run successfully.
To identify SQL Infrastructure bottlenecks (Server/Storage/Application) constraints and provide possible solutions.
Fit for purpose Infrastructure with the relevant configurations – Active/Active versus Active/Passive.
Strive for 100% availability of the SQL Infrastructure and database access.
Have a full overview of the SQL landscape and based on the IT strategy, identify constraints and risks which needs to be addressed.
Identify shortcomings and suggest improvements to existing processes, systems and procedures, then delivers a plan for a small element of a change management program with guidance from a project/program manager.
Implement all aspects of data architecture, turning event analytics, raw application data, and business systems into key business insights.
Review and maintain architectural designs and concepts.
Install and test the most complex databases and associated products to ensure they are suitable for use and meet customer requirements.
Lead in detecting and analyzing security incidents including attacks, breaches, and identified vulnerabilities and remediate any security gaps in line with the security incident management procedure.
Monitor and review performance and behaviors within area of responsibility to identify and resolve non-compliance with the organization's policies and relevant regulatory codes and codes of conduct.
Provide guidance on data structures which developers needs to adhere to.
Prescribe best practice installations to 3rd parties, thus protecting the business.
Ensure adherence to security and regulatory requirements.
Prepare and coordinate the completion of various data and analytics reports. Report (weekly) on database server health to management.
Take responsibility for developing and delivering a key element of the organization's data management system.
Education
Grade 12/ SAQA Accredited Equivalent (Essential); Relevant industry qualifications: MCSE or MCSD with a strong focus on SQL and Azure data management (Essential); Relevant degree in IT (Advantageous)
Experience
7 – 10 Years’ experience in Multiplatform environments with a focus on SQL 2008 – 2019 (Essential); A demonstrated proficiency of tuning and administration of large Microsoft SQL databases (Essential); Demonstrated ability working with multiple database platforms (Essential).
Click Here To Apply
