​

1. Database Architecture & Platform Design

• Design and maintain database architectures aligned to ABC’s microservices-driven platforms.
• Implement database-per-service patterns while ensuring interoperability across services.
• Support multi-tenant data models to enable multiple financial institutions on a shared platform.
• Define and enforce data standards, schemas, and governance frameworks.
• Optimize databases for high-volume transaction processing (millions of daily transactions).

2. Core Database Administration

• Install, configure, and manage on-premise database infrastructure in compliance with Bank of Uganda (BoU) guidelines.
• Administer production, UAT, DR, and development environments.
• Ensure 24/7 availability of critical systems.
• Perform patching, upgrades, and lifecycle management of database systems.

3. High Availability, Resilience & Disaster Recovery

• Design and manage high availability (HA) setups including clustering, replication, and failover.
• Implement and maintain Disaster Recovery (DR) sites with defined RPO/RTO targets.
• Conduct periodic DR drills and failover testing.
• Ensure zero/near-zero downtime for critical transaction systems.

4. Performance & Scalability Optimization

• Monitor and tune databases to support high-throughput, low-latency financial transactions.
• Optimize queries, indexing, and execution plans.
• Implement partitioning, sharding, and caching strategies.
• Continuously improve performance to support growing agent, merchant, and institutional volumes.

5. Security, Compliance & Audit

• Implement robust data security controls (encryption at rest and in transit, RBAC, masking).
• Ensure compliance with:
• Bank of Uganda (BoU) regulations
• National Payment Systems Act
• Data Protection and Privacy Act (Uganda)
• Maintain comprehensive audit logs for all database activities.
• Support internal audits, regulatory inspections, and external audits.

6. Microservices & Data Integration

• Enable data exchange across services via:
• APIs
• Messaging systems (e.g., Kafka, RabbitMQ)Event-driven architectures
• Support event sourcing, CQRS, and event streaming pipelines.
• Manage schema versioning and backward compatibility across microservices.
• Ensure consistency in distributed data environments.

7. Backup, Recovery & Data Integrity

• Design and manage automated backup strategies.
• Perform regular backup validation and restoration testing.
• Ensure data integrity and consistency across systems.
• Maintain secure, compliant backup storage (on-premise).

8. Monitoring, Automation & Observability

• Implement and manage database monitoring and alerting systems.
• Automate routine DBA tasks using scripts and configuration management tools.
• Support observability frameworks across distributed services.
• Proactively detect and resolve incidents.

9. Collaboration & Technical Support

• Work closely with:
• Software Engineers
• DevOps Engineers
• Product Teams
• Integration Partners
• Provide guidance on database design and best practices.
• Support incident management, root cause analysis, and post-mortems.