Brief The Database Administrator is responsible for the day‑to‑day maintenance, and administration of the organization's IT infrastructure and data systems. This includes managing databases, maintaining server and cloud environments and securing systems. The role requires hands‑on work across a wide range of technologies to ensure operational stability, performance, and end‑user satisfaction.
Key Performance Areas
- Database Administration (DBA)
- Systems and Infrastructure Management
- Security and Compliance
- Incident Response and Troubleshooting
- Monitoring and Maintenance
- Documentation and Asset Management
Responsibilities Database Administration (DBA)
- Install, configure, and maintain database systems (e.g., MSSQL, MySQL, PostgreSQL) to ensure optimal availability, performance, and security.
- Analyze and optimize slow‑running queries, implement efficient indexing strategies, and monitor storage usage.
- Automate routine DBA tasks through scripts or tools to support monitoring, deployment, and reporting.
- Apply necessary patches and upgrades across database environments.
- Conduct regular data audits and integrity checks to ensure consistency, accuracy, and reliability of stored data.
- Maintain up‑to‑date documentation of database configurations, schemas, and procedures.
- Participate in capacity planning, forecasting, and contribute to disaster recovery and business continuity planning.
- Provide technical support for database‑related issues, working closely with developers, system administrators, and stakeholders to resolve problems efficiently.
- Implement and test backup and recovery strategies, including regular validation of recovery procedures to ensure data integrity.
- Configure user access, roles, and permissions to enforce security.
- Ensure high availability and perform regular health checks on critical databases.
Systems Administration
- Install, configure, and maintain Windows and Linux servers, both physical and virtual.
- Support core services such as Active Directory, Group Policy, DNS, print services, file shares, IIS, and FreeRADIUS.
- Manage and monitor virtualized environments (e.g., VMware, Hyper‑V).
- Maintain and troubleshoot web services using Apache, NGINX, and Docker containers.
- Apply updates, patches, and security fixes across systems.
- Monitor performance and availability of systems using tools like Zabbix or similar.
Security & Compliance
- Support antivirus and endpoint security platforms (e.g., Defender for Endpoint).
- Assist with firewall rule changes and device hardening.
- Enforce IT policies regarding access controls, password hygiene, and patch management.
- Participate in security audits and remediate identified vulnerabilities.
Backup & Disaster Recovery
- Monitor and test server and database backups.
- Support the implementation of a 3‑2‑1 backup strategy.
- Assist with restoring files or systems in the event of data loss or corruption.
Cloud & Collaboration Tools
- Support Microsoft 365 and Google Workspace user environments.
- Manage user access, licenses, and basic security configurations.
- Assist with mailbox configuration, calendar sharing, Teams, OneDrive, Teams, and Google Drive support.
Networking & Connectivity
- Basic troubleshooting of LAN/WAN connectivity issues.
- Patch and maintain network devices under guidance from network administrators.
- Assist in monitoring internet availability and site‑to‑site VPNs.
Documentation & Asset Management
- Maintain accurate records of hardware, software, and configurations.
- Keep documentation updated for all routine processes and systems.
- Track assigned IT assets and participate in regular audits.
Qualifications Required
- Matric / Grade 12
- Diploma or certification in IT or related field (e.g. CompTIA, Microsoft, Cisco, Linux+)
- Certifications in SQL Server are advantageous
Work Experience
- Minimum 3 years of hands‑on IT support and systems administration
- At least 3 years of practical experience in database administration (MSSQL Server and MySQL)
- Experience with Windows and Linux servers in production environments
- Familiarity with helpdesk systems and end‑user support best practices
Skills Required
- Strong troubleshooting and analytical skills
- Solid understanding of server infrastructure and data environments
- Working knowledge of networking basics (TCP/IP, DHCP, DNS, VPN)
- Good verbal and written communication skills
- Ability to work independently and handle multiple tasks