Senior SQL Database Administrator at Telesure Investment Holdings (TIH)

Introduction    
Maintain database systems and identify potential risk to data and integrity not only on database level but also Infrastructure level, this includes an element of resource management and mentoring. The role is responsible for advanced planning, developing, installing, configuring, supporting, and optimizing all database related systems. The role is core to determining and executing strategy and will involve working closely with IT functional and technical areas, process owners, business and vendors. The role is strategic and operational in nature with elements of advanced operational support, execution and design.
Specification    
Technical Database Support

• 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.

Infrastructure support

• 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.

Database Specifications

• 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.

Operational Compliance

• 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.

Solutions Analysis

• 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.

Data Management

• Take responsibility for developing and delivering a key element of the organization's data management system.

Data Architecture

• 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.

Databases Installation

• Install and test the most complex databases and associated products to ensure they are suitable for use and meet customer requirements.

Information Security

• 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.

Documentation and Back up

• Create and maintain technical and/or user documentation to a high standard and back up files to ensure instant recovery if problems occur.

Personal Capability Building

• 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.

Insights and Reporting

• Prepare and coordinate the completion of various data and analytics reports. Report (weekly) on database server health to management.

Organizational Capability Building

• 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.

Improvement / Innovation

• 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.

Requirements    

• General 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)
• T-SQL (essential)
• SSIS (essential)

General 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)

Job Closing Date: 13th, March 2022