Database Administrator at Kenya Universities and Colleges Central Placement Service

REF: KUCCPS 034/18

JOB DESCRIPTION

Reporting to the Manager ICT, the officer will support and maintain the varied number of databases running within the Placement Service.

KEY RESPONSIBILITIES

• Support of production database services to ensure the highest standards of availability, resilience, integrity, security and performance as required by the Placement Service and other dependent business systems;
• Design, develop and administer the Placement Service databases and database packages and procedures;
• Performance monitoring, reporting, and tuning of the Placement Service databases;
• Review and tune SQL or database logic code or scripts;
• Ensure security and access control;
• Provide technical support to ICT development team in the design, development, testing, tuning and implementation of their various database applications and or projects;
• Create and maintain SQL queries and routines;
• Provisioning of (database) development and testing environments;
• Write ad hoc queries based on schema knowledge for various reporting requirements and data extract requests;
• Deal with complex data models and object relational database mapping, while producing complex reports;
• To ensure all servers are configured correctly with regard to security patches, software versions, security configuration, and recoverability and that, all servers are backed up correctly and to carry out regular test restores
• Support staff in execution of difficult technical tasks, including data extracts and the creation of specialized reports.

MINIMUM REQUIREMENTS

• Have a minimum of three (3) years' experience in relevant work in the Public Service or the Private Sector;
• Have a Bachelor's degree in any of the following fields: Information Technology, Computer Science/Engineering, or any other relevant and equivalent qualification, from a institution recognised institution
• Have experience and training in MySQL, and Microsoft SQL, Unix based operating systems, XML or other related or equivalent qualifications
• Fulfill the requirements of Chapter Six of the Constitution.
  • Kenya Revenue Authority;
  • Ethics and Anti-Corruption Commission;
  • Higher Educations Loans Board;
  • A Licensed Credit Reference Bureau;
  • Directorate of Criminal Investigations