Oracle Database Administrator
Kuwait National Petroleum Company
مجموع سنوات الخبرة :18 years, 0 أشهر
o Installation of Oracle DBA 19c Applied Latest Patch set.
o Installed and configured OBIA which includes ODA and OBIEE.
o Installed and configured Oracle Analytics server.
o Installed and configured OAM for SSO setup.
o Installed and configured OHS as reverse Proxy server.
o Installed and configured Web Center Portal.
o Installed and Configured OUD with Microsoft Active Directory.
o Security Patching for OAM and OVD Products.
o Cloned database from ASM to NON ASM file system.
• Performing daily health check on Databases as well as Oracle Application.
• Work on daily alert related to tablespace, locks, user creation, invalid index, E-business suite request and monitoring services.
• Performing database refresh through cold, hot and RMAN.
• Configured and support of 11g oracle data guard.
• Code migration, patching are also the part of daily activity.
• Installed and configured Oracle EBS R12.1.1 for Production, Development, and testing environment on Linux/IBM platforms.
• Cloned Oracle instance and Oracle EBS instance for Testing, Development and Staging purposes performing regular Refresh process.
• Upgraded HRMS module in 11.5.10.2 EBS.
• Upgrade Application from R12.1.1 to R12.1.3 on Linux/IBM platform
• Working as Oracle RAC Database Administrator. Responsible for Installation, Upgrade, Applying Patches, Cloning, Trouble shooting.
• Cloned Ebiz R12 from single node to multinode node.
• Implemented NLS Stage (Arabic) for Oracle ERP Installation.
• Upgrading Oracle Ebiz Database from 11gR1 to 11gR2
• Installed Discoverer 10g and Integrated with EBS.
• Replacement of New Storage Device, for RAC two nodes with ocfs2.
• Performed patch set upgrade of RAC database from 10.2.0.3 to 10.2.0.5.
• Configured Apex 4.2 with 11g Oracle Database.
• Configured Apex 4.2 with 12c Oracle Database and 11g OFM web tier.
• Configured Advanced Security Option and Oracle database Vault for example TABLESPACE LEVEL ENCRYPTION, COLUMN LEVEL ENCRYPTION and NETWORK LEVEL ENCRYPTION
• Performing daily health check on Databases as well as Oracle Application
• Performing operations like Creation of Users, Session Management, and Granting Privileges to users from Applications.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Deployment of code on production as well as test and Dev instances
• Monitoring RMAN backups
• Performing Point-in-time restores as per customer requests.
• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations.
• Worked with RAC environment.
• Configured Blocking, locks and removal scripts for RAC env.
• Configured Data Guard ( Standby database)
• Performed Data Guard (Standby database) Switch Over activity in PROD.
• Cloning of various Productions on weekly and monthly basis.
• Cloning of instance from single node to single node.
• Cloning of instance from single node to multi node.
• Patch analysis and applying Patches on test and productions.
• Working Tablespace Space issues.
• Working with Oracle on SR’s raised for critical Oracle Errors.
• Installation of Oracle Home and Creation of Database.
• Managing Enterprise Manager Services.
• Creation of DB links.
• Monitoring and Creation of Indexes.
• Monitoring sessions requested by Application team for any locks.
• Performed Switch over Activity in Data guard in Prod
• Configured database from non RAC to RAC.
• RMAN Restoration and Recovery on Different nodes
• Schema refreshes on adhoc basis using export, import and data pump.
• Enabled Simplified Chinese Language for existing E-Business Suite 11.5.10.2 instance
• Implementation of E-Business Suite R12 ( 12.1.1) on AIX 6.1
• Enabled Russian Language for Newly created E-Business Suite R12 (12.1.1) instance.
• Upgraded E-Business Suite R12 from 12.1.1 to 12.1.3
• Upgraded E-Business Suite from 11.5.10.2 to R12.1.1
• Installation of 10g AS and configuring the same environment as Prod
• Working Knowledge in SSO, OID
• Deployment of EAR files from Backend and Frontend.
• Expert in 10G Oracle RDBMS installation on Linux platforms.
• Upgradation of database from 9i to 10g.
• Cloning of various Productions ERP and Non-ERP on quarterly basis.
• Cloning of instance from single node to multi node.
• Cloning of instance from multi node to single node.
• Schema refreshes on adhoc basis using export, import and data pump.
• Working on long running Concurrent requests
• Working on Change requests.
• Performed Single node and multi node Installation on 11.5.9/11.5.10.2
• Schema refreshes on adhoc basis using export, import and data pump.
• Monitoring sessions requested by Application team for any locks.
• Monitoring and taking care of Mount point issues.
• Creation of Database
• Patch analysis and applying Patches on test and Development.
• Well versed with adadmin, adpatch, adrelink, adctrl, adadmin
Client: First Rain
Role: Associate Consultant
Duration: May 2006 - Dec2008
Responsibilities:
• Creation of database schemas, Creating and managing Tablespaces, users, and indexes
• Performing daily health check on Databases as well as Oracle Application.
• Creating users & privileges with appropriate roles and levels of security.
• Managing tablespaces, control file, data file, log file and parameter file.
• Monitoring Alert log
• Monitored the disk space in the operating system and taking necessary actions
• Cloning of various Productions ERP and Non-ERP on quarterly basis.
• Performing Hot and Cold backups.
• Extensive use of Oracle Application maintenance utilities AD utilities
• Monitoring sessions requested by Application team for any locks.
• Monitoring and taking care of Mount point issues.
• Patch analysis and applying Patches on test and Development.
• Creation of Database.
Educational Qualification
Professional: MBA in Systems (2004-06) from New Delhi Institute of Management, New Delhi, approved by AICTE.
Bachelor of Computer Application from Madras University Chennai (Affiliated to Madras University)