Database Administrator

CCG Systems; Gauteng; On-site; ZAR 700,000 - 1,000,000; Full time

Job summary

CCG Systems seeks a Database Administrator to ensure the availability, performance, security and recoverability of Microsoft SQL Server databases across production, development and UAT environments at our Head Office.

You will implement robust backup strategies, monitor health and performance, optimize queries, manage security, and participate in disaster recovery planning and testing to safeguard critical financial and operational data.

Qualifications

• Diploma or Bachelor's Degree in IT/CS or related field.
• Microsoft SQL Server certification.
• Microsoft Azure database-related certification.
• ITIL Foundation or equivalent service-management certification.
• Cybersecurity certification.

Responsibilities

• Install, configure and maintain Microsoft SQL Server environments and databases; manage instances, schemas and objects.
• Monitor database health, availability and performance; optimize slow queries and manage indexes.
• Design and implement backup strategies; ensure successful backups and test restoration procedures.
• Manage database security: users, roles, permissions, and AD integration; enforce least privilege; monitor access.

Skills

Database administration

SQL expertise

Education

Diploma or Bachelor's Degree in IT/CS or related field

Microsoft SQL Server certification

Microsoft Azure database-related certification

ITIL Foundation certification

Cybersecurity certification

Tools

Microsoft SQL Server

SQL Server Management Studio

Job description

CCG Systems is an ICT sector and is well known to specialize in the implementation and support of ERP systems as well as Payroll & HR Systems to which our clients are made of mostly Municipalities throughout South Africa. Our company is looking for a potential candidate to join our IT team in the capacity of a Database Administrator, to be based at our Head Office.

The Database Administrator is responsible for the availability, performance, security, integrity, reliability and recoverability of the organisation's databases. The role will administer and support production, development and UAT database environments, with particular focus on Microsoft SQL Server and databases supporting critical business applications, ERP, financial, billing and reporting systems. The DBA will ensure that databases are properly maintained, monitored, secured and backed up, while providing technical support for database-related incidents, performance issues, system implementations, upgrades and disaster recovery activities. The position requires a high level of technical discipline because the databases support business-critical and financially sensitive applications.

Formal Qualification required

• Diploma or Bachelor's Degree in Information Technology, Computer Science, Information Systems, Database Administration; or a related field. Relevant Microsoft SQL Server certification.

• Microsoft Azure database-related certification. ITIL Foundation or equivalent service-management certification. Relevant cybersecurity certification
  

Legal Requirements

• Valid code B driver’s license and own transport
• Passed credit and criminal checks
• S.A Citizen, Resident or Valid S.A Work Permit

Database Administration

• Install, configure and maintain Microsoft SQL Server environments.
• Create, configure and maintain databases.
• Manage database instances, databases, schemas and database objects.
• Monitor database health and availability.
• Perform routine database maintenance.
• Manage database growth and storage requirements.
• Monitor database capacity and proactively identify potential capacity constraints.
• Maintain accurate database documentation and configuration records.
• Support production, development, testing and UAT database environments.
  

Database Performance Management

• Monitor database and SQL Server performance.
• Investigate slow-running queries and database performance issues.
• Analyse execution plans and identify inefficient queries.
• Perform query optimisation and performance tuning.
• Manage indexes and statistics.
• Investigate blocking, deadlocks and long-running transactions.
• Identify CPU, memory, disk I/O and storage-related database bottlenecks.
• Establish performance baselines and monitor deviations.
• Recommend infrastructure or database configuration improvements where required.

Backup and Recovery

• Design, implement and maintain database backup strategies.
• Monitor the successful completion of scheduled backups.
• Perform full, differential and transaction-log backups as required.
• Regularly test database restoration procedures.
• Maintain backup retention policies.
• Investigate and resolve failed backups.
• Ensure databases can be recovered within defined recovery requirements.
• Participate in Disaster Recovery planning and testing.
• Maintain appropriate Recovery Point Objective (RPO) and Recovery Time Objective (RTO) procedures

Database Security

• Manage SQL Server users, roles and permissions.
• Implement role-based access controls.
• Ensure the principle of least privilege is applied.
• Monitor privileged database access.
• Support integration with Windows/Active Directory authentication where applicable.
• Implement database security controls and encryption where required.
• Ensure appropriate protection of sensitive and financial information.
• Participate in database security assessments and remediation activities.
• Ensure database access is aligned with organisational security policies