Background

Incorporated under the laws of Zambia in 1999, Zambia Electronic Clearing House Limited (ZECHL) is a reputable organisation which is committed to the provision of efficient, reliable, secure and cost-effective intercompany switching and clearing services. ZECHL is an equal-opportunity employer and will not therefore segregate on any grounds in line with its values. To fulfill part of this mandate, the Company seeks applications from individuals who are suitably qualified for the position below;

Job Summary

To assist the ICT Manager in designing, implementation, monitoring, and maintenance of Oracle databases, and Oracle Golden gate replication across the ZECHL environments. Ensure high availability, performance, security, and integrity of mission-critical data while supporting seamless data integration between systems.

Key Responsibilities

• Install, configure, patch and upgrade Oracle Databases for all ZECHL environments.
• Design, deploy and manage Oracle GoldenGate configurations for real-time data replication between ZECHL systems.
• Monitor and tune databases performance (to also include SQL tuning, indexing, memory and storage management).
• Implement and maintain high-availability solutions (RAC, Data Guard) and support data recovery procedures using online and tape backups.
• Perform backup, recovery, and database cloning (RMAN, Tivoli, etc)
• Administer database security: user management, role-based access, auditing, encryption.
• Troubleshoot replication issues, resolve data conflicts and ensure data consistency across sites.
• Document procedures and configuration details.
• Collaborate with applications teams, infrastructure and vendors for solution design and issue resolution.
• Conduct capacity planning and performance testing on all ZECHL systems in collaboration with other administrators.

Qualifications & Experience

• Grade 12 School Certificate with at least a credit in five subjects that must include English & Mathematics.
• A Bachelor’s degree in Computer Science/IT or equivalent from a recognised institution.
• At least 3 years’ hands-on experience in administering Oracle Databases (11g, 12c,19c), Oracle GoldenGate and Oracle DataGuard.
• Certification in Oracle Database and GoldenGate administration (OCP 12c/19c) will be an added advantage.
• Proficiency with Linux/Unix administration and ability to write shell scripts.
• Must have excellent knowledge in relational databases.
• Must have excellent knowledge in SQL query design and optimisation.
• Must have knowledge and hands on experience in coding in languages including, but not limited to, Java, C, C++, C#, or Python.
• Innovative solution provider, capable of articulating new ideas and changes.
• Must be a multi-tasker, able to work in a fast-paced & changing environment.
• ICTAZ Membership and any other.
• Strong Communication and documentation skills.
• Excellent problem-solving skills and ability to work under pressure.

• Install, configure, patch and upgrade Oracle Databases for all ZECHL environments.
• Design, deploy and manage Oracle GoldenGate configurations for real-time data replication between ZECHL systems.
• Monitor and tune databases performance (to also include SQL tuning, indexing, memory and storage management).
• Implement and maintain high-availability solutions (RAC, Data Guard) and support data recovery procedures using online and tape backups.
• Perform backup, recovery, and database cloning (RMAN, Tivoli, etc)
• Administer database security: user management, role-based access, auditing, encryption.
• Troubleshoot replication issues, resolve data conflicts and ensure data consistency across sites.
• Document procedures and configuration details.
• Collaborate with applications teams, infrastructure and vendors for solution design and issue resolution.
• Conduct capacity planning and performance testing on all ZECHL systems in collaboration with other administrators.

• Proficiency with Linux/Unix administration and ability to write shell scripts.
• Excellent knowledge in relational databases.
• Excellent knowledge in SQL query design and optimisation.
• Knowledge and hands on experience in coding in languages including, but not limited to, Java, C, C++, C#, or Python.
• Innovative solution provider, capable of articulating new ideas and changes.
• Multi-tasker, able to work in a fast-paced & changing environment.
• Strong Communication and documentation skills.
• Excellent problem-solving skills and ability to work under pressure.

• Grade 12 School Certificate with at least a credit in five subjects that must include English & Mathematics.
• A Bachelor’s degree in Computer Science/IT or equivalent from a recognised institution.
• At least 3 years’ hands-on experience in administering Oracle Databases (11g, 12c,19c), Oracle GoldenGate and Oracle DataGuard.
• Certification in Oracle Database and GoldenGate administration (OCP 12c/19c) will be an added advantage.
• ICTAZ Membership and any other.