PEOPLESOFT ADMINISTRATOR
University of Missouri - Columbia (MU)
Columbia, MO
Full-time
Administration / Clerical
Posted on April 15, 2024
Hiring Department
Division of Information Technology
Job Description
Support of PeopleSoft Application and Database Administration for Campus Solutions 9.2, HCM 9.2 and FSCM 9.2. Identify, troubleshoot and document performance and configuration issues as necessary. Pager coverage and possible off shift coverage will be required.
Provide expert troubleshooting for isolating technical problems in the PeopleSoft Internet Architecture including Oracle databases, tuxedo application servers, process schedulers and WebLogic web servers on Unix and Windows platforms. Respond to problem and change tickets related to production application and server support operations. Analyze issues with SQR, PeopleCode, Application Engine, Process Schedulers, Application Servers, Application Messaging, and Web Servers.
Project development. As needed, perform analysis, create specifications, and execute tasks as specified by project requirements
Environment creation, change management, migration of objects/code, performance tuning and production support. Support the data refresh of various test environments from production data sources.
Develop, tune, and debug SQL statements within PeopleSoft Query, Application Engine, and native SQL. Assist development teams with SQL tuning
Create and maintain backups, restoration, and disaster recovery database procedures
Configure PeopleSoft PIA including networking, firewall and load balancing
Perform complex PeopleSoft administration tasks including PeopleSoft tax updates, PeopleSoft and PeopleTools upgrades, patches and PeopleSoft object migrations using Change Assistant and PeopleSoft Update Manager (PUM).
Develop and administer standards for programming, database design, data tables, data element naming, and data library maintenance. Engage in strategic planning for long-term server needs, backup and retention requirements, restoration and disaster recovery database procedures. Advise analysts and programmers on optimum database design and application coding.
Install and configure Elastic Search setup, Phire and PERFMON environments to provide added functionality to PeopleSoft Applications.
Shift
M-F, 8am – 5pm; Pager coverage and possible off shift coverage would be required.M-F, 8am – 5pm; Pager coverage and possible off shift coverage would be required.
Minimum Qualifications
A Bachelor's degree in Computer Science or an equivalent combination of education and experience from which comparable knowledge and skills can be acquired is necessary. At least 2 years prior experience in an IT field, preferably in Higher Education, is required.A Bachelor's degree in Computer Science or an equivalent combination of education and experience from which comparable knowledge and skills can be acquired is necessary. At least 2 years prior experience in an IT field, preferably in Higher Education, is required.
Preferred Qualifications
Experience working as a PeopleSoft Administrator for over 1 yearExperience working as a PeopleSoft Administrator for over 1 year
Anticipated Hiring Range
Salary Range:$50,367 - $91,052 Commensurate with experience$51,875 - $91,052 Commensurate with experience
Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.
Sponsorship Information
Visa Sponsorship Information:
Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas.
Benefit Eligibility
This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website athttps://www.umsystem.edu/totalrewards/benefits.
Values Commitment
We value the uniqueness of every individual and strive to ensure each person's success. Contributions from individuals with diverse backgrounds, experiences and perspectives promote intellectual pluralism and enable us to achieve the excellence that we seek in learning, research and engagement. This commitment makes our university a better place to work, learn and innovate.
In your application materials, please discuss your experiences and expertise that support these values and enrich our missions of teaching, research, and engagement.
Equal Employment Opportunity
The University of Missouri System is an Equal Opportunity Employer. Equal Opportunity is and shall be provided for all employees and applicants for employment on the basis of their demonstrated ability and competence without unlawful discrimination on the basis of their race, color, national origin, ancestry, religion, sex, pregnancy, sexual orientation, gender identity, gender expression, age, disability, or protected veteran status, or any other status protected by applicable state or federal law. This policy applies to all employment decisions including, but not limited to, recruiting, hiring, training, promotions, pay practices, benefits, disciplinary actions and terminations. For more information, visithttps://www.umsystem.edu/ums/hr/eeoor call the Director of Employee and Labor Relations at 573-882-2146.
To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.
