Database Senior Administrator at Commercial International Bank (Egypt)

Giza, Giza, Egypt -

Full Time

Start Date

Immediate

Expiry Date

09 Jun, 26

Salary

0.0

Posted On

11 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, IBM Db2, Teradata, Microsoft Sql, Oracle, Performance Tuning, Health Checks, Risk Assessment, Security Compliance, Disaster Recovery, Backup And Restore, Capacity Planning, Technical Procedures, Itil Foundations

Industry

Banking

Description

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 Qualifications & Experience:  Bachelor degree of Engineering, Computer science or its equivalent.  Administrator: Minimum 2-4 years of experience in Database administration role Sr. Administrator: Minimum 5-7 years of extensive experience in Database administration role.  Must have profound experience in one or more database administration technologies (Oracle, SQL, Teradata, DB2).  Good understanding of operating systems (Unix, Solaris, MS Windows).  Good understating of storage, networking and security concepts.  Minimum to have one of the following certifications o Oracle Database Administration Certified Professional o Teradata Vantage Certified Administrator o IBM Certified Database Administrator (DB2) o MCSA: SQL Database Administration Skills:  Good command of written and spoken English and Arabic languages.  Good Communication and Presentation skills.  Good analytical and problem solving skills.  Background of ITIL foundations

Responsibilities

The primary role involves administering, troubleshooting, and maintaining the availability and performance of all databases to ensure secure and seamless data flow between backend systems and bank applications. This includes building, configuring, tuning, and securing database management systems across various technologies.