Oracle Apps DBA
Resume:
Hammad Ul Hassan
Oracle Apps Database Administrator
C-524, Street 11 Sec-31/E Lucknow Cooperative Housing Society.
Karachi, Pakistan Mobile: +92-313******* Email: ************@*******.***
LinkedIn: https://www.linkedin.com/in/hammad-ul-hassan/
PROFILE SUMMARY
Around 5 years of professional experience in Information Technology industry which includes Oracle Applications DBA with hands on in administering Oracle Databases, Tools and ERP Applications.
JOB OBJECTIVE
To take up a challenging role as an Oracle Applications DBA in a world class I.T Organization. Consistently meeting the Organizational goals in tandem with personal growth. In my job, I look for opportunities to learn, grow, practice and deliver while working with a team of highly motivated individuals.
PROFESSIONAL SUMMARY
Extensive experience in managing shared service model which includes Production, Stage, Development Test instances.
Extensive experience in administering maintaining Oracle Applications E-Business Suite 11i and R12 and Oracle Databases 10g, 11g and 12c.
Good hands on experience in executing Patching, Refreshes Upgrades.
Involved in Installation of Oracle Databases on ASM/Non-ASM file systems.
Expertise in Dataguard/Standby setup.
Involved in 11g/12c Grid Infrastructure implementation CRS ASM, RAC databases installation, Upgradation of CRS and RAC Databases. Hands on Experience in working with Non-RAC, RAC environments.
Good knowledge on using Datapump and Physical Backup's like COLD and HOT Backup, Restore and Recovery at different scenarios. Expertise in migration of tablespaces, schemas and huge data across the environments using datapump.
Expertise in RMAN Backup and Recovery, Developed weekly strategy for RMAN Incremental backups and weekly Tape backups. Extensive experience in refreshing core DB instance using RMAN backups.
Involved in Oracle E-Business Suite, Administering Shared APPL TOP Parallel Concurrent Processing.
Familiar with Discoverer, Workflow configurations, Forms and Reports. Troubleshooting Concurrent manager, Apache and Discoverer issues.
Expertise in Oracle WebLogic Installation and Administration. Knowledge of WebLogic Clustering. Basic Knowledge of Oracle BI Installation and Administration.
Experience on Implementation, Maintenance of Oracle Apps R12.2. Expertise in Cloning, Patching using ADOP in 12.2
Ability to work with and listen to customers/users. Capable of self-learning to explore technically. Ability to interact with end users, self-motivated, quick learner and team player with Good communication skills.
TECHNICAL SKILLS
Operating Systems
Windows, Linux (RHEL, OEL, Ubuntu)
Applications
Oracle E-Business Suite, Oracle WebLogic
RDBMS
Oracle 10g, 11g, 12c & MySQL
Tools Utilities
SQL Plus, Export, Import, OEM, TOAD, VNC, Xmanager, RMAN, adop, adadmin etc.
KEY PROJECTS
Organization: Integration Xperts.
Client: United Bank Limited (UBL).
Designation: Oracle Apps DBA
Project Summary: Upgrade Oracle E-Business Suite 12.1.3 to 12.2.8.
Environment: Oracle Database 11.2.0.4, Oracle Apps R12 12.1.3
Responsibilities
Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
Involving in Database and Application performance issues including Weblogic issues.
Database restoration and recovery using RMAN.
Configuring RMAN backups.
Oracle Database installation, Maintenance and support.
Hands on working experience on 12.2 environments.
Experience in Cloning from Single node to Multi Node. Non RAC to RAC.
Expertise in Oracle Apps 12.2 Patching using ADOP.
Create and Configure Oracle learning management with Content Server.
Implement Oracle E-Business Suite High Availability Environment with Load Balancer.
Involved in Installation and Configuration of ASM, Migration of Non-ASM Databases to ASM. Implementation of Oracle RAC.
Installed and Configured Oracle Weblogic for Oracle Utility Applications.
Experience in Oracle Weblogic Clustering.
Organization: Integration Xperts.
Client: JS Bank Limited.
Designation: Oracle Apps DBA
Project Summary: Support on Oracle E-Business Suite 12.2.
Environment: Oracle Database 12c, Oracle Apps R12.2
Responsibilities
Worked on Maintenance, Support, Patching and Cloning using Rapid Clone.
Involving in Database and Application performance issues including Weblogic issues.
Database restoration and recovery using RMAN.
Configuring RMAN backups.
Involved in CPU Patching, DST Patching and Mass patching.
Involved in Database related activities like Refreshes, Patching, DB Performance issues.
Managing in creating the SR's and Efficiently involved in transferring the SR's across other teams and getting the work done.
Managing OWC sessions across Customers and Other team members.
Communicating with the Team members very frequently, effectively involving in the work and making sure to complete within the requested time.
Effectively sharing the work across Team members. Taking responsibility of allotting work and making sure of all the SR's in the queues were addressed.
Organization: Innovative Channels Pvt. Ltd.
Client: Pakistan Stock Exchange.
Designation: Oracle Apps DBA
Project Summary: Oracle Apps Maintenance Support, Refreshes Upgrades.
Environment: Oracle Database 10g, Oracle Apps 11i
Responsibilities
Support and maintenance of 11i and R12 Applications.
Regular maintenance works and Configuration tasks Such as Patching, Performance Tasks etc.
Involved in performance issues related to DB MT.
Involved in Database related activities like Refreshes, Patching, DB Performance issues.
Performed complete Patch Analysis and application of Apps and DB Patches.
Successfully completed Oracle Applications upgrade on Test instance from 11i to R12.
Involving with the Support/Development Teams for getting any workarounds on issues.
Clones/Refreshes of 11i instances.
Effectively managing the Standard process flow and maintaining Customer satisfaction.
Managing OWC sessions across Customers and Other team members.
Communicating with the Team members very frequently, effectively involving in the work and making sure to complete within the requested time.
Effectively sharing the work across Team members. Taking responsibility of allotting work and making sure of all the SR's in the queues were addressed.
Effectively involving in managing Post refresh documentation as per Customer requirements.
Organization: Innovative Channels Pvt. Ltd.
Client: Peoples Steel Mills.
Designation: Oracle Apps DBA
Project Summary: Oracle E-Business Suite Database Upgrade 11g to 12c.
Environment: Oracle Database 11g, Oracle Apps 12.1.3
Responsibilities
Upgrade Oracle EBS Database from 11g to 12c.
Regular maintenance works and Configuration tasks Such as Patching, Performance Tasks etc.
Daily 24/7 active support for Prod and Non-Prod environments.
Analysis and application of Apps and DB Patches and adadmin activities.
Involved in Database related activities like Refreshes, Patching, DB Performance issues.
Performing SYSADMIN tasks.
Performing Pre-Patch Analysis for multiple patches.
Merging the patches using admrgpch.
Involving with the Support/Development Teams for getting any work arounds on the issues.
Effectively Following the Post Refresh Documentations.
Effectively managing all the Front-end tasks.
Managing in creating the TAR's.
Effectively managing the Standard process flow and maintaining Customer satisfaction.
Involving with the Support/Development Teams for getting any work arounds on the issues
.
OTHERS PROJECTS
Organization: Innovative Channels Pvt. Ltd.
Clients: UBL Fund Manager, MCB Arif Habib, FedEx, Silk Bank etc.
Designation: Oracle Database Administrator
Project Summary: Oracle Databases Maintenance Support.
Responsibilities
24x7 DBA support
Tablespace maintenance like adding and resizing datafiles.
Maintaining, Administering of Oracle Databases and Applications.
Schema backups using export and import utilities.
RMAN backups. Incremental and Full.
Monitoring DB alert log errors, Tablespace usage, Locks in a Database.
Patch Analysis and Patching.
AD utilities adpatch, adadmin, adctrl etc.
Involved in System Administration tasks.
Cloning of the Applications using Rapid Clone.
Created/Maintained Technical Notes and Documentation.
Scheduling and managing CRON jobs.
Monitored and performed daily incremental backups, weekly backups using RMAN.
Implement Oracle Data guard setup in test environment.
Implement Heterogeneous Services to migrating data from SQL Server to Oracle.
EDUCATION & TRAINING
Virtual University of Pakistan
Bachelor in Computer Science.
Quaid-e-Azam Degree Boys Collage.
Intermediate in Pre-Engineering.
CERTIFICATION
LinkedIn - Oracle 12c Database: Administration.
LinkedIn - Oracle Database 12c: Security.
REFERENCE
Name
Organization
Position
Contact No
Syed Hammad Shah
System Limited
Advisory Software Engineer
Jamal Bakhshi
Innovative Channel Pvt. Ltd
Senior Oracle Apps DBA
Khawer Saleem
State Bank of Pakistan
Assistant Director of ISD
Contact this candidate