SUMMARY

• Oracle Certified Database Administrator with nearly 8 years of experience in Oracle Apps E - Business Suite (11i, R12.1.3, 12.2) and Oracle Database (9i, 10g, 11g, and 12c) Administration.
• Worked in Cloud migration project to migrate Oracle databases, R12 EBS and WebLogic applications from On Premise datacentre to Oracle Public cloud with IaaS model.
• Upgraded Oracle E-Business Suite from 11.5.10.2 to R12.1.3.
• Installed Oracle E-Business suite 12.2.5 Vision Instance and Upgraded 12.1.3 EBS application in AIX to 12.2.5 in Linux.
• Upgraded Oracle Database from 10.2.0.4 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2.
• Database migrations from Non ASM to ASM file system.
• Converted and configured a single node DB instance to 2 node RAC instance.
• Enabled SSL and Configured Load balancer between two application servers in R12.
• Configured R12 Application server in a DMZ with reverse proxy server set-up.
• Migrated R12.1.3 Oracle E-Business suite database from AIX servers to Exadata servers.
• Implemented Active Data Guard in 11g for reporting database and disaster recovery site.
• Have good knowledge in automating things using shell scripts, R12.2 online Patching, Cloning, Installing SSL certificates and Oracle RAC.
• Clone the Non-production environments using RMAN backups of PROD.
• Installed 13c OEM and configured alerts to monitor the databases and applications.
• Monitor the server resource and disk space utilization and perform capacity planning.
• Upgraded Java from 1.6.u45 to 1.7.u65 in R12 with enhanced JAR signing.
• Monitor the performance of apps and DB and do performance tuning by analysing AWR/ SQLT reports, creating SQL baselines, profiles, indexes, Table Reorgs and Gather stats.
• Installed and maintained Kintana (for R12.1.3) and STAT (for R12.2.5) object migration tools and used Subversion (SVN) for version control.
• 24*7 Production support experience to troubleshoot issues and install fixes/changes.
• Supported OSSO 10g/OID with Microsoft AD as LDAP and WNA (Kerberos based) authentication as Single Sign On solutions for EBS.
• Implemented Fall-back Authentication for multi browser authentication.

TECHNICAL SKILLS

Databases: Oracle Database 10.2.0.4 (10g), 11.2.0.2, 11.2.0.4 (11g), and 12.1.0.2 (12c)

Applications: Oracle E-Business Suite 11.5.10.2, 12.1.3, 12.2.4, and 12.2.5 Oracle WebLogic server 10.3.5, 10.3.6 (11g), and 12.1.3, 12.2.1 (12c) Oracle Web Tier (11.1.1.7), Informatica 9.0.1 Hotfix 2 Oracle Single Sign On / OID / OIM / OAM (10g & 11g) Oracle Applications server 10g Release 3 (10.1.3), Apache Tomcat server 7 Oracle Enterprise Data Quality (EDQ), SOA Suite

Hardware: Oracle Corporation Sun4v SPARC, Sun4v x86 and Linux x86 IBM 9179-MHB, HP DL 380 G5 and HP DL 380 G7

Operating Systems: Red Hat Linux 4.8, 5.5, 6.4, 7.1, Oracle Linux 6.4, 7.1IBM AIX 5.3, 6.1, 7.1, Sun Solaris 5.10Windows XP SP 2, Windows 7 and 8

Tools: RMAN, DIP, ODSM, Kintana, STAT 5.8, Subversion, Toad, OAM and OEM PL/SQL Developer, Oracle SQL Developer, MobaXterm, GIT, BitBucket and JIRA. Forms Builder, Reports Builder

PROFESSIONAL EXPERIENCE

Confidential, Miami, Florida

Senior Oracle Applications Database Administrator

Responsibilities:

• Analyse and design the strategy to migrate the applications and databases from On-Premise datacentre to Oracle Cloud with IaaS.
• Make sure the required RPMs/Packages are installed in the new Linux/Solaris machines in the Oracle Cloud for the respective applications and databases.
• Clone all the databases (10g, 11g and 12c) from On Premise servers to new OPC Solaris SPARC servers using User Managed database backups.
• Create Physical Standby databases using Active Data Guard for all the Production databases.
• Install OEM 13cR2 and install the agents in the respective databases and setup alerts to monitor them on a regular basis.
• Migrate the Oracle EBS applications (11.5.10.2, 12.2.4, and 12.2.6) from On-Prem Linux server to OPC Linux servers using Rapid Cloning and Lift and Shift method.
• Migrate the Oracle WebLogic (10.3.5, 10.3.6 and 12.1.3), Enterprise Data Quality (EDQ), Web Tier (11.1.7), Oracle Watchlist Screening (OWS), Business Process Management (BPM) and SOA (11.1.1.7) applications from Linux and Solaris servers to Cloud using T2P cloning.
• Install Informatica (9.0.1 Hotfix 2) PowerCenter in the new Cloud server without domain and repository, Copy the Binaries, Domain and Repository from source to target.
• Support the instances that are migrated to Cloud, troubleshoot any connectivity or performance issues that arise and resolve the tickets that are raised in JIRA.
• Document all the issues that occur and their resolutions and manage them in KM.
• Maintain the scripts and their versions using GIT, BitBucket.

Confidential, Plano, Texas

Senior Oracle Applications Database Administrator

Responsibilities:

• Leading Oracle Apps DBA team in 24*7 support project, supporting 11i and R12 applications.
• Install fixes, migrate objects, perform maintenance by coordinating with respective teams and implement Change Requests based on Release Management.
• Migrated R12.1.3 Oracle EBS database from AIX servers to Exadata servers using Transportable Tablespace method.
• Installed Oracle E-Business suite 12.2.5 Vision Instance.
• Upgraded 12.1.3 EBS application in AIX to 12.2.5 in Linux.
• Database Upgrade from 10.2.0.4 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2
• Clone Non-production environments using RMAN backups of PROD as scheduled in the Environment Refresh Calendar (ERC)
• Monitor the server resource and disk space utilization and perform capacity planning.
• Upgraded Java from 1.6.u45 to 1.7.u65 in the application server with enhanced JAR signing.
• Performance tuning on daily/monthly jobs by analysing SQLT / AWR reports and creating SQL baselines, SQL Profiles, Index optimization, Table Reorgs and Gathering stats.
• Supported Oracle Discoverer 10gR 2 10.1.2.54.25 integrated with 11i EBS.
• Installed and maintained Kintana (for R12.1.3) and STAT (for R12.2.5) object migration tools and used Subversion (SVN) for version control.
• Implemented Active Data Guard for reporting database with R12.1.3 and 11.2.0.4 DB.
• Prepared a dashboard to publish peak monitoring reports, instance details, day to day monitoring and on-going project related activities.
• Developed a maintenance page for maintenance using a dedicated Apache Tomcat server and redirection logic behind it.
• Upgrade Oracle 10g Release 3 (10.1.3) Oracle home to 10.1.3.5 Patch set by applying CPU patches and install SHA2 certificates into the wallets.
• Supported Single Sign On solution using OSSO (10g) and OID with Microsoft AD as LDAP. It involves Kerberos based Windows Native Authentication (WNA).
• Implemented Fall-back Authentication to provide multi browser authentication functionality to SSO feature as WNA is only for Internet Explorer.
• Enabled SSL for EBS in 11.5.10.2 and 12.1.3 and installed certs in wallet either using orapki or OWM (Oracle Wallet Manager) and in java keystore using keytool.
• Configured OSN to serve as a messaging hub between Confidential and Suppliers to send POs and receive invoices. Also renew OSN's certificates and supplier’s certificates for punchout in respective files in application server.
• Implemented GPG for encrypting payment related files, before sending it to bank/other teams.
• Have good hands on and troubleshooting experiences in AD utilities like adautocfg, adcfgclone, adpatch, adadmin, adctrl, adrelink, adsplice and adident.
• Automated Monitoring shell scripts for multiple things like Tablespace growth / Blocking sessions / Workflow mailer services / Web services / Inactive session count / File system clean-up / concurrent manager monitor / application listener monitor / zip archive interface files / password expiry alert / new invalid objects / long running programs..
• Optimized Output Post Processor and workflow mailer to effectively use Java heap space.
• Configured R12.1.3 EBS application with Parallel Concurrent Processing (PCP) and failover mechanisms for RAC database.
• Table Reorg and Index rebuilds at periodic intervals to have consistent better performance across all modules in the application.
• Troubleshoot issues and resolve them within SLA in BMC Remedy (ticketing tool).
• Raise service requests and work with Oracle through Oracle Support for any issues.
• Worked with Infosys in Panaya for Gap/Impact analysis before applying RUP patch or Upgrade.

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Migration of the database from Non-ASM to ASM File system using RMAN Duplicate.
• Performing the Oracle Apps E-Business suite upgrade from 11.5.10.2 to R12.1
• Performing Application upgrade from R12.1 to R12.1.3
• Performing Database upgrade from 10.2.0.4 to 11.2.0.3
• Converting the single node DB instance to 2-Node RAC Instances
• Oracle Learning Management (OLM) Content Server Setup using Oracle Applications server 10g Release 3 (10.1.3)
• Configure Load balancer between two application servers in Oracle Applications R12
• Configure an external application tier in a DMZ with reverse proxy server setup.
• Migration of customizations from 11i to R12.
• Managing the project instance backup locally using RMAN.
• Supporting the various testing teams involved in the upgrade project.

Confidential

Oracle Applications Database Administrator

Responsibilities:

• Ticket resolution for the incidents allocated to the DBA queue in CCM.net with in SLA.
• Technical-Support bridge call, Online Web-Ex based support for Severity 1 tickets.
• Root Cause Analysis reports submission for the resolved Sev-1/2 tickets.
• Monitoring the application and database performance and server resource utilization.
• Proactively monitor the Tablespaces and increase them based on the threshold alerts.
• On-Call support during the out-of-office hours and weekends.
• Clone and refresh of Non-production environments from LIVE backups as scheduled in the Environment Refresh Calendar (ERC).
• Co-ordinate with the Infrastructure team during the planned / un-planned outages.
• Issue resolution by Oracle SR and OWC as needed.
• Code promotion for bug fix and enhancements as approved by Confidential Change and release Management Processes using CCM.net tool.
• Support regular Application/Database patching and Disaster Recovery drills.
• Adhere to the defined security policies and practices of the DBA privileged user.
• Ensure Production instances are backed up using RMAN as per schedule.
• Provide high availability of services and keep the uptime of the environments with in the SLA.
• Ensure the data replication from Primary to DR site and the data is in sync.