SUMMARY

• Over 20 years of IT experience, in administering very large and complex Oracle Production/Application DBA in all aspects of Oracle DBA tasks of all oracle database versions 8i/9i/10g/11gR1/11gR2/12c.and ERP systems which includes four years as People Soft DBA, one year as Oracle Application(11.5.3) DBA and 16 years as Oracle Production DBA. Confidential in supporting very large databases on multiple platforms including Exadata, Linux,AIX 6.1 and VM wares in setting up and support of DEV,TEST and PROD environments.
• Experience in supporting and upgrade of all oracle database versions 8i/9i/10g/11gR1/11gR2/12c
• Extensive experience in setting up and administration of Oracle RAC 11g on Linux and Oracle structure and standards
• Experience with Oracle 12c multitenant architecture and managing many databases as one.
• Experience with Oracle 12c pluggable databases and converting to pluggable databases.
• Experience in supporting Exadata environments.
• Extensive experience with RMAN for backup and recovery.
• Experience in fine tuning applications performance.
• Experience in generating AWR reports and analyzing them.
• Experience with RDA, ADDM and SQL performance tuning.
• Installation configuration of Oracle Enterprise Manager OEM 12c
• Configuration of oracle databases and OEM with single sign on using Oracle Access manager.
• Experience in all aspects of Development and testing aspects of DBA activities.
• Generating explain plan and using them for performance tuning.
• Extensive experience in all aspects of Oracle cloud control 12c (OEM)
• Experience in supporting multiple application/production environments.
• Excellent Backup and recovery scenarios and have good experience in recovering 10G/11G databases.
• Experience in designing and implementing enterprise wide backup solutions using RMAN and TSM.
• Experience in installation and configuration of Oracle 10G/11G real application clusters(RAC)
• Experience in 24 - hrs 7/day on-call support. Interfaces with users, vendors, and all MIS groups.
• Experience in developing UNIX shell scripts to automate DBA tasks.
• Upgrade of Oracle RAC from 11.1.0.7 to 11.2.0.3 ASM on AIX 6.1
• Configuration of oracle databases and OEM with single sign on using Oracle Access manager.
• Experience Supporting database environments with Oracle fusion Middle ware products OID,OAM, Oracle Portal, Weblogic etc.
• Experience in installing and configuring 11gr1 grid control to monitor production database to administer and manage large number of databases and enterprise wide targets.
• Install configure Regular Security Patching on Oracle Products and interim patching for various bug fixes on database products.
• Migration from application server (OC4J) TO WebLogic.
• Experience in Database security and implementations including transparent data encryption
• Experience in implementing database security including Label Security, audit Vault and Data Vault.
• Implementation Oracle wallet for password security to the end users and without using Oracle passwords OS Authentication method.
• Performance database Monitoring and tuning to ensure databases run at peak performance.
• Troubleshooting performance issues on RAC cluster database environment.
• Configuring Kerberos authentication for OEM 12C R2
• Experience in setting and maintenance of standby databases
• Worked as weekend support DBA provided off-hours, during database hangs/crashes or any other critical performance issues /Holidays on demand coverage is provided for the client .
• Team Player, with Good Analytical Technical and Communication Skills.

TECHNICAL SKILLS

HARDWARE: SUN Enterprise E4500, E3500, E450, E420R, E250, SPARC 5, 10, 20, HP, DELL/ COMPAQ Servers, Siemens Nixdorf Servers, Macintosh, and Intel Pentium PCs, RS-6000, Sun A-5200/A-1000, HP DL 385,HP EVA8100,IBM SAN DS5000, Oracle Exadata servers.

OPERATING SYSTEMS: IBM AIX 6.1,Linux Red hat 4.o/5.5, Solaris 2.6/2.7/2.8, SCO/UNIX 5.x, Linux 5.2, HP/UX, Windows 95/98/NT/2000, DOS,VM ware.

SOFTWARE TOOLS: Oracle Enterprise manager, RMAN, JDBC, Visio, SQL Navigator Toad,DBArtisan

RDBMS: ORACLE12c, 11.2.0.4/11.2.0.3/10.2.0.4/9.2.0/8.0.5/8.1.7/7.3.2

LANGUAGES: SQL*PLUS, PL/SQL, C-K SHELL NT SQL Server, Sybase Open Client 10.0.2, ERwin/ERX 7.0, Oracle Server 8i,9i,10G, SQL Server 2000(SP4), SQL Server 2005 (SP3), SQL Server 2008 (SP1),Mark LogicVersion 4.0 Server, Crystal Report, Autosys

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr.ORACLE DBA

Responsibilities:

• Performed application tuning and recommended new indexes and profiles for their code for better execution plan.
• Experience in supporting multiple application/production environments.
• Generating explain plan and using them for performance tuning
• Performed Disaster recovery for Webcati BETA database point-in-time recovery.
• Implemented Password complexity for TMO databases as security standards of the Bureau for 11g databases.
• Install configure Regular Oracle Security patching on database products and interim patching for various bug fixes on 11g database.
• Configuring OEM 12c with Oracle Identity Manager and Oracle Access Manager.
• Upgrading OEM12cR1 to 12cR2
• Configuring web gate with OracleAccessManager
• Configuring Kerberose authentication for OEM 12c R2
• Setting up oracle 11gR1 data guard on AIX production with GPFS and standby with ASM.
• Installation and configuration Oracle Enterprise Manager (Grid control) 11gR1
• Learned and participated in new development and deployment to production of Mark Logic Server: Cover Automation Application, Digital Warehouse Application, and Contract Application.
• Implemented and monitored daily and weekly batch jobs, using AutoSys Scheduler, Microsoft SQL DTS, and Microsoft SQL SSIS packages.
• Database Migration from Production to Beta and Integration other environments.
• Prepared TMO SOP documentation for various process like ASM migration, OPatch installation and Database accounts creation and deletion.
• Work with Oracle support at times when the issue needs more in-depth troubleshooting.
• Proactively improve existing database infrastructure and reporting mechanisms.
• Maintain secure database and software environment by deploying patches, implementing database auditing as part of security measures. Implement CIS bench marking standards.

Confidential, MD

Sr.ORACLE DBA

Responsibilities:

• Performed Oracle Database upgrades from 10g to 11g in Red hat Linux 5
• Installed Oracle RAC over ASM environment on Oracle 10g & 11g on Linux and Oracle structure and standards
• Performance tuning of oracle databases running on Exadata servers.
• Installed RAC 10G on 2node cluster for SYSLAB system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database and configured.
• Generating explain plan and using them for performance tuning
• Implementation, installation, upgrades on various versions of Oracle databases from 10.2.0.3 - 10.2.0.4 and 10.2.0.4 -11.2.0.2
• Installing Oracle Identify, Oracle Access Manager (11.1.1.5.0 ) and Web logic Server.
• Install configure Regular Security patching on oracle products and interim patching for various bug fixes on database products.
• Implementation Oracle wallet for password security to the end users and without using Oracle's OS Authentication method.
• Performance database Monitoring and tuning to ensure databases run at peak performance
• Troubleshooting performance issues on RAC database
• Managing Backup & Recovery through RMAN Configuration, Archiving /Export & Import
• Administering Services and Storage Administration, Adding and deleting Nodes and instances.
• Installed and configured EM Central Grid control on 10g and 11g to administer and manage large number of databases and enterprise wide targets.
• Performed Database MAF/TIGER refresh from Production database to DEV/ITV.
• Performed and tuned using AWR, OEM Grid and tkprof etc Oracle Databases.
• Provided production support on a 24x7 basis.

Confidential, NJ

People soft /Oracle DBA

Responsibilities:

• PeopleSoft Application Administration and Database Administration (production database) for PS Tools 7.01 on PS Apps 7.00 /PS 8.9 For PS Tools 8.45 & 8.48 on Oracle 10.2.0.3,10.2.0.4,11.2.04 (HRMS/Financials) AIX 5..2 /Sun Solaris 2.51 and Windows95 Clients.
• Performing database refreshes from Production to Demo, Develop, Test & UAT
• Applied patches and fixes, unit tested them and assisted in their migration to the development & test environment.
• Installed, configured, maintained & supported PeopleSoft HRMS 8.3/8.9 including creation of the databases, configuring and tuning of Application Servers, Process Schedulers and Web Servers.
• Configured and managed PeopleSoft Internet Architecture .
• Configured Integration Broker gateway, nodes, channels and Application messaging between HRMS and Financial environments.
• Applying patches, fixes, Bundles & Tax updates periodically.
• Performing Application Tuning - Apps Server, Process Scheduler, & Web server.
• Installing and upgrading Oracle 9.2.0.7 to 10.2.0.3, 10.2.0.4 RAC on Test, Develop and Production databases.
• Responsible for Oracle Upgrade from 10.2.0.4 to 11.2.0.2
• Responsible for OID implementation and maintenance.
• Implemented Data guard based disaster recovery infrastructure for applications.
• Configured and scheduled RMAN backups (BCV Schedule) through Maestro setup.
• Responsible for Data Pump Export and Import Modes.
• Responsible for daily monitoring of database objects like table spaces, indexes and rollback segments.
• Providing performance tuning and application tuning of the production database.
• Monitoring database through Oracle Grid control & Quest Performance tool.
• Assisting developers in SQL queries and other troubleshooting.
• Responsible for reorganizing the database to avoid the fragmentation.
• Responsible for creating procedures for database refresh and data conversion of Development, Test and others.

Confidential, Columbus, OH

Peoplesoft DBA

Responsibilities:

• Project involved implementation of merger environment, application upgrade and support of PeopleSoft HRMS 8.3/8.8, as a member of Global Technology Infrastructure team.
• Performing database refresh & environment refresh from Demo, Develop, Test & Prod.
• Responsible for SQR migration & project migration from Demo, Develop, Test & Prod.
• Applying Patches, Fixes & Tax updates periodically.
• Installing/maintaining PeopleSoft HRMS 8.3/8.9, including Creation of the databases, Configure and Deploy the PIA Components such as Web Logic
• Responsible for Web Server, Process Scheduler, Application Server for various domains with failover/load balancing.
• Identifying areas of improvement, troubleshooting application and database issues.
• Providing production and development support to both application end users and internal technical staff to resolve their technical issues, like TimeAdmin, Payroll, etc.
• People soft Data Archiving project (payroll data stored in the People soft Production Database).
• Built Verification Test to check proper installation and running of all PeopleSoft components, processes & reports on both NT & UNIX.
• Application Tuning - Apps Server, Process Scheduler, & Web server.
• Monitoring PeopleSoft application logs & File usage daily.
• Exporting & Importing; Backups & Recovery.
• Creating users’ login account to the People soft application & assigning user roles & profiles.
• Database Tuning; monitoring PeopleSoft Performance daily.

Confidential, St. Louis, MO

Application DBA

Responsibilities:

• Performing Schema changes on Demo, Develop, Test & Prod.
• Applying Patches, Fixes periodically.
• Monitoring PeopleSoft application logs & File usage daily.
• Performing database refresh & environment refresh from Demo, Develop, Test & Prod.
• Exporting & Importing; Backups & Recovery.
• Responsible for Configuration Management - Configuring & Editing Application Servers, Process Scheduler, and Web Server.
• Performing SQR migration & project migration from Demo, Develop, Test & Prod.
• Performed Database Tuning, Monitoring PeopleSoft Performance daily.
• Responsible for Application Tuning - Apps Server, Process Scheduler, & Web server.
• Responsible for load balancing options and optimization in Application and Web server.
• Creating new PeopleSoft instance with Oracle and Troubleshooting.
• Built Verification Test to check proper installation and running of all People

Confidential, California

Application DBA

Responsibilities:

• Providing Database Management - Refresh, Export & Import, Backups & Recovery & Database Tuning.
• Responsible for SQR migration & Project migration from Demo, Develop, Test & Prod.
• Responsible for Application Management - Research, Applying Fixes, and Patches.
• Troubleshooting the issues pertaining to the databases.
• Supporting People soft batch processing.
• Enabling online context sensitive help.
• Provided Application Tuning - Apps Server, Process Scheduler, & Web server.
• Configuring & editing Application Servers, Process Scheduler, and Web Server.

Confidential

Application DBA

Responsibilities:

• The PeopleSoft eCenter project involved supporting more than 21 customers. PeopleSoft HRMS, E&G & FDM (both V7.5 & 8.0) were being supported from this center.
• Performing database refresh from Demo, Develop, Test & Prod.
• Providing application Management - Applying Fixes/Patches and Tax Updates to Demo, Develop, Test & Prod. instances.
• Creating new PeopleSoft instance with Oracle on Unix.
• Responsible for Configuration Management - Configuring & Editing Application Servers, Process Scheduler, and Web Server.
• Performing environment refresh which included NT & UNIX Code.
• Responsible for SQR migration & project migration from Demo, Develop, Test & Prod.
• Exporting & Importing; Backups & Recovery.
• Built Verification Test to check proper installation and running of all PeopleSoft components, processes & reports on both NT & UNIX.
• Enabling online context sensitive help.
• Responsible for Application Tuning - Apps Server, Process Scheduler, & Web server.
• Performing Tools Upgrade .01 (Demo, Develop, Test & Prod)
• Troubleshooting and monitoring related to Application Server/Process Scheduler Configuration, Web server.

Confidential, Atlanta

Responsibilities:

• Setting up the environment, including configuring servers (Application Servers, Process Schedulers, etc.)
• Supporting People soft batch processing.
• Getting familiarized with Curtis Tools - Dameware (for Remote Connectivity).
• Taking database and code tree backups in source and target databases.
• Running update statistics scripts at various stages.

Confidential, Illinois

Oracle Apps DBA

Responsibilities:

• Responsible for the installation of Rel 11i in multi-tier architecture.
• Responsible for the System Administration Activities on Release 11i, like configuration of Printers in Oracle Applications & OS level.
• Responsible for the management of Concurrent Managers and other SYSADMIN activities.
• Setting up the Printers, Users and Data Auditing.
• Applying patches on Production & Test databases for Bug-Fixing.
• Performing Logical backups (Export/Import) and physical backups (online/offline) on Production & Test databases.
• Monitoring database performance using Scripts UTLBSTAT /UTLESTAT.
• Writing scripts to automate the shutdown, start-up of the database.

Confidential, Los Angeles

Responsibilities:

• Installing and upgrading Oracle 8.1.5, 8.1.6, and 8.1.7 on test and production databases.
• Creating the database and maintaining their security.
• Performance tuning, application tuning of the production database.
• While on-call for support, responsible for all the production databases.
• Planning and implementing appropriate backup and recovery strategies and also responsible for scheduling cron jobs.
• Taking care of SQL*Net related issues.
• Applying Oracle upgrades and patches.
• Testing of Oracle name server and standardizing the TNSNAMES.ORA.
• Responsible for Reorganizing of the Database to avoid the fragmentation. All production databases are running in Archive log mode, each of the databases generates around 2 - 3 GB of Redo log files in a day. The database size varies from 20 GB to 80 GB.

Confidential, California

Responsibilities:

• Involved in DB admin support for the Sales & Marketing application, Product Master Warehouse, Global Software Schedule, America Reference Data and Approval applications.
• Providing 24 x 7 production support for the all production databases (Distributed environment under different time zones).
• Migrating Oracle 7.3.4 to Oracle 8i.
• Responsible for performance tuning, application tuning of the production database.
• Responsible for daily monitoring of database objects like table spaces, indexes and rollback segments.
• Maintaining database backups recovery and also responsible for scheduling cron jobs and exports.
• Preparing the AIX and Sun UNIX server for all Oracle databases starting from Oracle Installation and configuration of the machine.
• Handling SQL*Net related issues.
• Serving as team member for preparing DBA Handbook as per Confidential Standards.
• Migrating BMC Patrol Configuration monitoring tool to HP DB-SPI Metrics Monitoring tool.

Confidential, California

Oracle DBA

Responsibilities:

• Responsible for maintenance, configuration, administration, installation of Oracle database and RMAN on Sun Solaris.
• Creating roles, users and their profiles.
• Responsible for daily monitoring of database objects like table spaces, indexes and rollback segments.

Confidential, California

Oracle DBA

Responsibilities:

• Responsible for daily monitoring of database objects like table spaces, indexes and rollback segments.
• Providing performance tuning and application tuning of the production database.

Confidential

Oracle DBA

Responsibilities:

• Installing new database servers and setting up the new schemas.
• Creating roles, user profiles and authorization profiles.
• Estimating disc space requirements.
• Creating database, database objects and also creating new schemas.
• Involved in developing reports and migrating reports from 2.5 to 3.0.