SQL Database Administrator

**Job Title**:SQL Database Administrator

**Department**:Roadside Safety Enforcement

**Company**: TMT Services and Supplies (Pty) Ltd

**Location**:Mega Depot (Germiston)

**Job Type**:Fixed term contract ending 2028

**Description**:
**Position overview**

**Key Responsibilities**:
**Database Management and Maintenance.**Responsibilities include but are not limited to.
- Manage, maintain, and administer SQL databases to ensure high performance, availability, and security.

**Backup and Recovery**: Responsibilities include but are not limited to.
- Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
- Test backups to ensure the business can meet Recovery Time Objectives (RTO).

**Troubleshooting and outage Management**:Responsibilities include but are not limited to.
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.

**Performance Tuning and Optimization**:Responsibilities include but are not limited to.
- Monitor and optimize database performance.
- When performance issues arise, determine the most effective way to increase performance, including hardware purchases, server configuration changes, or index/query changes.

**Security Management**: Responsibilities include but are not limited to.
- Ensure database security by managing access controls, encryption, and monitoring for unauthorized activities.

**Database Design and Architecture**:Responsibilities include but are not limited to.

**Disaster Recovery**: Responsibilities include but are not limited to.
- Develop and test disaster recovery plans to minimize data loss and downtime in case of a major incident.

**Instillation and Configuring**:Responsibilities include but are not limited to.
- Install and configure SQL Servers, including deploying database change scripts provided by third-party vendors.

**Monitoring and Reporting**:Responsibilities include but are not limited to.
- Configure SQL Server and Monitoring Server Application utilities to minimize false alarms.
- Continuously monitor database health, performance, and usage, providing regular reports to stakeholders.

**Technology Knowledge and Integration**:Responsibilities include but are not limited to.
- Maintain knowledge of Analysis Services, Integration Services, and Reporting Services.
- Document the company’s database environment in the company’s EDMS system.
- Configure, test, and manage changes in integrated systems.

**Occupational Health and Safety**:Responsibilities include but are not limited to.
- Responsible for compliance with the department.

**Education and Experience**
- Matric or NQF equivalent.
- Bachelor’s degree in computer science, Information Technology, Software Engineering, or a related field.
- Minimum 2 years prior experience in a similar role.
- Basic SQL query writing and database management experience.
- Exposure to relational database management systems.
- Technical experience in:
SQL query writing and optimization.

Stored procedures, functions, triggers, and indexing.

Database Administration Tools.

Performance tuning and optimization.

Backup and recovery processes.

Security and compliance procedures.

**Skills and Competencies**
- Strong attention to detail and excellent observation skills.
- Good problem-solving and analytical skills.
- Strong administration skills.
- Good communication skills for interacting with team members, law enforcement, and other stakeholders.
- Enjoy working in a team but also can work independently.
- Be patient, tactful, diplomatic, and approachable.
- Demonstration of customer service orientation.

**About TMT**:
A guiding principle of our business is to build our technology that essentially makes a difference. We are a South African company that has been in operation since 2002 with a rich history in servicing the road safety enforcement, public transport and safety & security sectors.

To bring together the latest tech with our industry experts to develop better, more efficient mobility experiences. To quickly gain a deep understanding of the local mobility challenges our clients face and develop technological solutions that address the needs of both our clients and the citizens they serve.

Diversity, Equity, Inclusion and Belonging are key value sets embedded in the TMT culture. TMT focuses on hiring and developing talent across diverse races, gender, ethnicity, age and abilities. Priority talent recruited will be based on promoting and enhancing a more diverse and inclusive workforce at TMT.

**Job Type**: Temporary
Contract length: 36 months

Ability to commute/relocate:

- Germiston, Gauteng: Reliably commute or planning to relocate before starting work (required)