Database Specialist Exadata,Oracle ERP
Government of Abudhabi
Total des années d'expérience :17 years, 10 Mois
dministration of Oracle ERP Release 12i (12.1.2) on EXADATA Machines and 11i RDBMS for ebusiness suites
Managing Some of the Huge Production Environment Datastructure in Business Critical Environment on EXADATA Machines on RHEL 6 and Application servers on SUN-SOLARIS 10
Dataguard configuration of Oracle Application database (RDBMS) 11g and oracle applications stack
JRE Upgrade with latest Patches and authorised certification
Rapid Cloning of Databases and Application Environments.
Configure SSO (Single Sign On) with Oracle EBS
Configure Discoverer Reporting Server
Maintenance of Discoverer Reporting Server
Load Balancing (Hardware for app nodes)
Configure PCP for concurrent managers
Configuring RAC to Non RAC instance and vice versa.
Cross Platform Database migration.
Performance Tuning of Databases (Creating Recommendations via Sql Tuning sets and Advisor) SPM, CPU Caging and CPU Caching
Installation of RAC on different versions (10.2.0.1 to 10.2.0.5) and with latest Grid
Configuration of ASM on RAC and Non RAC Standalone Database.
Infrastructure on 11g (11.2.0.3) on RHEL5 and 6
RMAN configuration for online Database Backups
Export & Import of the Database and Schemas
Administration of MSSQL, BI Databases
Workflow configuration for Oracle Applications
External application tire configuration
24x7 support & monitoring of Database & Applications
Administration of Oracle ERP Release 12i (12.1.1) and 11i RDBMS ebusiness suites.
Upgrade Oracle RDBMS from 10g to 11g latest Release and Application stack to 12.1.3
Managing Some of the Huge Production Environment (6 TeraBytes) Datastructure in Business Critical Environment on HP Superdome Machines and RHEL 6
Upgradation of Oracle Application database (RDBMS) from 10.2.0.3 to 11.2.0.3 and Application stack to R12.1.1
Rapid Cloning of Databases and Application Environments.
Load Balancing (Hardware for app nodes)
Configure PCP
Implementation of DMZ
Configure Shared Application Tier
Configure Discoverer 10g/11i with EBS suite
Configure Oracle Identity Management (OID)/ Oracle Access Manager (OAM) with Oracle EBS suite
Configure Single Sign On (SSO)
Configure Forms Servlet/Socket Mode
Administration of OID and OAM
Adding new Application Tier
Configuring RAC to Non RAC instance and vice versa.
Cross Platform Database migration.
Performance Tuning of Databases (Creating Recommendations via Sql Tuning sets and Advisor)
Installation of RAC on different versions (10.2.0.1 to 10.2.0.5) and with latest Grid
Configuration of ASM on RAC and Non RAC Standalone Database.
Infrastructure on 11g (11.2.0.3) on RHEL5 and 6
Installed Oracle 8i, 9i, 10g, 11g databases on Linux, Unix, HP_UX, Superdoms, AIX and Windows environments.
Expertise Installations, Upgrade and Maintaining RAC DB on the Unix Enviroments
Data Replication using Schema and Table level Streaming
System administration functions like creating users, creating responsibilities and menus.
OPATCH Patching Activity on Database.
Dataguard Installation and Maintenance on Windows and Unix Environments.
Active Datagurad Configuration.
Implementing Disaster Recovery Plan (DR)
Actively involved in Capacity Planning
Datapump for taking export and import.
Oracle Streams configuration table level and schema level Replication.
Configured RMAN for online backups and restore.
Trivoli backup tool for the daily backups and restores.
Monitoring Database growth.
Troubleshooting Database and Application Related issues.
Regular Observation of logs files.
Health check of the Database Space management
Coordinating with Oracle support for troubleshooting major issues via metalink TAR.
Database Refreshing.
Flashback Database with Restore Point.
Installation and configuration of printers on OS and application site
System administration functions like creating users, creating responsibilities and menus.
Analyzing tables and schemas
Defragmentation of the Database objects
Purging of concurrent requests, logs and output files on timely bases..
Monitoring Concurrent Managers.
MWA Configuration with WMS
DMZ configuration with SSL
PCP configuration
Implementation of latest release of Oracle E-Business Suite R12, with Satyam as Implementer, having integrations with various Manufacturing Execution Systems (MES), ensuring timely implementation within Budget.
Maintenance of installed Oracle Applications ERP Release 12.0.4 suite and Troubleshooting. Cloning, Patching, Sysadmin, Troubleshooting. Database administration of production and test instances.
Modules: Oracle Financials, Purchasing and Warehouse.
Environment: Oracle Applications 12.0.4, RDBMS 10.2.0.4
Administration of Oracle Release 12i (12.0.4) and RDBMS 10G(10.2.0.4).
Database upgrade from 10.2.0.3 to 10.2.0.4.
Datagurad Configuration for Disaster Recovery.
Patching on Database and Application environments.
Deploy RUP6 update latest patchset release on Oracle Application Stack.
Used Oracle Applications tools for maintaining applications such as adpatch, adctrl, adadmin
admerge etc.
Configured Oracle Enterprise Manager (OEM).
Installation and configuration of printers.
Cloning with Rapid Clone.
Installation of SOA 10.1.3.4 Suite
Install NLS Arabic language patch
RMAN backup tool has been configured with HP Data protector for taking backups and restore.
Configured and Scheduled weekly and monthly online(hot) and offline(cold) backups.
Database Refreshed and Recovery
HP Data protector configuration setup with Linux Box and SAN storage.
Sysadmin and Applications Troubleshooting..
Managing Concurrent Managers.
Database space management.
Workflow configuration and Administration.
Collecting database performance statistics periodically Diagnostic Reports using RDA.
Handling Security Related issues for both the Environments.
Database administration of production and test instances.
System administration functions like creating users, creating responsibilities and menu.
Coordinating with Oracle support for troubleshooting major issues
Migration of Codes, reports and Forms using migration Scripts
Administration of Oracle 11i and Oracle 11.0.3 Environments.
Rapid Cloning for Oracle Applications Cloning.
Manual Cloning for 11.0.3 Oracle Applications.
Installation of Printers on OS and Application level.
Sysadmin, Troubleshooting.
Patching Activity on Database and Applications.
Collecting database performance statistics periodically.
Oracle TAR Management and Resolution
Designing Backup and Recovery solution of Oracle EBS
Database administration of production and test instances.
System administration functions like creating users, creating responsibilities and menu.
Coordinating with Oracle support for troubleshooting major issues
Migration of Codes, reports and Forms using migration Scripts.
Peregrine Issue tracking system.
Used Oracle Applications tools for maintaining applications such as adpatch, adctrl, adadmin
admerge etc.
Configured and Scheduled Hot and Cold Backups of the Databases.
Administration of Oracle 11i and Oracle 11.0.3 Environments.
Sysadmin, Troubleshooting
Applying Patches on Production, Test and Development Server.
Cloning with Rapid Clone of Oracle 11i Environments.
Database Refreshing.
Manual Cloning for 11.0.3 environments.
Used Oracle Applications tools for maintaining applications such as adpatch, adctrl, adadmin
admerge etc
Handling SLA Level Peregrine Support.
Migration of Codes, reports and Forms using migration Scripts.
Peregrine Issue tracking system.
Interacting with business users across the globe and providing un-interrupted Apps database support.
Configured and Scheduled Online and Offline Backups of the Databases
Database Space Management of production and test instances.
System administration functions like creating users, creating responsibilities and menu.
Coordinating with Oracle support for troubleshooting major issues.
Using Load runner, UserLoad as the third party tools.
Migration of Codes, reports and Forms using migration Scripts.
Control-M Tool for the Job Scheduling Purpose.
Oracle Certified Professional (OCP) on Oracle 11g Database Track Oracle Certified Associate (OCA) on Oracle 11g Database Track Received Oracle Applications version 11.5.* certification from Oracle Co-operation. Received In House tranining on RAC on Linux Platform from WIllshire Institute Hydrabad. ITIL Foundation Certified (2011)