Assistant Database Administrator

Electricity Generation Company (MW) Ltd

Applications are invited from suitably qualified persons of Malawian origin to fill vacant positions in the company.

THE ORGANIZATION

Electricity Generation Company (Malawi) Limited. EGENCO is a limited liability company incorporated under the Companies Act (Cap.46:03) of the Laws of Malawi on 7th September 2016.

The company is wholly owned by the Government of Malawi and was established with the mandate of generating electricity in Malawi. It started its operations on 1 January 2017.

To fulfil its mandate effectively and efficiently, the company now invites suitably qualified and experienced dynamic individuals to fill the following challenging and exciting position in the Company

ASSISTANT DATABASE ADMINISTRATOR (GRADE EG7) – (1 POSITION)

Tenable in the Company in the ICT Department at the Head Office, Chayamba, Blantyre. This post reports to the Data Centre Administrator.

PURPOSE OF THE POSITION

The Assistant Database Administrator (ADBA) shall play a critical role in managing and optimizing the Company’s database systems, ensuring their reliability, security, and performance. The primary purpose is to oversee the administration, maintenance, optimization of database environments to support the Company’s data management needs.

KEY DUTIES AND RESPONSIBILITIES

  1. Administering and maintaining database systems, including installation, configuration, and patching of database software.
  2. Monitoring and optimizing database performance, ensuring efficient query execution, data storage, and resource utilization.
  3. Implementing and maintaining database security measures, including access control, authentication, and encryption, to protect sensitive data.
  4. Designing and implementing backup and recovery strategies to ensure data integrity and availability in case of system failures or disasters.
  5. Managing database users, roles, and permissions, ensuring compliance with security policies and regulatory requirements.
  6. Performing database tuning and optimization, including index management, query optimization, and database schema design.
  7. Troubleshooting and resolving database-related issues, such as performance bottlenecks, data corruption, and connectivity problems.
  8. Planning and executing database upgrades and migrations, ensuring minimal downtime and disruption to business operations.
  9. Collaborating with developers, system administrators, and other IT teams to integrate database systems with applications and infrastructure.
  10. Ensuring data replication between the primary and secondary data centres occurs in accordance with replication protocols.
  11. Be responsible for storage management of all data in the IMIS ecosystem including scheduling of all backups.

EXPECTED COMPETENCIES

  1. Proficiency in database management systems, such as Oracle, SQL Server, MySQL, or PostgreSQL, including installation, configuration, and administration.
  2. Strong understanding of database architecture, data modelling, and relational database concepts.
  3. Experience with database performance monitoring and tuning tools, such as Oracle Enterprise Manager, SQL Server Management Studio, or equivalent.
  4. Knowledge of database security principles and practices, including encryption, access control, and auditing.
  5. Excellent troubleshooting and problem-solving skills to diagnose and resolve database issues effectively.
  6. Effective communication and collaboration skills to work with cross-functional teams and stakeholders.
  7. Ability to work independently and prioritize tasks in a fast-paced environment.
  8. Attention to detail and commitment to maintaining data integrity and confidentiality.

RELATED KNOWLEDGE, SKILLS, AND ABILITIES

  1. Familiarity with database backup and recovery technologies, such as RMAN (Recovery Manager) or native backup utilities.
  2. Understanding of high availability and disaster recovery solutions for databases, including clustering, replication, and failover mechanisms
  3. Knowledge of database replication and synchronization techniques for distributed environments.
  4. Experience with database automation and scripting languages, such as SQL, PowerShell, or Python.
  5. Understanding of database performance monitoring and diagnostic tools, such as Oracle AWR (Automatic Workload Repository) or SQL Server Performance Monitor.

QUALIFICATIONS AND EXPERIENCE

  1. Bachelor’s Degree in Computer Science, Information Technology or a related field.
  2. Aged between 25-35.
  3. Certifications in database administration, such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDBA), or equivalent shall be an added advantage.
  4. At least a minimum of 2 years of experience in database administration roles, with hands-on experience managing enterprise-level database systems.
  5. Proven track record of implementing and maintaining database solutions in complex environments.
  6. Experience with database migrations, upgrades, and performance tuning initiatives.
  7. Knowledge of industry best practices and standards for database management and security.

METHOD OF APPLICATION

Interested persons should submit applications attaching a comprehensive CV, relevant certificates, and names of three traceable referees and these should reach the undermentioned not later than Monday, 9th December 2024.

Acting Director of Human Resources Management
Electricity Generation Company (MW) Ltd
Chayamba Building – Floor No. 4
P O Box 1567
BLANTYRE

***WE ARE AN EQUAL OPPORTUNITY EMPLOYER***