SUMMARY:

• Over thirteen years of Information Technology experience including 9+ years of DBA experience. The focus areas have been DBA, People soft tools and application upgrades.
• Excellent Systems and Application , High Availability, , Enterprise Batch Automation, Resource Planning, Trouble shooting, Supporting, Archiving, Optimizing and Performance Tuning skills for Oracle/PeopleSoft Finance, CRM and HR Applications.
• Responsible for leading teams and performed hands-on as the lead upgrader for HCM 9.0, HCM 8.9 upgrades as well as Financials/SCM 8.8 and 8.9 upgrades. Managed off shore Project teams.
• Level 1 Oracle Project Management certification. Completed Service Pack upgrades, migrations, updates & fixes.
• Has over eight years of database administration and extensive PeopleSoft implementation experience that includes design and implementation phases, along with ongoing customer support for various large companies.
• Worked as a senior database administrator with extensive experience in database administration and design. Skills include logical and physical database design, optimization and administration, multi-tier architecture configuration, UNIX system maintenance, PeopleSoft upgrades and updates & fixes. Other skills include system support, QA support, troubleshooting of UNIX based systems.

EDUCATION 
MS (Systems & Information) 

Certifications 
Oracle Level 1 Project Management certified
Peoplesoft Upgrade Level2 certified consultant
Certified PeopleSoft Tools & Technology consultant

SKILLS SUMMARY 
Oracle Database tools

• Enterprise Manager
• Oracle Universal installer
• Oracle collaboration suite (User level)
• Database config Assistant (DBCA)
• Oracle CASE
• ASM (Automatic storage Management)

PeopleSoft

• Application Server
• PeopleSoft Internet Architecture (PIA)
• Application Designer
• Data Mover
• Application Engine
• Process Scheduler
• Change Assistant

Databases

• Oracle 10G, 9.X, 8.X
• DB2 UDB on UNIX
• MS SQL Server 2003 and 2005.

Hardware & Operating Systems

• UNIX
• AIX
• Windows XP, Windows 2000
• HP-UX
• Novell
• Solaris

Programming Languages

• SQL
• UNIX shell
• COBOL

Other

• Quest Central for DB2 and Oracle
• Rational Quest
• Maximo
• Data warehouse/ETL – Informatica 8.1.1

Training
Oracle 10g RAC, Oracle SOA suite10g Ed1, PeopleSoft Security 8.4X, Oracle 10g new features for Administrators
PIA Server Administration, PeopleSoft People Tools (I & II), Technical Advanced training, Data Management Tools, Data warehouse/ETL-Informatica 8.1.1

PROFESSIONAL EXPERIENCE

2008 to 2009 Confidential, IN
Lead DBA

• Provided DBA support for web development environments. Provided inputs in Database design and layouts. Worked in Database support, backup & recovery in Oracle 10g environment.

1999 to 2008 – Confidential USA 
Lead DBA/Consultant

• Worked in Peoplesoft tools upgrade from 8.0 to 8.49 and application upgrade from 8 sp1 to 9.0.
• Worked in planning and with initial upgrade. Researched and provided resolutions. Provided guidance and knowledge transfer to customer.
• DBA responsibilities were instance creation, backups using rman, space management and monitoring on Oracle 10g using ASM in HP-UX environment.
• Upgraded people tools 8.46 to 8.49. Tasks included planning and applying upgrade steps, tuning for multiple Databases. Other tasks were Database monitoring of Sql Server database and maintenance. Performed backup for sqlserver 2005
• Worked in Tuxedo, AppServer and BEA WebServer, installation.
• Upgraded PeopleSoft tools 8.46 to 8.49. Tasks included planning and applying upgrade steps for multiple Oracle 10G Databases. Created and monitored Unix cron jobs. Also worked on AppServer installation.
• DBA tasks were performing space allocation using ASM, backups using rman, cloning of DB environments and tuning on Oracle 10G. Monitored Production Databases.
• Performed DBA support during Peoplesoft Financials upgrade from 8.8 to 8.9 including monitoring and tuning of Database.
• Worked on initial upgrade from HR/Campus Solutions 8SP1 TO 9.0. Tasks included running upgrade steps, data conversion, researching, troubleshooting and documentation. Monitored performance of conversion tasks and provided recommendations.
• Used PeopleSoft process scheduler to schedule batch jobs.
• DBA activities were monitoring and performance tuning of the SQL on Oracle 10G and HP-UX, Provided support for production Databases. Also recommended changes to configuration parameters. Modified and administered Unix cron jobs
• Worked in upgrading from PeopleSoft Financials release 8.4 to 8.9 with Tools 8.48. Modules included GL, AP, Projects and Inventory. Responsibilities included working with upgrade lab consultants, upgrade planning, running test moves, troubleshooting, applying Maintenance packs and fixes.
• Performed HCM 8.3 to 8.9 upgrade. Responsibilities included mentoring, guiding and walking through upgrade process for initial and test moves. Successfully delivered Test moves and Production Upgrade within budgeted timelines. Worked on HCM 8.47 tools upgrade, applying fixes, upgrade bundles and Maintenance packs using Change Assistant.
• DBA tasks included backup using rman and performance monitoring of Test and Production Databases. The environment is Oracle 10g and HP-UX. Monitored System performance during various upgrades. Worked in setting up hot backup and exports. Administered storage using ASM
• Analyzed customer\'s Security setup and upgrade methodology. Provided recommendations for improvement. Performed trouble shooting for Security and Tools 8.46 issues. Provided knowledge transfer & walk-thru for customer tech team on Tools 8.46.
• Upgraded a 600G HCM DB2/UNIX reporting database to HCM 8.8 for America’s second largest retailer. The core HCM modules upgraded included HR and Payroll. Responsibilities were running various upgrade tasks during test moves and production upgrade, unloading and loading data, trouble-shooting and modifying upgrade templates. Assisted with production upgrade for live, non-reporting database. Prepared task and time schedules and worked with both Security and DBA teams to coordinate dependent activities.
• Worked as the Technical Lead on one of PeopleSoft’s first large Enterprise Service Automation (ESA) projects. Applied over 125 patches and fixes for the modules Projects, Expenses, Resource Management and Contracts to multiple Oracle 9i Databases on Unix. Assisted team in Oracle 9i upgrade.
• Managed off shore team during Project. Team worked in customizations and test upgrades. Obtained status and communicated to the Project Director
• Installed FDM 8SP2 Database using OFA model and provided Production Database support. Performed troubleshooting during new DB creation. Provided lead and support services for other consultants during DBA activities. Used OFA model. Also coached customer DBA and performed knowledge transfer.
• Performed DBA support for PeopleSoft 7.5X and Unix/Oracle 8.0 System. Responsibilities included backup, recovery, space management, User Account Management and supporting Implementation team.

1997 to 1998 – Confidential,
Oracle DBA support- GM- EDS

• Senior DBA for a large automotive company. Provided production support, troubleshooting and Application Upgrades for 20 manufacturing plants. Created and administered Unix cron jobs
• Worked in upgrading Oracle 8 to 9i. Upgraded multiple Databases. Performed exports and imports. Migrated data into new release.

Environment: Oracle 8.X, IBM-AIX

1995 to 1997 –Confidential
Oracle/ Unix DBA support- multiple customers

• DBA support for Web based Transportation System. Performed Database Design and DB tuning, Web Server maintenance for Production and Development DBs.
• Support for Product handling System for a Fortune25 photographic equipment manufacturing company. Responsibilities included Database Design, change control using Oracle CASE and Database Administration.

Environment: Oracle 8.X