Senior Data Engineer

• Feb 2023 - Present

Temenos Data Lake (TDL) Developer

• Sep 2022 - Feb 2023

✓ Design database systems – The main responsibility is to analyze the needs of an organizationand produce an effective database system according to their needs and specifications. Thisincludes collecting data, analyzing the data, designing algorithms, drawing flowcharts andimplementing code for the logic developed through the algorithms and flowcharts.✓ Develop database documentation – Must write documentation about the system and puttogether both operational and technical manuals. The documentation must include informationregarding changes or improvements to the database as they are implemented.✓ Work with front-end development team to improve applications and establish best practices -Once the databases are ready, and the front-end development is complete, I must work withthe front-end development team to integrate the modules together. Once this is done, theintegrated code must again be tested and any errors must be fixed.✓ Gather user requirements and identify new features.✓ Solve database usage issues and malfunctions.✓ Provide data management support to users.

Database Administrator

• Nov 2021 - Sep 2022

 SQL Server Mirroring and AlwaysOn Availability Group – I participated in the configuration of database mirroring and AlwaysOn Availability Group on MSSQL Cluster Server for disaster recovery and high availability of the Bank’s applications databases which help us to safeguard the database for business continuity. SQL Server Auditing – I configured the Microsoft SQL Server Audit which is a tool built into SQL Server, which can read database transaction logs to provide information about data and object changes affecting the database. Backup and Recovery Strategy – I was involved in the design and implementation of a proper database backup strategy which would facilitate us to have a restorable backup in case of a disaster, resulting in the minimization of data loss. So, a well-designed backup and restore strategy must balance our business requirements for maximum data availability and minimum data loss, while considering the cost of maintaining and storing those backups. Upgrade and Patching of Microsoft SQL Server – At Bank of Kigali, I have been able to upgrade the version of SQL Server and we moved from 2016 to 2019. But also we did the patching from the oldest service pack to the newest (SP3) so that we could get support from Microsoft anytime we needed it. Automation of backups – I have been able to automate the daily backups of MySQL and PostgreSQL databases. Additionally, at the end of the backup, there was a notification email on whether the backup has been completed successfully or with errors. Replication of MySQL databases – I have been able to configure two types of replication of MySQL databases. The first type of Replication was Master to Slave Replication which we configure only when you want the PDC node to be synchronized on DR node or simply it is a one way replication. The second one was Master to Master Replication which we use when we want the two nodes to synchronize on each other. In other words, it is called a circular replication.

IT Application Officer

• Sep 2019 - Nov 2021

 Participating in the design and development of some modules of new applications (Develop software that fully implement business requirements).  Participating in the design and development of new features in the existing Core Banking System (CBS).  Performing adequate unit and integration testing of in-house and vendors’ software and ensure all requirements have been addressed, all basic functionalities work, and errors are handled properly.  Participating in integration of existing software products and getting incompatible platforms to work together.  Maintaining systems by monitoring and participating in correcting software defects.  Translating business and technical requirements, perform complex analysis to develop automation specifications that span more than one business area. Work with business users to understand technical requirements.  Ensuring that systems, processes and methodologies as specified, are followed to ensure effective monitoring, control and support of service delivery.  Documenting system problems and resolutions for future reference.  Creating and Implementing Request for Change (RFC) and adhere to all documented change management process.  Writing and maintaining system documentation (Operational manual for business applications running in Umwalimu SACCO).  Conducting User Acceptance Testing (UAT) to ensure the systems meet business requirements.  Troubleshooting application issues to ensure that they are resolved without causing additional problems.  Providing training to user support staff for developed applications as required.  Providing innovative solutions to business issues or challenges by means of automation.