SUMMARY:

• Over 9+ years of experience in Oracle Database, Oracle E - Business Suite, Oracle Fusion Middleware, Oracle Identity Management, Oracle WebLogic, Oracle Applications Server, Oracle Enterprise Manager Grid Control, OBIEE, Oracle Discoverer, SOA, ODI, Oracle Goldengate and Shell scripting.
• Expert in Administration of Oracle Applications E-Business Suite (11i, R12.1.x and R12.2.x).
• Expert in installing and Administrating Oracle RAC and Grid Infrastructure 10g/11g/12c database.
• Expert in Database (RAC/non-RAC) upgrade from 10g to 11g and 11g to 12c.
• Strong experience in Dataguard setup and administration along with Data guard Broker.
• Rich Experience in Backup and recovery using Cold, Hot and RMAN.
• Automated lot of DBA day to day operations using Unix Shell Scripts.
• Proactive monitoring and performance tuning of production databases using Oracle Enterprise Manager (OEM) and scripts.
• Monitor and optimize the database performance.
• Having good expertise on Oracle ASM with RAC
• Expertise on Statspack, TK Prof, AWR & ADDM reports for analysis/troubleshooting of DB/SQL performance issues.
• Implemented RAC with ASM and Converted Non RAC to RAC.
• Experience in cross Platform Migration project from Solaris to IBM AIX & AIX to Linux.
• Configured Active Dataguard for reporting purpose.
• Implemented the Audit Vault & Database Vault to track all DBA activities and to report the changes in GUI format.
• Performed DR Switchover/Switchback for disaster recovery purpose.
• Expert in Design, Install, upgrade, administer, monitor, patch, and clone Oracle eBusiness 11i/R12.1.x/R12.2.x and related Oracle 9i/10g/11g/12c databases in RAC and non-RAC environments.
• Experience in EBS Application upgrade from 11i (11.5.10.2) to R12 (12.1.3), R12.1.3 to R12.2.2 and 11.5.10.2 to R12.2.x.
• Installed and configured Oracle Goldengate replication between various versions of Oracle databases. Had set up alerts on Goldengate for monitoring the health, sync and performance related to cpu/memory of Goldengate processes.
• Implemented DMZ and F5 Load balancer, with iSupplier Portal.
• Extensive Experience on Oracle minimum Base Line patching activity and upgraded Database from 9i to 10g, upgraded 10 production instances to get extended support from oracle.
• Worked on Database Character Set Conversion and installed 15 NLS languages in Oracle Applications.
• Expertise on PCP (Parallel Concurrent Processing) configuration.
• Extensive experience in cloning and Adding application nodes with shared appl-top configurations.
• Patching (One-off, Mini Pack, Family Pack and CPU/PSU).
• Extensive experience in supporting and managing Production, Development and test instances and Oracle Applications environments of varied complexity.
• Did fresh installations of 11.5.10, 11.5.10 CU2, R12.1.x and R12.2.x Oracle Applications.
• Upgraded Discover from 10g Rel 2 (10.1.2) to 11g Rel 1 (11.0.0.4) and Deploying in Web logic server.
• Configured Single Sign On for EBS 12.2 using Oracle Access Manager (OAM) and OID.
• Automated Clone of EBS instance of R12.1.x & R12.2.x daily.
• Automated Clone of DB from standby database and/or from an RMAN backup.
• Implemented SSL in EBS 12.2.
• Install/Upgrade and Administering Oracle Enterprise Manager (OEM). Prepared custom OEM reports.
• Cross Platform Migration of EBS R12.1.3 database from AIX to Linux using XTTS approach.
• Experience in Installation and Administration of Weblogic Server.
• Rich experience on OBIEE Administration, Upgrades and Cloning.
• Good Knowledge on Oracle Exadata & Exalogic.
• Expertise on working with Stat Migration Tool for performing code migrations as per Application Development Team’s requests.
• Hands on experience on working with Sitescope, Nagios & Zabbix for configuring alerts for monitoring.
• Adequate knowledge on MySQL: setting up new instances, cloning and basic administration.
• Having Good experience in OS Admin Activities.
• Very Good interpersonal skills with demonstration abilities to reach customer satisfaction.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

Primary DBA / Lead DBA

Environment: Oracle Applications 11i/R12/12.2.x - Linux/AIX/Unix

Responsibilities:

• Had been first point of contact for DBA escalations on all PROD issues, connect to the system and resolve issues on priority and/or delegate team members with directions to deliver on the priorities.
• Leading the meetings with various teams from Technical/Functional/Development teams to figure out the associated issues and finding out solutions from DBA’s perspective and suggesting any further actions from their scope.
• Upgraded EBS (Financial) database from 11.2.0.4 to 12.1.0.2 using export and import method with size of 1.5 TB.
• Upgraded OBIEE/Warehousing database from 11.2.0.3 to 12.1.0.2.
• Applied latest RPC, CPU & PSU patches on every quarter.
• Working on day to day production support for Core databases, E-Business suite, OBIEE, SOA, ODI, SSO and Goldengate environments.
• Configured Active data-guard database for all production databases.
• Upgraded EBS R12.1.3 to EBS 12.2.4 and then to 12.2.5.
• Administration including patching using adop and other maintenance tasks of EBS 12.2.x.
• Configured backups using shell scripts through RMAN methodologies.
• Cloning of RAC/non-RAC instances to Non-Prod Instances.
• Implemented RAC with ASM and Converted Non RAC to RAC. Implement load balancing, failover among the RAC nodes.
• Install new Recovery catalog with Oracle 11g and Configure RMAN backup through 12c Oracle Enterprise Manager, setup the retention policy and backup schedule for the database.
• Configure automatic alert and notification with OEM.
• Cloning OEM to different server and upgraded from OEM 12c upgrade to OEM 13c and implementing AMP packs
• Prepared custom OEM reports.
• Automated the cloning/refresh process of databases from PROD standby databases as source.
• Hands on experience on troubleshooting adop(Latest patching tool from R12.2 EBS) issues and various other R12.2 issues such as Oracle Workflow, concurrent processing, user issues etc.
• Performing code deployments, java deployments on Oracle Application Server and Weblogic servers.
• Migrated the EBS R12.1.3 database from AIX to Exadata using XTTS approach.
• JRE Upgrade from 1.6 to 1.8.
• Applied RPC Patches yearly.
• Cloning of Warehousing and OBIEE environment.
• Attended the meetings with Client management, draw out the requirements, update the client with status on deliverables and recommend any new activities for the improvements of the project.
• Planning and coordinating the project needs with Offshore teams
• Performed EBS Web-tier load balancing, enabling SSL & integrating with SSO
• Configured Single Sign On for EBS 12.2 using Oracle Access Manager (OAM) and OID.
• Implemented Parallel Concurrent Processing, concurrent process load balancing, implemented multiple (Output Post Processer) OPP managers for better load balancing of costly concurrent programs consuming the server load.
• Registering and/or deregistering of EBS with SSO during cloning.
• Convert Single node applications to multi-node of shared appl-top and dedicated appl-top. Design, test, implement, and maintain high availability solutions for databases and applications
• Upgraded OBIEE from 11.1.1.6.5 to 11.1.1.7.1. Has documented procedure while doing POC.
• Installed and configured Weblogic, SOA 12c Suite, ODI 12c for single node and multi-node configurations.
• Automated purging of historical data from cube schemas of SOA.
• Upgraded SOA Suite from 12.1.3 to 12.2.1
• Working with Oracle Support while applying Exadata patches, fine tuning various parameters at Database/Server level to make best use of Exadata features
• Suppressed Java pop-ups while launching EBS forms in order to avoid extra burden for end-users to respond to java pop-ups
• Finding out any bugs, performing the root cause analysis, working with Oracle Support on the need basis and providing permanent solutions to the issues.
• Installed and configured Oracle Goldengate replication between various versions of Oracle databases. Had set up alerts on Goldengate for monitoring the health, sync and performance related to cpu/memory of Goldengate processes.
• Building DR databases from RAC to single node, cloning the databases from standby databases, setting up alerts on DR sync monitoring and setting up Rsync between EBS apps systems
• Reorganization of tablespaces to reclaim the fragmentation and to improve the performance

Confidential

Backup DBA for Lead DBA

Responsibilities:

• Backup Lead DBA to share the load of the DBA activities, plan and coordinate the maintenance tasks with offshore team
• Involved in upgrading the EBS from R12.1.3 to R12.2.5
• Involved in upgrading the database from 11.2.0.3 to 12.1.0.2
• Setting up the DR database and implementing clones from DR to avoid any performance issues in terms of network, cpu and memory.
• Implemented security rules in order to open necessary ports between PROD and DR database servers.
• Implemented rsync between PROD application server and DR application server.

Confidential

Backup DBA for Lead DBA

Responsibilities:

• Involved in platform migration of database from Solaris to Linux
• Involved in upgrading of DB from 10g to 11.2.0.4
• Involved in upgrading of EBS from R12.1.3 to R12.2.4
• Upgraded SOA environment from 10g to 11g.
• Automated jobs for monitoring, cloning of DB and EBS.
• Primarily responsible to analyze ETL loads and identify performance bottlenecks at DB and OS level. Tune databases (EBS, OBIEE and SOA) for optimal utilization of hardware.
• Assist developers in tracing dashboard reports and identifying expensive SQL’s.
• Asses and submit hardware recommendations.
• Verify and create necessary indexes as per Oracle recommendations/best practices.

Confidential

Associate Lead DBA

Responsibilities:

• Installed 11.2.0.3 database for Agile environment.
• Support the Application teams on performance issues and end-users requests
• Applied latest RPC, CPU & PSU patches.

Confidential

Senior Oracle Apps DBA, Technical Lead

Environment: Oracle Applications 11i/R12 - Linux/AIX/Unix/Windows

Responsibilities:

• Worked in Day to day production support in a 24*7 team.
• Played as a Technical Lead role for a team of 18 members. Had been first point of contact for recommending/resolving any issues across various databases and applications.
• Documenting various best practices, maintaining sharepoint for DBA technical references and guiding DBA team members to follow the process while performing the associated DBA maintenance tasks.
• Worked on clone of Oracle application 11i/R12 with various backup methods.
• Installing and upgradation of Oracle Application Server and Weblogic server.
• Monitor databases and application through OEM Grid Control.
• Configured DMZ amongst the 2-external nodes.
• Configured F5 Load balancer in the External nodes and the Internal nodes.
• Configured PCP amongst the 2-internal nodes.
• Performed Single to Multi-Node cloning and Multi-Single node.
• Added Nodes to Shared-APPLTOP instances.
• Upgraded multiple databases from 10g to 11g across various customers
• Implemented RMAN backup strategy for cloning and extensively used it for Cloning Applications.
• Performed Code migrations and Oracle Forms/Reports deployments on Oracle Application Server for various client environments
• Migrated the new Custom Code between DEV-CRP-UAT-PRXY-PROD
• SYSADMIN activities were performed during the day-to-day Support.
• Worked on Database Character Set Conversion and installed 15 NLS languages in oracle Applications.
• Migrated the Oracle EBS 11i from Solaris to IBM using the Transportable database and RMAN.
• Two Databases were migrated of size 2TB, 60G from Solaris to IBM AIX.
• Performed the SOP first on Test database and followed the same plan for both prxy and prod.
• Worked closely with OS team to get apply the required setup for migration of the Oracle EBS.
• Troubleshoot the issues after migration.
• Configured WorkFlow Mailer and resolved the Workflow Notification Mailer issues.

Confidential

Oracle Apps DBA

Environment: Oracle Database 11g - Linux/AIX

Responsibilities:

• Performed migration of databases from AIX to Linux environments.
• Performed proactive performance tuning of the databases, setting up the database parameters to achieve the required functionalities
• Configuring and scheduling rman backups, hot and cold backups as per the project requirements.
• Upgraded databases from 10g to 11g
• Provided support for the application/techno-functional teams on their various requests such as code migrations, sysadmin activities, user management tasks etc.
• Adding space to the tablespaces, generating data growth reports and reporting the growth trend to the leads.
• Analysis and applying of CPU/PSU patches, one-off patches for various bugs
• Troubleshooting the issues by collecting the required diagnostics through various tools such as AWR, ADDM and tkprof.

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i

Responsibilities:

• Configured the standby database for Financial database from a two-node RAC database to a single node standby database
• Providing DBA support for multiple instances of Oracle Applications 11i & Database 11g with RAC and carrying out the associated maintenance tasks.
• Investigated on various long pending issues of databases, EBS & SSO environments, and recommended feasible solutions for better performance
• Attended various meetings with Application/Techno-Functional/Development teams, listed out various issues related to different domains and took them forward towards feasible solutions.
• Fixed various performance issues related to database and EBS
• Applied various bug fix patches as recommended by Oracle Support as a conclusion from the related service requests (SR/TAR).
• Automated various day to day jobs to report the health of the databases and applications
• Built shell scripts for monitoring the performance of the databases and known issue conditions.
• Support various third party applications integrated to the Oracle databases along with the EBS.
• Support for the code migrations from Development teams and troubleshoot the issues after migration.

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i/R12 - Linux/AIX/Unix/Windows

Responsibilities:

• Upgraded the database from 9i to 10g of in both EBS and Core database.
• Applied the Oracle Minimum Base line patches.
• Performed the discover upgrade (10g to 11g Rel1), developer 6i,jre upgrade.
• Worked in Day to day production support.
• Upgraded applications from 11i (11.5.10.2) to R12 (12.1.3) for various client environments.
• Upgraded Database base from 9i to 10g and then further to 11g.
• Worked on Character set conversion in DB level and installed NLS languages in Applications.
• Worked on Noetix Installation (6.0.1), Upgrade(5.8.4 to 5.8.7 and 6.0.1) and Implemented the Security with Noetix Admin.
• Worked on clone of Oracle application 11i/R12 with single tier and multi-node configurations.
• Maintaining Applications Database Objects like Validating, recreating grants and synonyms to Apps schema, compiling Forms, Compile AOL tables using adadmin utility.
• Registering Concurrent Programs with Concurrent Managers and Creation of Additional Concurrent Managers and Maintenance.
• Installing and upgrading Oracle HTTP server and Oracle Portal
• Identifying the patches related to bugs in Oracle Applications and applying these patches using AD Utilities and Database OPatch.
• Installing and configuring of SSO, OC4J applications across various client environments.
• Performing code deployments, java deployments on Oracle Application Server and Weblogic servers.
• Cloning/DB Refresh & Backups
• Monitoring & Troubleshooting
• Operating System Sysadmin activities
• Core DBA Activities - For Legacy Application
• Worked on Character set conversion in DB level and installed NLS languages in Applications.
• Upgraded the core forms and reports from 10g rel1 to 11g rel1 and deployed in weblogic server.
• Troubleshoot the upgrade issues and base line patching issues.
• Worked on Oracle Minimum Base Line patching activity and upgraded Database from 9i to 10g to get extended support from oracle.
• Worked on ASCP(Advanced Supply Chain Planning) setup
• Implemented the Audit Vault & Database Vault to tracking all DBA tasks.
• Monitor databases and application through various tools and applications such as OEM Grid Control, Sitescope, Nagios and Shell scripts

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i

Responsibilities:

• Maintaining Applications Database Objects like Validating, recreating grants and synonyms to Apps schema, compiling Forms, Compile AOL tables using adadmin utility.
• Registering Concurrent Programs with Concurrent Managers and Creation of Additional Concurrent Managers and Maintenance.
• Identifying the patches related to bugs in Oracle Applications and applying these patches using AD Utilities and Database OPatch.
• Cloning/DB Refresh & Backups
• Monitoring & Troubleshooting
• Operating System Sysadmin activities
• Core DBA Activities - For Legacy Application
• Upgradation of Oracle DB from 8.1.7.0 to 10.2.0.4.
• Working with various Backups and Recovery Methods.