Job Description
Advert No. 2024 – 2
1.1 JOB TITLE: Database Administrator DEPARTMENT: ICT
1.2 REPORTS TO:
Head of ICT
1.3 SUPERVISES:
Assistant Data Administrators
2.0 PURPOSE OF THE JOB
Reporting to the Head of ICT , the job holder will be responsible for managing and administering
multiple MS SQL database systems including back -up, performance tuning, capacity planning,
monitoring critical events and documentation.
3.0 KEY RESPONSIBILITIES/ACCOUNTABILITIES
Managing SQL Server databases through multiple product lifecycle environments, from
development to mission-critical production systems.
Carrying out ETL activities that include data extraction, transformation, and loading.
Ensuring that this external data is cleaned up and transformed to fit the desired format
so that it can be imported into a central repository.
Creating backup and recovery plans and procedures based on industry best practices.
Using existing backups to restore lost information to the system.
Configuring and maintaining database servers and processes, including monitoring of
system health, tuning activities, and ensuring high levels of performance.
Developing strategies and implement solutions for managing back-ups, restoration, and
replication.
Implementing strategies for database high availability and scalability to ensure a smooth
deployment of new services and solutions.
Maintaining data integrity, security, and access - monitoring user access, developing and
maintaining system security in line with standards and ensuring compliance to all
standards and procedures.
Maintaining tuning use tools like SQL Profiler for database tuning. Generating traces,
execution plans, identify performance issues, deadlocks/contention and resolve them.
Applying data modelling techniques to ensure development and implementation
support efforts meet integration and performance expectations.
Proactive housekeeping/archiving and shrinking of databases.
Independently analyzing, solving, and correcting issues in real time, providing problem
resolution end-to-end.
Refining and automating regular processes, track issues, and document changes.
Assisting developers with complex query tuning and schema refinement.
Providing 24/7 support for critical production systems.
Performing scheduled maintenance and support release deployment activities after
hours.
Sharing domain and technical expertise, providing technical mentorship and cross
training to other peers and team members.
Any other duty as maybe assigned.
4.1 Experience
5 years’ and above experience in administering Microsoft SQL server databases in a
financial institution.
Detailed experience writing T-SQL and stored procedures and query tuning on hightransaction systems, SQL Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS) and SQL Server Analysis Services (SSAS).
Experienced in ETL (Extract-Transform-Load) development / data integration.
Experience working with Microsoft Dynamics Nav 2016 ERP will be an added advantage.
4.2 Academic Qualification
Bachelor’s degree in computer science or equivalent field from a recognized University.
4.3 Professional Qualification
Certification in database administration; Oracle DBA, SQL, MySQL or equivalent.
4.4 Technical Skills, General Skills & Personal Attributes
Technical Skills
Proven experience as a Database Administrator with expertise in MySQL
Strong command of SQL and experience with query optimization.
Knowledge of database design principles and normalization.
Familiarity with Microsoft SQL server databases.
Experience in performance tuning, backup and recovery, and security management.
Proficient with SQL server profiler for monitoring and troubleshooting database activity
and performance.
Experience in SQL Server Clustering and HA technologies including mirroring, log
shipping, failover cluster and various replication technologies.
Strong Knowledge of Database Security.
Experience working with Windows server, including Active Directory.
Ability to develop procedure documents and maintain detailed database related
documents.
Innovative approach to work, constantly looking for upgrading the system to more
efficient and effective new technologies.
Ability to communicate ideas in both technical and user-friendly language.
Highly self-motivated and directed.
Keen attention to detail.