Job Description
REF. NO. NSSL/DBA/2023 (1post)
Nawiri DT Savings and Credit Cooperative Society Limited (Nawiri Sacco) is a
leading country-wide, fast growing, and licensed DTS (Deposit Taking Sacco). To
achieve the planned growth, the Sacco is looking for qualified and competent persons
to fill the following vacancies:
DATABASE ADMINISTRATOR
Job Summary
Reporting to the System Administrator, the job holder will assist the Administrator
in designing, installing, configuring, monitoring, maintaining, securing, and
improving the performance of databases and data stores.
Core duties and responsibilities
Ensure that the database of the organization comply with the ACID properties
(atomicity, consistency, integrity, and durability).
Provide authentication to the servers and database.
Coordinating with the staff to ensure data security and integrity.
Implementation of database design plans as approved by the administrator to
enable user friendly systems.
Help the users to easily connect with the system and provide essential
guidance in operation of the system; assist the System administrator to refine
the logical model to make user specific data models.
Work in the association of the System administrator to help, develop and
maintain the database to ensure its availability to the users.
Provide with satisfactory solutions on triggers, which might arise in the
system. Managing and testing of backup and recovery plans. Assist the
administrator to recover and retrieve the data in emergency (recovery
control).
Work under the guidance of the System administrator to manage the control
access privileges and permissions and provide locks to certain authenticated
data which is confidential in the interest of the organization.
Help in the upgrades and installing of new DMBS application systems as
required to enable the user to use it with ease.
Provide 24/7 database user support.
Academic Qualification
A University Degree in Bachelor of Science in IT or related from a recognized
University.
KCSE C + and above
SQL Server Administration qualification.
Experience
Two (2) years working experience in ICT area.
Extensive experience writing T-SQL and stored procedures, functions, and
triggers.
Experience in SQL Server Clustering and HA technologies
Proficient with SQL server profiler for monitoring and troubleshooting
database activity and performance.
Ability to work in Windows server 2019 environment and Active directory.
Interpersonal, communication and negotiation skills
Knowledge of Sacco products, services, and policies
Knowledge, skills, and attributes
Analytical thinking and problem solving
Decisiveness & Judgement
Personal Organization
Self-development
Adaptability
Teamwork
Excellent writing and presentation skills
Key Result Areas
Attainment of 99% Databases availability, Database optimization
100% Database security compliance,
Daily and periodic database backups
Zero security breaches in databases