ICT Officer – Database Administration at Mission for Essential Drugs and Supplies (MEDS)

Position Overview

This position reports to the ICT Manager and is responsible for managing and maintaining the organization's databases to ensure performance, security, and availability.

Key Responsibilities

• Design and implement database schemas, including tables, indexes, relationships, and constraints based on application requirements
• Develop and maintain data models and database architecture to support business processes and applications
• Install and configure database management systems (DBMS) and related tools, setting up database parameters and configurations to optimize performance and meet operational requirements
• Analyze and optimize SQL queries and database performance through indexing, query rewriting, and other techniques
• Use performance monitoring tools to track database performance metrics, such as response times, throughput, and resource utilization
• Develop and implement backup strategies to ensure data is regularly and securely backed up
• Manage and execute database recovery procedures to restore data in case of corruption, loss, or disaster
• Implement and manage access controls, including user roles and permissions, to secure sensitive data
• Enforce database security policies and practices to protect against unauthorized access and vulnerabilities
• Plan and execute data migration tasks, including moving data between databases, systems, or environments
• Integrate databases with other systems and applications to ensure seamless data flow and consistency
• Perform regular maintenance tasks, such as applying patches, performing database health checks, and managing space usage
• Apply software updates and patches to the DBMS to address bugs and security vulnerabilities
• Diagnose and resolve database-related issues, such as performance bottlenecks, connectivity problems, and data corruption
• Provide support for application developers and end-users regarding database-related queries and problems
• Monitor database performance and health on an ongoing basis