Skip to Main Content
Community/Job Board/Job Board/Technical (Programmer, Developer, Analyst)/Systems and Database Analyst

Systems and Database Analyst

Posted: February 10, 2020
Description
Skills
Education
Company Description

GENERAL STATEMENT OF DUTIES:
Working within the Information Technology (IT) team, under the supervision of the Director of Applications, the Systems and Database Analyst is a key member of the support team for the College’s SIS/ERP system Ellucian Banner, its learning management system Moodle, its portal MyGCC and other critical College applications. The Systems and Database Analyst provides primary support in a team environment for the Ellucian Banner Student Information System and focuses on the health, performance and reliability of the College’s Oracle databases as well as performing software development and system analyst tasks as required.

EXAMPLES OF DUTIES:

Application Infrastructure Support
• Support Banner 9 essential services such as Application Navigator, Ethos Identity Services, Jasper reports and Admin Pages.
• Work with Application team and Network/Systems team to maintain the availability and data integrity of Banner 9.
• Conduct systems analysis, programming, testing and implementation of modifications to support Banner.
• Maintain and develop College web applications.
• Make modifications and enhancements to Banner 9 in support of institutional requirements.
• Create or enhance user reporting and/or extracts.
• Create, maintain and support feeds to and from external systems.
• Monitor application servers.
• Apply application upgrades for the Banner functional modules.
• Create cases, as required and work with Ellucian Technical support to troubleshoot Banner related problems.
• Troubleshoot daily help desk tickets related to Banner.
• Develop and maintain documentation of systems and procedures.
• Evaluate programs to assure compliance with standards and regulations.
• Estimate time and staff requirements for current or proposed systems or projects.
• Work with staff and faculty to enhance existing reports and design new reports
• Perform related duties as required.

Database Support
• Provide database administration including cloning, patching, and monitoring multiple applications and instances
• Perform database upgrades.
• Work with Application team and Network/Systems team to ensure accurate, timely database backups and disaster recovery.
• Support the Oracle Enterprise Manager (OEM) to monitor database health

MINIMUM QUALIFICATIONS: • Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience • At least 2 years’ experience in web-based programming • At least 3 years’ experience supporting Student Information Systems (SIS) and/or Enterprise Resource Planning Systems (ERP) OR equivalent experience supporting enterprise-level multi-faceted applications such as Banner, Colleague, Peoplesoft or Jenzabar • Experience with SQL and PL/SQL REQUIRED SKILLS, KNOWLEDGE AND APTITUDES: • Ability to read, write and comprehend the English language • Excellent verbal and written communication skills. • Detail oriented organizational skills with a high degree of accuracy. • Ability to work independently and meet deadlines. • Occasional availability for off-hours and weekend work required to perform system maintenance tasks. PREFERRED QUALIFICATIONS: • At least 3 years’ experience working in a higher education setting • Experience with Ellucian Banner Student Information System (SIS) • Database administrator experience supporting Oracle • Experience using code version software such as GitHub • Experience developing or maintaining web applications using standard web development tools such as JavaScript, Python, Ruby on Rails, etc. • Experience in all phases of the software development cycle • Experience with application and web server management EQUIVALENCY STATEMENT: Applicants who do not meet the qualifications as stated above are encouraged to put in writing precisely how their background and experience have prepared them with the equivalent combination of education, training and experience required for the responsibilities of this position.

• Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience

Greenfield Community College is located in the beautiful and historic Pioneer Valley of western Massachusetts, between the foothills of the Berkshire Mountains and the fertile farmland of the Connecticut River watershed. GCC is known for the caring and supportive attitude of the faculty and staff, academic excellence, and for the broad support it enjoys from the surrounding community. We are accredited by the New England Association of Schools and Colleges, and we work closely with bachelor degree granting colleges of the Massachusetts public higher education system, including the University of Massachusetts, and with private colleges and universities, which enables us to offer diverse transfer opportunities to our students. The career programs offered by the College prepare our students to enter the work force or update their skills, while credit-free workshops and seminars are offered for personal enrichment. Day, evening and weekend classes are offered so that students who need a flexible academic schedule can be served.

Description

GENERAL STATEMENT OF DUTIES:
Working within the Information Technology (IT) team, under the supervision of the Director of Applications, the Systems and Database Analyst is a key member of the support team for the College’s SIS/ERP system Ellucian Banner, its learning management system Moodle, its portal MyGCC and other critical College applications. The Systems and Database Analyst provides primary support in a team environment for the Ellucian Banner Student Information System and focuses on the health, performance and reliability of the College’s Oracle databases as well as performing software development and system analyst tasks as required.

EXAMPLES OF DUTIES:

Application Infrastructure Support
• Support Banner 9 essential services such as Application Navigator, Ethos Identity Services, Jasper reports and Admin Pages.
• Work with Application team and Network/Systems team to maintain the availability and data integrity of Banner 9.
• Conduct systems analysis, programming, testing and implementation of modifications to support Banner.
• Maintain and develop College web applications.
• Make modifications and enhancements to Banner 9 in support of institutional requirements.
• Create or enhance user reporting and/or extracts.
• Create, maintain and support feeds to and from external systems.
• Monitor application servers.
• Apply application upgrades for the Banner functional modules.
• Create cases, as required and work with Ellucian Technical support to troubleshoot Banner related problems.
• Troubleshoot daily help desk tickets related to Banner.
• Develop and maintain documentation of systems and procedures.
• Evaluate programs to assure compliance with standards and regulations.
• Estimate time and staff requirements for current or proposed systems or projects.
• Work with staff and faculty to enhance existing reports and design new reports
• Perform related duties as required.

Database Support
• Provide database administration including cloning, patching, and monitoring multiple applications and instances
• Perform database upgrades.
• Work with Application team and Network/Systems team to ensure accurate, timely database backups and disaster recovery.
• Support the Oracle Enterprise Manager (OEM) to monitor database health

Skills

MINIMUM QUALIFICATIONS: • Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience • At least 2 years’ experience in web-based programming • At least 3 years’ experience supporting Student Information Systems (SIS) and/or Enterprise Resource Planning Systems (ERP) OR equivalent experience supporting enterprise-level multi-faceted applications such as Banner, Colleague, Peoplesoft or Jenzabar • Experience with SQL and PL/SQL REQUIRED SKILLS, KNOWLEDGE AND APTITUDES: • Ability to read, write and comprehend the English language • Excellent verbal and written communication skills. • Detail oriented organizational skills with a high degree of accuracy. • Ability to work independently and meet deadlines. • Occasional availability for off-hours and weekend work required to perform system maintenance tasks. PREFERRED QUALIFICATIONS: • At least 3 years’ experience working in a higher education setting • Experience with Ellucian Banner Student Information System (SIS) • Database administrator experience supporting Oracle • Experience using code version software such as GitHub • Experience developing or maintaining web applications using standard web development tools such as JavaScript, Python, Ruby on Rails, etc. • Experience in all phases of the software development cycle • Experience with application and web server management EQUIVALENCY STATEMENT: Applicants who do not meet the qualifications as stated above are encouraged to put in writing precisely how their background and experience have prepared them with the equivalent combination of education, training and experience required for the responsibilities of this position.

Education

• Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience

Company Description

Greenfield Community College is located in the beautiful and historic Pioneer Valley of western Massachusetts, between the foothills of the Berkshire Mountains and the fertile farmland of the Connecticut River watershed. GCC is known for the caring and supportive attitude of the faculty and staff, academic excellence, and for the broad support it enjoys from the surrounding community. We are accredited by the New England Association of Schools and Colleges, and we work closely with bachelor degree granting colleges of the Massachusetts public higher education system, including the University of Massachusetts, and with private colleges and universities, which enables us to offer diverse transfer opportunities to our students. The career programs offered by the College prepare our students to enter the work force or update their skills, while credit-free workshops and seminars are offered for personal enrichment. Day, evening and weekend classes are offered so that students who need a flexible academic schedule can be served.

Position Overview

Company

Greenfield Community College

Location

Greenfield, MA

Job Type

Full time

Salary

Grade 23: $2,558.62 bi-weekly. (Candidates may qualify for placement beyond entry-level salary if they are currently employed in the state system and transfer without a break in service, subject to verification by the Executive Director of Human Resources.)

Apply Now

Listing Contact

Laura Garcia

garcial@gcc.mass.edu 413-775-1318

Position Details

Description

GENERAL STATEMENT OF DUTIES:
Working within the Information Technology (IT) team, under the supervision of the Director of Applications, the Systems and Database Analyst is a key member of the support team for the College’s SIS/ERP system Ellucian Banner, its learning management system Moodle, its portal MyGCC and other critical College applications. The Systems and Database Analyst provides primary support in a team environment for the Ellucian Banner Student Information System and focuses on the health, performance and reliability of the College’s Oracle databases as well as performing software development and system analyst tasks as required.

EXAMPLES OF DUTIES:

Application Infrastructure Support
• Support Banner 9 essential services such as Application Navigator, Ethos Identity Services, Jasper reports and Admin Pages.
• Work with Application team and Network/Systems team to maintain the availability and data integrity of Banner 9.
• Conduct systems analysis, programming, testing and implementation of modifications to support Banner.
• Maintain and develop College web applications.
• Make modifications and enhancements to Banner 9 in support of institutional requirements.
• Create or enhance user reporting and/or extracts.
• Create, maintain and support feeds to and from external systems.
• Monitor application servers.
• Apply application upgrades for the Banner functional modules.
• Create cases, as required and work with Ellucian Technical support to troubleshoot Banner related problems.
• Troubleshoot daily help desk tickets related to Banner.
• Develop and maintain documentation of systems and procedures.
• Evaluate programs to assure compliance with standards and regulations.
• Estimate time and staff requirements for current or proposed systems or projects.
• Work with staff and faculty to enhance existing reports and design new reports
• Perform related duties as required.

Database Support
• Provide database administration including cloning, patching, and monitoring multiple applications and instances
• Perform database upgrades.
• Work with Application team and Network/Systems team to ensure accurate, timely database backups and disaster recovery.
• Support the Oracle Enterprise Manager (OEM) to monitor database health

Skills and Experience

MINIMUM QUALIFICATIONS: • Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience • At least 2 years’ experience in web-based programming • At least 3 years’ experience supporting Student Information Systems (SIS) and/or Enterprise Resource Planning Systems (ERP) OR equivalent experience supporting enterprise-level multi-faceted applications such as Banner, Colleague, Peoplesoft or Jenzabar • Experience with SQL and PL/SQL REQUIRED SKILLS, KNOWLEDGE AND APTITUDES: • Ability to read, write and comprehend the English language • Excellent verbal and written communication skills. • Detail oriented organizational skills with a high degree of accuracy. • Ability to work independently and meet deadlines. • Occasional availability for off-hours and weekend work required to perform system maintenance tasks. PREFERRED QUALIFICATIONS: • At least 3 years’ experience working in a higher education setting • Experience with Ellucian Banner Student Information System (SIS) • Database administrator experience supporting Oracle • Experience using code version software such as GitHub • Experience developing or maintaining web applications using standard web development tools such as JavaScript, Python, Ruby on Rails, etc. • Experience in all phases of the software development cycle • Experience with application and web server management EQUIVALENCY STATEMENT: Applicants who do not meet the qualifications as stated above are encouraged to put in writing precisely how their background and experience have prepared them with the equivalent combination of education, training and experience required for the responsibilities of this position.

Education

• Bachelor’s Degree and at least 3 years’ experience with relational database programming, support, upgrades and other database administration tasks OR Associate’s Degree and at least 4 years’ experience OR at least 5 years’ experience

Company Description

Greenfield Community College is located in the beautiful and historic Pioneer Valley of western Massachusetts, between the foothills of the Berkshire Mountains and the fertile farmland of the Connecticut River watershed. GCC is known for the caring and supportive attitude of the faculty and staff, academic excellence, and for the broad support it enjoys from the surrounding community. We are accredited by the New England Association of Schools and Colleges, and we work closely with bachelor degree granting colleges of the Massachusetts public higher education system, including the University of Massachusetts, and with private colleges and universities, which enables us to offer diverse transfer opportunities to our students. The career programs offered by the College prepare our students to enter the work force or update their skills, while credit-free workshops and seminars are offered for personal enrichment. Day, evening and weekend classes are offered so that students who need a flexible academic schedule can be served.

Become a Member

Complete the application for Institution Membership to start using NERCOMP member benefits now!

Get Started