PROFESSIONAL SUMMARY:

• Confidential possesses over fifteen years of experience operating as a senior peoplesoft administrator / senior oracle dba implementing the peoplesoft applications hrms 8.x/9.x, financials 8.x/9.x, enterprise portal 8.x/9.x, customer relationship management 8.x/9.x, and enterprise learning management 9.x within both production and non - production environments while also configuring, tuning, upgrading, and supporting the underlying unix oracle database infrastructure.
• Confidential installs, troubleshoots, and applies upgrade patches via the peoplesoft development tools such as change assistant, upgrade assistant, application designer, application engine, sqr, and crystal reports. Confidential has worked with peoplesoft web application servers such as weblogic 6.1, 8.1, 9.2, and 10.3.6.

TECHNICAL SKILLS:

Sun Solaris, IBM H50 RS6000, IBM S70 RS6000, AS400, HP VAX, Defender, Mainframe (Open VMS), IBM PCs, laptops, laser printers, modems, Data Vault, Windows 2000/2003/2008 , Windows XP, MS NT Server 3.51/4.0/2000 , MS NT Workstation 3.51/4.0/2000 , MS Windows 3.11, MS Windows for Workgroups, MS Windows 95/98, Novell NetWare 3.1x and 4.11, Unix, Sun Solaris 5.7/5.8/5.10 , AIX 4.3.2 - 7.1, Linux Enterprise Server, HP/UNIX, VAX, OS390 (Open VMS), XA, Peopletools 7.x, 8.40, 8.42, 8.48.10, 8.49.08, 8.49.14, 8.51.08, 8.52, 8.53, 8.54, Peoplesoft Application Engine, PS Process Scheduler, PS Application Server, Crystal Reports, Nvision, BEA Web Logic 8.1, 9.2, 10.3.6, Apache, Tuxedo 6.5/8.1/11gr1, Jolt 1.2, MS Visual Basic 6.0, MS Word, MS Excel, MS Outlook, MS Outlook, MS Exchange 5.0/5.5, MS SQL 6.5/7.0, MS Proxy 1.0/2.0, MS Systems Management Server, MS IIS, WINS, DHCP, Oracle8i, Oracle9i, Oracle10g, Oracle 11g, Oracle 12c server on Unix, Oracle 7.3.4 on unix, Oracle 7.3.4 Workgroup Server on NT, Attachmate 3270, VTAM, CICS, TSO/ISPF, Open MVS, Telnet, Banyan Vines 5.51/5.53, Beyond Mail, Reflections, Visio Professional, Lotus Notes 5.1, Genesis, Vantive

DETAILED EXPERIENCE:

Confidential, Hanover, MD

Senior peoplesoft system administrator

Responsibilities:

• Responsible for creating, building, and populating the pristine peoplesoft hrms, financials, enterprise portal demonstration oracle 11g, and 12c database environments with seed data via the sqlplus and datamover data conversion database build scripts (peopletools 8.53, 8.54, 8.55).
• Responsible for proactively monitoring the production and non-production database environments so that we may identify any contention or table-level locks which may degrade intensive business processes (example: financial data ledger loads, peoplesoft online processing, peoplesoft automated batch processing; peopletools 8.53, 8.54, 8.55)
• Responsible for installing, configuring, troubleshooting and tuning the Enterprise Portal and Peoplesoft integration technologies (integration broker, application messaging, etc.).
• Responsible for providing support throughout scheduled disaster recovery test initiatives.
• Responsible for maintaining peoplesoft application role, row-level, and service operation security (peopletools 8.53, 8.54, 8.55)
• Understanding of PeopleSoft Security hierarchy and setup (Role-level, Permission Lists, User Profiles, Field-level, etc.) across application components (peopletools 8.53, 8.54, 8.55)
• Responsible for creating oracle databases.
• Responsible for supporting oracle standby databases.
• Responsible for monitoring oracle production and non-production environments.
• Responsible for monitoring oracle production and non-production environments.
• Experience with supporting Oracle Rac and Golden Gate.
• Responsible for maintaining and completing oracle backups.
• Fifteen years experience of proficiency with unix shell scripting, sqlplus tuning, and plsql tuning.
• Provide technical support for managed oracle database hosting services consisting of system administration of non-production and production oracle database technology components.
• Design, install, configure, support, upgrade, and tune oracle database instances.
• Design, install, configure, support, upgrade Peoplesoft environments on oracle real application clusters (RAC).
• Implement backups using RMAN; disaster recovery using DataGuard, and monitoring using Oracle Enterprise Manager.
• Responsible for applying database patches, updates and perform upgrades.
• Responsible for communicating with the application and database vendors for resolution of non-production and production issues (functional bugs, performance issues, etc.).
• Assist in the planning and execution of disaster recovery tests.
• Responsible for monitoring capacity.
• Responsible for performing routine production support activities and providing incident and problem management support.
• Produce non-production and production documentation as required.
• Implement automated project-type activities and miscellaneous requests for services.
• Responsible for performing support activities during scheduled maintenance windows.
• In the event of non-scheduled outages or emergencies, responsible to provide support (either on-site or remotely using VPN connectivity) outside normal working hours.
• Responsible to provide standby and scheduled on-call support.
• Responsible to troubleshoot database-related issues and undertake performance tuning (oracle database issues, and peoplesoft application related issues).
• Fifteen years of peoplesoft administration experience including installation, support, troubleshooting, monitoring, optimization, tuning infrastructure components (web, app, process scheduler), sql tuning, applying maintenance using PUM, application and peopletools upgrades.
• Peopletools 8.53, 8.54, 8.55, Peoplesoft Financials 9.2, Peoplesoft HCM 9.2, process scheduler (unix and windows), application server (tuxedo), web server (weblogic), application designer, data mover, integration broker, sqr, BI Publisher, change assistant, PUM, SES, unix / linux (Red Hat, OEL), shell-scripting and oracle sql 8i, 9i, 10g, 11g, 12c.
• Responsible for completing load / stress testing within the Peoplesoft Financials and Peoplesoft HCM/HRMS load stress test instances via load-runner automated scripts.

Environment: hrms 9.1, 9.2, financials 9.1, 9.2, portal 9.2 (peopletools 8.53, 8.54, 8.55) oracle 11g, 12c, otd (oracle traffic director), webcenter

Confidential, Sterling, VA

Senior peoplesoft system administrator

Responsibilities:

• Responsible for creating, building, and populating the pristine peoplesoft hrms, campus solutions, financials, elm (enterprise learning management), crm (customer relationship management), epm (enterprise performance management), and enterprise portal demonstration oracle 10g, 11g, and 12c database environments with seed data via the sqlplus and datamover data conversion database build scripts.
• Responsible for upgrading and establishing the required development, testing, user acceptance testing, training, production, and stress or loading oracle database instances.
• Responsible for installing, configuring, troubleshooting and tuning the Enterprise Portal and Peoplesoft integration technologies (integration broker, application messaging, etc.).
• Responsible for generating the database statistics in lieu of enhancing database access.
• Responsible for proactively monitoring the production and non-production database environments so that we may identify any contention or table-level locks which may degrade intensive business processes (example: financial data ledger loads, peoplesoft online processing, peoplesoft automated batch processing).
• Proficient with the client’s disaster recovery solution.
• Responsible for providing support throughout scheduled disaster recovery test initiatives.
• Responsible for generating oracle database traces and peoplesoft application traces in support of tuning peoplesoft application code (oracle sqlplus calls via peoplesoft batch processes such as cobol/sql, application engine/sql, sqr/sql, online navigation/sql).
• Knowledgeable with validating the current status and generating oracle object partitions to enhance data access.
• Experienced in scheduling nightly peoplesoft batch housekeeping and oracle database specific housekeeping job streams via the maestro scheduling system.
• Experienced in documenting and completing the daily oracle database related and peoplesoft administrative related tickets within the service-now and remedy tracking systems.
• Confidential became Tricare certified in Tricare PHI / PII and HIPPA covered protected health information with the Defense Health Agency Mission Assurance.
• Confidential completed the non-production iplanet proxy web server domain clean-up effort containing 90+ non-production environments.
• Completed the Metalico and ERP database decommission effort.
• While supporting the Metfacs2 peoplesoft environments Confidential assisted the Metfacs upgrade testing team by completing the required file transfers between the production Metfacs and non-production Metfacs instances via service-now and remedy support tickets.
• Confidential also assisted the Metfacs application developer team with production support validating that the production environments are properly load balanced as required.
• Confidential produced supplemental Metfacs2 Financials, Markview, and Vertex support documentation.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).
• Manages and coordinates all aspects of the customer environment.
• Troubleshot peoplesoft environment technical issues.
• Perform peopletools and application upgrades of hrms 9.1 (peopletools 8.51) to hrms 9.2 (peopletools 8.54).
• Perform peopletools and application upgrades of financials 9.1 (peopletools 8.51) to financials 9.2 (peopletools 8.54)
• Perform peopletools and application upgrades of campus solutions 9.1 (peopletools 8.51) to campus solutions 9.2 (peopletools 8.54).
• Manage and administer Peoplesoft security.
• Installation and configuration of peoplesoft application components.
• Coordinate operating system and database upgrades / patching.
• Coordinate job streams with the functional teams, and developers.
• Completes peoplesoft application server, web server and process scheduler server administration.
• Assist with application and peoplesoft internet architecture tuning.
• Understand and use peoplesoft application upgrade tools, migration tools, and data mover.
• Understand and able to execute peoplesoft delivered utilities.
• Understands client database platform and perform basic database administration tasks.
• Assist in performance tuning.
• Run and analyze peoplesoft and oracle traces.
• Confidential possesses fifteen years of peoplesoft administration and oracle database administration experience supporting the Peoplesoft HRMS 8.x / 9.x, Campus Solutions 8.x / 9.x, Finance 8.x / 9.x, Enterprise Learning Management 9.x, Customer Relationship Management 9.x, and Enterprise Performance Management 9.x applications on unix aix, redhat enterprise linux 6, and windows platforms.
• Confidential possesses fifteen years of expertise completing peoplesoft application, peopletools and oracle database upgrades.
• Possesses three years of experience with implementing and configuring the peoplesoft ptf framework (peoplesoft test framework) and have collectively worked in conjunction with the functional and technical application development staff with regard to validating and executing the technical scripts.
• Responsible for completing load / stress testing within the Peoplesoft Financials, Peoplesoft HCM/HRMS, and Peoplesoft Enterprise Learning Management load stress test instances via load-runner automated scripts.

Environment: hrms 9.1, 9.2, campus solutions 9.1, 9.2, elm 9.0, crm 8.9, hcm 9.1, 9.2, financials 9.1, 9.2, portal (peopletools 8.51.19, 8.51.23, 8.52.07, 8.53.00, 8.54.00) oracle 10g, 11g, 12c

Boeing, Hazelwood, MO

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Completed the manual upgrade of the demonstration, development, test, uat non-production ohs (oracle http server), weblogic, and java patch updates.
• Automated the process of applying ohs, weblogic, and java patch updates via unix shell scripting.
• Generated the unix shell automated scripts which would reconfigure the peopletools application server and process scheduler domains.
• Responsible for installing, configuring, troubleshooting and tuning the Enterprise Portal and Peoplesoft integration technologies (integration broker, application messaging, etc.).
• Confidential was responsible for completing routine environment refresh and rebuild activities.
• Responsible for the availability of the weblogic webserver domains, peopletools application server domains, and the peopletools process scheduler domains.
• Required to provide non-production and production support during a peopletools 8.51.19 to peopletools 8.51.23 upgrade.
• Required to provide non-production and production support during the application campus solutions 9.1 to campus solutions 9.2 upgrade.
• Required to provide non-production and production support during the application elm 9.0 to elm 9.2 upgrade.
• Required to provide non-production and production support during the application crm 8.9 to crm 9.2 upgrade.
• Required to provide non-production and production support during the oracle 11.2.0.2 to oracle 11.2.0.3 upgrade.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).

Environment: hrms 9.1, 9.2 elm 9.0, campus solutions 9.1, 9.2, crm 8.9, hcm 9.1, 9.2, portal 9.2 (peopletools 8.51.19, 8.51.23, 8.53.00) oracle 10g, 11g

Confidential, Seattle, WA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Completed the installation of the demonstration, development, test, uat non-production and production peoplesoft / oracle database instances, which included the installation of the oracle10g, 11g databases, the creation of the weblogic webserver domains, peopletools application server domains, and the peopletools process scheduler domains.
• Assisted with the upgrade from hrms 8.9 (peopletools 8.48.10) to hrms 9.0 (peopletools 8.50.08).
• Responsible for completing all required configurations within change assistant which is used to complete the upgrade path.
• Required to troubleshoot, and tune all aspects of the peoplesoft internet architecture, the corresponding oracle database, as well as tune oracle calls (sql calls and application tuning).
• Confidential established the database level backup strategy which included various strategies such as oracle hot backups, oracle exports, and oracle rman.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).
• Responsible for installing, configuring, troubleshooting and tuning the Enterprise Portal and Peoplesoft integration technologies (integration broker, application messaging, etc.).

Environment: hrms 9.0, 9.1, hcm 9.0, 9.1, portal 9.0 (peopletools 8.50.08, 8.50.14, 8.51.08), oracle 10g, 11g

Confidential, San Jose, CA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• As senior peoplesoft administrator oracle dba Confidential assisted with the upgrade of peoplesoft hrms 8.8.0 (peopletools 8.49.14) to hrms 9.10.00 (peopletools 8.51.08).
• Completed the installation of various peoplesoft client based file server homes within the citrix metaframe environment; hrms 8.8.0, 9.10 (peopletools 8.49.08, 8.49.14, 8.51.08), and financials 7.52 (peopletools 7.59).
• Apart from assisting with the hrms upgrade Confidential also applied the required tax updates, executing the corresponding datamover scripts and loading cobol stored statements.
• Collectively with the oracle dba staff Confidential tuned (sql calls, via sql trace and tkprof) degraded peoplesoft batch processes, confirmed the status of scheduled oracle rman backups, and completed scheduled non-production database refresh cycles.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).

Environment: hrms 8.8, 9.1, hcm 8.8, 9.1 (peopletools 8.49.08, 8.49.14, 8.51.08), financials 7.52 (peopletools 7.59), oracle 9i, 10g, 11g

Confidential, San Diego, CA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• As senior peoplesoft administrator oracle dba Confidential was responsible for the installation, configuration and tuning of the peoplesoft hcm 9.1 (peopletools 8.51), financials 9.1 (peopletools 8.51) environments containing bea weblogic server 10.3.1, application server, and process scheduler domains.
• Confidential maintained the demonstration, development, and production instances for each of the hcm and financial environments.
• Confirmed that the integration broker message nodes, process scheduler report nodes, and single sign-on functionality remain available.
• Confidential also acted as team technical support in resolving peoplesoft application server, process scheduler, bea weblogic server, and oracle database issues.
• Confidential acted as the primary oracle dba responsible for installation, configuration, tuning and performance, and support of the production and non-production instances.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).

Environment: hrms 9.1, hcm 9.1 (peopletools 8.51), financials 9.1 (peopletools 8.51), oracle 9i, 10g

Confidential, Mclean, VA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Completed the upgrade of hrms 8.9 (peopletools 8.46.00) to hrms 8.9 mp10 (peopletools 8.48.10) via change assistant.
• Completed the upgrade of enterprise portal 8.9 (peopletools 8.47.00) to enterprise portal 8.9 bundle 6 (peopletools 8.48.10) via change assistant.
• Completed the upgrade of enterprise learning management 9.0 (peopletools 8.48.00) to enterprise learning management 9.0 (peopletools 8.48.10) via change assistant.
• Performed the upgrade of bea weblogic 8.1 to 8.1 sp6.
• Performed a new implementation of campus solutions 8.9.
• Within the non-production environment Confidential maintained the demonstration, development, training, test, uat, and loading instances for each of the supported applications, hrms, enterprise portal / interaction hub, elm, and campus solutions.
• Responsible for streamlining the non-production refresh process which was initially occupying five business days to complete and finally streamlined to one and a half business days after automating eighty percent of the refresh process.
• Daily administrative tasks included configuring and validating the integration broker message nodes for all hrms, enterprise portal / interaction hub, and elm environments were available, along with confirming the corresponding process scheduler report nodes, and reports successfully post without failure.
• Responsible for allocating system storage and planning future storage requirements for the database system and unix peopletools file systems.
• Operated as the mentor to the junior peoplesoft and oracle dba staff.
• Performed routine oracle database clones, tuned sql calls via sql trace and tkprof, confirmed the status of oracle export backups, hot backups, and rman backups.
• Installed, configured, troubleshot and tuned various batch programs as required (sqr, cobol, crystal reports, psquery, etc.).

Environment: hrms 8.9 mp10, hcm 8.9 (peopletools 8.48.10), campus solutions 8.9, enterprise portal 8.9 bundle 6 (peopletools 8.48.10), enterprise learning management 9.0 bundle 9 (peopletools 8.48.10), oracle 9i, 10g

Confidential, Torrance, CA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Responsible for developing a unix shell and sqlplus automated refresh process which would initiate an oracle schema level export and import between two specific database environments.
• Developed automated shell scripts responsible for building all pertinent sqlloader control files used to populate the database with legacy data.
• Knowledgeable in the use of sqlloader utilizing direct and conventional mode and the parallel load option.
• Via unix shell, sqlplus and plsql, Confidential also created scripts to help manage remote systems with less manpower and to reduce downtime.
• Provided availability for all database instances and completed tuning and performance as required.
• Possess excellent performance tuning skills at both the database and individual sql call levels.
• Confidential was the key point responsible for completing the upgrade from oracle 9i (9.2.0.4) to Oracle 9i (9.2.0.7).
• Responsible for the preservation and administration of the Enterprise Linux 3 oracle 9i, 10g databases such as developing a combination of unix shell and sqlplus scripts which would monitor, report and backup each of the in-house custom environments.
• Applied the required oracle 9i, 10g patch sets, created the application tablespaces, tables, and indexes, and troubleshot all database issues during the installation of oracle 9i, 10g.
• Acquired experience in using oracle table level partitioning options, and the use of plsql, stored procedures, and packages.

Environment: hrms 8.4, hcm 8.4 (peopletools 8.44), financials 8.4 (peopletools 8.44), oracle 9i, 10g

Confidential, New York, NY

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Confidential was responsible for the installation, configuration and tuning of the peoplesoft hrms and financials 8.4x environment containing bea weblogic, peopletools 8.4, application servers, process schedulers, peoplesoft nt file server, and oracle 9i, 10g unix server.
• The peoplesoft financials modules which were supported are general ledger, payables, projects, asset management, billing, purchasing, eProcurement, and inventory.
• The peoplesoft hrms modules supported were global payroll, benefits, payroll, and human resources.
• Performed technical peoplesoft oracle 9i, 10g dba duties for the corporate hrms 7.3, 8.42, 8.8 and financials 7.3, 8.4, 8.8 databases on hewlett packard unix and microsoft server platforms.
• Provided availability for all oracle 9i, 10g databases, maintained tables, and completed tuning performance as required.
• Developed unix shell, sqlplus, microsoft dos scripts to help manage remote systems with less manpower and to reduce downtime.
• Performed database and peoplesoft application tuning guidance, enhancing sqr, application engine, cobol, sqlplus, plsql programs by creating custom indexes to speed data access.
• Confidential also gathered response timed statistics for various departments and processes during the tuning phase.
• Possess experience resolving peoplesoft application problems by analyzing peoplesoft oracle 9i, 10g trace files.
• Debugged and tuned various peoplesoft online processes to streamline production processing.
• Confidential acted as the key programming language resource for hp unix shell scripting, sqlplus, and plsql programs.

Environment: hrms 7.3, 8.4, 8.8, hcm 8.8 (peopletools 7.x, 8.x) financials 7.3, 8.4, 8.8 (peopletools 7.x, 8.x), oracle 10g, 11g

Confidential, Woburn, MA

Senior peoplesoft administrator / oracle dba

Responsibilities:

• Confidential built the peoplesoft environments web, application, process scheduler, file server domains, and underlying oracle databases.
• The peoplesoft oracle administration was completed on the hp unix infrastructure.
• Performed multiple peopletools 8.44 to 8.45 upgrades for all the non-production environments.
• Confidential possesses fifteen years of expertise completing peoplesoft application, peopletools and oracle database upgrades.

Environment: hrms 8.4, hcm 8.4 (peopletools 8.44, peopletools 8.45), financials 8.4 (peopletools 8.44, peopletools 8.45), oracle 10g, 11g

Confidential, New York, NY

Senior peoplesoft administrator / sql dba

Responsibilities:

• Performed the peoplesoft financials 8.4 to financials 8.4 sp2 upgrade.
• The peoplesoft implementation was completed on microsoft sql server databases.
• Responsible for the installation, configuration and tuning of the production and non-production peoplesoft 8.4 financials (peopletools 8.44) environment containing bea weblogic, application server, process scheduler, microsoft windows file server, and microsoft sql database servers.
• Confidential acted as the team technical support lead in resolving peoplesoft application, process scheduler, web domain server configuration, database platform programming issues.
• Established cases with peoplesoft concerning upgrade issues and acted as single point of contact for open cases with peoplesoft customer support.

Environment: financials 8.4 (peopletools 8.44), financials 8.4 sp2 (peopletools 8.44), oracle 8i, 9i