This position serves as the System Administrator (SA) for University-wide Enterprise-level Academic / Event Scheduling System. The SA will clarify the business needs of stakeholders and help find solutions (often technical) to meet those identified needs. This position will monitor system servers, processes, and resources and will help troubleshoot when problems arise. The SA will recommend solutions/changes to system settings/business processes or identify workarounds to be implemented until permanent fixes can be made. This position also gives direction to other Scheduling Analysts regarding system processes and procedures.
Production support (Enterprise Scheduling System & PeopleSoft Interface Maintenance): (60%)
Support enterprise system by reacting to issues affecting the customers (students /faculty/staff/support units) supported by OCM, including all system campuses.
Assist with the rapid and thorough resolution of production issues. Evaluate, document, and report issues to management and vendor.
Evaluate issue patterns to plan and execute process improvements and system upgrades.
Work with clients and technical resources to troubleshoot production emergencies.
Represent user areas in the more complex system enhancement and design activities.
Ensure documentation of business requirements and create detailed functional/technical specifications.
Assist with the implementation of “workarounds” when system issues affect business needs.
Maintain in-depth knowledge of all business processes in one or multiple business areas.
Function as application expert (second tier support) for help-line staff.
Diagnose problems and provide procedural and technical guidance to less experienced staff.
Provide support by reacting to issues affecting the data import/exports from/to PeopleSoft into the Enterprise Scheduling system.
Review import logs of Scheduled Import Jobs to validate data transference.
Identify and rapidly resolve PeopleSoft interface issues. Evaluate, document, and report issues to Management and appropriate OIT unit.
Engage vendor and/or OIT technical support, when required, to resolve production interface issues.
Enterprise Scheduling System & PeopleSoft Upgrade Support: (30%)
Analyze scheduling system releases for testing applicability.
Create detailed test conditions, create test scripts, perform testing, and report results for scheduling system upgrades and releases.
Analyze PeopleSoft upgrade impacts on integration with Enterprise Scheduling System and PS Interface.
Create test scripts, perform testing, and report defects for PeopleSoft upgrades and releases.
Other & Professional Development: (10%)
Gain and maintain knowledge of tools used to support the enterprise systems. Examples are: SQR, SQL, PeopleTools, workflow, equation engine, application engine, and web tools.
Serve on committees and task forces related to the department as required.
Function as an effective resource person in areas of expertise.
Work effectively with other ASR and University staff.
Attend various ASR related meetings as OCM representative
** This position offers the following benefits:
University paid contribution (10% of your salary) to your retirement account - vested immediately.
22 paid vacation days per year, in addition to paid medical leave and 11 paid holidays.
Reduced tuition opportunities covering 75% - 100% of eligible tuition.
Excellent and affordable health care benefits.
Wellness program with opportunity to earn lower health care rates.
Free disability insurance.
Free basic life insurance benefit (115% base salary, $200,000 maximum).
*Some benefits depend on percent-time appointment
BA/BS degree in a related field AND two years of work experience in the areas of database design and administration; or BA/BS degree in an unrelated field AND four years of work experience in the areas of database design and administration.
Knowledge of database concepts, project management, analysis, user acceptance testing (UAT), and system troubleshooting techniques.
Experience working with service providers and vendors to identify and resolve system or database problems.
Excellent written and oral communication skills.
Ability to work under general guidance without technical supervision.
Working knowledge of relational databases (preferably MS SQL) to include table structure and queries.
Knowledge of and experience utilizing front-end software for updating database and reporting.
Experience developing reports and analyzing data.
Two+ years of work experience at a university or college.
Two+ years of PeopleSoft experience.
Experience with Astra Schedule or another similar academic scheduling software.
Internal Number: 330823
About University of Minnesota, Twin Cities
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.