Zeeshan Jahangir
IT Operations System and Database Manager at United Bank Limited
Dubai, United Arab EmiratesWork 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 SciencesJan 2006 - Jan 2009 - 3 yr
Achievements
ITIL Certified Prince 2 Certified OCP 12c Certified
Training & Certifications
Oracle 12c Administrator Certified Professional
Oracle·2016Oracle E-Business Suite R12 Applications Database Administrator Certified Professional
Oracle·2014Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator
Oracle·2014Oracle Real Application Cluster
Oranet·2013Oracle Golden Gate Certified Implementation Specialist
Oracle·2011