SQL Server DBA — Automation, Security & High Availability

Transnet Company; Pretoria; On-site; ZAR 540,000 - 760,000; Full time

Job summary

Transnet invites applications for a Database Administrator to ensure performance, integrity and security of our databases. The role designs, implements and maintains database systems, troubleshoots issues and collaborates with development teams to enable data-driven objectives.

The incumbent will lead automation, cost optimisation and enforce data governance, with 3+ years in ICT and at least 1 year in a supervisory or specialist role.

Qualifications

• Minimum 3 years National Diploma in ICT-related qualification.
• Minimum 5 years’ ICT experience as a Database Administrator, with at least 1 year in a Supervisory or Specialist role.
• OR Minimum 6 years’ ICT experience as a Database Administrator, with at least 2 years in a Supervisory or Specialist role.

Responsibilities

• Design, implement and maintain robust database schemas, tables, stored procedures and functions in collaboration with software development teams.
• Enforce database standards, naming conventions and best practices to ensure consistency and maintainability.
• Manage the full database lifecycle including provisioning, upgrades, migrations and decommissioning.
• Plan and execute upgrades, patches and migrations with minimal business disruption.
• Develop and maintain automation scripts using PowerShell, Python and SQL.

Skills

Database administration

SQL

Automation

Monitoring

Security

Education

National Diploma in ICT

ICT-related qualification

Tools

PowerShell

Python

Job description

Transnet invites applications for a Database Administrator to ensure performance, integrity and security of our databases. The role designs, implements and maintains database systems, troubleshoots issues and collaborates with development teams to enable data-driven objectives.

The incumbent will lead automation, cost optimisation and enforce data governance, with 3+ years in ICT and at least 1 year in a supervisory or specialist role.