Dickson Gathima Email & Phone Number

Nairobi County, Kenya

Kenya

Database Management· Managed databases, including MSSQL, Oracle, MySQL, MongoDB and PostgreSQL, across on-premises and cloud environments (AWS/Azure).· Planned and implemented database software upgrades, managing end-of-life stages, new releases, and timely patches.· Perform daily tasks, including error checks, monitoring physical resource health (disk space, memory, CPU, etc.) and adjusting performance parameters as needed.· Oversaw database instances, involving performance monitoring, optimization, backups, error and alert checks, and providing operating system support.· Established security measures across all databases, focusing on three fundamental security tasks: authentication, authorization and auditing.· Configuring High availability using data guard and RAC for oracle, replication, mirroring and log shipping for MSSQL and PGpool and patroni for PostgreSQL.· Executed database migration, refreshing and cloning.· Maintained above 98% score on database CIS (Center for Internet Security) benchmarks.· On-boarded all non-windows database servers (Linux and Solaris) to Active directory authentication (AD Bridge).· Achieved 25% savings on database licensing through containerization and migration to open-source databases including PostgreSQL and MySQL.· Implemented a customer screening and anti-money laundering system by configuring data ingestion from core systems.· Implemented a database activity monitoring solution (Imperva DAM).· Developed ETL pipelines for data ingestions using Apache airflow, SSIS, AWS glue and Data factory. Backup Administration (NetBackup and cloud Backups).· Configured and managed system backups for database and servers using Veritas NetBackup as per backup policy.· Performed quarterly restore for NetBackup backup images.· Monitored backups and handled NetBackup and cloud backups support issues.· Train new staff on NBU procedures.

Kenya

Managed databases, including Microsoft SQL Server, Oracle and MySQL on local data center.. Installed and configured Database Management Systems (DBMS) on both Windows and Linux platforms.Planned and implemented database software upgrades, managing end-of-life stages, new releases, and timely patches.Perform daily tasks, including error checks, monitoring physical resource health (disk space, memory, CPU, etc.) and adjusting performance parameters as needed.Oversaw database instances, involving performance monitoring, optimization, backups, error and alert checks, and providing operating system support.Establish and maintain security measures across all databases, emphasizing authentication, authorization, and auditing. Regularly review and update security policies and procedures.Monitor database performance, identify and resolve bottlenecks using native and third-party tools, and optimize queries and database structures for efficiency.Executed database migration, refreshing and cloning.Implemented high availability and disaster recovery solutions: Oracle Real Application Clusters (RAC) and Data Guard.Collaborate with internal and external auditors and CISO team, documenting resolved and ongoing issues, and overseeing matters requiring management intervention.Offered DBA support for CIC operations in Kenya, Uganda, South Sudan, and Malawi.

Kenya

• Team leader in design, development, and implementation of insurance software solutions in Uganda.• Implement system change requests in accordance with changing client needs and industry requirements.• Systems implementation and conducting of user training sessions.• Organize and coordinate business requirements workshops aimed at collecting, analyzing, and documenting business requirements.• Conduct research and perform testing of new emerging technologies and advise management on the benefits.• Participate in the tender process by responding to requests for information from potential clients.• Prepare and share implementation status reports with the Project Management team and other stakeholders.• • Prepared monthly management report for Uganda system support.

Netbackup 8.1 Administration, Cerification, Attendance Certification

• Discuss the challenges of performing backups in today’s enterprise computing environments. • Describe the functions of the master.

Oracle Workshops 1 & 2, Oracle 10G, Cerificate Of Participation

Activities and Societies: N/A Oracle 10g Training - Workshop 1 and 2 Install Oracle Database 10g and configure a database Manage.

Bachelor Of Science (B.Sc.) Computer Technology., Information Technology, Second Class, Upper Division

Activities and Societies: Christian Union, Institute of Computer Science and Information Technology-ICSIT

Kcse, Secondary Education

Activities and Societies: -History Club, Hockey.