JOB PURPOSE:
To administer, Troubleshoot and maintain availability and performance for all Databases to guarantee seamless and secure data flow between backend databases and the bank applications.
Description
Database Administration
1. Build, configure, and maintain highly available and scalable database management systems environments based on various technologies (IBM DB2, Teradata, Microsoft SQL, and Oracle) to meet applications’ backend requirements.
2. Create, maintain and troubleshoot database instances and ensure their maximum performance for the relying applications.
3. Perform on-going tuning for the database engines, instances and queries to continuously improve databases’ performance and response time to the relying applications.
4. Perform and automate ongoing health checks, performance tuning, resources utilization analysis, and conduct risk assessment exercises for database environments to ensure efficiency, availability and smooth functionality for CIB’s bank services.
5. Apply fixes to remediate security issues, comply with the global security standards (PCI, ISO, etc.), close audit requirements and findings and support the bank strategy for implementing security baselines.
6. Ensure all databases are monitored on 24/7 basis along with logging, alerting, notifications and provide the monitoring team with the monitors, performance indicators and thresholds to be enabled/configured.
7. Apply technology best practices, upgrades, apply vendor recommendations, provide support to the applications’ different teams during troubleshooting and projects and implementations.
8. Ensure and test Databases’ availability in Disaster recovery situations.
9. Ensure all databases are being backed up according to the applications and business requirements along with performing regular restore tests to ensure backup/restore procedures are effective and the backups are valid.
10. Participate in capacity planning and performance trend analysis exercises by submitting regular databases’ performance and utilization reports.
11. Participate in writing technical procedures, run books, documentations for database management systems.
12. Apply service and operation level agreements (SLA/OLA) in addition to abiding to target Key Performance Indicators (KPIs).
Policies, Processes and Procedures
13. Follow all relevant department policies, processes, standard operating procedures and instructions so that work is carried out in a controlled and consistent manner.
Day- to-day operations
14. Follow the day-to-day operations related to own jobs in the IT Infrastructure management department to ensure continuity of work.
Compliance
15. Comply with all relevant CBE regulations, banking laws, AML regulations and internal CIB policies and code of conduct in order to maintain CIB’s sound legal position and mitigate any potential risks.

5. COMMUNICATION & WORKING RELATIONSHIPS
Internal:
 IT Departments
 Data warehouse Department
External:
 IT Vendors