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 tiers, middle tiers, and /or back-end database tiers 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.
