ICT Officer I, (Database Administrator) at Co-operative University of Kenya (CUK)

REMUNERATION:

• Basic Salary per month range: Kshs. (63,647/= - 97,988/=)
• House Allowance per month: Kshs. 35,383/=

Applicants should meet the following requirements:

• Must possess a Bachelors Degree in Computer Science, Information Technology or a related field from an accredited or recognized institution;
• Must possess three (3) years’ experience in grade 9 or comparable position with exemplary track record experience in database administration or applications development, including system customisations, Integrations, & Report designs for/in a University setting;
• Must have demonstrable experience with Oracle, MSSQL, MySQL/MariaDB, SQLite and PostgreSQL databases and database abstraction tools e.g. ADO.NET, ORM, LINQ to SQL etc.
• Must have demonstrable knowledge in database performance housekeeping such as tuning, indexing etc.
• Must have demonstrable knowledge in Systems Integrations using both RESTful and SOAP-based APIs;
• Advanced knowledge of relevant ERP Systems;
• Must demonstrate Systems development experience with any modern programming tools/platforms e.g. PHP, NET, JavaScript, Java etc. is an added advantage.

Duties & Responsibilities

• Developing and maintaining database documentation, including data standards, procedures and definitions for data elements and tables in the institution;
• Identifying and implementing database requirements for new or existing applications by working collaboratively with other teams;
• Optimizing database performance and efficiency by evaluating and recommending new database technologies;
• Supporting users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices;
• Executing regular database maintenance tasks, including database defragmentation, backups, and database replication;
• Developing User Requirement Analysis – URA documents for new developments or as per the users’ requirements and mapping of the same to the software and/or database components;
• Defining and implementing event triggers that will alert on potential database performance or integrity issues;
• Performing the necessary technical design and development functionality to ensure that business application systems can be effectively developed and implemented;
• In collaboration with other teams, design and develop front-end tier(s), middle tier(s), and /or back-end database tier(s) for business application;
• Configuring and/or customizing business applications to meet business requirements using various database and software tools;
• Making improvements to, and offering inputs on, the existing software;
• Creating software testing environments (database) and carrying out test procedures using defined use cases;
• Assisting in presentations of system functionality to new users and departments. Drive systems adoption by business users;
• Work directly with the IT support teams to resolve data-related issues identified and escalated during daily operations;
• Investigating data-related issues/bugs with the software and working with the development team on resolving the issues;
• Identifying, reporting, and managing database security issues, audit trails, and forensics;
• In collaboration with other teams, develop and provide reports and documentation of the new software version and changes;
• Researching and providing input on database design approach, performance and base functionality improvements for various procedures and applications;
• Reviewing database user requirements documents to ensure that requirements are testable;
• Developing test plans, test cases, test scripts and test reports on multiple projects of varying sizes;
• Designing, developing and operating automated software build, packaging, testing and deployment tools to ensure predictable and repeatable software migration from development to test and eventually production environments - Continuous Integration (CI) and Continuous Delivery (CD);
• May be required to perform other related duties based on the CUK’s needs.

Technical/ Functional competencies

• Ability to use a scripting language (like Python or Peri) to automate database administration tasks
• Experience with web servers and application servers e.g. Apache, IIS, Apache Tomcat, JBoss, WebSphere, WebLogic.
• Experience in data warehousing, business analytics, knowledge in Business Systems Modelling and data retrieval.
• An added advantage is relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
• Wide knowledge of testing approaches, manual and automated software testing
• Knowledge of database automation tools
• Unix user skills.
• Experience in process and procedure management.
• Good understanding of Service Oriented Architecture (SOA).
• Demonstrate integrity and professional competence as reflected in work performance and results.