Responsible for the technical and administration of the company’s database systems, data warehouses and SQL database infrastructure.
Duties:
• Database modelling, Design of physical database schema.
• Database development: Developing database stored procedures, database functions,
• database views, Common Table Expressions, and database Tigger functions.
• Administration of the database including performance monitoring and turning.
• Database Backups and Replications.
• Managing database security and user roles.
• Data migrations between systems. Building Python ETL and ELT scripts. (Building data pipelines )
• Data analytics and building machine learning models
• Data processing of large amount of structured and unstructured data

Projects:
EMIS: Education Management Information System
CEMIS: Central EMIS Data Warehouse,
ACMIS: Academic Information Management System.
https://www.education.go.ug/emis/

Project:
EGP: Electronic Government Procurement
https://egpuganda.go.ug/
Technical skills
Backups: Logical and Physical backups
Replications
Duties:
• Experience designing database structures, indexes, views, partitioning.
• Develop SQL reports that meet client expectations for the application
• Removing the Index bloat Concurrently to improve the performance.
• Query optimization and troubleshooting
• Maintaining custom vacuum strategies at table and db level.
• Performing schema management, database sizing, maintaining privileges.

Duties:
• Data business logic development
• Data visualization using Tableau, Matplotlib, Seaborn
• Data analysis using python