Database Administrator

South African National Blood Service; Gauteng; On-site; ZAR 400 000 - 600 000; Full time

Job summary

A prominent health service provider in Gauteng seeks a Database Administrator to oversee database operations, ensure compliance with regulations, and enhance database performance. The ideal candidate will possess extensive experience in SQL Server and hold current database certifications. Responsibilities include budget management, troubleshooting, and training staff on database usage.

Qualifications

• 3+ years of experience in Database Administration and Business Intelligence.
• Hands-on knowledge of database design, optimization, and troubleshooting.
• Experience with MS SQL Server tools including Query Analyzer and Profiler.

Responsibilities

• Oversee budget allocations for database infrastructure.
• Act as the main point of contact for SQL database needs.
• Conduct performance monitoring and troubleshooting.

Skills

Analytical Thinking

Attention to Detail

Change Management

Problem Solving

SQL Server

Project Management

Education

Current Microsoft Database Certification

ITIL Skill set

Minimum of 3 years experience in Database Administration

Tools

Microsoft SQL Server

MS SharePoint

Blood Establishment Computer System (BECS)

Job description

The incumbent will support the IT Infrastructure through best practice implementation and solutions whilst contributing to Infrastructure excellence.

Key Performance Areas (KPAS)

KPA 1 : Finance

• Oversee budget allocations for database infrastructure, ensuring efficient resource utilization.
• Analyse cost‑saving opportunities related to database management and maintenance and proposing alternate technology.
• Prepare reports on database‑related expenditures and forecast future costs.
• Contribute to the annual departmental budgeting and business planning process.
• Identify underutilized resources and recommend scaling down where appropriate.
• Assess and implement cost‑effective database solutions, such as cloud services or virtualization.
• Monitor licensing agreements and ensure compliance to avoid unnecessary expenses.
• Implement strategies that enhance database performance and reduce downtime, contributing to overall business productivity.

KPA 2 : Customer

• Act as the main point of contact for BI, BA, and ERP teams regarding SQL database needs and issues.
• Conduct regular check‑ins with stakeholders to gather feedback and address concerns proactively.
• Facilitate training sessions for internal teams to maximize their effective use of database resources.
• Ensure timely resolution of incidents and service requests according to established SLA metrics.
• Regularly review and adjust SLA compliance processes to maintain high service levels.
• Implement monitoring tools to track database health, performance, and security.
• Develop and maintain automated alerts for critical performance issues and potential outages.
• Lead root cause analysis sessions to identify and rectify recurring problems effectively.

KPA 3 : Internal (Processes)

• Utilize performance monitoring tools like Idera to track database metrics, identify bottlenecks, and suggest improvements.
• Troubleshoot and isolate performance problems, ensuring minimal impact on user experience.
• Perform routine database health checks, optimising indexes and queries as needed.
• Collaborate with development teams to optimise application queries and improve overall system performance.
• Execute routine backups, ensuring data integrity and availability for recovery purposes.
• Conduct security audits and implement necessary changes to protect against vulnerabilities.
• Implement and maintain database security for databases, safeguarding sensitive information.
• Document and establish procedures for database maintenance tasks, ensuring compliance with internal policies.
• Design and implement database servers that meet the organisation's requirements.
• Research and propose the use of the most appropriate solution for the organisation's database needs.
• Provide and maintain documentation related to database and data warehouse structures, including configuration and setup.
• Design and implement data transformation rules according to set standards and methodologies to ensure data quality.
• Evaluate and implement approved updates and patches on designated platforms to enhance security and performance.
• Implement and monitor DB clones used in the organisation for testing and development purposes.
• Evaluate and implement new hardware and software for capacity planning, ensuring future scalability.
• Perform analysis and troubleshooting to resolve database issues as they arise.
• Diagnose software and hardware problems and provide timely solutions, minimising downtime and impact on operations.
• Design database schemas to ensure data integrity and support business processes.
• Integrate large data files and databases from disparate systems, ensuring seamless data flow and accessibility.
• Implement a trend analysis toolset to provide management with insights and analysis for informed decision‑making regarding resource management.
• Work closely with developers to ensure database designs align with application needs and scalability.
• Engage with network engineers to ensure optimal database connectivity and performance.
• Participate in project planning sessions to provide input on database requirements and constraints.
• Research and recommend new database technologies and best practices to enhance operations.
• Lead pilot projects to test innovative solutions before broader implementation.
• Gather and analyse feedback from users to continuously refine and improve database processes.
• Implement and monitor early warning systems to detect potential issues before they escape.
• Contribute to the implementation of projects for the organisation by ensuring project deliverables align with organisational goals.
• Adhere to project timelines and budget schedules, ensuring efficient use of resources and meeting deadlines.
• Communicate progress on the status of project tasks to relevant stakeholders, facilitating transparency and collaboration.
• Adhere to the SANBS Project Management Methodology to ensure all projects are executed effectively and efficiently.
• Participate in project meetings and provide input on technical requirements and challenges.

KPA 4 : Learning and Growth

• Pursue ongoing education opportunities to remain up‑dated on the latest SQL Server features and technologies.
• Attend industry conferences, workshops, and webinars to enhance professional knowledge and skills.
• Share knowledge gained through training with the team to foster a culture of continuous learning.
• Organise regular knowledge‑sharing sessions to discuss challenges and solutions within the team.
• Evaluate and recommend emerging technologies that could enhance the database environment.

KPA 5 : Governance (Risk, Notifications, Compliance)

• Develop and implement database policies that align with GDPR, HIPAA, and other relevant frameworks.
• Conduct regular audits to ensure compliance with internal and external data protection regulations.
• Collaborate with legal and compliance teams to address any potential risks related to database management.
• Conduct risk assessments to identify vulnerabilities in database systems and operations.
• Implement security measures such as encryption, access controls, and regular security updates.
• Develop and maintain a disaster recovery plan to minimise downtime in the event of a data breach or system failure.
• Maintain detailed logs of database activities, changes, and access to facilitate audits and compliance checks.
• Create regular reports on database performance, security incidents, and compliance metrics.
• Work with internal teams to ensure all database documentation is up to date and accessible.
• Establish protocols for alerts related to database health, performance, and security breaches.
• Implement a notification system for timely communication of critical issues to relevant stakeholders.
• Regularly review alert criteria and thresholds to ensure they align with operational requirements.

Skills

• Cognitive: Analytical Thinking and Attention to Detail; Change Management; Judgment and Decision Making; Problem Solving; Planning, Organising and Monitoring.
• Personal: Flexibility and Adaptability; Orientation; Ethical Behaviour; Interpersonal; Customer Service Orientation; Teamwork; Communication; Knowledge Sharing.
• Prof. Technical: Business and Financial Acumen; Systems Competence; Computer Literacy.
• SQL Server and newer.
• MS SharePoint.
• Blood Establishment Computer System (BECS) / SAP (or any other relevant programme / application).
• Leadership; Project Management; Education.

Qualifications

• Current Microsoft Database Certification.
• ITIL Skill set requirement (Problem Management / Incident Management / Change Management, etc.).
• Minimum of 3 years directly related work experience in Database Administration and Business Intelligence / Data Warehousing in an environment with multiple production databases.
• Hands‑on professional experience must include an overall knowledge of database design, optimisation, and troubleshooting, as well as Microsoft SQL.
• Experience with MS SQL Server, including use of Query Analyzer, stored procedures, DTS, Jobs and Profiler.