Tasked with ensuring uptime of the core Oracle Databases and none core databases that are in the live environmentEnsuring the NCWSC ERP and Billing system are up and functioning optimally Tasked with tuning of the databases and ERP to enable optimal functionality at all times Installation of databases and deploying RAC, OEM, ASM in live production systemsEnsuring high availability of storage system using net app storage and VMware in virtualizing servers and creating instances… Show more Tasked with ensuring uptime of the core Oracle Databases and none core databases that are in the live environmentEnsuring the NCWSC ERP and Billing system are up and functioning optimally Tasked with tuning of the databases and ERP to enable optimal functionality at all times Installation of databases and deploying RAC, OEM, ASM in live production systemsEnsuring high availability of storage system using net app storage and VMware in virtualizing servers and creating instances of databases in the new serversAdministration of NCWSC databases, ERP, billing system ensuring resources are used optimally, maintaining database audits, ensuring information life cycle is per the government standards User management and monitoring user process and resources used by users Tasked with doing migration of databases 10g -11g ,11g-12 c,12c-19c and cross system migrations (migration from legacy billing system to current billing system)Data cleanup and creation of data marts to assist in the cleanup process by acting as reference to data in production.Ensuring that all databases are backed up and a recovery conducive environment is always availableDeveloped the online customer contracting module that integrates NCWSC Billing system with the NCWSC USSD platform and web interface to provide an online customer platform for doing new customer contractingDeveloped the integration of NCWSC E-bill application with the email server and SMS integrator for dispatching monthly bills to customersDevelop APIs /integrations with NCWSC USSD provider that provides customer account balance query services-bill registration services, NCWSC personnel identifier(Tambua)Migrated the current integration database from oracle 10g to 11gIntegration of NCWSC Meter reading/Disconnection system with core billing systemDeveloped java EE web application that: enables upload of RTGs to the billing system, does billing simulation Show less

Working in the Nairobi City Water And Sewerage Company as the onsite project manager of the Commercial Management System(CMS) Debugging of batches and modifying batch applications using C as per client requirementEnsuring CMS and all its functionality and parameters function as requiredSolving problems involving CMS via writing code in according to users specifications and requirementsSolving CMS backend problems by ensuring only clean data goes to the database via inserting the… Show more Working in the Nairobi City Water And Sewerage Company as the onsite project manager of the Commercial Management System(CMS) Debugging of batches and modifying batch applications using C as per client requirementEnsuring CMS and all its functionality and parameters function as requiredSolving problems involving CMS via writing code in according to users specifications and requirementsSolving CMS backend problems by ensuring only clean data goes to the database via inserting the correct data that meets the constraints.Writing PL/SQL procedures to carry out various issues to ensure consistency in the Database.Debugging and troubleshooting of client application and writing code to fix bugs on the CMS applicationMonitoring batch operations and how data is inserted offline or online i.e. the collections, readings, extractions and upload, billing and splitting processes and collections.In charge of monitoring how the billing cycle progressesTroubleshooting system errors and coming up with proposals on enhancements of the system and effecting themUsing Tortoise SVN versioning system for source code maintenanceEnsuring database controls are always adhered and rights and privileges given to write personnelTrouble shooting of DB bottlenecks e.g. locks and rogue sessions and ensuring they don’t curtail database processesAssist in monitoring backups and archiving processes Installing and configuring oracle reports for report generation Show less

Using Nagios application for monitoring the current systems, routers and switches in KRAUsing Cacti graphing tool to issue indicators and also monitor systems.Using Nagvis mapping tool to map the systems, routers and switches to provide a visual aid for monitoring of systems.Assisting in deploying of modules in JBoss and apache tomcat and general maintenance of server boxes.Monitoring the SAN system and making sure storage is always availableMonitoring and Administering… Show more Using Nagios application for monitoring the current systems, routers and switches in KRAUsing Cacti graphing tool to issue indicators and also monitor systems.Using Nagvis mapping tool to map the systems, routers and switches to provide a visual aid for monitoring of systems.Assisting in deploying of modules in JBoss and apache tomcat and general maintenance of server boxes.Monitoring the SAN system and making sure storage is always availableMonitoring and Administering Oracle Databases used by KRA including Simba Database.Using application server technology i.e. use of jboss and apache tomcat to host applications to enable a user friendly way of accessing applications.Configuring RAID and installation of SUSE environment on server boxes.Checking of oracle health and escalation of oracle health issues to enable database tuning and uptimeModifying Linux system files i.e. etc,usr when configuring various applications and ensuring system/OS compatibilitiesEnsuring the KRA website server is up and monitoring the web services and ensuring all nodes are communicating Show less