Role Summary
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 servers and cloud environments and securing systems.
Responsibilities
Database Administration
- 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 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
- Matric / Grade 12
- Diploma / Degree in IT
- Certificate in CompTIA, Microsoft, Cisco, Linux+
- Certification in SQL Server (Advantageous)