Job Description
DUTIES AND RESPONSIBILITIES
i.Design database structures and objects including tables, views, procedures, functions, triggers etc.;
ii.Perform database performance optimization and tuning;
iii.Perform administration of systems and databases, server virtualization and server infrastructure;
iv.Manage security aspects to the assigned systems, databases, integrity controls, related records, and documents;
v.Installation, upgrade, and maintenance of software applications and databases;
vi.Maintenance, administration, monitoring, problem management, and production for databases;
vii.Undertaking daily maintenance, testing, backup, and recovery of systems and databases;
viii.Applying patches and upgrade of systems and databases;
ix.Install, configure, operate, upgrade and maintain assigned systems hardware, software and infrastructure;
x.Provide appropriate infrastructure technology solution to support operations;
xi.Provide technical advice and support in problem solving related to DBMS
xii.Contribute to the disaster recovery and business continuity planning process regarding the assigned systems and infrastructure;
xiii.Assist in management of hardware devices, licensing and all programs as assigned;
xiv.Produce database reports when requested; and
xv.Ensure the high-availability of systems and services.
QUALIFICATION AND EXPERIENCE
nafasi za kazia.BSc/BEng in IT/IS/Computer Science/Computer Engineering or equivalent degree from a recognized institution.
b.Working knowledge of MS Windows, Linux and Unix Server platforms;
c.Working knowledge of databases (e.g. MS SQL, PostgreSQL, MySQL, Oracle, etc.);
d.Working knowledge in Clustering, Security/encryption, Fail over management and automatic switch over;
e.System Backup types and administration (full, incremental, etc.);
f.Practical skills in configuring access to file services as Access Control, managing NTFS file and folder permissions, managing permissions for shared resources, determining effective permissions, configuring and managing distributed file system as Distributed File System (DFS) Overview, configuring DFS Namespaces, configuring DFS replication, deploy file sharing services, deploy an FTP server and a web server;
g.Working knowledge in Clustering, Security/encryption, Fail over management and automatic switch over;
h.Practical skills on Database schema creation and management;
i.Practical skills on Performance management and tuning;
j.Knowledge of Storage management techniques;
k.ERP and business knowledge will be an added advantage;
l.Possession of a relevant recognized ICT professional certification will be an added advantage;
m.Practical knowledge and skills relevant to the position will be added advantage.
REMUNERATION: Attractive remuneration Package