Innovative Channels Pvt Ltd, Karachi, Pakistan     Oct 2017 – Present
Oracle Core & Apps DBA

RESPONSIBILITIES:
Giving Support and Implementation on different Clients like
People Steel Mill, Karachi
Bank Alfalah, Karachi
Pakistan Stock Exchange, Karachi
NITF, Karachi

•    Apps and DB’s Backup & Cloning
•    Perform Upgrade of Database and Application. 
•    Perform Dataguard activity.Swithover, Failover and solve issues.
•    Designed, configured and maintained backup and recovery policies including RMAN backups and Manual Backup. 
•    Performed Import and Export using Oracle Data pump utilities 
•    Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis. 
•    Used external tables and SQL*Loader to import data from flat files. 
•    Managing backup, performance, etc. of 12 business unit databases of Oracle 11gR2 on Linux 6 64bit
•    Technical Support on different versions of EBS R12.1.1 to R12.2.4
•    Work on EBS 11.0.2 to 12.2.4 version and DB 10.1.0.2 to 11.2.0.3 versions.
•    Database & Apps Troubleshooting and Add OACORE on Application to enhance Application Performance.
•    24/7 & emergency support on site or Remote Support for Production ERP environment.
•    Enterprise Manager configuration and implementing the recommendations.
•    Installation of Linux Red Hat and create partitions according to Oracle DB requirements.
•    Follow SR recommends patches and solutions.
•    Troubleshoot issues regarding the databases, applications and development tools.
•    Plans and implements backup of Oracle Database and also restore and recover Database.
•    Recover data through Archive on Cold Backup Cloned.
•    Configured Custom Top on different versions of EBS
•    Applied web logic patches on EBS 12.2.4
•    Application Cloning on EBS 12.1.1 to 12.2.4
•    Applied Oracle Patches and Apps Patches using Adop Patching Cycle and Hot Patch.
•    VNC Server Configuration and Setting.
•    Monitored database space requirements and adjusted for future needs. 
•    Migrated Database between servers using Data pump Export/Import 
•    Perform database administration tasks as part of a scheduled change management task. 

Inbox Business Consultancy, Karachi, Pakistan                        July 2016 – Aug 2017
Oracle Core & Apps DBA

RESPONSIBILITIES:
Gave Support and Implementation on different Clients like
Liaquat National Hospital, Karachi
NishatChinuin  Ltd, Lahore
Housing Development Finance Corporation Plc, Maldives
Habib Bank Limited, Karachi

Handle 8 Servers of Pakistan’s Largest Bank HBL and giving full support on single handed without any Senior or Junior DBA.

•    Apps and DB’s Backup & Cloning
•    Designed, configured and maintained backup and recovery policies including RMAN backups and Manual Backup. 
•    Performed Import and Export using Oracle Data pump utilities 
•    Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis. 
•    Used external tables and SQL*Loader to import data from flat files. 
•    Managing backup, performance, etc. of 12 business unit databases of Oracle 11gR2 on Linux 6 64bit
•    Technical Support on different versions of EBS R12.1.1 to R12.2.4
•    Work on EBS 11.0.2 to 12.2.4 version and DB 10.1.0.2 to 11.2.0.3 versions.
•    Database & Apps Troubleshooting and Add OACORE on Application to enhance Application Performance.
•    24/7 & emergency support on site or Remote Support for Production ERP environment.
•    Enterprise Manager configuration and implementing the recommendations.
•    Installation of Linux Red Hat and create partitions according to Oracle DB requirements.
•    Follow SR recommends patches and solutions.
•    Troubleshoot issues regarding the databases, applications and development tools.
•    Plans and implements backup of Oracle Database and also restore and recover Database.
•    Recover data through Archive on Cold Backup Cloned.
•    Configured Custom Top on different versions of EBS
•    Applied web logic patches on EBS 12.2.4
•    Application Cloning on EBS 12.1.1 to 12.2.4
•    Applied Oracle Patches and Apps Patches using Adop Patching Cycle and Hot Patch.
•    VNC Server Configuration and Setting.
•    Monitored database space requirements and adjusted for future needs. 
•    Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration. 
•    Migrated Database between servers using Data pump Export/Import 
•    Knowledge of the Oracle Data Guard installation, configuration, troubleshooting.
•    Perform database administration tasks as part of a scheduled change management task. 

ENVIRONMENT:Oracle 11g, databases, Oracle Application Performance, OACORE, Data pump, OEM 11g, Offshore Team, 24/7 on-call support, Linux, TOAD, SQL Developer, VM Ware.

Predictify Me, Karachi, Pakistan   June 2015 – May 2016
Assistant DBA

RESPONSIBILITIES:
•Vertica Installation
•Vertica Projections
•Flex Table
•Oracle Stand By Database.
•Load Data on Vertica Database
•Create Queries and Troubleshoot it
•Dealing with Database Corruption and Space issues
•Installation and maintenance of Application and Database Servers – Oracle E-Business Suite R12.1.1 (Single/Multi Node)
•     (Fresh/Vision Instances) both on Linux/Windows on Physical/Virtual Machines (VMware Esxi 4.0 and other flavors’)
•     User Manage and RMAN Backup
•     Applied Oracle Patches
•Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network
performance, CPU and Memory tuning, IO Load,Huge pages etc).
•24/7 & emergency support on site or Remote Support for Production ERP environment.
•Apps and Db’s Backup & Cloning
•Performance and Tuning of Database EBS and SQL Queries.
•Database Security and User Access & Privileges.
•Managing backup, performance etc of 12 business unit databases of Oracle 10gR2 on Linux 5 64bit
•Database & Apps Troubleshooting
•Enterprise Manager configuration and implementing the recommendations.
•Installation of Linux Red Hat and create partitions according to Oracle DB requirements.

ENVIRONMENT:LINUX, Oracle 10g/11g, Oracle,Vertica DB,AWS, CentOS, Veritas Net Backup

Soorty Enterprise Ltd, Karachi, Pakistan                                        Dec2014 – May 2015
Junior Oracle Apps DBA

RESPONSIBILITIES:
•    Dealing with Database Corruption and Space issues
•    Installation and maintenance of Application and Database Servers – Oracle E-Business Suite R12.1.1 (Single/Multi Node)
•    (Fresh/Vision Instances) both on Linux/Windows on Physical/Virtual Machines (VMware Esxi 4.0 and other flavors’)
•    User Manage and RMAN Backup
•    Applied Oracle Patches
•    Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load,Huge pages etc).
•    24/7 & emergency support on site or Remote Support for Production ERP environment.
•    Apps and Db’s Backup & Cloning
•    Performance and Tuning of Database EBS and SQL Queries.
•    Database Security and User Access & Privileges.
•    Managing backup, performance etc of 12 business unit databases of Oracle 10gR2 on Linux 5 64bit
•    Database & Apps Troubleshooting
•    Enterprise Manager configuration and implementing the recommendations.
•    Installation of Linux Red Hat and create partitions according to Oracle DB requirements.

ENVIRONMENT:Red Hat 6, Oracle, Oracle Application, Linux, Centos, VMware

OA Consultant, Karachi, Pakistan                                        May 2014 – Nov 2014
Junior Oracle Apps DBA

RESPONSIBILITIES:
Give Support to Client like: Lucky Tex Ltd and Cresox
•    Dealing with Database Corruption and Space issues
•    Database Troubleshooting 
•    Installing Oracle Database 10g & 11g
•    Database Security and Access Privileges.
•    Cold Backup
•    Oracle Patches
•    Apps and DB Cloning
•    RMAN Cold and Hot Backup
•    Performance and Tuning of database and SQL Queries
•    Flashback Recovery and Data Pump
•    Create remotely access to Server Pc through SSH, VNC, Winscp& Telnet
•    Installation of Linux Red Hat and create partitions according to Oracle DB requirements.

ENVIRONMENT:Red Hat 6, Oracle, Linux, Windows, Ms Office, Centos, Oracle Application

ORIX Leasing Pakistan, Karachi, Pakistan                                    Feb 2014 – Apr 2014
Internee Oracle Apps DBA

RESPONSIBILITIES:
•    Dealing with Database Corruption and Space issues
•    Database Troubleshooting 
•    Installing Oracle Database 10g & 11g
•    Database Security and Access Privileges.
•    Cold Backup
•    Oracle Patches
•    Apps and DB Cloning
•    RMAN Cold and Hot Backup
•    Performance and Tuning of database and SQL Queries
•    Flashback Recovery and Data Pump
•    Create remotely access to Server Pc through SSH, VNC, Winscp& Telnet
•    Installation of Linux Red Hat and create partitions according to Oracle DB requirements.

ENVIRONMENT:Windows, Ms Office, Red Hat 6, Oracle, Linux, Centos, ERP

Jemidium Technologies, Karachi, Pakistan                        Sept 2013 – Jan 2014
Internee Oracle Apps DBA

RESPONSIBILITIES:
•    Installing and Upgrading Oracle 11g & Oracle Web Logic
•    Performance Tuning.
•    Patching
•    Controlling and monitoring user access to the Database
•    Installing Windows
•    Software & Drivers Download
•    Purchasing of IT Equipment and Computer Devices on requirements
•    Installing Software & Drivers in Operating System
•    Installation of Computer Devices (RAM, Hard Disk, DVD Rom, Etc)
•    Diagnose problem of windows and devices
•    Delivery of computer system & IT Equipment to clients
•    Installing Pc on client side
•    Arranging use & new laptops, computers, computer devices, tablets for clients on requirement
•    Doing Marketing of company services
•    Windows and Linux(RHEL 4.6, 6.0) Installation
•    Creating Partition on Linux OS according to Oracle DBA requirements
•    Backup and Restoring Database.
•    Oracle Form and Reports Designing.

ENVIRONMENT:Windows, Ms Office, Photoshop, Oracle, SQL ServerLinux

EDUCATION:
•    Bachelors in Commerce,         University of Karachi.
•    Advance Diploma in IT,         Academy of Business Computer.
•    Oracle DB OCA, OCP         Training, Ora Tech.
•    Intermediate in Commerce,     National College