Summary
Overview
Work History
Education
Skills
Certification
SEC membership
Iqamaprofession
Personal Information
Timeline
Generic

IRFAN AHMED KHAN

Summary

12+ years of experience in Oracle E-Business Suite, Ellucian Banner ERP and Database administration Working for leading Education sector customer and handled technical roles such as DBA Team Coordinator, Oracle Apps DBA, Oracle RAC DBA, MS SQL DBA, Ellucian Banner DBA and System Analyst Experience on wide range of products such as Oracle E-business suite, Oracle RAC Database Cluster, Ellucian Banner ERP, PostgreSQL DB, Oracle WebLogic application Servers and Microsoft SQL Server Always on Cluster Excellent onsite 24/7 Database Support and maintenance Proactive in identifying issues and make sure services are meeting SLA Oracle Certified Professional Proficient in Installation, configuration, cloning, patching of databases Oracle 11g/12c/19c, Oracle E- Business suite R12.2/R12.1.3 and Ellucian Banner Student ERP Expertise in setup of Oracle RAC, physical standby Dataguard, Oracle ASM, Oracle Multitenant CDB and PDB’s, WebLogic on different platforms Highly skilled in backup, recovery, performance tuning of Oracle 11g/12c/19c and EBS Applications Proficient in working with technical and functional teams Skilled in databases MS SQL servers 2019, 2014, Clustering and Always on feature in MS SQL Skilled in Symantec NetBackup backup/recovery for oracle/SQL databases and flat file systems Well adhere to ITSM/ITIL process like change control, problem management, incident management (ISO 27000)

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Lead DBA

KFUPM
01.2023 - Current
  • Responsible for all aspects of Core/Rac/Application database administration including Installation, configuration, product upgrades, capacity planning, backup and recovery
  • Serves as Database Administrator for 120+ Oracle core databases & supporting E-Business Suite applications
  • Manage and work through Oracle’s (Service Requests) SR escalation process, applying software patches and upgrading the Oracle Applications environments
  • Providing leadership for DBA/APPS DBA Projects
  • Administration of Tape library & backup tools like VERITAS net backup ,Quest net vault & Oracle secure backup
  • Perform off-site Tape Backups activity quarterly for whole Environment
  • Administering & developing framework for remote deployment of patches
  • Installing and administering 10g/11g/12c/19c Oracle databases in various platforms like Unix (AIX, Solaris, HP-UX & Linux) and Windows (2008R2 & 2012)
  • Responsible for both managing and supporting all Production, Development and Staging instances for Oracle Version 10g, 11g, 12c&19c
  • Installing and administering Oracle Golden Gate
  • Managing Data Guard environments
  • Creating duplicate databases using RMAN
  • Applying CPU and PSU patches and upgrading databases
  • Backup and recovery using RMAN, scripts for various database activities, troubleshooting etc
  • Ensuring successful & periodical Backup, Restoration
  • Planning for system growth and monitoring capacity usage for new hardware or software requirements
  • Maintaining Tablespace Management
  • Creation and maintenance of user accounts and granting privileges
  • Performing logical and physical backups
  • Implementing 10g/11gr2/12c RAC setup, Cluster ware installation, DB Binaries, creating ASM instances, and monitoring ASM Databases
  • Configured ASM for several standalone servers and HA domains
  • Monitoring RAC Databases, and creating users and giving privileges to those users
  • Attending the problem and change management meetings
  • Monitoring the production Databases on Daily Basis
  • Monitoring & checking Archive logs files and Primary Database &DR Databases
  • Upgrade databases to latest versions
  • Performing routine checks of space utilization and extended tablespaces by resizing/adding data files when needed
  • Setting up RMAN backups for crucial in-house databases
  • Exporting and Importing data using tools like Exp, Imp and Data pump
  • Upgrading databases and applying patches
  • Refreshing/Cloning of databases from production to development using data pump utility, RMAN and Data Mover utility
  • Troubleshooting customer's database related issues through ticket tracking system
  • Monitoring Level backups Incremental backups, Cumulative backup, Complete backups
  • Design and Implementing DataGaurd setups (Active Physical standby) and monitoring databases
  • Switching the role of Primary database and standby database and Switch over and Switch Back Actives
  • Generating AWR and ADDM report for investigating the cause of performance issue and providing the appropriate solution
  • 10g/11gr2/12c RAC DB installation in OEL platforms on client servers
  • Worked on data guard activities in client's critical High availability domains
  • Restore/Recovery of databases through user managed and RMAN utility
  • Database performance and availability monitoring using Oracle diagnostic logs and notification logs.

Senior ORACLE DBA/APPSDBA

Universal Cold Stores Trading Company Limited
01.2010 - 01.2022
  • Responsible for all aspects of Core/Rac/Application database administration including Installation, configuration, product upgrades, capacity planning, backup and recovery
  • Serves as Database Administrator for 120+ Oracle core databases & supporting E-Business Suite applications
  • Manage and work through Oracle’s (Service Requests) SR escalation process, applying software patches and upgrading the Oracle Applications environments
  • Providing leadership for DBA/APPS DBA Projects
  • Administration of Tape library & backup tools like VERITAS net backup ,Quest net vault & Oracle secure backup
  • Perform off-site Tape Backups activity quarterly for whole Environment
  • Administering & developing framework for remote deployment of patches
  • Installing and administering 10g/11g/12c/19c Oracle databases in various platforms like Unix (AIX, Solaris, HP-UX & Linux) and Windows (2008R2 & 2012)
  • Responsible for both managing and supporting all Production, Development and Staging instances for Oracle Version 10g, 11g, 12c&19c
  • Installing and administering Oracle Golden Gate
  • Managing Data Guard environments
  • Creating duplicate databases using RMAN
  • Applying CPU and PSU patches and upgrading databases
  • Backup and recovery using RMAN, scripts for various database activities, troubleshooting etc
  • Ensuring successful & periodical Backup, Restoration
  • Planning for system growth and monitoring capacity usage for new hardware or software requirements
  • Maintaining Tablespace Management
  • Creation and maintenance of user accounts and granting privileges
  • Performing logical and physical backups
  • Implementing 10g/11gr2/12c RAC setup, Cluster ware installation, DB Binaries, creating ASM instances, and monitoring ASM Databases
  • Configured ASM for several standalone servers and HA domains
  • Monitoring RAC Databases, and creating users and giving privileges to those users
  • Attending the problem and change management meetings
  • Monitoring the production Databases on Daily Basis
  • Monitoring & checking Archive logs files and Primary Database &DR Databases
  • Upgrade databases to latest versions
  • Performing routine checks of space utilization and extended tablespaces by resizing/adding data files when needed
  • Setting up RMAN backups for crucial in-house databases
  • Exporting and Importing data using tools like Exp, Imp and Data pump
  • Upgrading databases and applying patches
  • Refreshing/Cloning of databases from production to development using data pump utility, RMAN and Data Mover utility
  • Troubleshooting customer's database related issues through ticket tracking system
  • Monitoring Level backups Incremental backups, Cumulative backup, Complete backups
  • Design and Implementing DataGaurd setups (Active Physical standby) and monitoring databases
  • Switching the role of Primary database and standby database and Switch over and Switch Back Actives
  • Generating AWR and ADDM report for investigating the cause of performance issue and providing the appropriate solution
  • 10g/11gr2/12c RAC DB installation in OEL platforms on client servers
  • Worked on data guard activities in client's critical High availability domains
  • Restore/Recovery of databases through user managed and RMAN utility
  • Database performance and availability monitoring using Oracle diagnostic logs and notification logs.

Education

B.Tech - Computer Science & Information Technology

Jawaharlal Nehru Technological University
05.2005

Skills

  • Oracle Products
  • RDBMS
  • POSTGRESS
  • Microsoft SQL
  • Oracle Enterprise Manager
  • EBS-R12
  • Oracle Security Manager
  • RMAN
  • Performance tuning
  • ASM
  • Oracle 12c RAC
  • Backup/Recovery
  • Import/Export
  • Data Pump
  • Conceptual design
  • AWR
  • ADDM
  • ASH
  • PL/SQL
  • UNIX
  • SunOS
  • HP-UX
  • Linux
  • AIX
  • Windows 2012
  • Windows 2008R2
  • DBUA
  • DBCA
  • VIPCA
  • NETCA
  • TOAD
  • SQL Developer
  • OEM
  • XManager
  • Vnc
  • Oracle E-Business Suite
  • Oracle Retail Applications
  • Middleware
  • Point Of Sale
  • Store Solutions
  • Weblogic Server
  • Database Upgrades
  • Oracle ZFS
  • IBM Storage
  • Sparc Servers
  • Audit Management
  • Infrastructure Implementation
  • Oracle Instances
  • Application Release
  • Capacity Planning
  • Root Cause Analysis

Certification

  • Oracle Certified Professional (OCP) in 10g Database Administration
  • Oracle Certified Expert in Oracle 10g RAC Administration
  • Sun Solaris 10 – System Administration

SEC membership

Active

Iqamaprofession

Computer Programmer

Personal Information

  • Date of Birth: 01/12/1984
  • Gender: Male
  • Nationality: Indian

Timeline

Senior Lead DBA

KFUPM
01.2023 - Current

Senior ORACLE DBA/APPSDBA

Universal Cold Stores Trading Company Limited
01.2010 - 01.2022

B.Tech - Computer Science & Information Technology

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
IRFAN AHMED KHAN