Senior Peoplesoft System Administrator / Oracle Dba Resume
Las Vegas, NV
PROFESSIONAL SUMMARY:
- Confidential possesses over fifteen years of experience operating as a senior peoplesoft administrator / senior oracle dba / solution architect 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 PUM (Peoplesoft Product Update Manager via deployment kits dpk), 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, 10.3.6, and 12.x.
TECHNICAL SKILLS:
Technology and Tools: 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 R2/WIN 2012, 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, OEL 5, 6, 7 Redhat Enterprise Linux, 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, 8.55, 8.56, Peoplesoft Application Engine, PS Process Scheduler, PS Application Server, Crystal Reports, Nvision, BEA Web Logic 8.1, 9.2, 10.3.6, 11.x, 12.x, Apache, Tuxedo 6.5/8.1/11gr1, 12.x, 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, sqlplus programming / tuning expert, plsql programming / tuning expert, Attachmate 3270, VTAM, CICS, TSO/ISPF, Open MVS, Telnet, Banyan Vines 5.51/5.53, Confidential Mail, Reflections, Visio Professional, Lotus Notes 5.1, Genesis, Vantive, WebLogic 12c (weblogic 12.1.3.0.0 ), Tuxedo 12c (tuxedo 12.1.3.0.0 ), Peopletools 8.50, 8.51, 8.52, 8.53, 8.54, 8.55, 8.56, Secure Enterprise Search, Elastic Search, Verity Search.
PROFESSIONAL EXPERIENCE:
Confidential, Las Vegas, NV
Senior peoplesoft system administrator / oracle dba
Responsibilities:
- Responsible for creating the demonstration peoplesoft hrms, campus solutions, financials, elm (enterprise learning management), crm (customer relationship management), epm (enterprise performance management), and enterprise portal demonstration oracle 12c database environments with seed data via the sqlplus and datamover data conversion database build scripts.
- Implemented and configured the peoplesoft ptf framework (peoplesoft test framework).
- 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 in addition to AWS ( Confidential web services) as it relates to EC2, VPC and security groups (peopletools 8.53, 8.54, 8.55)
- Responsible for applying database patches, updates and perform upgrades.
- Responsible to provide standby and scheduled on-call support.
- Fifteen years of peoplesoft administration experience including installation, support, troubleshooting, monitoring, optimization, tuning infrastructure components (web, app, process scheduler, oracle), sql tuning, applying maintenance using PUM, and change assistant, application 9.0/9.1/9.2 and peopletools (8.53,8.54, 8.55, 8.56) upgrades.
- Responsible for enabling / disabling the fluid functionality when appropriate across the Peoplesoft production and non-production environments.
- Responsible for upgrading and establishing the required development, testing, user acceptance testing,, 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.
- Responsible for providing support throughout scheduled disaster recovery test initiatives.
Environment: hrms 8.8, 8.9, 9.0, 9.1, 9.2, financials 8.8, 8.9, 9.0, 9.1, 9.2, crm 8.9. 9.0 (peopletools 8.48, 8.49, 8.50, 8.51, 8.52, 8.53, 8.54, 8.55) oracle 10g, 11g, 12c
Confidential, Hanover, MD
Senior peoplesoft system administrator / oracle dba / solution architect
Responsibilities:
- Hands on implementation knowledge of Oracle Data Masking within the Peoplesoft HCM, HRMS, and Financials applications.
- Strong knowledge of SQL (structured query language).
- Strong knowledge of different masking Algorithms.
- Strong knowledge of sensitive data discovery.
- Execute the data masking scripts within a copy of the Peoplesoft HCM and Financial applications within the cloned non-production environments (masking environments);
- Experienced with conducting performance tuning of the data masking routines.
- Responsible for monitoring oracle production and non-production environments (including the masking / data masking environments).
- Implement automated project-type activities and miscellaneous requests for services (including routine refresh cycles and database cloning of the peoplesoft hcm, hrms, financials oracle production and non-production masking and non-masking database environments).
- Responsible for creating, building, and populating the pristine peoplesoft hrms, hcm, financials, enterprise portal, crm 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) within the Exadata (oracle database infrastructures) and Exalogic (peoplesoft infrastructures) platforms.
- 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) within the Exadata and Exalogic platforms.
- Responsible for installing, configuring, troubleshooting and tuning the Enterprise Portal and Peoplesoft integration technologies (integration broker, application messaging, LDAP, MS Active Directory AD with Redhat Enterprise Linux 6 and remote desktop services, etc.) within the production and non-production Exalogic platforms.
- Responsible for providing support throughout scheduled disaster recovery test initiatives.
- Responsible for maintaining peoplesoft application role, permission list, 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 in addition to AWS ( Confidential web services) as it relates to EC2, VPC and security groups (peopletools 8.53, 8.54, 8.55)
- Responsible for creating oracle databases within the Exadata and Exalogic platforms.
- Responsible for supporting oracle standby databases.
- 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 residing on the Exadata platform.
- 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 to the OEL 5, 6, 7 Redhat Enterprise Linux, Oracle 11G / 12C and Peoplesoft Enterprise Exadata and Exalogic platforms.
- 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.
- 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) residing on the Exadata and Exalogic platforms.
- Fifteen years of peoplesoft administration experience including installation, support, troubleshooting, monitoring, optimization, tuning infrastructure components (web, app, process scheduler, oracle webcenter, oracle traffic director), sql tuning, applying maintenance using PUM, and change assistant, application 9.0/9.1/9.2 and peopletools 8.50,8.51,8.52,8.53,8.54 (fluid),8.55 upgrades residing on the Exadata and Exalogic platforms.
- 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 5, 6, 7), 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.
- Thorough understanding of the entire Software Development Lifecycle (SDLC) and IT systems architecture including hardware and software.
- Strong commitment to following SDLC / Change-Management principles.
- Experience with the upgrade and migration path via SDLC: assessment, compare, keep-drop analysis, multiple test moves, migrations, tuning, security while utilizing tools such as Phire, Quest STAT, application designer, and change assistant.
- Responsible for supporting, configuring, and validating the status of automated oracle database and peoplesoft job streams scheduled in various batch scheduling systems such as Maestro, CA7, Autosys, and Appworx.
- Responsible for validating, tuning and support of backup and recovery of production and non-production database instances.
- Proficient with Microsoft Office, SharePoint and Microsoft Project.
- Detailed understanding and experience with ITIL processes and structured program management (PMI).
- Responsible for deploying, configuring, troubleshooting Peoplesoft Secure Enterprise Search and Elastic Search.
- Maintained the production and non-production Peoplesoft environments and underlying oracle 12c database environments on exalogic and exadata infrastructures (OEL 5, 6, 7 Red Hat Enterprise Linux 5, 6, 7).
- Responsible for enabling / disabling the fluid functionality when appropriate across the Peoplesoft production and non-production environments.
- Acted as backup Peoplesoft Report Analyst being responsible for developing, configuring, and identifying Peoplesoft reports.
- Acted as backup Peoplesoft Report Analyst remaining responsible for developing ad-hoc queries via PS Query.
Environment: hrms 9.1, 9.2, financials 9.1, 9.2, portal 9.2, crm 8.9, 9.0 (peopletools 8.53, 8.54, 8.55) oracle 11g, 12c, otd (oracle traffic director), webcenter
Confidential, Sterling, VA
Senior peoplesoft system administrator / oracle dba
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,, 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, Active Directory AD integrations with Redhat Enterprise Linux 6, 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 (top security clearance).
- 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, OEL 5, 6, 7 Redhat Enterprise Linux 5, 6, 7 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.
- Responsible for supporting, configuring, and validating the status of automated oracle database and peoplesoft job streams scheduled in various batch scheduling systems such as Maestro, CA7, Autosys, and Appworx.
- Responsible for deploying, configuring, troubleshooting Peoplesoft Secure Enterprise Search and Elastic Search.
- Maintained, supported and tuned the Peoplesoft EPM (Enterprise Performance Management) application and oracle OBIEE infrastructures.
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
Confidential, 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.).
- Responsible for supporting, configuring, and validating the status of automated oracle database and peoplesoft job streams scheduled in various batch scheduling systems such as Maestro, CA7, Autosys, and Appworx.
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, Montvale, NJ
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.).
- Responsible for supporting, configuring, and validating the status of automated oracle database and peoplesoft job streams scheduled in various batch scheduling systems such as Maestro, CA7, Autosys, and Appworx.
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,, 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 Confidential 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 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
Confidential, Westbury, NY
Senior peoplesoft administrator / oracle dba
Responsibilities:
- Performed the peoplesoft hrms 7.3 to hrms 8.0 upgrade.
- Performed the peoplesoft hrms 8.0 to hrms 8.3 sp1 upgrade.
- Rectified all upgrade issues and provided technical solutions.
- Completed the peoplesoft financials upgrade from version 7.5 to revision 8.42 utilizing upgrade assistant.
- Performed the upgrade of oracle database 8i to 9i, peopletools 8.16 to peopletools 8.42 upgrade.
- Applied tuxedo and jolt patches, weblogic service packs and jvm updates.
- Throughout the upgrade Confidential managed cases with peoplesoft customer support concerning upgrade issues while also acting as the single point of contact for open cases with peoplesoft serving as the technical resource for developer and functional leads.
- Performed routine peoplesoft migrations to various instances.
- Responsible for running environment compare reports, reviewing results, executing all upgrade steps via upgrade assistant, merging custom objects, during the move to production, and sustaining application security.
- Debugged and tuned various peoplesoft sqr's and online processes to enhance production processing in addition to tuning sqlplus scripts and sqr programs in support of the upgrade conversion process.
- The hrms modules supported were global payroll, benefits, payroll, human resources.
- The financial modules supported were general ledger, payables, projects, asset management, billing, purchasing, eProcurement, and Inventory.
- Provided 7/24 production support for all peoplesoft hrms, financial environments.
- Performed Oracle 8i, 9i database and peoplesoft application tuning, sqr tuning, application engine tuning, cobol tuning, sqlplus tuning, and plsql tuning by creating custom indexes to enhance data access.
- Gathered response timed statistics for various departments and performed oracle 8i, 9i database tuning.
- Confidential possesses experience resolving peoplesoft application problems by analyzing peoplesoft oracle 8i, 9i trace files.
- Determined the peoplesoft and oracle roles and permissions, user creation of user id's for all employees, provide security procedures and security for the application staff.
- Acted as team technical expert in online and batch process troubleshooting while also providing support in database configuration and platform issues within an oracle 8i, 9i windows and unix environment.
- Configured peoplesoft windows servers via configuration manager, allowing users the ease of switching between multiple peoplesoft environments.
- Cloned database instances to insure consistency between development, test and production environments via oracle database clone strategies.
- Implemented proactive monitoring tools detailing disk usage and log anomalies. For example one tool would page the on-call dba to critical engine events as they occur. Another tool remotely queries instances at a configurable interval insuring maximum uptime.
- Design, develop, deploy and maintain oracle terabyte size instances across servers for development, test and production environments for applications with online analytic processing (OLAP), online transaction processing (OLTP) and scheduled batch processes.
- Performed technical peoplesoft oracle 8i, 9i dba duties for the corporate hrms 7.3, 8.3 and financial 7.3, 8.42 on unix and microsoft windows platforms.
Environment: hrms 7.3, 8.3 sp1, hcm 8.3 (peopletools 7.x, 8.42), financials 7.3, 8.4 (peopletools 7.x, 8.42), oracle 8i, 9i
Confidential, Palo Alto, CA
Senior peoplesoft administrator / oracle dba
Responsibilities:
- Confidential acted as the technical lead during the upgrade of peopletools within an hp unix oracle platform.
- Upgraded and tested peopletools revision using upgrade assistant.
- Applied the required peoplesoft and oracle patch sets.
- Developed technical project documents for the upgrade project.
- Responsible for the preservation of the unix sun solaris back-end oracle databases, such as developing a combination of unix shell sqlplus scripts, which would monitor each of the peoplesoft hrms and financial environments.
- Completed the oracle 8i, 9i installs, configuration, upgrade, maintenance, and planned for backup and recovery of production and non-production database instances.
- Archived data was maintained on tape.
- Backup and restore strategies of production and non-production included Sql Backtracks, oracle export dump files, and tablespace backups.
- Confidential was responsible for releasing test environments following an oracle clone refresh process.
- Possess experience in using oracle table level partitioning options.
Environment: hrms 8.4, hcm 8.4 (peopletools 8.40, 8.42), financials 8.4 (peopletools 8.40, 8.42), oracle 8i, 9i
Confidential, San Carlos, CA
Senior peoplesoft administrator / oracle dba
Responsibilities:
- Confidential was responsible for developing an automated sqlplus refresh process which would initiate an oracle schema level export and import between two specific database environments.
- Maintained four microsoft nt 4.0 oracle database servers containing twenty database instances.
- Control, monitor and optimize user access and performance of the database instances.
- Acquired experienced in utilizing the function of control structures and loops, creating stored programs such as procedures, functions, packages and triggers via oracle sqlplus programming.
- Possess a thorough understanding of logical and physical modeling concepts with experience with Erwin data modeling.
- Provided technical consultation and analysis, solving environment migrations, installation of oracle patch sets and production support.
Environment: hrms 8.4, hcm 8.4 (peopletools 8.42) financials 8.4 (peopletools 8.42), oracle 8i, 9i
Confidential, Pleasanton, CA
Senior peoplesoft administrator / oracle dba
Responsibilities:
- Confidential built and maintained the technical infrastructure for remote customer users, physical web servers, application servers, process scheduler servers, windows file servers, and unix oracle and db2 database servers required by the customer of the Peoplesoft eCenter ASP department.
- Completed the peoplesoft upgrade of hrms 7.3 (peopletools 7.x) to hrms 8.0 (peopletools 8.0) on the oracle 8i and db2 database environments.
- Completed the peoplesoft upgrade of financials 7.3 (peopletools 7.x) to financials 8.0 (peopletools 8.0) on the oracle 8i and db2 database environments.
- Implemented peoplesoft upgrades including the periodic 1099 and tax updates.
- Supported Peoplesoft's eCenter ASP production and non-production systems ensuring 7/24 customer availability.
- Installed, configured and implemented the peoplesoft applications hrms, financials supply chain management, and development toolsets such as sqr, crystal reports, nvision, application engine, application designer, peopletools, bea tuxedo, apache/weblogic web, application, process scheduler, and database servers within a three-tier configuration.
- Provided technical consultation and analysis solving customer problems during the peoplesoft hrms 8.0 and financials 8.0 implementation on both oracle 8i and db2 database environments.
- Maintained and customized online and offline documentation.
- Troubleshot and rectified all upgrade assistant activities/issues.
- Troubleshot all technical issues including connectivity, server process problems, and script errors, etc.
- Collectively worked with the development and functional staff.
- Confidential performed analysis on comparison reports between upgrade environments and successfully addressed discrepancies.
- Participated in the successful conversion of existing peoplesoft 7.3 security to the new 8.0 structure.
- Provided weblogic 6.1 expertise with regard to tuning the web server for optimal performance within nt and unix environments.
- Responsible for the preservation of the unix sun solaris back-end oracle and db2 database environments such as developing a combination of unix shell sqlplus scripts which would monitor each of the peoplesoft hrms, financials 7.x, 8.x key objects and would supply a complete report of the current extent and overall size growth of these objects (tablespaces, tables, indexes).
- Confidential also automated specific business processes.
Environment: hrms 7.3, 7.5, 8.0, hcm 8.0 (peopletools 7.x, 8.0), financials 7.3, 7.5, 8.0 (peopletools 7.x, 8.0), oracle 7.3, 8i
Confidential, Fresno, CA
Peoplesoft administrator / oracle dba
Responsibilities:
- During the implementation phase of the Peoplesoft 7.x application (Financials Supply Chain Management Supply Chain Management 7.x/HRMS 7.x), I was responsible for the creation/modification of all Oracle database objects, which had become accessed and populated with data.
- Daily I would consult with the Peoplesoft applications group to relay all information pertaining to creation/reorganization of all Peoplesoft 7.x objects such as tablespaces, tables, indexes, views, etc.
- Via customized Unix SQLPLUS/PLSQL scripts as well as Oracle Enterprise Manager, I would monitor/optimize each of the Peoplesoft environments for the underlying Oracle memory objects such as the library cache, dictionary cache, and buffer cache along with the physical structures, which would include the Oracle database files, redo logs and rollback segments.
- Knowledge of implementing Oracle Parallel server concepts.
- Experience supporting very large databases being housed across HACMP SMP systems, which are able to utilize/share resources in the event of a fail over.
- Responsible for the monitoring and maintenance of twelve Oracle Servers (51 total databases, 1 Mainframe (Open VMS) DBS, 5 NT DBS, 45 Unix DBS).
- Responsible for installing and upgrading the Oracle Server and application tools.
- Responsible for allocating system storage and planning future storage requirements for the database system.
- Complete the process of creating primary database storage structures (tablespaces) once application developers have designed an application
- Creating primary objects (tables, views, indexes) once application developers have designed an application
- Performed requirements, needs, analysis and provided recommendations
- Complete the modification of database structures, as necessary, from information given by application developers
- Enrolling users and maintaining system security
- Control and monitor user access to the database
- Complete the monitoring and optimizing the performance of the database
- Plan for backup and recovery of database information
- Maintain archived data on tape
- Backup and restore the database
- Responsible for contacting Confidential for technical support
- Assist the project lead in the design, implementation, and documentation of various projects.
- Responsible for tuning of the memory (library cache, dictionary cache, buffer cache), database files, redo logs, and rollback segments.
- Provide MS SQL DBA support and perform activities such as monitoring the database system, verifying jobs ran as scheduled, troubleshooting as necessary, performing backups and recovery, etc.
- Performance tuning the database (with and without wizards), identifying best practices on database design; improve application performance through query optimization, database system tuning, and database redesign (where appropriate)
- SQL Programming using MS SQL Server
- Full knowledge of the MS SQL Server environment, including all aspects and recovery.
- Possess experience working in a highly active environment with 24x7x365 technical management experience. This includes very good knowledge of MS SQL Server and its interrelationship with the OS.
- Experience writing stored procedures, functions, dynamic SQL in MS SQL Server.