About Kingdom Bank

Kingdom Bank is a subsidiary of the Co-operative Bank of Kenya, following its acquisition of Kingdom Bank in August 2020. We are now part of a Group with over Kes. 457 Billion total assets and Kes 20.7 Billion profit before tax as at 31 December 2019.

Responsibilities

Specifically, the successful jobholder will be required to:

• Monitoring performance and managing parameters to provide fast query responses to front-end users ensuring performance of production databases.
• Monitoring including systems logs, events and event correlation and maintaining performance statistics and setting baseline statistics.
• Monitoring and managing the high availability components including storage and the underlying infrastructure for mission critical databases.
• Developing, managing and testing back-up and recovery plans and ensuring that storage, archiving, back-up and recovery procedures are functioning properly.
• Take lead role in the various I.T. audits in providing necessary information and enforcing closure of audit, change management and compliance issues.
• Manage key IT risks for all database systems and ensure proper mitigation.
• Take lead role in BCP and disaster recovery preparedness through periodic testing as scheduled and update of disaster recovery procedures and sharing the results with management.
• Team up with applications support, development and infrastructure team in the development, implementation, management applications, infrastructure, and monitor system health in order to proactively identify weaknesses and address them.
• Perform database tasks such as schema design, capacity planning, maintenance, trouble shooting, and change control activities.
• Considering both back-end organization of data and front-end accessibility for end-users and further refining the physical design to meet system storage requirements.
• Installing database management systems (RDBMS) using best practice; ensure compliance with RDBMS license agreements and maintain upgrades and critical patches
• Database setup, configuration and administration of MSSQL, PostgreSQL.
• Creating and maintaining database documentation, including data standards, procedures and definitions for the data dictionary (metadata) and maintain all technical documentation relating to database management.
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
• Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
• Setting up and testing new database and data handling system

Qualifications

The successful candidate will be required to have the following skills and competencies:

• Bachelor’s degree in software engineering, Computer Science, Information Technology, or related discipline, or equivalent.
• 2 – 3 years in database technology with experience deploying database and data warehousing technologies (e.g. High in production environments.
• Oracle MSSQL and PostgreSQL with strong SQL and PLSQL skills including data warehouse objects.
• Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data mining Familiarity as well with ICT standards such as ITIL, COBIT.
• Proficiency in various operating systems like Linux & windows.
• Thorough knowledge on data profiling, data modeling and data validation and associated tools; Skills in Database Sizing, Storage. Performance, and Security Considerations.
• Strong analytical skills: ability to analyze and correlate complex data and excellent knowledge on the Oracle Technology stack as well as excellent knowledge of ICT system architectures, platforms and Infrastructure.

• Monitoring performance and managing parameters to provide fast query responses to front-end users ensuring performance of production databases.
• Monitoring including systems logs, events and event correlation and maintaining performance statistics and setting baseline statistics.
• Monitoring and managing the high availability components including storage and the underlying infrastructure for mission critical databases.
• Developing, managing and testing back-up and recovery plans and ensuring that storage, archiving, back-up and recovery procedures are functioning properly.
• Take lead role in the various I.T. audits in providing necessary information and enforcing closure of audit, change management and compliance issues.
• Manage key IT risks for all database systems and ensure proper mitigation.
• Take lead role in BCP and disaster recovery preparedness through periodic testing as scheduled and update of disaster recovery procedures and sharing the results with management.
• Team up with applications support, development and infrastructure team in the development, implementation, management applications, infrastructure, and monitor system health in order to proactively identify weaknesses and address them.
• Perform database tasks such as schema design, capacity planning, maintenance, trouble shooting, and change control activities.
• Considering both back-end organization of data and front-end accessibility for end-users and further refining the physical design to meet system storage requirements.
• Installing database management systems (RDBMS) using best practice; ensure compliance with RDBMS license agreements and maintain upgrades and critical patches
• Database setup, configuration and administration of MSSQL, PostgreSQL.
• Creating and maintaining database documentation, including data standards, procedures and definitions for the data dictionary (metadata) and maintain all technical documentation relating to database management.
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
• Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
• Setting up and testing new database and data handling system

• Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data mining
• Familiarity as well with ICT standards such as ITIL, COBIT.
• Proficiency in various operating systems like Linux & windows.
• Thorough knowledge on data profiling, data modeling and data validation and associated tools;
• Skills in Database Sizing, Storage. Performance, and Security Considerations.
• Strong analytical skills: ability to analyze and correlate complex data
• excellent knowledge on the Oracle Technology stack
• excellent knowledge of ICT system architectures, platforms and Infrastructure.

• Bachelor’s degree in software engineering, Computer Science, Information Technology, or related discipline, or equivalent.
• 2 – 3 years in database technology with experience deploying database and data warehousing technologies (e.g. High in production environments.
• Oracle MSSQL and PostgreSQL with strong SQL and PLSQL skills including data warehouse objects.