SUMMARY:

• Over Thirteen plus years of IT experience in Oracle
• Excellent work ethics and team oriented with strong analytical and leadership qualities
• Oracle E - Business Suite R12 (12.2/12.1.3) Installation & Upgrade, database 12c/11g Installation
• Database Migration from AIX to RHEL using Roll-Forward XTTS approach
• EBS R12.2.6 Implementation with AD Delta 9
• GRID 12c/11g Configuration
• FMW 12c Installation, SOA Suite configuration
• MongoDB Installation and performed multiple 3.x version upgrade using Ops Manager
• Oracle EBS R12.1.1 Upgrade from 11i & EBS R12.1.3 Upgrade from R12.0.4
• Oracle 12c (12.1.0.2) Upgrade from Oracle 11g (11.2.0.3) on EBS R12.1.3
• Multiple Oracle 10g/11g Point Upgrade on EBS 11i/R12
• Oracle Weblogic 11G & Webcenter Portal Installation
• Workflow Notification Mailer Configuration & Troubleshooting workflow issues
• Implementation of MWA (Oracle Mobile Application) using Multiple Dispatchers
• Oracle Warehouse Builder (OWB) Installation & support
• Implementation of Enhanced Security for Oracle EBS Database
• Familiar with SOX audit policies and SOX conflict in System administration
• Have Strong interpersonal skills with the ability to interact with end-users, managers, technical personnel, etc.

TECHNICAL SKILLS

Packages(Incl Versions): Oracle Applications R12 (12.2,12.1.3, 12.0.6, 11.5.10.2)

Modules: System Administration

Language: SQL, PL/SQL, Unix/Perl Shell scripting

Database: Oracle 12c,11g, 10g, 9i, MongoDB

Operating System: Sun Solaris 9 & 10, HP-UX, AIX, RHEL

GUI: Oracle Apps 11i/R12, Weblogic, Oracle forms 6i, Reports 6i

Tools: OEM, TOAD, HP-PPM, OFA, Discoverer, SQL Developer, OpsManager

PROFESSIONAL EXPERIENCE

Principal Consultant - Sr. Oracle Apps DBA

Confidential, San Jose, CA

Responsibilities:

• Supporting Cisco’s mission critical Oracle core (11g & 12c) & ERP (EBS R12.2.6 & R12.1.3), Middleware and MongoDB environments
• Estimate Database size growth (Database Size Management) & File System Growth (Physical Space Management)
• Managing Complex EBS database having 26 nodes application tier and 18 nodes database tier with a database size over 55 TB
• Capacity Planning & working with Management for implementation of new Oracle products
• Database upgrade from 11.2.0.3 to 12.1.0.2
• Oracle EBS 12.2.6 Implementation on RAC
• Weblogic 12c - 12.2.1 Installation and support
• Experience in managing huge databases ranging up to 55 TB
• Applying Oracle EBS patches using ADOP - online patching
• MongoDB Installation and Upgrade using OpsManager
• Configuring and maintaining ASM and RAC databases
• Expertise in configuring and managing High Availability standby(Dataguard) databases
• Performed multiple Database switchover and failover using Dataguard broker
• Involved in maintaining security standards by applying quarterly PSU patches
• Troubleshooting of various critical P1 issues within SLAs
• Experience in database & Application tuning and object rebuild
• Cloning of instances using RMAN active duplicate database and ADCLONE
• Experience in replication using Oracle Golden Gate
• Patch analysis, merging patches & Applying patches using ADOP, adpatch and opatch
• Performing ERP System Administrator activities like managing application Users, Profiles, Responsibilities, and Concurrent managers, etc.
• Installation & administration of OBIEE 11g
• Troubleshooting ERP login issues, JVM level issues & issues related to forms & reports
• Tuning SQL queries for improved performance
• Adding node to existing RAC cluster
• Supporting Agile App servers running on Weblogic 11g
• SSL & DMZ configuration
• Tuning of JVMs and Concurrent Managers
• Configured 10G, 12c OEM Grid Control to monitor corporate wide databases
• Troubleshooting user reported issues
• Process adherence for Incident and Problem Management
• Working in 24/7 Support Model and coordinating with offshore DBAs

Consultant

Confidential,Tampa, FL

Responsibilities:

• Database migration from AIX to LINUX using XTTS and Datapump Export/Import
• Oracle 11GR2 database installation
• Grid Infrastructure (ASM) installation on LINUX using SCAN listener and migrated database from filesystem to ASM
• Database downsizing using OPTIM tool & tablespace reorg
• PSU Patching & database upgrade from 11.2.0.2 to 11.2.0.3 on AIX
• Oracle Weblogic 11G & JRockit Installation on RHEL
• Webcenter Portal 11G Installation
• Applications patching using adpatch
• Discoverer upgrade
• Database backup using RMAN
• Administration and maintenance of Concurrent managers
• Creating/modifying shell scripts as & when required for task automation
• Performance Tuning of production application on apps tier and db tier at regular points using OEM, sqlt, AWR, ADDM
• Oracle EBS Cloning using adcfgclone
• Database administration and regular Production monitoring of E-Business Suite 12.0.6 on IBM AIX and RHEL
• Configuring Oracle Restart which is a new feature of 11GR2
• Markview 170 Systems administration
• Knowledge of WebCenter Imaging
• Oracle 10g Application Server (10gAS) Administration
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Managing user Accounts in databases as well as applications
• Monitoring & Managing the Tablespaces and data files growth using OEM
• Work with Oracle SR to resolve issues
• Code migration using HP PPM Kintana
• Sysadmin activities like Concurrent Manager monitoring, Printer Setup, User creation, defining alerts through Alert manager, etc.
• 24*7 Production Support with Onshore-Offshore model

Senior Database Administrator

Confidential, San Diego, CA

Responsibilities:

• Cloning the Oracle Applications from Production to Development and Test servers
• Database administration and regular Production monitoring of E-Business Suite 12.0.6 on HP-UX
• PSU Patching & database upgrade
• Applications patching using adpatch
• Very well versed in AD utilities like adPatch, adadmin, adsplice, adlicmgr, adctrl, adtmplreport, adrelink for Oracle Applications
• Administration and maintenance of Concurrent managers
• Creating/modifying shell scripts as & when required for task automation
• Monitoring and supporting day today activities of the production and development databases and work on urgent issues
• Performance Tuning of production application on apps tier and db tier at regular points
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, contention issues (deadlocks, I/O, memory, CPU, etc.).
• Generating AWR & ADDM reports for performance tuning
• Configuring the printers and assigning them to concurrent programs
• Managing user Accounts in databases as well as applications
• Monitoring & Managing the Table spaces and data files growth using OEM
• Oracle Custom Application Creations - Created Custom Application, menu, function and attached custom forms and custom reports. Also created custom table space and oracle database user.
• Raising SR and monitoring them. Responsible all SR update and providing all needed information to Oracle from Oracle Diagnostics Tool, files versions, SQL scripts Run.
• Oracle Apps Sysadmin
• Migration of Change Requests (CR)/Fulfillment Requests (FR) through HP-PPM
• Sysadmin activities like Concurrent Manager monitoring, Printer Setup, User creation, defining alerts through Alert manager, etc.
• Creation of Oracle Wallet for password management
• Oracle Financial Analyzer (OFA) Administration
• SOX rules and SOX conflict administration for user accounts
• Administration of Markview & RELO
• Managing the Offshore DBA team

Technical Lead

Confidential

Responsibilities:

• Oracle EBS R12 Installation (12.0.4)
• Oracle 11gR1 Real Application Cluster Installation
• ASM Installation
• Oracle 11g DB Upgrade: 10.2.0.3 -> 11.1.0.6
• Oracle EBS R12 Upgrade: 12.0.4 -> 12.1.1
• Oracle DB Upgrade: 11.1.0.6 -> 11.1.0.7
• Database Restore using Flashback database
• Agent 10g Installation
• OWB (Oracle Warehouse Builder) Installation in EBS
• Parallel Concurrent Processing (PCP) Configuration
• Load Balance Configuration
• Patch analysis and patch application using adpatch & opatch
• Single Node to Single Node
• Single Node to Multi Node
• Multi node (RAC) to Single Node (Non-RAC)
• Implemented Enhanced Security for EBS Database & Applications (As part of “Penetration Testing”)
• Advanced Supply Chain Planning (ASCP) Configuration
• RBAC configuration (Role Based Access Control for R12)
• Implementation of MWA (Oracle Mobile Application) using Multiple Dispatchers
• Customization of MWA using adcustomizer
• Adding/dropping ASM disks to/from diskgroups
• Workflow Mailer Configuration
• Code Deployment
• More4Apps Integration with EBS
• Database Monitoring
• General DB Activities
• Backup of database using RMAN, HP Data Protector tool

Confidential

Associate Consultant

Responsibilities:

• Oracle 10G DB Upgrade on EBS 11.5.10.2
• Oracle 9i version Upgrade
• Shared Oracle Home Implementation
• Developer6i Patchset Upgrade
• Cloning (Multinode to Multinode)
• Database Refresh
• Complex Patch Analysis & Patching
• JDK/Jinit Upgrade
• Solving day-to-day service tickets as per SLA
• Apps Related Troubleshooting
• Concurrent Manager troubleshooting
• Oracle 10gAS Administration
• Generating Statspack reports
• Troubleshooting Oracle forms related issues
• Printer Registration
• Forms Playback enabling/troubleshooting
• Monitoring Oracle Applications Instance and Oracle Databases
• Backup of Oracle Applications Instance and Oracle Database using NetApps
• User creation in Database & Application
• Creating database Roles, privileges, functions, procedures
• Unix shell scripting
• Knowledge of tools like Kintana, TOAD, Discoverer, etc
• General Database activities
• 24*7 Support Project based on Onsite-Offshore Model

Confidential

Oracle DBA

Responsibilities:

• Oracle 9i database installation
• Patch Analysis & Application using adpatch/opatch
• Database & Application cloning using adcfgclone
• Database monitoring
• Concurrent Managers troubleshooting
• Installation of Oracle Forms6i/Reports6i on Users machines
• Monitoring db usage/load, space utilization, user sessions, locks
• Troubleshooting user applications login
• Performing periodic cold and hot backups using RMAN
• Database cloning done to create test and training environments
• SQL, PL/SQL Programming. Written PL/SQL Functions, Procedures, Packages and Triggers
• Performed day-to-day DBA activities including schema management, creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence
• Monitoring alert log, memory, disk I/O, CPU, scheduling jobs in cron
• Created Unix Shell Scripts for monitoring purpose and automation of regular activities