Ihsan ul Haq

Career Objectives:

I am a pragmatic, highly adaptable Oracle database & middleware specialist (OCP) who has the ability to work under pressure and in confidence with colleagues, superiors and customers alike .With over 5 years’ experience, from March, 2013 to present, I am good at analyzing critical issues, challenges and priorities, resolving them in an efficient and resourceful manner through the use of my good communication and experience. I work very successfully without supervision and thrive in challenging environments.

Working in Inbox as Apps DBA/Technical Consultancy from Sep 2016

Provide Support and Implementation on different Clients like

LESCO (Lahore Electric Supply Company)

Nishat Chunian Ltd, Lahore

Peshawar University

Responsibilities:

• Managing backup, performance, etc. of 12 business unit databases of Oracle 11gR2 on Linux 6 64bit

• Technical Support on different versions of EBS R12.2.2 to R12.2.5

• Work on EBS 12.2.2 to 12.2.5 version and DB 10g,11g,12c versions.

• Database & Apps Troubleshooting

• 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.

• Enterprise Manager configuration and implementing the recommendations.

• Installation of Linux Red Hat and create partitions according to Oracle DB requirements.

• Follow SR recommend patches and solutions

• Recover data through Archive on Cold Backup Cloned.

• Applied web logic patches on EBS 12.2.2 to 12.2.5

• Application Cloning on EBS 12.2.2 to 12.2.5.

• ADOP Patching Cycle and OPatch.

Provide Full Support to Client like

Oracle EBS R12.2.4 Implementation at LESCO Lahore.

Dealing with Database Corruption and Space issues

Database Troubleshooting

Installing and Upgrading Oracle Database 11g & 12c

Installation and upgrade of Oracle EBS R12.2.4

Database Security and Access Privileges.

Oracle Patches

Apps and DB Cloning

RMAN Cold and Hot Backup

SOA&BPM server administration

Performance and Tuning of database.

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.

Oracle EBS R12.2.5 Implementation at University of Peshawar

Dealing with Database Corruption and Space issues

Database Troubleshooting

RMAN Backup and Recovery

Performance and tuning of database and application

Patching

Cloning

Technical Support of 11g and R12

Installation and upgrade of Oracle EBS R12.2.5

Solve run time issues

Worked in Bifringence as App DBA from April 2015 to Sep 2016

Oracle EBS R12.2.3Implementation at NADRA Head Quarter Islamabad.

Advised management on long-term strategy, planning, and implementation of new releases of Oracle and related System Software.

Estimating Database size growth (Database Size Management).

Estimating File System Growth (Physical Space Management).

Estimating OS requirement to handle all Application components.

Installation Oracle Linux 7

Installation Oracle Application R12 using Rapid wiz in multi-node architecture.

Build Multiple Test Instance using Oracle Application Cloning Process.

Cloning Oracle application/Database using ADCLONE and Rapid

Up-grad Oracle Application to latest patch level using Maintenance Patch (e.g12.2.2.0 -> 12.2.3).

Configuration of Recovery Manager (RMAN) for Online Backup on SAN Storage

Configuration of incremental Backup on SAN Storage

Backup and Recovery through Tar

Analyzing Schema (Gather Schema Statistics)

Troubleshooting Oracle Application Performance/Tuning Issues.

Performed activities such as Security Management, Space Management User and Responsibility set-up, Performance Tuning & Monitoring, Concurrent Manager Monitor, defining printers.

Maintaining User, System and Custom Profiles.

Used Time Saving Techniques for Applications Patching.

Working as part of a team and providing 24x7 support when required.

Worked in Wizmen System Lahore

Worked in Wizmen System Lahore. (March, 2013 to April2015)

Installations, configuration and maintenance of database and security implementation on multiple platforms.

Working environment (Oracle 10g, 11g, 12c in windows) and can manage databases in Linux and UNIX environment.

Having knowledge of Oracle database backup and recovery and create script for backup and recovery.

Data Migration using data pump, export and import utility.

Provided Oracle database administrative support to different clients.

Migration and up gradation of databases from 10g to 11g, 12c.

Oracle Data guard (10g) configuration on Linux operating system and windows.

Perform backup, recovery using RMAN, Data Pump.

Client Exposure at Wizmen Systems

PRDL (Real Estate). (Lahore)

Divine Developers (Real Estate) (Lahore).

Zaitoon Group (New Lahore City)

Din Group (textile)

Triumphant international (Yum Chinese, Spice Bazar)

Gulistan Group (textile)

Certifications & Computer Skills

OCP 10g ( Certified ) Oracle University Testing ID (OC1128498)

OCA 10g ( Certified ) Oracle University Testing ID (OC1128498)

OCP 11g ( Certified ) Techno-Ed (Pvt) Limited Islamabad, Pakistan

OCP 12c ( Certified ) Oracle University Testing ID (OC1128498)

Apps DBA( Certified) Oracle University Testing ID (OC1128498)

Training & Seminars

Oracle 10g Data Guard Training From Era Soft Problem solution, Peshawar, Pakistan

DBA Oracle 11g, 10g Training from Tecno-Ed Training center, Islamabad, Pakistan.

Oracle 11g Data Guard Workshop at Ora-net Training center,Islamabad,Pakistan

Oracle EBS R12.2.2 Training From Ora-net Training center,Lahore,Pakistan

SOA & BPM Administration Training From Ora-net Training center,Lahore,Pakistan

Education Background

BCS (Hons) from CECOS University of Peshawar, Pakistan

3.15 / 4.00

(CGPA)

2007–2012

Intermediate (Pre-Engineering) from BISE Malakand, Pakistan

1st Division

2003–2005

Matriculation (Science) from BISE Malakand, Pakistan

1st Division

2001–2003

Personal Information

Name:

Ihsan ul Haq

Gender:

Male

Date of Birth:

4th oct 1986

Marital Status:

Married

Present address

Salamat Hostel Behind KFC Barkat Market,New Garden town,Lahore Room#7

Languages:

Can fluently speak read & Write English, Urdu & Pashto

References

Reference will be given on demands

ORACLE (DBA 10g, 11g, 12c)

Cell phone: +92-346*******

Skype id: danial.khan321

Email: ac7jaf@r.postjobfree.com

Contact this candidate