Senior Oracle Apps DBA
EG&G Middle East
Total des années d'expérience :21 years, 5 Mois
Installation 12.0.0 version on Oracle Linux 7.3.
Cloning from PROD to DEVL, UAT & TEST.
Monitoring Concurrent Manager, Invalid Objects,
growth of Tables pace etc.,
Patching on 12.2.6.
Helping Technical Consultant, HR Consultant, Finance and SCM consultant related to Error Issue.
Reset the POS.
Retry the POS.
Any New Module added, Adding Patches related to that.
Creating Application Users.
Created Custom Top.
Adding Responsibility to Existing Users.
Applying Database Patches.
Monitoring Performance Related Issues.
Installation of Oracle 12.2.0 Application Server.
Patching(Patch on 12.2.6). Applied Delta 8 patch.
Installation and Configuration of DMZ Server.
Load Ba lancer Configuration.
Cloning(Cloning on 12.2.6)
Installation and Configuration of SOA and Web logic.
Installation of Oracle 11i/12.1.3 Application Server & Apply mandatory patches for the Database and the relevant applications
Perform System Cloning of the ERP to the Test environments
Migrating code, database changes, data and menus to Production
Implementation of Monitoring Tools and Oracle enterprise manager
Troubleshoots with apps teams problems regarding the databases, applications and development tools
Creates and Manages Tickets with Oracle Support
Using Ad Utility maintain Applications.
Maintaining Custom Applications.
Creating Application Users and assigning responsibilities.
Helping Application Developer and Functional Team.
Upgrading From Oracle Applications From 11i(11.5.10.2) to R12
Compiling invalid objects
Manage Concurrent Managers, Forms/Report Servers, Web Servers, registration of reports and forms
Backup.
Maintaining Oracle Instance.
Handling Oracle Database Administration support activities including database storage file, maintenance, backup and recovery of databases, export and import of databases, client / server database connectivity, database security and user privileges.
Designing proper indexing strategy on transaction tables for optimal performance, performance tuning and monitoring of databases, data archiving and purging, troubleshooting and management of production databases and disk space management.
Providing hands on database availability support for about T5-2 production database instances having sizes up to 1 Tera Byte. implementing database shutdown, startup scripts in sync with cold backup & recovery utilities.
Recovering databases from database crash due to loss of data, index, and redo log files.
Implementing Open Database Backups (Hot Backups / Online Backups), Closed Database Backups (Cold Backups / Offline Backups) & converting Database in Archive Log / No Archive Log Modes.
Creating oracle RAC and non RAC databases using ORACLE ASM storage.
Implementing database storage structures using ASM, raw devices, UNIX File systems
Installed Oracle Application 11i and R12
Patching
Cloning
Maintaining Concurrent Manager
Using Ad Utility Maintain Application
Creating Application Users and assingning Responsiblities.
Helping Application Developer and Functional Team.
Upgrade Oracle 10.2.0.5.0 Database to 11.2.0.3.0
•Upgrade Oracle 11.2.0.4.0 Database to 12c
•Installed Oracle 11Rel2 on T5-2 Server
•Clone The Database from previous Cold Backup.
•Installed Oracle 12c on Sun Sparc Server.
•Created Database Link to access data between two different Database Schema.
•Analyze the tables and indexes.
•Rollback the Data from previous day export dump.
•Upgrade Oracle 9i Database to Oracle 12c Database.
•Migrate Oracle 12c Database on Windows Machine to Oracle 12c Sun Sparch T5-2 .
•Migrate Ms Access Database to Oracle Database.
•Created synonyms to access data between schemas within the same database.
•Installed patch 11.2.0.4.0 on 11.2.0.1.0 database version.
•Wrote Procedure to copy data from one schema to another schema automatically.
•Daily Monitor Online Backup and Logical Backup are done perfectly or not.
•Move Indexes from system Table space to Index Table space.
•Created New Database on Sun Fire Server.
•Export Few Rows of one Table and Imp into another Table.
•Migrated Database from SunFire 15k Server to M9000 Server
. Installation of Oracle 12i Application Server.
. Patching.
.Cloning.
.Maintaining Concurrent Manager.
.Using Ad Utility maintain Applications.
.Maintaining Custom Applications.
.Creating Application Users and assigning responsibilities.
.Trouble shoots Data related issues.
• Verify that listener is up.
• Verify that all instances are up.
• Examine the most recent entries in the alert log file for ORA errors.
• Verify that the Database backup was successful.
• Verify that the Database archiving to tape was successful.
• Verify free space in Tablespace.
• Verify all tables have unique primary key.
• Verify that all indexes use an index Tablespace.
• Verify that schemas look identical between Test environment and Production environment.
• Archive all Alert Logs to history.
• Installed Oracle 10g Database (10.1.0.0.0) on Windows 2000.
• Export Tables & Import Tables from one user to another user.
• Created Database link to access Remote Database.
• Installed Oracle 6i Forms, Reports and Oracle Client Software.
• Configure Tnsnames.ora
• Implemented Backup.
• Managing Data files, Control files, Online Redo Log files, Tablespaces, Rollback segments, Undo Management.
• Administration of Tables & Indexes, Index Re-Organization, extent and user management.
• Database Re-Organization.
• Managing Password Security and Resources, Users, Privileges and Roles.
• Implementation of Multi Threaded / shared Servers.
• Implementation of Simple and Advance Replication (Snap Shots).
• Data loading and moving using SQL*Loader, Direct-Load Insert
• Monitoring Overall Administration using Oracle Enterprise Manager.
• Implementation of Open Database Backups (Hot Backups / Online Backups).
• Implementation of Closed Database Backups (Cold Backups / Offline Backups).
• Conversion of Database in Archive Log / No Archive Log Modes.
• Implementation of Logical Backups (Export / Import) using Parameter file, Query based, Direct Export without using Buffer Area, User based, Full Database, INCtype and Cumulative.
• Using of Transportable Tablespaces.
• Implementation Complete Recovery (Archive Log Mode)
• Implementation Incomplete Recovery (Time Based, Cancel Based, Change Based) Procedures.
• Using RMAN in Catalog and No Catalog mode.
• Implementation of Standby Database Server.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Tuning of Buffer Cache, Diagnosing and Resolving LRU Latch contention.
• Tuning Redo Log Buffer.
• Tuning of Database using File Stripping and I/O using FILESTAT.
• Tuning of Rollback Segments, Monitoring and Detecting Lock Contention.
NA
NA
NA