Database Administrator at Co-operative Bank of Kenya

The role holder will be responsible for end-to-end and proactive database design and administration, performance monitoring and management of all databases, surrounding infrastructure, and general ICT Systems through the setting up of optimal performance benchmarks, use of modern and appropriate tools coupled with best practices.  The role holder will also ensure high systems availability and improvements to meet business growth demands, ensure timely intervention by key stakeholders, improved performance, enhance system security, business continuity, and competitiveness in product and service development.

The Role

Specifically, the successful jobholder will be required to:

• Monitoring performance and managing parameters to provide fast query responses to front-end users ensuring the performance of production databases.
• Monitoring systems logs, events, event correlation, maintaining performance statistics, and setting baseline statistics.
• Monitoring and managing the high availability components including RAC, Data guard, RMAN, ASM, and the underlying infrastructure for mission-critical databases.
• Developing, managing, and testing backup and recovery plans and ensuring that storage, archiving, backup, and recovery procedures are functioning properly.
• Take the lead role in the various I.T. audits in providing necessary information and enforcing the closure of audit, change management, and compliance issues.
• Manage key I.T. risks for all database systems and ensure proper mitigation.
• Take the lead role in BCP and disaster recovery preparedness through periodic testing as well as scheduling an update of disaster recovery procedures and sharing the results with management.
• Team up with applications support, development, and infrastructure team in the development, implementation, and management of applications, and infrastructure, and monitor system health in order to proactively identify weaknesses and address them. 
• Perform database tasks such as schema design, capacity planning, maintenance, troubleshooting, 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 practices; ensuring compliance with RDBMS license agreements and maintaining upgrades and critical patches 
• Database setup, configuration, and administration of MYSQL, MSSQL 
• Installation and administration of SAP HANA databases
• Creating and maintaining database documentation, including data standards, procedures, and definitions for the data dictionary (metadata), and maintaining 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 the reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.

Skills, Competencies, and Experience

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. 
• 1 – 3 years in database technology with experience deploying database and data warehousing technologies (e.g. High Availability, Real Application Clusters, ESBU Backups, Partitioning, Oracle DataGuard) in production environments.
• Oracle RDBMS 11g/12c OCP certification as well as strong SQL and PLSQL skills including data warehouse objects such as partitioning and materialized views. 
• Skills in Oracle RDBMS 19c.
• Skills in Oracle Engineered Systems e.g. Oracle SuperCluster, Exalytics, Exadata Storage, ZFS storage, and SmartScan.
• Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data mining as well as familiarity with ICT standards such as ITIL, COBIT.
• Proficiency in various operating systems like AIX, Solaris, Linux & windows.
• Thorough knowledge of 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 of the Oracle Technology stack as well as excellent knowledge of ICT system architectures, platforms, and infrastructure.  
• Ability to effectively communicate complex technical issues and exhibit a wide degree of creativity and latitude coupled with the ability to lead and direct the work of others without the benefit of a direct reporting relationship as well as the ability to utilize independent judgment and to support senior managers on operational criticality.
• General awareness of the banking industry ICT operations and security procedures.