PROFESSIONAL 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. Census Bureau 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 wif Oracle 12c multitenant architecture and managing many databases as one.
• Experience wif Oracle 12c pluggable databases and converting to pluggable databases.
• Experience in supporting Exadata environments.
• Extensive experience wif RMAN for backup and recovery.
• Experience in fine tuning applications performance.
• Experience in generating AWR reports and analyzing them.
• Experience wif RDA, ADDM and SQL performance tuning.
• Installation configuration of Oracle Enterprise Manager OEM 12c
• Configuration of oracle databases and OEM wif 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 has 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 wif 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 wif single sign on using Oracle Access manager.
• Experience Supporting database environments wif 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 teh end users and wifout 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 teh client .
• Team Player, wif 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 SQLServer Express

2014, SQLServer Express 2012.

LANGUAGES SQL*PLUS, PL/SQL, C-K SHELL

PROFESSIONAL EXPERIENCE:

Confidential

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 teh 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 wif Oracle Identity Manager and Oracle Access Manager.
• Upgrading OEM12cR1 to 12cR2
• Configuring web gate wif OracleAccessManager
• Configuring Kerberose authentication for OEM 12c R2
• Setting up oracle 11gR1 data guard on AIX production wif GPFS and standby wif ASM.
• Installation and configuration Oracle Enterprise Manager (Grid control) 11gR1
• 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 wif Oracle support at times when teh 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

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 teh 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 teh end users and wifout 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:

• Performing database refreshes from Production to Demo, Develop, Test & UAT
• Applied patches and fixes, unit tested them and assisted in their migration to teh development & test environment.
• Installed, configured, maintained & supported PeopleSoft HRMS 8.3/8.9 including creation of teh 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 teh production database.
• Monitoring database through Oracle Grid control & Quest Performance tool.
• Assisting developers in SQL queries and other troubleshooting.
• Responsible for reorganizing teh database to avoid teh fragmentation.
• Responsible for creating procedures for database refresh and data conversion of Development, Test and others.

Confidential, Columbus, OH

Peoplesoft DBA

Responsibilities:

• 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 teh databases, Configure and Deploy teh PIA Components such as Web Logic
• Responsible for Web Server, Process Scheduler, Application Server for various domains wif 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 teh 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 teh People soft application & assigning user roles & profiles.
• Database Tuning; monitoring PeopleSoft Performance daily.

Confidential, California, USA

Application DBA

Responsibilities:

• 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 wif Oracle on Unix.