Systems Database Engineer

University Of Massachusetts Amherst Amherst , MA 01003

Posted 3 months ago

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, the Systems Database Engineer will be responsible 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, implementation, and management of Windows and Linux operating systems, network platforms, VMWare virtualization, Windows OS, and Mac OS X; various technologies and tools as necessary and internet related protocols.

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 with a minimum of 6 years of relevant experience, or an associate degree with a minimum of 8 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 Operating Systems.

  • 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

Level 30

PSU Salary Schedule

Special Instructions to Applicants

Please apply online and submit a cover letter, resume and at least three professional references by July 19th, 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: Jul 5 2019 Eastern Daylight Time

Applications close:


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Maintenance & Controls Engineer

University Of Massachusetts Amherst

Posted 1 week ago

VIEW JOBS 9/13/2019 12:00:00 AM 2019-12-12T00:00 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 The University of Massachusetts in Amherst (UMA) has a campus wide building automation system (BAS) which consists of Johnson Controls network and field controllers installed in more than 90 buildings. The BAS has gone through multiple upgrades and still has a mix of new and old controllers (pneumatic systems) connected through a network around the campus. The Maintenance & Controls Engineer will support the Physical Plant engineering and control teams with a primary role of focusing on the oversight, care and maintenance of all University building automation controls and energy management systems (EMS). BAS controls consist of web-based systems and server-based systems, including, but not limited to, ALC WebCTRL, Johnson Controls MetaSys, Trane (Tracer, Tracker), Daikin, Mitsubishi, CentraLite, and Tridium systems, etc. Essential Functions The Maintenance & Controls Engineer will be responsible for: * Maintaining JCI's Metasys Extended Architecture Network Building Automation System including PMI systems, ADX server and any other control software's to be used in future expansions and upgrades. * Programming, troubleshooting, and repairing as necessary Supervisory Controllers including NCMs, NCEs and NAEs, field controllers and any other JCI legacy controllers. * Coordinating with JCI for control system upgrades, maintenance requirements and JCI Service Contract oversight. * Using established standard in designing and installing controls hardware and software, and programming HVAC control systems to meet the intent of system requirements. * Working closely with the University IT department on issues related to BAS software upgrade, controllers network campus wide and network troubleshooting. * Providing and/ or reviewing detailed HVAC and BAS project information and submittals to communicate design and operation requirements to customers, consultants, UMA DCM, Johnson Controls field installation team and subcontractors. * Performing Metasys software programming using established standards as a basis of design for graphics development, data-point tagging, and creation of front-end functions for BAS systems in new and existing buildings. * Directing and mentoring the university maintenance technicians in the installation, repair and replacement of various control components or HVAC systems. * Performing field work as needed for hardware/software installation; device testing, field points programming, and network troubleshooting. * Gaining an understanding of complex control sequences, designing documents, and performing HVAC equipment condition assessments within existing buildings; providing project management services as necessary. * Overseeing 'in-house' HVAC controls projects, including budget management and selecting controls hardware from standard design library for flow diagrams, sequence of operations, bill of material, network layouts and electrical schematics as required. * Coordinating as needed the creation of necessary BAS drawings and equipment schedules for submittals and installation. * Participating in commissioning of all controls system and network level controllers for major renovation projects or new buildings. * Validating complete system functionality and troubleshooting problems with subcontractors and other trades to ensure proper operation of control systems and HVAC equipment. * Gathering proper documentation and/or manuals for systems operation, including field changes from the project team and, as-built drawings, software and any pertinent information to be used in HVAC operation and maintenance. * Proactively pursue BAS operational improvement, developing resolution strategies, and implementing/optimizing sequences which maximize efficiency and align with facilities operations goals and priorities. * Providing BAS technical expertise as necessary in design development for all capital improvement projects. * Working closely with IT staff on issues related to BAS computers and embedded controllers network. * Maintaining and regularly inspecting existing control systems and making recommendations intended to improve the efficiency and/or safety of the system's performance. * Performing other related duties as assigned. Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure) * Associate's Degree in Mechanical or Electrical Engineering field with 7 years of industry related technical field experience with building automation systems (BAS) required * Current, valid Massachusetts Class D Driver's License * Demonstrated ability to integrate, maintain and troubleshoot a variety of DDC, controllers and network integrators associated with a computerized energy management system * Understanding of typical HVAC (LON, ModBus, BACnet, etc) systems, water based and refrigerant based, such as boilers, chiller plants, heat pump systems, air handlers, and terminal heating and cooling equipment * Experience with BAS programming both on a field controller level (example JCI CCT) and a supervisory controller level (example JCI LCT), as well as creating BAS graphics * Excellent knowledge of controls industry protocols: LON, ModBus, BACnet, etc. * Excellent programming of HVAC network and field controller, preferably JCI * Practice and promotion of excellent customer service in the work place, including meeting routinely with customers and Customer Service Representatives to determine their needs * Excellent verbal and written communication skills (must be able to communicate effectively with all levels of employees) * Translate technical requirements into a detailed design for new and existing code Preferred Skills * Experience with integrating equipment of one system into another control system; integration into the JCI Metasys system * Experience in managing and commissioning control projects * 5 years of BAS/DDC controls and programming experience, with JCI Metasys experience * Familiarity with installed JCI controls on UMass/Amherst campus Work Schedule Monday through Friday, first shift with requirement to work nights, weekends, and irregular hours during campus emergencies and during start-up and commissioning periods. Required to support ISO New England Demand Response events. Salary Information Grade 31 PSU Salary Ranges: https://www.umass.edu/humres/sites/default/files/UMass%20Amherst%20Exempt%20Salary%20Ranges_0.pdf Special Instructions to Applicants Please submit a resume, cover letter, and contact information for three professional references by September 26, 2019 to ensure priority consideration. The position may remain open until 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: Sep 12 2019 Eastern Daylight Time Applications close: University Of Massachusetts Amherst Amherst MA

Systems Database Engineer

University Of Massachusetts Amherst