Database Administrator

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. 

a)      Install, configure, patch and upgrade Oracle Databases for all ZECHL environments.

b)     Design, deploy and manage Oracle GoldenGate configurations for real-time data replication between ZECHL systems

c)      Monitor and tune databases performance (to also include SQL tuning, indexing, memory and storage management)

d)     Implement and maintain high-availability solutions (RAC, Data Guard) and support data recovery procedures using online and tape backups

e)     Perform backup, recovery, and database cloning (RMAN, Tivoli, etc)

f)       Administer database security: user management, role-based access, auditing, encryption

g)     Troubleshoot replication issues, resolve data conflicts and ensure data consistency across sites

h)     Document procedures and configuration details

i)       Collaborate with applications teams, infrastructure and vendors for solution design and issue resolution

j)       Conduct capacity planning and performance testing on all ZECHL systems in collaboration with other administrators.

a)      Grade 12 School Certificate with at least a credit in five subjects that must include English & Mathematics.

b)     A Bachelor’s degree in Computer Science/IT or equivalent from a recognised institution.

c)      At least 3 years’ hands-on experience in administering Oracle Databases (11g, 12c,19c), Oracle GoldenGate and Oracle DataGuard

d)     Certification in Oracle Database and GoldenGate administration (OCP 12c/19c) will be an added advantage.

e)     Proficiency with Linux/Unix administration and ability to write shell scripts.

f)       Must have excellent knowledge in relational databases.

g)     Must have excellent knowledge in SQL query design and optimisation.

h)     Must have knowledge and hands on experience in coding in languages including, but not limited to, Java, C, C++, C#, or Python.

i)       Innovative solution provider, capable of articulating new ideas and changes.

j)       Must be a multi-tasker, able to work in a fast-paced & changing environment.

k)     ICTAZ Membership and any other.

l)       Strong Communication and documentation skills.

m)   Excellent problem-solving skills and ability to work under pressure.