Someone wanted to know the PeopleSoft Admin’s responsibilities in another blog. I thought I could place the task list here which I responded in that blog.

I am sure that there are many tasks that can be added to this list.  It is a good practice to check some of the sites like Monster, hotjobs or dice for the requirements and improve upon such skill sets if you want be competitive in the market.

PeopleSoft Responsibilities:

• 
  Install and configure PeopleSoft server hosts, components, and clients for 3-Tier and 2-Tier.
• Create PeopleSoft databases and migrate/refresh databases, objects though Data Mover or externally.
• Create Windows Client Profiles for various development, test and production users and install.
• Implement load balancing for Web servers and application servers and monitor.
• PeopleBooks installation with search features and F1 features.
• Maintain integrity and internal consistency of the database using DDDAUDIT, SYSAUDIT reports periodically.
• Migrate Projects from one environment to other environments.
• Download and Apply Tax update; install patches periodically when they are released
• Upgrade database and People Tools in tune with application upgrades and patch installations application releases approved list by PeopleSoft.
• Install Change Assist for Upgrade in newer versions of PeopleSoft.
• Troubleshoot and fix performance issues with People code, App engine, SQR and other PeopleSoft programs.

Oracle DBA Responsibilities:

• Oracle Installation/Migration of various versions from 9i and 10g.
• Partitioning, Parallel and Multithreaded Server set up with RAC features
• Database modeling, Logical & Physical Design.
• OEM Repository Installation and configuring with various databases, nodes and instances.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Database Security Management: Users, Roles, Profile, and Groups
• Data Integrity Management Logical/Physical objects management
• SQL*Loader, SQL*Plus coding, SQL Tuning, Indexing, Clustering
• Periodic Backup and recovery, using Backup and Recovery Manager (RMAN) and Export/Import Utilities.
• Create and configure Events and jobs for Instance, node, server monitoring through OEM
• EMC Timefinder software to create BCV (Business Continuity Volume) for backup through RMAN and other database refreshes for oracle databases in Mission–critical production environment for larger databases.
• Evolving database object naming convention and for enforcing Oracle standards on the system and PeopleSoft naming convention for custom PeopleSoft objects and ensure.
• Write patrolling scripts for checking the health of the database to send automated alerts to DBA/SA.
• Configure routine database health report generation jobs in OEM repository.
• Snapshots, Views, DBlinks, Listeners set up
• PL/SQL Packages, Procedures, Functions, and Triggers: Coding & Trouble shooting and tuning.
• Space Management, Capacity Planning and Management, Backup and Recovery Planning.
• Data Migration, Conversion, Replication
• Periodic Database CLONING from production to Development and QA environments for PeopleSoft applications, maintaining Database Standards, Reviews, Documentation, Quality Assurance
• Involvement in full development cycle of application from design to testing and implementation, on-call production, test and development support.
• Setting up Security in PeopleSoft application, database, and Operating systems in the data centers to ensure that they comply with SOX recommendations.
• Recommend risk management and mitigations are applied in database backup, application backup and report retention policy are maintained as per SOX compliance requirements for the applications.
• Design, test and implement “Disaster Recovery and Contingency Plans” (DRCP) for databases, data centers and mission critical instances and applications.
• Ensure mock tests of disaster recovery are conducted periodically.
• Ensure the visibility and transparency in reporting and documenting in case of change manage¬ment, application development methodology and business requirement processes.
• Interface between the PeopleSoft applications and the external clients are secured to comply with SOX recommendations.
• Record retention policies are as per the SOX recommendations and maintained in the electronic forms as well as printed forms.
• Plan /Execute clustering of databases / application servers and stand by process schedulers for maximum availability for all applications.
• Use Control-M for scheduling and running the PeopleSoft and interface batch jobs and integrate the distributed (UNIX and NT) system environment.

Comments (5)

	1. 05-23-2008 16:10
	This is very helpful to me. I am new to peoplesoft. It is a good list of responsibilities. Guest

Pramod

	2. 05-26-2008 07:21
	Hi,  Plz kept the details about peoplesoft dba. Guest

ramakrishna

	3. 05-26-2008 07:23
	Let us know which area you would like to know more about, we will provied in that area http://psadmin.org Registered

RD

	4. 06-04-2008 20:27
	I am interested in the difference between the PS Admin and the DBA. Our organization has the role currently split (with little responsibilities defined). The list above shows the PS Admin creating the database and moving projects, but also shows the DBA responsible for structure changes. If you have a more detailed list that would be great! Guest

Lynn

	5. 06-30-2008 07:09
	I have worked on Project with only DBA role along with other 12 DBAs and no PSADMIN roles. The DBAs take care of only database roles like backup, refresh, performance tuning etc.   But still there were some PSADMIN responsibilities done by DBAs like moving projects to Production from UAT environments using APP Designer tool.     So it is difficult to exactly divide between the roles as most of the time DBAs have to do some PSADMIN work and PSADMINS have to do DBAs job.     Recently I read an article on DBA's Responsibility by Bob Watkins in IT Tech Republic which you may want to read.       http://blogs.techrepublic.com.com/datacenter/?p=391&tag=nl.e040 http://www.psadmin.org Registered

RD

Write Comment

Thankyou for your comments. Feel free to comment if there are any mistake in the postings also. If you have a Blog or website, feel free to provide the link. We will take a peak. Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button. Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
BBCode:
Comment:
Code:*
	I wish to be contacted by email regarding additional comments

Copy Right: AKOComments v.1.4.6