Acts as the lead systems specialist in the Department of Enterprise Systems and Cloud Services. Leads the implementation of software development life cycle methodologies to enhance the University’s PeopleSoft Financial system and provides primary support for multiple PeopleSoft modules through planning, requirements analysis, design, development, integration, testing, implementation, maintenance, and documentation in accordance with IT-MIS policies and standards. Duties include: manage multiple projects and support multiple critical applications; assist junior Applications Programmers with solutions to complex problems; maintain, tests, and update PeopleSoft ERP systems; improve performance of PeopleSoft batch programs, reports and online pages using techniques such as SQL tuning, database indexes, hints, statistics and explain plans; plan, upgrade, and deploy new PeopleTools versions and PeopleSoft application versions using PeopleSoft upgrade assistant, fit-gap analysis, data conversion, system and database audits, performance & integration testing; test and correct programs to ensure they work properly and to determine that programs meet client needs; develop statistical analysis and data analysis using PeopleSoft Query/XML Publisher reporting tools; coordinate work to develop, test, deploy and document PeopleSoft custom or delivered batch programs to interface with internal systems and to meet the University’s requirements; provide production support for the Financial system and maintains the daily production schedule of PeopleSoft systems; analyze and resolve production incidents; works with users and production control staff regarding schedule and problem resolution; provide on-call support for PeopleSoft systems; work closely with management to ensure adherence to UDIT policies and with users to determine their needs, recommend solutions, and keep them updated on project status; re-engineer business functions by evaluating requests for service and reviews policies, procedures, and workflows to ensure that the best systems are implemented; troubleshoot complex data processing problems and user data entry errors and coordinates problem resolution and testing with other programmers, users, and units; and participate (and may lead) in internal and external training programs.

Requires a Bachelor’s degree or foreign equivalent degree in Information Systems, Computer Science, Engineering, Business, or a related field and 5 years of experience with Oracle ERP and IDE (i.e., PeopleSoft Financials, PeopleTools core technologies, PeopleSoft reporting technologies, PeopleSoft Upgrade/Change Assistant, Oracle Database, Oracle Procurement), programming languages, and database querying and software implementation techniques. Limited telework permitted – must be on-site two days per week