Oracle Apps DBA
Al Ghazzawi Group
Total years of experience :16 years, 2 months
Position held: Oracle Apps DBA
Employer: Al Ghazzawi Professional Association.
Duration: Jun 2012 - Till Date.
Position held: Oracle Apps DBA
Employer: Al Ghazzawi Professional Association.
Duration: Jun 2012 - Till Date.
Position held: Oracle DBA/Support
Company: SAIB-Al Istithmar Capital.
Duration: Mar 2011 - Apr 2012.
Position held: Oracle Apps DBA
Client: ALLIANZ LIFE INSURANCE, Minneapolis, USA
Service Practice: Insurance
Period: Jan 2008 to Feb 2011
Role: APPS DBA
Job Responsibilities:
* Installation, Configuration of Oracle Applications 11i and R12 with in-depth understanding of Oracle EBS Architecture.
* Production Oracle Apps DBA support for ERP suite Linux platform.
* 24/7 support includes patching, cloning, performance tuning and documentation.
* Production support shared with off shore resources.
* Resolve performance related issues reported by user community.
* Manage and provide technical support for multiple Production and Development Oracle Applications environments of releases 11i and R12.
* Work on AD utilities, patching and cloning techniques of Oracle Applications environments on single and multiple nodes.
* Applications System Administration and Troubleshooting tasks involving practical knowledge of Parallel Concurrent Processing, Debugging Concurrent Managers and Requests.
* Managing database and applications security.
* Perform tasks involving Multi-Node and Multi-Tier Applications environments.
* Implementation of Oracle backup and recovery using different methodologies.
* Database reorganization, capacity planning, disaster recovery and high-availability.
* Database performance tuning, application tuning.
* Database and Application backup and recovery utilizing netbackup using RMAN.
* Design and Development of PL/SQL Procedures, Functions and Packages.
* Helped design custom data models that integrated with Oracle Applications.
* Ad hoc Reporting as per client's requirement.
* Analysis and Bug Fixing.
* Handling Change requests from Clients.
* Production Support & Meeting SLA's.
* Trouble shooting the errors reported by clients and application users in operations.
* Monitoring Nightly Cycle (online batch cycle) along with B300 Cycle.
* Working on the root cause of the issues reported.
* Enhancements which involve Understanding the requirement, interacting with business users, development, testing and completing all the formalities as per the release management process of the client.
* Educated the application users regarding the application in order to reduce the error count.
* Incidents resolving.
* Deliverables to the client.
* Documenting all the errors reported and fixing them by performing a code change as per client's specifications.
Project # 1:
Project Details:
Position held: Oracle Apps DBA
Employer: Al Ghazzawi Professional Association.
Duration: Jun 2012 - Till Date.
Position held: Oracle DBA/Support
Company: SAIB-Al Istithmar Capital.
Duration: Mar 2011 - Apr 2012.
Employer: Tata Consultancy Services Ltd. Bangalore, India.
Duration: Jan 2008 - Feb 2011.
Position held: Developer
Employer: Research Center Imarath, Hyderabad, India.
Duration: Jun 2007 - Dec 2007.
IT EXPOSURE
Operating Systems - RHEL 5.3, 6.3, UNIX, Windows XP, Windows Vista, Windows 7
KINGDOM EXPERIENCE:
Project # 4:
Client: Al Ghazzawi Professional Association, Jeddah, KSA.
Service Practice: Law firm and Business Group.
Period: Jun 2012 - Till Date
Role: Oracle Apps DBA
Project Summary: Ghazzawi Group's diversified business portfolio includes legal professional services, real estate development and management, construction, manufacturing, franchising, telecommunications and local & international investments.
Job Responsibilities:
• Installation of Oracle Applications 12.1.1 on RHEL 5.3 and 6.3 both fresh database and vision database.
• Upgraded oracle applications from 12.1.1 to 12.1.3 (two test instances and Production instances)
• Installing pre install RPMS related to Linux in order to make the operating system compatible for oracle applications installation.
• Maintenance, Patching, Cloning, Troubleshooting of Oracle Applications e-Business Suite.
• Apply Application and database patches as suggested by Oracle Support.
• Managing Responsibilities and adding responsibilities to users.
• Creating Concurrent requests and managing Cloned Oracle applications 12.1.1 and Databases.
• Applied product specific fix patches, family packs, and maintenance packs -all types of patches -adpatching.
• Custom Top creation for the newly cloned test instances.
• Cloning Oracle Application instances for 11i and R12 releases. Cloning of the Applications using Rapid Clone.
• Patch analysis and application in various tests, development & Production instances & documenting the technical instructions for patch application.
• Creation of DB links between two databases and worked on issues related to DB links.
• Finding long running requests and sessions terminate them if needed.
• Monitoring and supporting day-to-day activities of the production and development databases and work on critical issues.
• Supporting Oracle Applications 12.1.1, production systems and Test instances.
• TAR management with Oracle support.
• Compiling forms/pll, DB invalid objects.
• Applying application and database patches using adpatch and opatch utilities.
• Tablespace Monitoring.
• Managing concurrent managers and application printer configurations.
• Configure, add and maintain application printers.
• Work on functional issues related to different modules (AP, AR, OM etc., ) by following up with oracle support.
• Backing up the database using RMAN.
• Scheduling weekly and monthly DBA tasks and executing them.
• Performance Tuning.
• Document the patches applied in production and test instance, Service request history and all the Issues.
• Maintain issue repository of database and application issues with the root cause and resolution.
Project # 3:
ALISTITHMAR CAPITAL, RIYADH
Client: ALISTITHMAR CAPITAL, Riyadh, KSA
Service Practice: Local and International Brokerage
Period: Mar 2011 - Apr 2012
Role: Apps DBA
Project Summary: ALISTITHMAR CAPITAL is a Saudi limited liability company, and a subsidiary of The Saudi Investment Bank. The company uses AS/400 for creating user profiles and retrieval of the user data.
Job Responsibilities:
• Production Oracle Apps DBA support for ERP suite Linux platform.
• 24/7 support includes patching, cloning, performance tuning and documentation.
• Production support shared with off shore resources.
• Resolve performance related issues reported by user community.
• Manage and provide technical support for multiple Production and Development Oracle Applications environments of releases R12.
• Capacity planning required in creating and maintaining the databases.
• Perform database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Provide technical support to application development teams.
• Troubleshoot with problems regarding the databases, applications and development tools.
• Create new database users as required.
• Responsible for scheduling backup either cold/hot or RMAN.
• Database monitoring and maintenance of production and development databases.
• Creation, Backup and restoration of databases using Oracle utilities like Export and Import.
• Perform ongoing tuning of the database instances.
• Taking backups daily, weekly and monthly of Exchange Server and Application Servers.
• Addressing application user queries incase of issues and breakdown.
• Make sure all the applications are up and running without any issues.
• Document all the procedures, FIR's and Change requests.
Project # 2:
AZL-ASM-VS10 Variable Application - Off shore
Bachelor of Technology Specialized in Computer Science (B. Tech) Year 2007
CVR College of Engineering & Technology; HYDERABAD, INDIA