SUMMARY:

• 8+ years of IT Experience in PeopleSoft Database Administration and Oracle Database Administration
• Worked on various types of projects, including PeopleSoft upgrades, implementation, and support for PeopleSoft
• Installed and administered database design, creation, space management, and performance tuning
• Perform Backup and Recovery procedures for Oracle and SQL Server databases
• Created Jobs on UNIX and Windows platforms for backup and recovery procedure
• Excellent skills using UNIX and Windows Platforms
• Experience working in a 24X7 on - call environment

TECHNICAL SKILLS:

Operating Systems: Windows XP,Windows 2008 Server, 2012 Server, OEL, UNIX

Languages: SQL, core Java

Databases: Oracle 9i, 10g, 11g, 12c, SQL SERVER 2005, 2008R2

Web related: HTML, XML

Tools: & Utilities: MS Office, TOAD, Oracle Enterprise Manager

Web Servers: Oracle Weblogic Server

ERP: PeopleSoft Tools 8.4x/8.5x, PeopleSoft APP 8.8/8.9/9.0/9.1/9.2

PROFESSIONAL EXPERIENCE:

Confidential

Peoplesoft Application DBA

Responsibilities:

• Installed and configured PeopleSoft DEMO and System databases and applications for HCM/FSCM & Interaction Hub on People Tools 8.55 and on Oracle Databases
• Configure PeopleSoft Update Manager (PUM) via Change Assistant.
• Fine-tuned several server related parameters with tools 8.55
• Applying PUM Images to existing environments and created different types of PUM packages as needed.
• Apply Patch Updates to PUM images and create Change Packages for Bug Id
• Administer Oracle11g and 12c Databases on Linux environments
• Involved in the Oracle 12c database upgrade from 11.2.0.4 to 12.1.0.2.
• Involved in PeopleSoft database maintenance plans, including updating statistics, re-indexing, Capacity plans, and index analysis.
• Coordinated database backup/recovery strategy for various PeopleSoft databases.
• Upgraded Web logic from 10g to 12c.
• Upgraded Tuxedo from 11gR1 to 12c.
• Experience with Integration Broker, Application Designer, Change Assistant, Data mover.
• Troubleshoot Batch Processes like app engines, COBOL, SQR and app messages
• Incorporated strategies for tuning the environment for optimal performance.
• Optimized upgrade scripts and process to minimize downtime during final Move to Production.
• Prepared Project plans for critical projects so as to ensure to meet the deadlines.
• Apply tax updates to Development, test and production as part of life cycle.
• Configure, implement Change Assistant, Environment Management Hub/Agents
• Install & Configure WebLogic Single-server and Multi-server domains
• Installed SSL Certificates.
• Responsible for server and application build process across all environments (People Tools, Tuxedo, Process Scheduler, WebLogic, and PIA).
• Configure Integration Broker between HCM/FSCM & Portal.
• Worked on pre and post database refreshes and automated refresh scripts
• Performing PeopleSoft server administration tasks such as enabling, starting, stopping or configuring new server domains.
• Involved in Mock and Real Disaster Recovery test for Corporate Environments.
• Installed SES and configured Search functionality in PeopleSoft to enable Global Search and Menu Search.
• Monitor Server Vantage alerts for system problems and report/resolve issues
• Monitor system capacity and performance. Generate capacity reports.
• Providing operational support for all PeopleSoft applications.
• Responsible for applying the WebLogic, People Tools, Tuxedo patches to various environments.
• Fine-tuned Web, App & batch servers for optimal performance.
• Performed daily activities monitoring Web Servers, Application Servers and Batch Servers, Integration Broker Messages and performance of the Linux servers
• Administering WebLogic Servers and managing memory heaps.
• Clean up DDD/SYS Audit reports to keep both the People tools and Database Objects in Sync
• Responsible for PeopleSoft server administration and troubleshooting issues.

Environment: PeopleSoft HCM/PORTAL 9.0/9.2, Campus Solutions 9.0, People Tools 8.50.21/8.52.10/8.53.10/8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2, Red Hat Linux 5.6, IIS 6.0, Net Scout 5.3, STAT 5.6.2/5.6.4

Confidential

Senior IT Consultant

Responsibilities:

• Build, Configure PeopleSoft HCM 9.2, tools 8.55 on Image 19 using DPK's
• Build, Configure PeopleSoft FSCM 9.2, tools 8.55 on Image 20 using DPK's
• Installed and configured PeopleSoft DEMO and System databases and applications for HCM/FSCM & Interaction Hub on People Tools 8.55 and on Oracle Databases
• Configure PeopleSoft Update Manager (PUM) via Change Assistant.
• Act as a Subject Matter Expert in infrastructure design and upgrade projects and solutions based on best practices.
• Performed CS, PORTAL & Interaction Hub People Tools upgrade from 8.54 to 8.55
• Fine-tuned several server related parameters with tools 8.55
• Applying PUM Images to existing environments and created different types of PUM packages as needed.
• Apply Patch Updates to PUM images and create Change Packages for Bug Id
• Administer Oracle11g and 12c Databases on Linux environments
• Involved in the Oracle 12c database upgrade from 11.2.0.4 to 12.1.0.2.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, and Optimizer hints.
• Involved in PeopleSoft database maintenance plans, including updating statistics, re-indexing, Capacity plans, and index analysis.
• Coordinated database backup/recovery strategy for various PeopleSoft databases.
• Upgraded Web logic from 10g to 12c.
• Upgraded Tuxedo from 11gR1 to 12c.
• Configuring single sign-on for PeopleSoft Interaction Hub for multiple integrated PeopleSoft applications.
• Experience with Integration Broker, Application Designer, Change Assistant, Data mover.
• Troubleshoot Batch Processes like app engines, COBOL, SQR and app messages
• Knowledge of PeopleSoft interaction Hub applications and setup.
• Configuring and synchronizing user roles and user profiles across multiple PeopleSoft content providers.
• Synchronizing user personalization across multiple PeopleSoft content providers.
• Incorporated strategies for tuning the environment for optimal performance.
• Optimized upgrade scripts and process to minimize downtime during final Move to Production.
• Prepared Project plans for critical projects so as to ensure to meet the deadlines.
• Served as a core infrastructure domain expertise, PeopleSoft best practices and partnering with customers.
• Apply tax updates to Development, test and production as part of life cycle.
• Configure, implement Change Assistant, Environment Management Hub/Agents
• Install & Configure WebLogic Single-server and Multi-server domains
• Installed SSL Certificates, creation of CSRs on WebLogic server for various PeopleSoft environments.
• Responsible for server and application build process across all environments (People Tools, Tuxedo, Process Scheduler, WebLogic, and PIA).
• Configure Integration Broker between HCM/FSCM & Portal.
• Worked on pre and post database refreshes and automated refresh scripts
• Performing PeopleSoft server administration tasks such as enabling, starting, stopping or configuring new server domains.
• Involved in Mock and Real Disaster Recovery test for Corporate Environments.
• Installed SES and configured Search functionality in PeopleSoft to enable Global Search and Menu Search.
• Monitor Server Vantage alerts for system problems and report/resolve issues
• Monitor system capacity and performance. Generate capacity reports.
• Providing operational support for all PeopleSoft applications.
• Responsible for applying the WebLogic, People Tools, Tuxedo patches to various environments.
• Fine-tuned Web, App & batch servers for optimal performance.
• Performed daily activities monitoring Web Servers, Application Servers and Batch Servers, Integration Broker Messages and performance of the Linux servers
• Administering WebLogic Servers and managing memory heaps.
• Clean up DDD/SYS Audit reports to keep both the People tools and Database Objects in Sync
• Responsible for PeopleSoft server administration and troubleshooting issues.

Environment: PeopleSoft HCM/PORTAL 9.0/9.2, Campus Solutions 9.0, People Tools 8.50.21/8.52.10/8.53.10/8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2, Red Hat Linux 5.6, IIS 6.0, Net Scout 5.3, STAT 5.6.2/5.6.4

Confidential

Senior IT Consultant

Responsibilities:

• Installed and configured PeopleSoft DEMO and System databases and applications for HCM, FSCM, Campus Solutions and PORTAL on People Tools 8.54 and on Oracle 11g Databases
• Involved in the Application Upgrade from 9.0 to 9.2.
• Performed People Tools upgrade from 8.53.10 to 8.55.02
• Responsible for operating, managing, and maintaining over 150 physical and virtual servers for whole infrastructure.
• Configured PeopleSoft Update Manager (PUM). Applied CS PUM image 17, Applied CS PUM image 17.
• Configure, implement Change Assistant, Environment Management Hub/Agents.
• Applying Patches, bundles, Tax Updates and maintenance packs across all environments using PUM and change assistant.
• Applied People Tools and Tuxedo patches to various environments.
• Provide support on all the stages of database implementation and/or database related deployments including version upgrade and patch installs.
• Knowledge of Oracle performance tuning. Good knowledge on tools such as Oracle Enterprise Manager 12c, AWR, ADDM and SQL Tuning Advisor.
• Identified and corrected potential problems with business critical applications as Tier II on-call systems engineer.
• Proactively managed service delivery and application performance to avoid adverse business effects and meet SLA.
• Collaborated with development team to identify pre-production failures or anomalies, with the resolution fed back into the agile development process.
• Played a key role in troubleshooting, resolving complex issues and provided realistic workarounds to positively impact Go-Live decisions.
• Configured SES for PeopleSoft search functionality by Implementing across all the environments.
• Responsible for server and application build process across all environments (People Tools, Tuxedo, Process Scheduler, WebLogic, and PIA).
• Performance tuning of Web, App and process schedulers.
• Administering WebLogic Servers and managing memory heaps.
• Implemented single sign-on function between PeopleSoft and third party vendors for employee sign-in.
• Performed Database Refreshes for various environments.
• Helped DBA’s to Clone/Refresh Dev, QA & Test databases using Oracle EXP/IMP and Data Pump (EXPDP/IMPDP) utilities.
• Configured integration Broker between different PeopleSoft applications and external vendors.
• Worked on Integration Broker Messaging Issues that syncs employee data between CS & PORTAL systems.
• Extensively used STAT for PeopleSoft migrations across various environments.
• Clean up DDD/SYS Audit reports to keep both the People tools and Database Objects in Sync
• Configured new candidate gateway servers for external careers as part of People tools upgrade.
• Installed root CA certificates for external background checks.
• Identified, clean-up unused space and reclaimed about 5 TB of storage space.
• Involved in the monthly patching of Windows & Linux servers for various environments.
• Implemented Primary Disaster Recovery environment and performed successful testing.
• Troubleshoot Integration Broker messaging issues.

Environment: PeopleSoft HCM/PORTAL 9.0/9.2, Campus Solutions 9.0, People Tools 8.50.21/8.52.10/8.53.10/8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2, Red Hat Linux 5.6, IIS 6.0, Net Scout 5.3, STAT 5.6.2/5.6.4

Confidential

Senior IT Consultant

Responsibilities:

• Install, configure, trouble-shoot, performance tuning and administration of PeopleSoft Web, Application and Process Scheduler Servers on Windows & Linux Servers.
• Configure, implement and work with Integration Broker, Change Assistant, Environment Management Hub / Agents.
• Provided consultative services to customers from many technical areas in regards to the optimal strategy for the project implementation.
• Configure, implement and work with Integration Broker, Change Assistant, Environment Management Hub / Agents.
• Installed multi-language People Books for Canadian French & Spanish languages.
• Applied Global Payroll Core Product & multi-language (Canadian French & Spanish) packs.
• Responsible for Project, Code and Security migration between database environments (Dev into QA Testing, then into Production) after successful testing.
• Performed Database and Security Refreshes from the Production environments to Development and testing environments .
• Applying bundles and tax updates for all PeopleSoft environments.
• Analyze, map and create a new security permission lists and roles.
• Heavily involved in the UAT process with the end users and help in Ticket resolution.
• Worked on setup and configuration of Verity Search Engine and configure the database instances for File Attachments and customize the locations of the attachments for files on multiple layers .
• Clean up DDD/SYS Audit reports to keep both the People tools and Database Objects in Sync.
• Troubleshoot Issues related to Global Payroll Bundles/Language packs & tax updates.
• Configure & troubleshoot Integration Broker for App messaging.

Environment: PeopleSoft HRMS 9.0, People Tools 8.48.19, Oracle Web logic 10.1.0.2 Tuxedo 10g, Oracle 11.2.0.4, Win 2008, Toad 10.6

Confidential

Senior IT Consultant

Responsibilities:

• Installed and configured PeopleSoft Web Logic server, Tuxedo Application & Batch servers on both NT & Solaris Boxes.
• Performed People Tools upgrade for HR from 8.52.19 to 8.54.25 .
• Involved in the application upgrade of HR from 9.0 to 9.1 and tools 8.54.25 on Oracle Database
• Configured integration Broker between different PeopleSoft applications.
• Setup & configured STAT for PeopleSoft object migrations.
• Involved in a real time Disaster recovery test for various PeopleSoft instances.
• Knowledge in administering WebLogic Servers and managing memory heaps.
• Work on setup and configuration of Verity Search Engine with CS . Configure the database instances for File Attachments and customized the locations of the attachments for files on multiple layers.
• Lead a group of PeopleSoft Architects in the overall PeopleSoft component architecture for various modules including HCM and FSCM and Projects.
• Successfully performed Database Refreshes f or various environments.
• Fine- tuned PSAPPSRV.CFG file for improving performance.
• Incorporated strategies for tuning the environment for good performance.
• Implementation of new hardware architecture to support growing user community.
• Setup the Application and Server Level Trace/logging for troubleshooting most of the support issues.
• Extensive hands on knowledge on scheduling PeopleSoft batch jobs, troubleshooting, adding new jobs and changing existing jobs
• Monitored Space used by the Indexes, Table spaces and also rebuild/resized them whenever they have grown too large. Analyzed the Stats pack report and identified the SQL's that were getting stalled. Fine Tuned the SQL's to improve performance.
• Maintained good Documentation Standards for the whole PeopleSoft Infrastructure/Architecture.
• Extensively used PSADMIN utility to Administer, Create & Configure Application Server and Process Scheduler Servers.
• Setup and configured PeopleBooks for PeopleTools 8.54, HCM 9.0, FSCM 9.2 and also PeopleTools 8.55 on WebLogic Server.
• Setup the automated monitoring Scripts that alerts us through email in the event when the Servers go down.
• Worked extensively on Database tuning. Create Indexes, Sizing the indexes and computing the statistics on Table/Indexes after the creation. Also restructured the Queries for optimal performance. Identified the Long Running SQL's, SQL Blockers/Lockers and kill them to release the locking.
• Review alert logs, trace and dump files for errors.
• Fine Tuned the Production Web/App/Batch servers for optimal Performance.

Environment: PeopleSoft HCM/FSCM 9.0, People Tools 8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2, Red Hat Linux 5.6, IIS 6.0, Net Scout 5.3, STAT 5.6.2/5.6.4

Confidential

Client Technology Lead

Responsibilities:

• Installed PeopleSoft Database and Applications on NT and Unix Operating Systems
• Updated databases by applying Updates/Fixes/Patches after backup on timely basis and kept the record of the updates/fixes/Patches
• Configured Application Server, Web Server & Batch (Process Scheduler) Server.
• Installed BEA Tuxedo Appserver, WebSphere Web server,Oracle and created PeopleSoft DEMO and System Databases and Applied related Database patches and application Patches
• Configured Tuxedo services for windows and UNIX operating systems.
• Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service
• Changed the PSAPPSRV.CFG/PSPRCS.CFG configuration file for performance and tuning to specific environment.
• Experience in setup and configure PeopleSoft performance monitor for monitoring PeopleSoft performance data on Web Servers, application servers, process schedulers.
• Checked and cleared the application server cache on a regular basis as a maintenance process.
• Setup the Trace at various levels like the Log fence parameter in Domain Setting Section in the APPSRV.CFG file, trace logs in Configuration Manager for SQL, People Code, AE, etc and Enable Trace parameter in configuration.properties file on the Web Server.
• Created multiple Web Logic Server instances
• Installed PeopleBooks and configured the Web Server to access People Books.
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options (UPGOPT) project, update statistics and freeze PeopleTools.
• There were 20+ Oracle Databases ranging from 40 GB to 200 GB Databases ranging from 20 GB to 100 GB in size.
• Involved in Logical and Physical Design of databases. Organization of tablespaces across file system for performance optimization.
• Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing.
• Clone databases for new system implementations and development projects.
• Monitor database performance and growth such as table spaces, distribution of records, objects extents, fragmentation and free space.

Environment: PeopleSoft HCM/PORTAL 9.0/9.2, People Tools 8.50.21/8.52.10/8.53.10/8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2, Red Hat Linux 5.6, IIS 6.0, Net Scout 5.3, STAT 5.6.2/5.6.4

Confidential

Client Technology Lead

Responsibilities:

• Installed PeopleSoft Database and Applications on NT and Unix Operating Systems
• Updated databases by applying Updates/Fixes/Patches after backup on timely basis and kept the record of the updates/fixes/Patches
• Configured Application Server, Web Server & Batch (Process Scheduler) Server.
• Installed BEA Tuxedo Appserver, WebSphere Web server, MS SQL Server and created PeopleSoft DEMO and System Databases and Applied related Database patches and application Patches
• Configured Tuxedo services for windows and UNIX operating systems.
• Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service
• Changed the PSAPPSRV.CFG/PSPRCS.CFG configuration file for performance and tuning to specific environment.
• Experience in setup and configure PeopleSoft performance monitor for monitoring PeopleSoft performance data on Web Servers, application servers, process schedulers.
• Checked and cleared the application server cache on a regular basis as a maintenance process.
• Setup the Trace at various levels like the Log fence parameter in Domain Setting Section in the APPSRV.CFG file, trace logs in Configuration Manager for SQL, People Code, AE, etc and Enable Trace parameter in configuration.properties file on the Web Server.
• Created multiple Web Logic Server instances
• Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing.
• Monitor database performance and growth such as table spaces, distribution of records, objects extents, fragmentation and free space.

Environment: PeopleSoft FSCM/PORTAL 9.0/9.2 People Tools 8.50.21/8.52.10/8.53.10/8.54.05, Oracle Web logic 10.3.4/10.3.6/12 gR1, Tuxedo 10gR3/11gR1/12c, Verity 6.5.0, Oracle SES 11.2.2, Micro Focus COBOL Server Express 5.1, Oracle 11.2.0.4, Win 2008 SP2/2008 R2.

Confidential

Oracle DBA

Responsibilities:

• Installing and configuring Oracle Server on Red Hat Linux.
• Database Creation, Capacity planning.
• Upgraded database from 11g to 12c.
• Planning and Implementing Backup and Recovery Strategy using RMAN .
• Logical Backup using EXPDP and IMPDP .
• Knowledge on tablespace management, transportable Tablespaces to quickly refresh the Reporting database
• Monitoring and Maintaining User Activities.
• Implementing Security.
• Duplicate database using RMAN .
• Refresh the database using hot backup.
• Applied patch set 10.2.0.4.
• Knowledge on configuring physical stand by.

Confidential

Oracle DBA

Responsibilities:

• Daily basis health checks, Controlling and monitoring user access to the database.
• Responsible for the support and maintenance of 14 Oracle databases along with 2 physical standby for each databases in high availability (24*7 ) heterogeneous environment across all over India.
• ­Installation and Configuration of Oracle 11g, Created databases manually and using Database Configuration Assistant (DBCA ).
• Granted privileges to Oracle Users depending upon the requirements and worked on Oracle Space (adding, Dropping, resizing datafiles and tablespaces)and Instance Management.(Increasing parameter sizes, creating SP file, creating Pfile from Spfile and Spfile from Pfile)
• Responsible for support and maintenance of the Oracle Databases.
• Cloning the DEV instance from PROD for Single node Environments.
• Worked on Migration tasks and java upgrades.
• Applying Patches according to the requirement.