Oracle Apps DBA
International Medical Company
Total years of experience :19 years, 8 Months
Technologies : OEM, Oracle EBS R12 and Oracle DBA
ROLES &RESPONSIBILITIES:
•Having good experience in online and offline Cloning of EBS single node to single node, single node to multi node, multi node to single node and multi node multi node.
•Installation and configuration of ASM environment and configuring ASM disks and disk groups
•Expertise in Application patching using adpatch utility.
•Extensive knowledge of Cloning Oracle R12 Instances using Rapid clone (Online and Offline)
Working Knowledge on up gradation of EBS from 11i to R12.1
•Performance Tuning and Troubleshooting of EBS
•Extensive knowledge of AD utilities like adpatch, adadmin, adrelink, adident, adctrl, admrgpch, auto-config, FNDCPASS etc.
•Managing Oracle EBS through Oracle Application Manager.
•Concurrent Managers service(CMS) and creating Custom Concurrent Managers.
•Creating and managing user profiles and also assigning the responsibilities to the user
Profiles, Printer management
•Implemented custom applications according to requirement of client.
•Compiling forms (.fmb to .fmx) & User Management
Technologies : OEM, TOAD, Oracle DBA.
ROLES &RESPONSIBILITIES:
•Managing the Database configuration
•Control File, Redo log File and Archive Log Maintenance.
•Table space & Data file creation and Maintenance by Adding and Resizing data file if needed
•Creating Users, Profiles Granting Specific Privileges and roles to the Users.
•Managing the user profile and changing the parameter values to control the account.
•Cloning the Database (User Manage, RMAN).
•Database backup daily and weekly basis.
•Configure RMAN catalog database.
•Backup (Hot backup, Cold backup) using RMAN.
•Correcting Corrupted block by using RMAN.
•Refresh the database for Testing Purpose.
•Expertise in monitoring the databases through different tools like OEM.
•Used Expdp/impdp utilities.
•Data Transport (schema level) using Data pump EXPDP and IMPDP.
•Applying Patches Using Opatch (PSU & CPU; RDBMS & Grid)
•Gathering STATS
•Generating AWR report and ADDM report using sql-script.
•Installing, Maintaining and troubleshoot Oracle 11g database on Unix/Linux environment configured on RAW/ASM.
•Daily Monitoring Alert log files, Trace file.
•Creating Oracle Database Using Dbca and Manually, Managing the oracle Instance.
•Managing Undo Data, Implementing Database Security.
•Configuring the Oracle Network Environment.
•Using DDL Statement to Create and Manage Tables and Other Schema Objects.
•Implement all mandatory Oracle recommendations and have stable and bug free environment. (This includes applying patches, parameter changes, upgrades, migrations etc)
•Database Security by enforcing and implementing user level access and resource management.
•Coordinating with other support & development teams (such as OS (UNIX), Storage, Application and network) in environment maintenance.
•Performing database upgrades.
•Performing Export/Import activity based on the client request.
•Performing Point in time recovery for a schema objects/Tablespace using the logical backup.
•Managing Standby databases, including creation, recovery and disaster recovery procedures.
•Establish and Maintain Physical or Logical Backup.
•Performing day to day Database Maintenance tasks such as Database Monitoring, Backups, Space Management, Resource Utilization
•Troubleshoot issues related to Oracle database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
•Created user logins with appropriate roles, dropped login, created groups and granted privileges to users and groups.
•Troubleshooting database related issues.