DataBase Administrator at Equity Bank Kenya

Description

In line with enhancing career progression of staff and to support business growth, we seek to recruit a well-qualified, experienced, self-driven, highly motivated and passionate candidate to fill the following position in Information Technology Department.

Job Purpose

The Database Administrator(DBA) is responsible for the  performance, integrity, and security of the Bank’s information systems’ databases. The DBA provides technical expertise in the design, implementation, and maintenance of database management systems that support Bank’s business and operations. Additional responsibilities include reporting, data input and output, technology management, and end-user training and support. Is responsible for configuring, monitoring, performance tuning, cloning, troubleshooting, and patching the Oracle EBS system.

• Performs Oracle E-Business Suite EBS Applications database administration (DBA) tasks including patching, creating backup and recovery strategies, upgrading, performance tuning/optimization of Oracle EBS systems for recoverability, security, confidentiality, and integrity to ensure that:  (a) EBS applications and database configurations meet Oracle ERP goals, Oracle EBS requirements, and Banks standards; (b) patches are applied on a timely basis; (c) data integrity and security are maintained; (d) backups are performed as scheduled or deemed necessary; and (e) upgrades are made.
• Utilizes (a) Oracle EBS R12 Applications DBA (AD) utilities to perform maintenance of the multi-node e-Business Suite environment with Shared File System, managing and administering Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshooting Workflow Mailer/Notification issues; (b) Oracle Real Applications Clusters (RAC) to maintain a clustered database to provide performance, scalability, and resilience with Oracle Automatic Storage Management (ASM) and Oracle Cluster Ready Services (CRS) in a Linux operating system (O/S); (d) Oracle Recovery Manager (RMAN) and Data Guard for backup and disaster recovery; (e) Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM) Grid Control for proactive monitoring and notification of system status; and (f) Procedural Language/Structured Query Language (PL/SQL) packages, shell, and Perl scripts for task automation.
• Performs administration and maintenance of the Oracle Service Oriented Architecture (SOA) Suite, Oracle Hyperion, Oracle Business Intelligence (OBIEE), and Oracle WebLogic Server to support Oracle ERP system integration with legacy systems.
• Reviews, develops, recommends, enforces, and adheres to database policies and standards for the Bank; these policies and standards include policies and procedures on high availability, replication, archiving, access, and security. Develops new standard operating procedures (SOPs) for Oracle EBS application software installation and configuration including high availability and disaster recovery solutions.
• Proactively monitors, tests, and reports on Oracle EBS system integrity, security, and compliance measures. Identifies opportunities to upgrade or replace software to meet the current and future requirements of business areas and end-users, researching and evaluating potential solutions by coordinating with functional analysts, developers, and other technology personnel within and outside the Bank.
• Recommends changes and participates in the implementation and follow-on management of upgrades or replacements.
• Evaluates critical Oracle EBS security issues (content, internal controls, access levels, etc.) and makes recommendations, such as disaster recovery plans and upgrades to new versions of Oracle EBS R12 or successor releases.
• Communicates and interacts effectively with internal and external business contacts including, but not limited to, other members of the unit/team, other Bank employees (such as managers, supervisors, and support staff), contractors, and vendors.

Qualifications

• A Bachelor’s Degree in Information Technology, Computer Science or a field that provides a strong foundation for successful performance of the DUTIES in this job description.

• Five years of progressively responsible experience in Oracle EBS R12 Applications Database administration including experience working with: (a) AD utilities for maintenance of multi-node e-Business Suite environment with Shared File System, managing Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, and Workflows; (b) maintenance, upgrade and patching of RAC enabled databases, performance tuning, sizing and capacity planning, backup and recovery using RMAN and Data Guard; and (c) administration and maintenance of the Oracle SOA Suite, Oracle Hyperion, and Oracle OBIEE, including Oracle WebLogic Server. Software Implementation and Integration experience that includes Architecture, Analysis, Design and Development.
• Experience with UNIX systems (Solaris and Linux), Shell scripting.
• Good knowledge in configuration, Parameter Tuning, Performance monitoring and troubleshooting of Oracle SOA Suite and OSB 12c.
• Experience in configuring WebLogic admin console and Enterprise management console.
• Experience as WebLogic Administrator with knowledge in clustering, JMS, Connection Pools, J2EE Deployments, Thread Dump Analysis.