profile-img

Zeeshan Jahangir

IT Operations System and Database Manager at United Bank Limited

Dubai, United Arab Emirates

Work Experience

  • IT Operations System and Database ManagerFull Time

    United Bank Limited

    Aug 2017 - Present -7 yrs, 10 months

    United Arab Emirates , Dubai

    • Job Details:⦁ Responsible for smooth operations of Core Banking Application System , Database Configuration and Management, VM Infrastructure deployment and management, Disaster recovery and High availability IT solutions. ⦁ Responsible for Database Installation, Management, High Availability, Disaster Recovery, Backup and Recovery, Performance Tunning and Data Replication for Core Banking System Databases (UAE, BAHRAIN, QATAR, TANZANIA). ⦁ Installation, Configuration of Oracle VM Server and Oracle VM Manager, Creation of virtual Machines, Optimization, Allocation of Storage space, Performance tune-up and Replication of VM configuration to DR VM Server periodically. ⦁ Install/Configure/maintain Oracle Web logic server (Used for SAS Application) ⦁ Implement High Availability solution for Core Banking System Databases using Oracle Real Application Cluster 11g. ⦁ Configured Disaster recovery sites for Core Banking System Database using Oracle Data Guard. ⦁ Configuration of Tape Backup Solution to offload backups to tape media for longer retention. ⦁ Performing database Disaster recovery Drills. ⦁ Cloning Oracle Databases as and when required for replica environment in terms of Oracle Databases/Application servers. ⦁ Perform Oracle database Backup and Recovery (RMAN, Export Data Pump etc.) ⦁ Configure /Implement and Manager Oracle Enterprise Manager to monitor Oracle Databases. ⦁ Engage in proactive performance improvement strategies and performance tuning. ⦁ Install/configure maintain Oracle Application server products (Oracle Forms & Reports and Discoverer used for Core Banking System Symbols application). ⦁ Coordinating with development team and application vendors to resolve system/database issues. ⦁ Install/configure upgrade /maintain OS Red Hat Enterprise Linux. ⦁ Deploy Linux shell scripts for process automation.
  • Senior Database AdministratorFull Time

    Etisalcom Bahrain W.L.L

    Feb 2014 - Aug 2017 -3 yrs, 6 months

    Bahrain , Manama

    • Job Details:Etisalcom Bahrain W.L.L Telecom Company licensed to provide national and global telecom and IT services and a credible alternative, for fully integrated Information Communications Technology (ICT) solutions, including next generation voice, video and data services, in the Kingdom of Bahrain and beyond. Roles and Responsibilities are mention below. • Migrate to Real Application Cluster from single instance Oracle database. • Configure Oracle 11g R2 and My SQL databases on Linux platform. • Add new node in existing Oracle 11g Cluster database. • Delete node from existing Oracle 11g Cluster database. • Configure 2 node Oracle 11g RAC standby database and configured Golden gate replication from primary Oracle RAC cluster database to secondary Oracle RAC cluster database. • Configure Oracle Maximum Availability Architecture (MAA) • Implemented TAF with Oracle RAC to ensure high availability solution. • Implemented and supporting ASM using Oracle 11g R2 on Red Hat Enterprise Linux 5. • Configure RMAN Recovery Catalog for database backup • Implemented Golden gate replication solution from Oracle to Oracle and Oracle to MySQL • Managing My SQL databases on multiple node instances using sand box. • Configured and managing My SQL native replication. • Implement Linux shell scripts to automate the process. • Configured test environment for Oracle RAC, Golden Gate and Mysql Database using VMware Workstation.
  • Senior Database AdministratorFull Time

    Business Analytics

    May 2011 - Jan 2014 -2 yrs, 8 months

    Pakistan , Islamabad

    • Job Details:Working as Senior Database Administrator with Business Analytics on Zain telecom Kuwait/ Iraq projects, managing databases on Solaris operating system. Roles and Responsibilities are mention below. • Implement highly performance Oracle 11g Data warehouse server of size 25 TB for Zain telecom on M5000 machine • Manage Oracle Database Servers to ASM on SAN Storage. • Held responsibility for 30+ databases on Solaris, Linux and Windows environment, providing 24x7 production support services. • Planned and implemented Disaster Recovery site for oracle database using Oracle Data Guard, creating standby logical databases for real time data replication. • Implement online point in time backup and recovery strategy using Oracle RMAN. • Implement 2 node RAC machine. • Installing and configuring OBIEE 11g on SUN SOLARIS 10. • Established database standards, processes and procedures to streamline daily database administration duties. • Maintain SOP for compliance with CMMI level 3 models
  • Senior Database AdministratorFull Time

    Islamabad Stock Exchange

    Jul 2010 - Apr 2011 -9 months

    Pakistan , Islamabad

    • Job Details:Working as Senior Database Administrator / Oracle Team Lead with Islamabad Stock Exchange. Roles and Responsibilities are mention below. • Managing Oracle 10g, Oracle 11g , Sql Server Databases. • Implemented Oracle Dataguard for Disaster Recovery and High Availability (HA) solution, and maintained stand by database for reporting purposes • Performance tuning, troubleshooting & monitoring using ADDM, Statspack reports and Automatic Workload Repository Advisor • Implemented backup and recovery strategies using RMAN, Export/Import • Cloned production database to the test environment using Recovery Manager (RMAN) • Installation, Configuration, Patching and Cloning of Oracle E business Suite R12. • Managing user accounts: Creating users, Responsibility management, profiles.
  • Education

    • Master of Science in Information Technology in Informational and Business Support Systems

      Instititue of Management Sciences

      Jan 2006 - Jan 2009 - 3 yr

    Achievements

    ITIL Certified Prince 2 Certified OCP 12c Certified

    Skills

    Training & Certifications

    • Oracle 12c Administrator Certified Professional

      Oracle·2016
    • Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

      Oracle·2014
    • Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

      Oracle·2014
    • Oracle Real Application Cluster

      Oranet·2013
    • Oracle Golden Gate Certified Implementation Specialist

      Oracle·2011
    Share this Profile