IPOA/HR/05/2021; DATABASE AND SYSTEMS ANALYST, IPOA GRADE 6 (1 POSITION)- (CONSOLIDATED SALARY KES.90,000-130,000)

The Database and Systems Analyst will design and implement ICT systems and database infrastructure and architecture. The position will be responsible to the Head of ICT.

Job Description

Specific duties and responsibilities will entail: –

1. Manage Database on Microsoft SQL Server 2012/2014, tune performance and connections, implement disaster recovery strategies, database security, develop reports using reporting Services and structured query language (SQL) scripting;
2. Implement xRM solutions on the Microsoft Dynamics CRM 2013, 2015 or 2016 platform with entity, security model and web services engineering;
3. Monitor and maintain CRM integrations including technical troubleshooting of APIs and source/target integration points, Microsoft SharePoint setup and management, develop CRM custom workflow assemblies and plug-ins;
4. Integrate Microsoft CRM forms, screens, workflows, plugins and views, workflows and reports around the customer needs to address functionality and usability gaps and where necessary identify hardware and software requirement.
5. Collaborate with end-users to troubleshoot, resolve dynamics CRM issues and execute end user training, acceptance testing as well as system’s technical and user documentation, and provide advisory on utilization of packages, new software applications and programs.
6. Install and configure software packages and/or equipment, resolution of technical issues on windows servers/Linux and databases, and carrying out periodic patching ad upgrades.
7. Track and maintain log matrix for systems and databases process issues and incidents;
8. Develop and submit timely updates and advisories on systems and databases to inform strategic decision.
9. Implement system and database procedures and business continuity processes;

Profile:

1. Must be a citizen of Kenya.
2. Meets the requirements of Chapter six of the Constitution of Kenya (certificates to be presented during the interview).

Job specifications:

For appointment to this position, a candidate must have:

• Bachelor’s degree in any of the following; Information Technology, Computer Science/Engineering, Business Information Technology or Computer Technology from a recognized institution;
• Microsoft Dynamics CRM Certifications MCSE Level with experience is a MUST;
• Extensive experience in SDLC (Software/System Development Life Cycle) methodologies with 2+ years of proven experience in the development and administration of the latest MS Dynamics CRM platform (On premise or Online)
• A good understanding of standard networking protocols and components such as: HTTP(s), DNS, TCP/IP, ICMP, VPN, Active Directory, High Availability and Load Balancing
• Experience in Public Key Infrastructure, IIS, Exchange, SRS and other related technologies to CRM
• Experience in Microsoft SQL Server 2012/2014 database management
•  Professional certifications in ICT such as Certified Computer Network Professional (CCNP, CCNA, MCSE, MCSA, MCSD, Oracle Certified Database Administrator, CISM/CISA or their equivalent qualification from a recognized institution
• Microsoft SQL, MySQL database administration and Microsoft Dynamics Navision certification are added advantage

Required behavioural and functional skills:

1. Transparency and accountability
2. Ethics and Integrity
3. Team player
4. Creativity and innovation
5. Resilience
6. Organization and Planning Skills
7. Dispute Resolution Skills
8. Decision Making Skills
9. Interpersonal Skills
10. Communication Skills
11. Negotiation Skills
12. Analytical Skills
13. Database management skills