Ihsan ul Haq OCP
Senior Apps Database Administrator at Arabian Yemen Cement Co. Ltd.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Urdo -
Topline Score
Bio
Muhammad Tahir OCP Oracle OGG MS-SQL MYSQL AWS DBA
Ihsan is very talented and hard working person
Masood Shah
IHSAN IS VERY DETAIL-ORIENTED AND PRODUCED GREAT RESULTS FOR THE COMPANY..........
Muhammad Tahir OCP Oracle OGG MS-SQL MYSQL AWS DBA
Ihsan is very talented and hard working person
Masood Shah
IHSAN IS VERY DETAIL-ORIENTED AND PRODUCED GREAT RESULTS FOR THE COMPANY..........
Muhammad Tahir OCP Oracle OGG MS-SQL MYSQL AWS DBA
Ihsan is very talented and hard working person
Masood Shah
IHSAN IS VERY DETAIL-ORIENTED AND PRODUCED GREAT RESULTS FOR THE COMPANY..........
Muhammad Tahir OCP Oracle OGG MS-SQL MYSQL AWS DBA
Ihsan is very talented and hard working person
Masood Shah
IHSAN IS VERY DETAIL-ORIENTED AND PRODUCED GREAT RESULTS FOR THE COMPANY..........
Credentials
-
Oracle Cloud Infrastructure Developer 2020 Certified Associate
OracleJul, 2020- Oct, 2024 -
Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate
OracleJun, 2020- Oct, 2024 -
Oracle Autonomous Database Cloud 2019 Certified Specilist
oracleApr, 2020- Oct, 2024 -
Oracle Cloud Infrastructure Foundations 2020 Certified Associate
OracleApr, 2020- Oct, 2024 -
Oracle Database 12c Administrator Certified Professional
OracleApr, 2017- Oct, 2024 -
Oracle Database 11g: New Features for Administrators
OracleSep, 2015- Oct, 2024 -
Oracle Database 10g Administrator Certified Professional
OracleApr, 2013- Oct, 2024 -
Oracle Database 10g Administrator Certified Associate
OracleJun, 2012- Oct, 2024
Experience
-
Arabian Yemen Cement Co. Ltd.
-
Yemen
-
Building Materials
-
1 - 100 Employee
-
Senior Apps Database Administrator
-
Sep 2019 - Present
Responsibilities • Core Database Administration • Oracle Application Administration on multi node Environment • Cloning Oracle EBS R12.2.4 • Applying Online Patching of Oracle EBS R12.2.4 • Coordinate oracle EBS Project with external team • Install Oracle EBS R12.2 on RHEL 6.5 and Oracle Linux 6 • Administer Oracle Production, Development, Test & Training Server • Provide DB solutions to Management for automate the processes • Planning, Scheduling & Manage Logical & Physical Backups • Provide DB support to Development Team • Cloning and Migrating Oracle EBS R12.2.4 • Monitor DB and application Health
-
-
-
Inbox Business Technologies
-
Pakistan
-
IT Services and IT Consulting
-
500 - 600 Employee
-
Apps Database Administrator
-
Jun 2016 - Aug 2019
Provided Support and Implementation on different Clients like LESCO 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.3 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.3 to 12.2.5 • Application Cloning on EBS 12.2.3 to 12.2.5 • Applied Oracle Patches. • Adop Patching Cycle and OPatch. Provided 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 Database Security and Access Privileges. Cold Backup Oracle Patches Apps and DB Cloning RMAN Cold and Hot Backup BMP SOA 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
-
-
-
BiFringence
-
1 - 100 Employee
-
Database Administrator
-
Mar 2015 - Jun 2016
• Oracle EBS R12 Implementation at NADRA Head Quarter Islamabad. • Software/Hardware Requirement: Capacity planning for hardware and software in the configuration and implementation of Oracle Application R12. • 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/Upgrading and Cloning: • 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.0.2.0 -> 12.0.2.3). • Installing Developer 10g, Workflow Builder and other Development tools on Developer machines. • Backups and Disaster Recovery: Implementing Comprehensive Backup/Restore mechanism and data replication. • Configuration of Recovery Manager (RMAN) for Online Backup on SAN Storage • Configuration of incremental Backup on SAN Storage • Backup and Recovery through Tar • Optimization/Performance Tuning: Performance tuning & monitoring of the Oracle Application, Database and Unix kernel parameters • Database Space Management and Pinning Objects • Analyzing Schema (Gather Schema Statistics) • Troubleshooting Oracle Application Performance/Tuning Issues. • Regular Maintenance Activities: • Managing Oracle Applications Security. • User and Data Auditing. • Managing Tablespaces. • Managing Concurrent Processing. • 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. • Logging Technical Action Reports (TARs); applying patches.
-
-
-
Wizmen Systems
-
Pakistan
-
Software Development
-
1 - 100 Employee
-
Database Administrator
-
Jan 2013 - Mar 2015
• Current working at Wizmen System Lahore. (March,2013 to present) • Installations, configuration and maintenance of database and security implementation on multiple platforms. • Current working environment (Oracle 10g, 11g 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. . • Oracle Data guard (10g) configuration on Linux operating system and windows. • Implementation of database auditing OS /Database level. • Perform backup, recovery using RMAN, Data Pump. • Documentation of oracle databases.
-
-
-
Ora-Tech Systems
-
Pakistan
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Database administrator
-
Apr 2012 - Mar 2013
Provided Oracle database administrative support to different clients. • Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, troubleshooting and backup testing. • Moved database Schema changes to stage or production. • Migrated and upgraded databases from version from version 9i,10g to 11g. • Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery. • Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database de fragmentation. • Provided on-call production database support. • Tested and documented some Oracle10g new features, such as duplicate database using RMAN from both disk and tape, setup name server. • Created materialized views.
-
-
Education
-
2007 - 2011
CECOS University of Information Technology and Emerging Sciences
Bachelor's degree, Computer Science
Community
