The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts, and offers a rich cultural environment in a bucolic setting close to major urban centers. In addition, the University is part of the Five Colleges (including Amherst College, Hampshire College, Mount Holyoke College, and Smith College), which adds to the intellectual energy of the region.
Job Summary Under the general direction of the Associate Director of Infrastructure Systems, the Senior Peoplesoft Database Administrator has primary responsibility for the reliable and secure operation. management and support of the People Soft software, Oracle database, and related software components underlying
the People Soft Student Administration software and other administrative information systems. Essential Functions Leads software development, testing, and release management cycles for People Soft application software and underlying Oracle databases.
Ensures that all operating system, database, and application software updates and patches are applied and coordinated with development, testing, and production requirements. Maintains source code control libraries and other release management software as necessary. Manages multiple People Soft and database instances and sets up new People Soft Campus Solutions Server instances and new integrations. Creates and documents procedures for maintaining
these systems. Reviews critical software updates and new releases for People Soft Campus Solutions servers, application and underlying Oracle databases.
Consults and works with other IT units on best practices for automation and process improvements to ensure that they are consistent across the board. Documents best practices and procedures. Acts as technical resource and primary support for other third-party software such as the University's document management system Image Now, Oracle EPM Data Warehouse, job scheduling software Control-M and others and serves as primary technical contact with software vendors for system upgrades, fixes, and problem resolution.
Creates and maintains regression testing plan and associated test programs, scripts, and data which covers both vendor-supplied and locally developed software. Establishes administrative and technical design standards for application developers and technical support staff to ensure the performance, reliability, audibility and maintainability of the People Soft environment. This includes detailed coding style guides, naming specifications, and technical documentation standards. Coordinates periodic reviews to verify compliance with standards. Leads and participates in group and technical reviews for testing plans, documentation, and configuration to ensure that application design decisions meet the long-term objectives of the People Soft technical architecture.
Triages more complex user issues and handles daily Service Now tickets, handles issue escalations from Peoplesoft Database Administrators, and triages failed People Soft Campus Solutions server agent jobs, including backups and maintenance jobs. Implements improvements to existing processes to prevent issues from resurfacing. Other Functions Reviews existing major processes to determine if improvements are needed.
Assist Lead Peoplesoft Database Engineer to make recommendations to management. Mentors and provides training in the use of databases, tools, application development tools, and reporting tools for the Peoplesoft Database Administrators. Develops back-up and recovery plan and monitors compliance. Participates in off-hours on-call rotation for urgent problem resolution. Performs other related duties as required. Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure) Bachelor’s Degree with 6 years’ relevant experience or an Associate’s Degree with 8 years’ relevant experience.
Experience with vendor ERP software, including installation, implementation and administration. Experience with Oracle or SQL products (My SQl, MS SQL, Prostgres). Experience and knowledge of Linux or Windows Operating Systems. Demonstrated ability to work well in team environments. Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure) Experience and ability to develop and maintain source code libraries and manage formal software releases for production environments. Experience with Oracle database administration using Oracle administrative tools.
Experience with replication and clustering. Experience with People Soft software application is strongly preferred. Experience with using Dev Ops tools such as Ansible, Puppet, Jenkins, Git Lab, Vagrant, etc. Experience with diagnostic tools such as network packet, hardware performance, and storage analyzers, etc. Work Schedule 37.5 hours, Monday to Friday, 9:00am to 5:00pm. Participate in off-hours on-call rotation. Some nights and weekend hours required. This position has the opportunity for a hybrid work schedule, which is defined by the University as an arrangement where an employee’s work is regularly performed at a location other than the campus workspace for a portion of the week.
As this position falls within the Professional Staff Union, it is subject to the terms and conditions of the Professional Staff Union collective bargaining agreement. This position has the opportunity for a remote work schedule, which is defined by the University as an arrangement where the employee’s work location is to work from a site other than the UMass Amherst campus. As this position falls within the Professional Staff Union, it is subject to the terms and conditions of the Professional Staff Union collective bargaining agreement.
Salary Information Level 30 PSU Hiring Ranges Special Instructions to Applicants In addition to the online application, please submit a resume, cover letter and contact information for three (3) professional references. Applications will be accepted until the position has been filled. UMass Amherst is committed to a policy of equal opportunity without regard to race, color, religion, gender, gender identity or expression, age, interactionual orientation, national origin, ancestry, disability, military status, or genetic information in employment, admission to and participation in academic programs, activities, and services, and the selection of vendors who provide services or products to the University.
To fulfill that policy, UMass Amherst is further committed to a program of affirmative action to eliminate or mitigate artificial barriers and to increase opportunities for the recruitment and advancement of qualified minorities, women, persons with disabilities, and covered veterans. It is the policy of the UMass Amherst to comply with the applicable federal and state statutes, rules, and regulations concerning equal opportunity and affirmative action.
Advertised: Oct 11 2023 Eastern Daylight Time Applications close: For more details: jobs-search. org/architecture-construction_amherst-c434182/senior-peoplesoft-database-administrator-hybridremote-opportunity-amherst_i1969562773
