Officer – Database Administrator (ICT) at Kenya Revenue Authority (KRA)

Supervisor:       Supervisor – Database Administrator

Supervisee:      N/A

Job Summary:

This role is responsible for Installation and configuration databases, performance monitoring and tuning and securing databases.

Key Responsibilities: 

• Installs, deploys and configures database setups and software platforms
• Monitors database systems performance and address potential issues to ensure services are available
• Carries out database changes and updates during deployments of application releases
• Performs backups and recovery of data in case of incidents
• Implements relevant updates and patches and service packs on databases from time to time
• Implements procedures that will sustain database security
• Ensures optimal utilization of the system resources
• Executes all database system level changes (e.g., initialization parameters)
• Maintains documentation for all database instance parameters and system settings
• Maintains consistent database parameters and system settings across all like instances according to the approved development-to-quality assurance - to-production life cycle
• Executes database data definitions for applications and developer schemas
• Administers appropriate database management tools across all database instances
• Performs appropriate database sizing activities and interface with Third Parties as required
• Provides technical assistance and subject matter expertise to applications developers and Third Party vendor support
• Executes data extraction for reporting as per user request

Academic Qualifications       

Bachelor’s degree in Computer Science, Management Information Systems, Information Technology, Electrical / Electronic Engineering, Telecommunications or any other related field.

Professional Qualifications    

Required Certification

• Certification in Database administration (Oracle & Postgres)
• Red Hat/Unix/Linux Certified Systems Administrator/Microsoft Certified Engineer

The following certifications will be an added advantage:

• COBIT 5
• ITIL
• PRINCE2
• Web Application Servers i.e. Tomcat and JBOSS, Web Logic

Relevant Work Experience Required

• Have at least one (1) year hands-on experience in RDBMS installation, tuning and troubleshooting
• Have working experience in Unix and Windows operating systems

Skills Required:          

• Ability to manage enterprise databases on RDBMS like Oracle, Postgress, MySQL and Microsoft SQL Server.
• Demonstrate ability to diagnose and performance tune databases for optimal performance
• Experience in Programming/scripting languages such as SQL, PL/SQL
• Ability to install and configure Linux/ Windows installations

Key Competencies     

• Excellent listening and communication skills
• Ability to interact confidently with users to establish what the problem is and explain the solution
• Be proactive with good analytical and problem solving skills
• Team player
• Ability to pay attention to details
• Ability to prioritize competing work commitments and deliver on time
• Passion for innovation and creativity
• High levels of integrity
• Ability to work under minimum supervision