Database Administrator at National Bank of Kenya

Job Ref No. HR/085/2020

Division: ICT Division

Reporting to: Senior Database Administrator

Position Grade: MG8

Position Scope: The role holder will be responsible for administering, maintaining, developing and implementing policies and procedures laid out to ensure the security and integrity of the Bank’s databases. He/She will ensure seamless flow of information, in view of both backend data structure and frontend accessibility for users.

Key Responsibilities:

• Responsible to create and maintain databases required for development, testing and production usage
• Perform capacity planning required to create and maintain the databases
• Administration of Oracle RAC (Real Application Cluster), Oracle Exadata/DataGuard and SQL Administration
• Maintain database security, integrity and computing resources to comply with Bank and Compliance standards
• Administer all database projects, including tables, clusters, indexes, views, sequences, packages & procedures among others
• Monitor the performance of the database system and implement or recommend the required changes to increase the performance and maximum uptime to ensure seamless service delivery
• Plan and implement backup and recovery of Bank’s databases.
• Storage administration for V7000, DS4700 and Oracle Exadata Storage Cells
• Provide reliable backup services and conduct routine hardware and software audits of AIX servers to ensure compliance to established standards, policies, configuration guidelines, and procedures.
• Disaster recovery planning and implementation in line with Bank policy
• Manage and configure VIO client partitions, devices, V7000 & DS4700 storage.
• Automate tasks involving creation of scripts to run backups and monitor databases.
• Offer 24/7 databases support; provide rapid resolutions to database downtime and escalate issues to line manager & vendor as appropriate
• Ensure to promptly escalate anomalies to procedure or any suspicious activities as per the laid down procedures.
• Adhere to the Division’s service charter and ensure exceptional customer experience
• Any other duties that may be assigned by the supervisor.

Qualifications, Experience, Skills & Personal Attributes:

• A Bachelor’s degree in Information Technology or related field from a recognized university
• Oracle Certified Expert/Oracle Certified Master will be an added advantage
• OCP certification will be an added advantage
• MS SQL certification will be an added advantage
• Apps DBA certification will be an added advantage
• Three (3) years’ experience in a relevant ICT field
• Expert knowledge of physical database design
• Excellent knowledge of Oracle, backups and recovery scenarios
• Knowledge in Oracle RAC (Real Application Cluster), Exadata, & DataGuard Administration.
• Knowledge in Unix and Enterprise Linux administration
• Demonstrable knowledge on OBIEE& other BI tools.
• Proven experience on data warehouse management & ETL processes
• Collaboration; forms partnerships that help drive the Division’s service delivery agenda.
• Multi-tasking; able to manage several concurrent assignments and prioritize demands
• Innovation, flexibility and adaptability; ability to keep pace with latest technology and trends in addition to new delivery expectations.
• Excellent communication skills; articulate in communicating to both internal and external stakeholders
• Analytical; capable of managing numerous information sources and providing appropriate data analysis to relevant stakeholders
• Strong work ethic, exercise of due diligence & confidentiality
• Excellent interpersonal, planning & organizational skills
• Ability to work under pressure and speed of execution
• Proactive and Agile