Oracle DBA Consultant
SIBCO-(PEPSI)
Total years of experience :18 years, 3 Months
Designed and implemented the virtual database and Linux O.S architecture of the entire ERP and Reporting system as per the
company requirement, keeping into consideration factors like user friendliness, High Availability and optimal performance.
Suggested the Hardware Sizing.
Installed, upgraded and Migrated Multiple Oracle 9i, 10g, 11g, 12c and SQL Server database and oracle client wherever applicable
with various level of complexities including installation of database over 13 separate LUNS on SAN.
Installed and Administers Oracle 12c RAC instances
Managed daily Replication from 11 branches to head office
Proactively monitored around 22 database instances for any minor/major issues and resolved them, good experience in effective
liasion with Oracle Support to resolve any sophisticated issues in small time frames.
Proactive and reactive performance tuning at all levels-O.S, Database, SQL, Application and Hardware.
Reorganizes tablespaces online and offline, defragmented partitions at regular intervals.
Installed, Configured and Maintains Hot Standby(DATAGUARD) as part of the Business continuity strategy
Successfully performed 4 instances of Production DB Recovery, including a scenario wherein a downgrade of the entire
production database was required.
Suggested the appropriate backup procedure suiting Company environment so as to achieve a lower RTO in the unlikely event of
a database crash.
Administered and maintained backups of a multitude of database and file system using Veritas Netbackup and DataProtector and
perform backup health validation exercises.
Actively participate and contribute efforts towards issue resolutions for tasks to be performed within the virtual environment like
joining Virtual Linux Machines to domain, integrating with active directory, determine root cause by analysis of VM failure etc.
Undertook the entire system Administration tasks for Redhat Linux Operating System including SAMBA, FTP and VNC.
Knowledge of many activities on VMWARE environment like creating VM, Cloning, moving machines using vmotion,
establishing network connectivity, suggesting appropriate usage of the Virtual environment, etc.
Manage basic Administration of multiple COGNOS Business Intelligence servers
Installed, configured and administered Likewise/Centrify to enable Linux Servers to be joined to the Domain so users can directly
get authenticated from domain.
Administers and Manages AEOS Nedap Application for access control and migrated data from Oracle to SQL Server Database.
Installation of Oracle Applications E-Business Suite R12 (12.0.4, 12.0.6, 12.1.1) for
Multi Node, Shared Apps Tier.
Upgrading to 12.0.6 from 12.0.4 by applying CU2 Patch.
Monitoring the Instance on daily basis
Setting up new Users and Profiles.
Monitoring Application Services and Performing Checks.
Managing Concurrent Processing.
Creating Custom Top.
Cloning: Rapid Clone.
Cloning the Oracle R12 production instance for Dev, Test and UAT environment.
Applying Patches
Patching the R12 instance for product enhancements, resolving bugs etc.
Using adpatch, adctrl, adadmin, adconfig and other Ad utilities.
Creation of Custom Concurrent Managers, Assigning Workshifts.
Assigning Programs, Reports to Specialized Concurrent Managers.
Planning for the backup-recovery strategy for the whole Oracle E-Business Suite
Enhancing the Oracle Applications performance as and when required.
Setting up the Statspack for gathering the applications performance data
Configured Workflow mailer Notification
Analyzing the instance using reporting tools like ADDM, AWR, ASH etc.
Troubleshooting various applications issues/problems.
Licensing new Applications Modules and applying latest Family Pack Patches
Helping and coordinating with Oracle Functional and Technical (developers) team members resolve applications problems.
Liaison with Oracle-Support services to resolve technical issues.
-Installation of Oracle Applications E-Business Suite11i, 11.8/9/10.2 for
Single Node, Multi Node, Shared Apps Tier.
-Upgrading to R12, using DBUA and applying maintenance pack patch.
-Monitoring the Instance on daily basis
-Setting up new Users and Profiles.
-Monitoring Application Services and Performing Checks.
-Managing Concurrent Processing.
-Cloning: Rapid Clone.
-Cloning the Oracle 11i production instance for dev, test and UAT environment.
-Applying Patches
-Patching the 11i instance for product enhancements, resolving bugs etc.
-Using adpatch, adctrl, adadmin, adconfig and other Ad utilities.
-Creation of Custom Concurrent Managers, Assigning Workshifts.
-Assigning Programs, Reports to Specialized Concurrent Managers.
-Planning for the backup-recovery strategy for the whole Oracle E-Business Suite
-Enhancing the Oracle Applications Performance.
-Setting up the Statspack for gathering the applications performance data
-Troubleshooting various applications issues/problems.
-Licensing new Applications Modules and applying latest Family Pack Patches
-Maintained Oracle Applications with AD Utilities.
-Involved in Applications System Administration activities like setting up of profile options and printers, creating and managing users and their responsibilities, menus, functions etc.
-Helping and coordinating with Oracle Functional and Technical (developers) team members resolve applications problems.
-Liaison with Oracle-Support services to resolve technical issues
Continuously updating and following the CHECK-LIST to proactively manage the production environment.
Installing of oracle 10g on Linux platforms.
Creating database manually and using DBCA.
Regularly monitoring ALERT logs to know types of bottlenecks recorded during the day and if any, and rising to encounter them.
Monitoring daily backups.
Managing Tablespaces, adding new datafiles and Monitoring on a regular basis.
Managing Rollback segments, Control file, Data files, Log file and parameter file.
Creating Users and allocating Space and Privileges to Users.
Familiar with RMAN scripts for Backup & Recovery using RMAN.
Performing disaster recovery.
Troubleshoot problems related to Oracle Database.
Gathering statistics for CBO