ORACLE APPS DBA
QATAR MUSEUMS
Total years of experience :15 years, 1 Months
Installation of Oracle EBS 11i/R12 (single/multi node), Upgrade, Patching, Administration AD
Utilities) on Linux/ Windows.
Planning and creating databases manually as well as with DBCA.
Managing logical Backup.
Design Physical and Logical structure of the Database.
Monitoring Rollback Segments, Undo tablespace, temporary tablespaces and taking proper actions.
Checking ALERT logs to know types of bottlenecks recorded during the day if any, and rising to
counter them.
Monitoring the growth of Tablespace and taking proper actions.
Managing Physical backup.
Knowledge of Table Reorganization
Knowledge of Index rebuilding
Ad hoc table creation, Users creation enabling, disabling constraints
Monitoring archiving mount points and datafile mount points
Installation of databases such as Oracle 9i/10g.
Oracle 10g Application Server, Installation, Upgrade.
Oracle E business suite upgrade from 11.5.10.2 to R12.1.3
Oracle E business suite upgrade from R12.1.1 to R12.1.3
Sysadmin, Cloning, Patch application activities on EBS 11i/R12 environment.
Applied database patches using Opatch utility.
Cloning of the Applications using Rapid Clone and Ad clone.
Managing concurrent managers.
Creating users, Responsibilities, Menus and Managing profile option.
Used Oracle application tools for maintaining application like adpatch, adadmin, adctrl, adpatch etc.
Installing and configuring printers from O.S and Oracle application.
Testing and implementing restore procedure for complete and incomplete recovery.
Restoring and performing recoveries without or minimal loss of data.
Database upgradation from 9i to 10g.
Database Cloning and application tier cloning.
Tablespace level Management
Managing tablespaces, adding and resizing datafiles
System Administrator management.
User management
Logical backup
Toad installation
Archive log check
adpatching, ad utilities administration.
Oracle Database administration
Taking backup of the database on a periodic basis (hot/cold) and checking the validity of the backup
by restoring on a separate PC
Database monitoring and maintenance activities which include checking alert logs space
management, undo management, gathering database statistics, database locking issues, creation of
users, schemas, tablespaces and other database objects Maintaining Backup.