Careers

Systems Database Engineer

Apply now Job no: 497494
Work type: Staff Full Time
Campus: UMass Amherst
Department: Enterprise Systems & Develop
Pay Grade: 28
Categories: Administrative Professional, Computer & Information Technology, Information Technology, Technical

About UMass Amherst

UMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. 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 Administrative Infrastructure Database Manager, has primary responsibility for the reliable and secure operation of the SPIRE and PeopleSoft hardware and software, Oracle database, and related software components underlying the SPIRE and PeopleSoft Student Information System and other administrative information systems.

Design, develop, and implement data solutions to include the following: architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design, development and testing, and data solution debugging.

Lead in the planning and implementation of SPIRE/PeopleSoft related application and integration in Windows and Linux operating systems. 

Essential Functions

Leads in group reviews for new and existing technical data architecture and design, implementation, configuration, testing plans, and documentation,

Establishes administrative and technical design standards for application developers and technical support staff to ensure the performance, reliability, audibility, and maintainability of the SPIRE and PeopleSoft environment. This includes detailed coding style guides, naming specifications, and technical documentation standards. Coordinates periodic reviews to verify compliance with standards.

Provides support to various campus business and technology teams as necessary during design, development, and delivery to ensure solid, scalable, robust solutions.

Manages day-to-day tasks/activities in coordination with a team of Database Administrators and developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.

Creates and maintains regression testing plan and associated test programs, scripts, and data which covers both vendor supplied and locally developed software.

Develops and maintain scripts to automate IT tasks and procedures.

Leads in technical reviews to ensure that application design decisions meet the long-term objectives of the PeopleSoft technical architecture.

Develops back-up and recovery plan; monitors compliance.

Serves as primary technical contact with software vendors for system upgrades, fixes, and problem resolution.

Perform root cause analysis to quickly recover from service interruptions and to prevent recurring problems.

Monitor, manage, and tune platforms to ensure expected availability and performance levels are achieved.

Performs other related duties as required.

 

Other Functions

Facilitate operating system software installations, updates and upgrades. Troubleshoot system-related problems and issues and work with vendors to resolve technical issues.

Analyze and resolve network and software communication problems using diagnostic software and technical troubleshooting processes.

 

Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

Bachelor’s degree Computer Science or related field with minimum 6 years of relevant experience.

2+ years of VMWare Systems Administrator experience supporting a three tiered IT Infrastructure (web, application, and database)

Experience and knowledge of Linux and Windows system administration.

Demonstrated ability to work well in team environments.

 

Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

Master’s degree in Computer Science or related field with 4 or more years of experience

VMware Certified Professional (VCP preferred).

Experience using packet analyzer such as Wireshark, tcpdump, etc.

Experience using DevOps tools such as Ansible, Jenkins,GitLab, Vagrant, etc.

 

Work Schedule

37.5 hrs. per week, Monday - Friday

Participates in off-hours on-call rotation for urgent problem resolution.

 

Salary Information

Professional Staff salary Administration-Program Position Level 28 Associated to Level 30

See:  PSU Salary Schedule

On campus applicants are defined as Amherst campus, non-student employees.

 

Special Instructions to Applicants

Please apply online and submit letter of application, resume, and the names, titles, and telephone number of at least three current references by February 22nd, 2019 for priority consideration; however, applications may be accepted until the positions are filled.

UMass Amherst is committed to a policy of equal opportunity without regard to race, color, religion, gender, gender identity or expression, age, sexual 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: Eastern Standard Time
Applications close: Eastern Daylight Time

Back to search results Apply now Refer a friend

Share this: | More

The University of Massachusetts is an Equal Opportunity/Affirmative Action, Title IX employer. All qualified applicants will receive consideration for employment without regard to race, sex, color, religion, national origin, ancestry, age over 40, protected veteran status, disability, sexual orientation, gender identity/expression, marital status, or other protected class.