SUMMARY

• Over 6 ½ years of experience as Oracle Database Administrator and Apps DBA (11i - 11.5.10.,11.5.10.1.11.5.10.2 and R12.0.4,12.1.1,12.1.3) wif diversified experience in N-Tier and Client-Server Architecture using Oracle (9i 10g and 11g) on multiple OS platforms in Production, Development and Data Warehousing Environment.
• Over 6 years of experience wif Oracle products as Oracle APPS DBA (R12 /11i) and Oracle DBA (9i/10g/11g).
• Expertise in Installation, Upgrade & Performance tuning of Oracle Applications 11i/R12.
• Experience in full lifecycle implementations of client/server, Database application project analysis, business analysis, development as well as traditional software development methodologies.
• Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Expertise in applying Maintenance packs, Cumulative updates, Interoperability patches & Family packs using adpatch
• Implemented Oracle Golden gate 11g
• Worked on Unidirectional and Bi-Directional Replication Topologies
• Upgrading Golden gate from 10.4.0 to 11.1.1 and 11.2.1.0
• Troubleshooting golden gate issues like abends and Error 509
• Web Logic Server Code deployments/promotions, performance monitoring and performance tuning
• Hands-on Oracle SOA Suite 11g product noledge
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console and JMX.
• DDL replication and DDL Load, setting DDL marker table
• Configuring Golden Gate wif Oracle Enterprise Manager
• Cloning Oracle 11i Instance using Rapid clone and manual cloning.
• As an Oracle DBA (11g,10g,9i) expertise in Installation, Performance tuning, Backup and Recovery.
• Expertise in SQL query tuning and database tuning using ADDM,AWR and Explain Plan.
• Also worked on SQL tuning advisor using Grid control.
• Patch wizard and Patch analyzer(PAA)
• Managing Oracle application using Oracle Application Manager (OAM)
• Involved in Configuring & Managing Standby Databases (Data Guard)
• Hot and cold Backup and recovery of Oracle 10g/11g database using tools like RMAN( Recovery Manager), Flashback
• Install/clone Oracle SOA Suite including cluster and non¬cluster configurations
• Monitoring the environments from OAM.
• Cloning of database for development teams, import and export of data.
• Configuration and managing of Oracle 11g RAC (Real Application Cluster) and CRS(Cluster Ready Service).
• Managing and configuring ASM (Automatic Storage Management) file system
• Good practice in creating function, procedure, package, and trigger.
• Proactive monitoring and performance tuning of production databases using Oracle Enterprise Manager (OEM) and scripts.
• Setting up Standby Database/Data Guard to protect against failures. Configured the Standby Database in such a way dat the database is kept synchronized wif the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
• Expertise in performance tuning of large databases and SQL/PLSQL programs.
• Hands on experience in situations where on-call 24 x 7 support for mission critical databases and Production support required.

TECHNICAL SKILLS

OperatingSystems: HP-UX, Linux, UNIX, Windows2000/NT /XP

Databases: ORACLE 9i/10g/11g, Real Application Clusters (RAC 10g/11g), SQL Server 2008R2/2012

Applications: Oracle E-Business Suite R12/11i, Oracle Financials (AP, AR, GL, FA), ADI (Application Desktop Integrator).

Application Server: Oracle Application Server (9iAS 1.0.2.2) /10gAS/Web Logic server 10g and 11g

Tools: SQL PLUS, SQL*Loader,SQL*Report writer, Export & Import utility, Data Pump, RMAN, Data Guard 9i/10g,TOAD, Statspack, Opatch, Oracle Diagnostics Pack, Discoverer, SQL navigator, AD Utilities, Oracle reports, OAM(Oracle Applications Manager),MS Office, Data Guard &OEM.(Oracle Enterprise Manager)Languages: SQL, PLSQL, HTML, Perl &Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Oracle Application DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration wif E-Business 11i and R12
• Successfully upgraded 11.5.10.2 to R12.1.1 to 12.1.3 wif 10.2.0.3 to Oracle 11g. Maintaining production, development & test databases and applications.
• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicat Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for GoldenGate and Adding database Checking points
• Upgraded Oracle Applications database 9.2.0.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Applications 11.5.10.2 to R12
• WebLogic servers development, testing, applying patch and service packs
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console and JMX.
• Administer middle tier Oracle SOA, Oracle HTTP server
• Converted single instance e-business database to Oracle 11g RAC
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Applications/Database Cloning & Refresh using RAPIDCLONE
• Administration of Oracle ERP applications version 11.5.10.2 and R12
• Good Knowledge in Data Modeling tools like Erwin & Oracle Financial Analyzer.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, HRMS and INV.
• Conducted pre patch analysis for the patching of the Oracle E-Business Suite 11i.
• Applied the HRMS RUP 3 patch and OracleHRMSQ1-2009 SQWLpatches to development and production environments.
• 24*7 on-call production support for high-availability web-based application running Oracle9i RAC on HP-UX cluster wif EMC SAN.
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family packs, CPU patches, Patch Sets.
• Oracle Applications Systems Administration.
• Planning and Administration of backup and recovery strategies & configuring backups using RMAN & hot and cold backups using Net App snapshots.

Environment: Oracle Apps R12.1.3/11i (11.5.10, 11.5.10.2), Oracle /10g RAC¸ HP-UX &Windows, Linux, OEM, Oracle Golden Gate 11g(11.2.1.0 and 11.1.1.), SQL Loader, Toad, Oracle Discoverer

Confidential, Seattle, Washington

Sr. Oracle Applications DBA

Responsibilities:

• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations on SOLARIS 8 and LINUX AS 5.0.
• Upgrade of Applications from 11.5.8 to 11.5.9 on test servers on SOLARIS 8 system.
• Applying latest releases of the patches using utilities ADPATCH and ADCTRL.
• Cloning instances from production to Test, Development instance to test wif Rapid Clone and Autoconfig.
• Upgrading Oracle Golden gate 10.4.1.0 to 11.1.1.0.0
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• DDL replication
• Filter DDL Operations
• Good understanding of Golden gate Manager commands me.e INFO,SEND,START,STATUS,STOP
• Develop and maintain UNIX shell scripts to manage the Oracle Database and ERP Application environments. The major product modules include FND, AR, AP, PO, FA, GL and HR
• Involved in Database Backup strategies & recovery scenarios and implemented Backups using RMAN.
• Involved in time-to-time troubleshooting Oracle Databases.
• Monitoring user sessions, maintaining, administrating and troubleshooting database issues for OLTP -Oracle databases on Solaris and Red hat Linux.
• SUN SOLARIS and Windows Administration activities like USER Management, Oracle APPS File System Management, Mounting the hardware devices etc.
• Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.
• Configured Data Guard Broker between the primary and standby databases
• Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
• Monitoring and troubleshooting concurrent manager jobs, manage system profile setups, Troubleshooting printer set-ups and other SYSADMIN responsibilities.
• Installation, configuration, creation of end user layer (EUL), maintenance and troubleshooting of Oracle Discoverer 10g.
• Generated Position Management Reports which involves HR, PSB and GL Modules.
• Configured Business intelligence Oracle Applications 11i, and administering End User Layer.
• Generated Custom workbooks for Public Sector Budgeting using Oracle discoverer.
• Configured Discoverer Custom workbooks on Oracle Self Service Portal
• Installed and configured Single Sign-On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Oracle OID/SSL/Single Sign-on Implementation and Support.
• Oracle Data Guard Implementation for HA and remote DR site.
• Performance tuning of Oracle Database, applications and queries.
• Installation & Integration of Demantra wif ASCP environment

Environment: Unix/Linux, Oracle Database 10g (10.2.0.4), Oracle Applications 11i (11.5.10.2), TOAD, SQL Loader, AD Utilities. Oracle Discoverer 10g, Oracle Golden Gate 11g (11.1.1.0 and 10.4.1.)

Confidential, Chicago, IL

Oracle Apps DBA

Responsibilities:

• Successfully upgraded Oracle Applications Database from 10.2.0.2 to 10.2.0.4
• Worked closely wif technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages wif focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• Worked wif HR RUP3 patch to development and production environments.
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Participated in a team to maintain and support Oracle Applications in 24 X 7 environments.
• Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support.
• Upgraded JInitiator and other technology stack components in development environment.
• Cloning of database and application environments using Rapid Clone and other cloning options to create an in house instance for internal research and development.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Troubleshooting / resolving issues wif concurrent managers
• Troubleshooting of Oracle Self Service Web Applications, Jserv Debugging.
• Applied Oracle Projects Maintenance pack to Development environments.
• Worked wif technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle 11i applications.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Environment: Oracle Apps 11i, Oracle RAC 10g, HP-UX, HRMS, TOAD, SQL Loader, AD Utilities,EOY Phase1 and Phase2, KBACE

Confidential, VA

Oracle Apps DBA

Responsibilities:

• Installed and maintained oracle applications 11i.
• Cloning of Oracle EBS from different environments like Dev, Test, QA and Project instances.
• Applied additional one of patches to stabilize the environment.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed number of SYSADMIN functions including Oracle Applications System administration, Created user and attached responsibility to these users, Registered new applications, Monitored user activity, Defined Data groups, Request groups, Menus, Alerts, Workflow, Profiles, Printer installation, Flex fields etc.
• Monitoring the environments from OAM.
• RMAN Cloning
• Implementing OTL and Applied RUP4 patches
• Maintaining and monitoring daily backups.
• Using AD Administration and other AD Utilities
• Data and Transaction analysis using Log Miner
• Patch Management
• Autoconfig configuration
• Database and Application cloning.
• Monitoring and handling Concurrent Managers related issues.
• Assigning the Program to Concurrent Manager (scheduling)
• Interacted wif Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database.
• Performance turning of PLSQL programs and Oracle reports.
• 24X7 support for databases and production operations teams.

Environment: Oracle E-Business suite 11.5.10, Oracle 9i and 10g, HP-UX and windows,Toad,SQL Loaded,Rman,Adrelink, Adadmin,Adpatch

Confidential

Oracle DBA/Oracle Apps DBA

Responsibilities:

• Working closely wif functional and development teams, involved in migrating of data from legacy system
• Configuring the Printer (Style, Driver, Type) compatible to the reports
• Applying Patches/Patchsets/Mini-packs on both the database and application tiers using adpatch
• Monitoring the Database Growth and providing proactive Space Management for database of 50+ GB
• Designing the Backup Strategy, Testing Strategy, Taking Backup (Cold/Hot), Maintaining Backup and Archived files on tapes and Restoring / Recovering the database as and when required
• Configuring the Production Database to be in ARCHIVELOG Mode wif mirrored Control, Redo Log files
• Developed Shell Scripts to run the Batch jobs
• Refreshing the Development and Test instances (in NOARCHIVELOG Mode) wif Production
• Data stage Administration and Support
• Validate / Schedule / Run / Monitor Jobs using Datastage Scheduler.
• Support approximately 100 users on Oracle Applications
• Cloning Oracle 11i Instance for development and testing purpose.
• Troubleshoot and resolve issues related to Oracle Applications includes Apache Server, Forms Server, Concurrent Managers, Reports, Database.
• Create and maintain custom responsibilities and menus.
• Designed and maintained schemas involving creating tables and indexes wif scripts,
• Creating triggers, and creating procedures.
• Used the oracle NET8 Configuration Assistant to establish network sessions between client and server machines using host names and local names methods. (Configuration of TNSNAMES.ORA and LISTENER.ORA).
• Responsible for troubleshooting of the connectivity problems for end- users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
• Allocating system storage and planning future storage requirements for the database system.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User dump Files for errors.

Environment: Oracle Applications 11i, Oracle 9i, Linux, HP-Ux TOAD, Adadmin, FNDLoader. Autoconfig, SQL loader, Replication

Confidential

Oracle DBA

Responsibilities:

• Installed 10g/9i, database on Aix Unix and Windows
• Backup of database using RMAN
• Wrote control files for SQL * loader to load data into data warehouse.
• Provided database related services to their development and QA environments.
• Was actively involved in constant site enhancements along wif developers - code and data push between different servers and testing and moving to production.
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned SQL queries to pull data from data warehouse tables.
• Tuned production database performances and was instrumental in SQL tuning dat improved application response.
• Run oracle statspack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Implemented database related security measures dat proved very TEMPeffective.
• Implemented Oracle Replication to enable database fail over incase of system or database crash.
• Backup and recovery using cold, hot and export methods.
• Wrote database triggers, functions and procedure by using PL/SQL.
• Automated a no. of database related jobs.
• Set multiple destinations for archives redo logs for safety.

Environment: Oracle 10g/9i, UNIX-AIX 4.2, Window 2003.,Toad,SQL Loader. RMAN

Confidential

Oracle DBA

Responsibilities:

• Developing the GUI of the project according to the given specifications.
• Programming design, E-R diagram activities, etc.
• Created users, roles etc.
• Helped senior DBA’S in backup operations.
• Planning of logical database layout.
• Creation of database tables indexes and referential integrity constraints.
• Checking the specifications and recommending the enhancement changes.
• Testing the GUI wif substantial input data.
• Writing the triggers and stored procedures.
• Preparing the hourly schedule of the project developments and reporting to the Manager.

Environment: Oracle 9i, SQL, SQL*PLUS, PL/SQL, TOAD, WINDOWS 2000/NT.ROLLBACK SEGMENTS