Oracle APPS DBA Team Leader
Ghabbour Auto
مجموع سنوات الخبرة :21 years, 0 أشهر
Oracle APPS DBA Team leader, Ghabbour Group:
Roles & Responsibilities:
Leading DBA Team, Project manager for upgrading Oracle EBS 12.1.3 to 12.2.4
- Facilitate projects issues resolution and resolve conflicts as and when they arise.
- Ensure that initiatives align with business strategies.
- Reviewing the demand and collating it for planning and discussion with domain teams.
Filtering and prioritizing the demand before submission to IT teams
Technical Skills:
E-business suite versions (12.1, 12.2)
Apps environment including installation, administration, maintenance, upgrades,
(autoconfig, adpatch, adop -online patching) .
Applications cloning R12.1.3 (manual clone using hot backup, rapid clone, Storage clone)
troubleshooting Apache, Forms, Concurrent Manager, login and database related issues
Experience on patch analysis of application patches including (CPU patch, rollup patch,
maintenance patch and one-off patch).
Experience in taking Physical Backup and RMAN
Performance tuning for database
Good exposure of using Oracle performance tools like AWR/ADDM, TKPROF, SQL Trace.
Database upgrading 11GR2 to 12c
Monitoring tablespace free spaces, re-sizing data files, Alert log, trace files.
Installing and integrate Oracle E-business suite applications with Endeca
Active Data Guard implementation
Fair knowledge in WebLogic administration
Responsible for upgrading from 12.1.3 to 12.2.4 on AIX 6.1
Support IT and business on production incidents
Implemented Disaster recovery plan
Responsible for Data backup schedules (Incremental & deferential & normal), (regular &
critical) on time basis (Monthly - Weekly - daily).
Working as a member in Application Technology Group/ Installation & Configuration Management to support Oracle’s customers globally, and to manage, and resolve Service Requests (SR’s) logged by customers (internally, and externally) on Oracle products. As well as contribute to proactive support activities according to support strategy model, and strategy.
Roles & Responsibilities:
• Owning and resolving problems and managing customer expectations throughout the SR lifecycle in accordance with global standards
• Maintaining product expertise in assigned cluster
• Reducing escalations
• Contributing to knowledge management content creation and maintenance
• Working with development on product improvement programs
Technical Skills:
E-business suite versions (11i, 12.0, 12.1, 12.2)
• Supporting Apps environment including installation, administration, maintenance, upgrades, (autoconfig, adpatch, adop -online patching) .
• Applications cloning 11i & R12 (manual clone using hot backup and rapid clone-fs_clone)
• troubleshooting of Apache, Forms, Concurrent Manager and database related issues
• Experience on patch analysis of application patches including cpu patch, rollup patch, maintenance patch and one-off patch .
• Experience in taking Physical Backup and RMAN
• Good exposure of using Oracle performance tools like AWR/ADDM, TKPROF, SQL Trace, opatch, exp/imp, analyze tables and Indexes
• Worked on database upgrading 9i, 10GR1, 10GR2, 11GR1, 11GR2 and 12c
• Monitoring tablespace free spaces, re-sizing datafiles, Alert log trace files.
• Installing and integrate Oracle E-business suite applications with Endeca
• Installation and administration of Oracle E-business Suite on NT Platform (WIN.2003)
• Implementing for the modules General Ledger, Payables, Fixed Assets, Accounts Receivable, and Purchasing; including uploading data using (SQL Loader, Data Loader, ADI)
• Following up any bugs and solving it through application of patches.
• Maintenance of all Oracle Application modules.
• Upgrading of Oracle Applications.
• Taking backup for the database and oracle applications and setting the strategy for the backup method
• Creation of clones for application from one server to another server (PRODUCTION TO TEST)
• Training of key users on Oracle applications to be able to create and maintain users, responsibilities, menus, and printers and to be responsible of tuning, backup and recover all databases.
• Handling many task into supply chain modules PO, INV, LCM, Costing and OPM Financial
- Financial modules Implementations which includes requirement gathering from business, studying the existing process, documentation of requirements, preparing the functional design specification and detail design specifications, estimating and scheduling the projects also experienced at handling the offshore resources as an Onsite Coordinator
· Installation of the oracle database 8i and 9i.
· Installation of developer6i and its patches.
· Installation of Alpha program.
· Make Troubleshooting of the database problems.
· Make Troubleshooting of alpha program problems.
· Make tuning and recovery for database.
· Design Forms and Reports for customers.
· Handling customer's problems.
· Make data replication between customer branches.
· Make retrieve for customer old data from old programs by sql loader or excel