JOB SUMMARY
To ensure optimal performance, availability, security and support of the organization's databases and business systems, through effective administration, analysis, integration, and continuous improvement of critical applications and data platforms.
Duties and responsibilities
- Administer and maintain enterprise databases e.g. Microsoft SQL Server, MySQL, Oracle, ensuring availability, security, scalability, and performance.
- Perform routine database backups, restorations, and regular testing of recovery procedures to ensure data integrity and business continuity.
- Monitor database health jobs, logs, space utilization, and perform tuning and optimization of queries, indexes, and storage.
- Configure and manage database replication, high availability, and disaster recovery features.
- Apply patches and upgrades to database platforms in accordance with change control processes.
- Enforce database access control, audit trails, and security by design principles.
- Support, maintain, and enhance the organization’s business systems e.g. MS BUSINESS CENTRAL, ERP, CRM, HRMIS, financial systems, portals.
- Analyze, document, and validate business and technical requirements to align systems with operational needs.
- Participate in testing, rollout, configuration, and upgrades of business systems and modules.
- Monitor system performance and logs to proactively identify and resolve application-level issues.
- Support business process automation and integrations, including troubleshooting application and API-related issues.
- Develop custom reports and data extraction queries to support operations and decision-making.
- Provide ongoing end-user support, training, and documentation to improve system adoption and utilization.
- Ensure seamless integration of new applications with existing business systems and databases.
- Participate in application upgrades, testing, user acceptance testing UAT, and change request handling.
- Map and document system interfaces between legacy and new platforms to guide transitions and minimize disruptions.
- Adhere to formal change management and incident management processes.
- Document all database and business systems configurations, processes, and support procedures.
- Train new and existing users on business systems, new features, and best practices.
- Conduct system demos and communicate key updates and changes to relevant departments.
- Escalate complex issues to vendors or senior ICT staff and follow up to resolution.
- Identify risks and vulnerabilities related to databases and business systems and propose mitigation strategies.
- Ensure compliance with data protection laws, system access policies, and ICT security standards.
- Participate in audits and implement recommendations related to business systems and database operations.
KEY QUALIFICATIONS AND COMPETENCIES
Academic Qualifications
- Minimum Kenya Certificate of Secondary Education C+ Plus
- Bachelor’s degree in Information Technology, Computer Science, or related field.
- Professional certifications such as Microsoft Azure, Cisco, Comp TIA Security+, CEH, or ISO 27001 Implementer are an added advantage.
- Professional certifications such as Microsoft Certified: Azure Database Administrator, Oracle Certified Professional OCP, or CBAP for business analysis are an advantage.
- Age 30 - 40 years.
Knowledge, Experience and Skills
- 3–5 years’ experience in a database or business systems administration role.
- Experience working with Microsoft SQL Server, MySQL/PostgreSQL, or Oracle DBMS.
- Experience supporting ERP/CRM/HRMIS/financial systems e.g. SAP, Microsoft Dynamics, etc.
