Edwin Kiai Kabuya

Responsibilities based on site:

Gulf African Bank

• Upgrade and patching of 2 Oracle Database Appliance X9-2 HA Systems from 19.18 to 19.24

Kenya Airways Limited

• Deployment of 2 Oracle Database Appliance X9-2 HA Systems, including upgrade and patches to Release 19.24

Kenya Power and Lighting Company.

• Redeploying Oracle 19c Real Application Clustering (RAC) Software on M8 Oracle SuperCluster, including patch application
• Upgrading Oracle 12c and 18c RAC Clusterware to 19c on multiple M8 Oracle SuperCluster engineered systems
• Oracle Exadata Storage Cells maintenance tasks
• Setting up Oracle Standby databases using Oracle Data Guard
• Served as the primary point of contact for clients, addressing concerns promptly and professionally.

Responsibilities based on site:

Office Burundais des Recettes, Burundian Revenue Office

• Deployed Oracle Audit Vault and Firewall Release 20.9
• Conducted training on advanced Oracle Solutions: Oracle RAC, Oracle Data Guard, Oracle Audit Vault, Oracle Database Security

DIB Bank Kenya

• Undertook Oracle Database Forensic Audit

Maintenance and resolving database challenges across multiple clients

Responsibilities based on site:

NCBA Group PLC

• Deployed two 2-node Oracle 19c RAC Cluster setups for both the Trinity Transaction and Cards project.
• Optimized the Red Hat Enterprise Linux Operating Systems,Clusterware and Databases for performance
• Day to day database administration measures
  

Bank of Khartoum, Sudan

• Deployed a 4 Node Oracle 19c RAC Cluster and Database Software inclusive of patches on Oracle Private Cloud Appliance (PCA) virtual machines
• Migrated the IMAL Core Banking System from HP Servers to the above RAC Database on the Oracle PCA
  

National Bank Of Kenya

• Migrated Oracle RAC databases from X8-2 Exadata DB Machine to X8M-2 Exadata DB Machine using Oracle Data Guard, including setting up E-Business Suite R12.2.4 DBTierand AppsTier for Business Continuity (Disaster Recovery Site)
• Relocation of Exadata X4-2 DB Machine to DR site, involved;
  • Oracle Clusterware IP Address reconfiguration on the Compute Nodes including IP Address Changes on the Storage Cells
  • Upgrading Oracle RAC Cluster and Database Software to 19c including patch application
  • Upgrading the Oracle Linux Operating System and Exadata System Software acrossthe Compute Nodes and Storage Cells
  • Patching the Infiband Switches
  

New Kenya Co-operative Creameries Limited

• Upgraded Oracle 11g SAP Landscape databases on MS Windows and migrated them to 12c Oracle Exadata DB Machine using Oracle Data Guard
• Deployed Oracle Enterprise Manager 13c Cloud Control as a central management utility for Oracle Exadata engineered system, Oracle Virtualized Servers and ZFS Storage Appliance
  

Co-operative Bank of Kenya

• Oracle Database Support; facilitating Oracle Platinum Patching on M7 Oracle
  SuperCluster including resolving Storage Cell Grid Disks issues

Kenya Power and Lighting Company

• SAP (ERP) Oracle single instance database migration from Solaris Sparc OS filesystem
  to Oracle SuperCluster RAC Solaris Sparc zones using Oracle Data Guard solution
• SAP Landscape System Oracle RAC Databases replication using Data Guard

• Deployed Apache web server on RHEL 6 for hosting EPAY Application services
• Facilitated a successful Production Exadata DB Machine platinum patching by Oracle Advanced Support
• Using Golden Gate for near zero downtime cutover, migrated critical database for authorizing Mobile and ATM transactions from 11gR2 to 12cR1
• Using 12cR1 Database Upgrade Assistant, upgraded multiple databases from 11gR2 to 12cR
• Upgraded and patched DR Exadata DB Machine; updating Exadata software and Operating System from Oracle Enterprise Linux including other components.

Responsibilities based on site:

National Bank of Kenya

• Managing the High Availability RAC Database solution for Bank Fusion Universal Banking (MISYS) Core Banking System and its performance tuning including Oracle
  Active Data Guard Replication solution for disaster recovery
• Managing several Oracle Databases for the TranzWare Card Management Systems and the Oracle Active Data Guard solutions
• Implemented Internet Banking, Mobile Banking, County Revenue Collection Databases’ Maximum Availability Architecture (RAC combined with Active Data Guard)
  on Exadata Database Machines running on both Production and Disaster Recovery sites. This also included; setting up Internet Banking WebLogic (Clustered Domain) Servers, Apache web hosting servers, Mobile Banking JBOSS servers
• Setup up the Islamic Banking (IMAL), Electronic Document Management System and Back Office Banking systems databases
• Migrated existing core databases mentioned above to the Exadata Database Machine from both AIX and OEL OS platforms using Export/Import Data Pump and
  Transportable Tablespaces with reduced downtime
• Setup the Oracle Business Intelligence Enterprise Edition 11g (with Oracle Data Integrator) for integration with Oracle Business Financials (E-Business suite R12.2)
• Setup the Oracle E-Business Suite R12.2 Vision Demo for user training
• Facilitated E-Business Suite R12.2 deployment by adding dedicated Oracle Homes on Exadata DB Machines including patch application and bug fixes. Further created several Demo Vision E-Business suite setups
• Upgraded Exadata DB Machine RAC cluster resources from 11.2.0.4.0 to 12.1.0.2.0 (12cR1), added new 12c R1 database resources including patch application to
  accommodate the core banking system upgrade (Fusion Bank Essence MISYS)
• Upgrading OEM 12c to OEM 13c; Oracle infrastructure discovery which includes Exadata DB Machines providing efficient management of the IORM and Flash Cache
  

Imperial Bank of Kenya

• Troubleshooting database performance issues on Oracle 10g R2 databases running on HPUX Unix and Oracle Enterprise Linux 5 platforms

Bank Populaire Du Rwanda (BPR Rwanda)

• Setup Oracle Active Data Guard replication for the T24 Banking System having Oracle RAC databased hosted on AIX 7.1 platform (IBM Power Systems)
  • Tuning RMAN backups and export data pump dumps

• Provided administrative support on both Oracle Live/Production and Development Databases (9iR2, 10gR2 and 11gR2) on Red Hat Enterprise Linux (5 & 6), Sun Solaris Sparc (8 & 10) platforms and Microsoft Windows (2008R2) server i.e.
• Tuned database performance using Statspack and AWR reports, Database Health Checks, Incremental RMAN backup for efficient space management, basic scripting at OS level for RMAN backups and Database Schema/Table Exports, created database user accounts and database (system-level and object-level) objects etc
• Worked with developers to facilitate upgrading of StarCARDMAN Proprietary (ATM) Card Generating Application; including Application patching
• Payment Card Industry Data Security Standards (PCI DSS) Compliance Project which entailed: Upgrading 10gR2 and 11gR2 databases to newer releases and versions; which also included application of latest Critical Security Update and Patch Set Update database patches
• Enabling Database Auditing on all Oracle Databases within PCI scope
• Configuring User Administration and Security (Password Complexity) as per PCI requirements
• Data Retention Policies and Database Encryption
• TSYS PRIME 4 (Visa Payment Card Processing Application) upgrade which involved: Installing and patching Oracle 11gR2 databases on RHEL 6.3
• Support in implementing and maintaining Oracle Streams for PRIME databases
• Configuring database compliance to PCI DSS specifications mentioned above.

• Tutored Oracle Database Administrator and Oracle Developer courses, in addition to Red Hat Enterprise Linux System Administration
• Managed Production database on Red Hat Enterprise Linux platform including other enterprise databases
• Occasionally implemented RMAN Incremental Hot Backups using Crontab Scheduling.