Oracle APPS DBA
Resume:
SARAS CHANDRAN S R
MOBILE: 469-***-**** EMAIL: **********@*****.***
Objective
A position as an Oracle Application Database Administrator in the IT industry with my ability to quickly learn technology and implement in the shortest period and also manage Application and Database with higher uptimes.
Career Summary
An Oracle Application DBA having IT experience of more than 9 years in the field of Oracle DBA and Oracle Application DBA.
Oracle Certified Associate in 10g Database administration.
Extensively worked on Oracle Applications 11i, R12 E-Business Suite, Oracle 9i, 10g & 11g Databases, Oracle 10gAS in Production Environment.
Involved in several major Oracle Application Database Administration like Migration, Cloning, Patching, Maintenance and Optimization of application usage.
Involved in all major Database Administration activities like Installation, Up-gradation, Creation, Maintenance, Patching, Optimization and RAC.
Involved in installation, maintenance and administration of Oracle Transportation Management, (OTM), Oracle Golden Gate, ADF, Demantra
Excellent Communication and Interpersonal skills
Technical Skills
Oracle Technologies: Oracle Application version (11.x, 12.x), Oracle Database (9.x, 10.x, 11.x), Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Oracle Data Guard, Oracle Golden Gate, Oracle Transportation Management (OTM), Flash Recovery Area (FRA),
Operating Systems: SOLARIS 10/9/8, LINUX 6/5
Languages: Unix Shell Scripting (Very strong), SQL, PL/SQL
Remote Accessing S/w: Telnet, Putty, VNC
Others: Oracle RAC, Discoverer, Golden Gate, OTM, Dataguard, Demantra, ADF, SQL*Loader, Oracle DataPump, Export/Import, SQL Developer, Data Guard, TKPROF, EXPLAINPLAN, AWR, WinSCP, Golden gate, Workflow.
Qualification & Certification
Bachelor of Technology in Electronics and Communications from Cochin University of Science and Technology Kerala
Oracle Certified Associate.
Professional Experience
Accenture Services Pvt. Ltd Feb 2006 - Till date.
1.Project: AT&T Apr 2014 – Till Date
My responsibility is to maintain the Oracle applications and databases. I am taking care of different projects along with supporting more than 60 oracle application environments. I have the responsibility to support all the instances and provide assistance to the markets and users in case of any issues.
Overall Roles and Responsibilities
Installed Oracle APPS 12.1.3 on RHEL6 platform
Upgraded Oracle Database from 11.2.0.2 to 11.2.0.4
Migrated Oracle Ebiz Suite R12.1.3 from Solaris to Red Hat Enterprise Linux platform
Installed new database (11.2.0.4) as per user requirement
Shared APPL_TOP setup.
Upgraded JDK/JRE in Application (10.1.2 and 10.1.3) and Database tiers.
Performed DR exercise.
Set-up and actively administered/maintained standby databases
Installed and maintained OTM (Oracle Transportation Management)
Installed Demantra, ADF.
Installed and maintained Oracle Golden Gate.
Performed SSO setup
Prepared scripts using shell and sql to monitor database and application status.
Automated cloning process using shell/sql scripts.
Analyzed and applied latest Oracle PSU patches.
Analyzed and applied latest Inter-Operability patches.
Actively used datapumps (expdp and impdp) for large tables.
Configured and Managed Concurrent managers including PCP.
Configured and administered Workflow Notification Mailer.
Actively used AD utilities.
Actively used Oracle Enterprise Manager.
Troubleshooting application, UNIX and database problems.
Supporting Oracle SR for technical and functional issues.
Analysis of long running jobs and provides suggestion to the users on the action plan.
2.Project: AIES Sept 2013 – Mar 2014
As an Oracle APPS DBA, I have the responsibility to install, upgrade and maintain Oracle Application. I also have the responsibility to do the migration of data from one instance to another.
Overall Roles and Responsibilities
Installed Oracle APPS 12.1.3 on RHEL6 platform
Upgraded database from 11.1.0.7 to 11.2.0.3
Applying application patches.
Migration of data using datapump utilities.
Configuring and maintaining Concurrent managers.
Troubleshooting long running programs.
Minor performance tuning of sql queries.
3.Project: AT&T Mar 2011 – Aug 2013
As an Oracle Apps DBA, my responsibility is to maintain the Oracle applications Ebiz and databases. I am supporting more than 60 oracle application environments. I have the responsibility to support all the instances and provide assistance to the markets and users in case of any issues.
Overall Roles and Responsibilities
As an Oracle Application Administrator,
Supporting more than 60 Oracle application instances out which 4 are in multi tier environments.
Regular cloning and refreshing (netapp and non-netapp) of Oracle Application in multi tier model and single tier model.
Applying application patches.
Configuring Workflow.
Upgrade and Configure discoverer in 10g BI.
Configuring and Managing Concurrent manager.
Resolving workflow and discoverer related issue.
Creating Application users and responsibilities as per requirement.
Troubleshooting application, UNIX, printers and database problems.
Supporting Oracle SR for technical and functional issues.
Analysis of long running jobs and provides suggestion to the users on the action plan.
As a Database Administrator,
Online Customer Supporting for Databases sizing from 20GB to 16TB.
Installation and upgrading of Oracle Software and at Development and Production Environments and troubleshooting the day to day problems.
Troubleshooting of database/software for bugs and applying patches as required.
Configuration of Database parameters for optimal performance.
Monitoring Databases for fragmentation and storage management.
Maintaining the Partition tables and there global/non-global indexes and External Tables
Regular re-org of huge segments and regular tuning of database for optimal performance.
Analyze and advice on capacity planning based on transaction volume and growth of the database.
Perform periodic backup and recovery of the database and testing the backup set status.
Restoring Production Environment Database to various other Environments.
Working with Various Environment of Database like Production, UAT and QA.
4.Project: Henkel May 2010 – Feb 2011
My responsibility was to maintain the databases. I had the responsibility to manage Knowledge Transfer from EDS while taking over the project. I was also maintaining/administering datastage.
Overall Roles and Responsibilities
Lead transition process from a different vendor, and made sure that transition happened smoothly.
Supported 5 Oracle databases.
Upgrade and Configure discoverer in 10g BI.
Creating Application users and responsibilities as per requirement.
Analysis of long running jobs and provides suggestion to the users on the action plan.
Troubleshooting application, UNIX, printers and database problems.
Administering/Maintain Datastage.
Create/Schedule jobs in Datastage.
5.Project: Pfizer Inc May 2006 – Apr 2010
My responsibility is to maintain these databases and implement any new project that comes up from the Business Group. I am supporting more than 40 oracle application environments. I have also been a part of support designing across India, Ireland and US model. I have the responsibility to support all the instances and provide assistance to the markets and users in case of any issues.
Overall Roles and Responsibilities
As an Oracle Application Administrator,
Supporting more than 40 Oracle application instances out which 3 are in multi tier environments.
Regular cloning and refreshing of Oracle Application in multi tier model and single tier model.
Applying application and database patches.
Configuring Workflow.
Upgrade and Configure discoverer in 10g BI.
Configuring and Managing Concurrent manager.
Resolving workflow and discoverer related issue.
Configuring the printers.
Creating Application users and responsibilities as per requirement.
Troubleshooting application, UNIX, printers and database problems.
Supporting Oracle SR for technical and functional issues.
Advising the function and development team for the patch or other requirement.
Analysis of long running jobs and provides suggestion to the users on the action plan.
As a Database Administrator,
Online Customer Supporting for Databases sizing from 20GB to 2TB.
Installation and upgrading of Oracle Software and at Development and Production Environments and troubleshooting the day to day problems.
Troubleshooting of database/software for bugs and applying patches as required.
Assist and advice in database design at development stage in Oracle.
Configuration of Database parameters for optimal performance.
Monitoring Databases for fragmentation and storage management.
Maintaining the Partition tables and there global/non-global indexes and External Tables
Regular re-org of huge segments and regular tuning of database for optimal performance.
Analyze and advice on capacity planning based on transaction volume and growth of the database.
Perform periodic backup and recovery of the database and testing the backup set status.
Restoring Production Environment Database to various other Environments.
Recovering Real time Databases using Manual and Import Utilities.
Working with Various Environment of Database like Production, UAT and QA.
As a Programmer,
Assisting in development of Software using SQL/PLUS and UNIX Shell scripting.
Automated the monitoring and reporting of the batch jobs to remove manual intervention.
Automated the retrieval of log file, out file, TKProfs and other ad-hoc activities using UNIX shell script to reduce the effort and manual intervention which helped in reduction of time.
Corporate Training Session
Oracle 10g workshops from Oracle.
11i Install Patch and Maintain Oracle Applications Ed 5.1
Achievements
Best JSE Achiever Award, in Accenture Services Pvt. Ltd.
ACE – 2 Times Instance Karma Award winner, in Accenture Services Pvt. Ltd.
Personal Information
Email ID: **********@*****.***, ***************@*****.***
Residence: 8205, Towne Main Drive
Plano, Texas - 75024
Mobile: 469-***-****
Date of Birth: 11 May 1984
Nationality: Indian
Marital Status: Married
Contact this candidate