Sauk Makes it Possible — You Make it Happen
Sauk Valley Community College Human Resources

Job Descriptions

JOB DESCRIPTION

Job Description Listing

TITLE:

System Analyst/DBA

SUPERVISED BY:

Dean of Information and Security

DEPARTMENT:

Information Technology Services

GRADE:

Prof/Tech 

CATEGORY:

Full-time Professional/Technical

STATUS:

Exempt 

FUNCTION OF THE JOB:

Responsible for SVCC administrative database maintenance and support. Provide College-wide technical support for the Banner application package. Develop and write reports as needed for users.

DUTIES AND RESPONSIBILITIES

  1. Provide technical support for Banner, Argos, and any ancillary applications. Act as a technical consultant and trainer when necessary. Perform technical activities related to the design, analysis, development, and tuning of the Oracle databases and Banner.
  2. Develop and maintain data-blocks, dashboards, and reports in the Argos reporting system as requested by College departments.
  3. Perform systems installation, integration, maintenance, and performance management of the Oracle databases, Banner, and related applications.
  4. Monitor and install Banner upgrades in production, development, and test environments. Work with departments to schedule upgrades and perform upgrades outside of campus hours.
  5. Analyze and evaluate business processes and work with departments to make recommendations for improvements. Review upgrade and release documentation to continually develop knowledge of existing technologies and systems, in preparation for changing needs of our business systems.
  6. Organize and lead campus Banner User Group, demonstration, and implementation meetings.
  7. Assist supervisor in analysis and evaluation of the functionality and feasibility of ancillary applications and other software requested by the campus. Work with other ITS staff to use campus software to improve business processes.
  8. Analyze and evaluate system setup and data to ensure accuracy, efficiency, and compliance with federal and state reporting requirements.
  9. Develop and maintain process and technical documentation and end-user documentation as requested by departments.
  10. Monitor Oracle database backups, clone and refresh databases from the production environment to development and testing environments as needed.
  11. Write ad-hoc reports using SQL and other programming languages used by the College. Develop triggers and other programs as needed for business processes.
  12. Coordinate user management with ITS staff responsible for Banner Security (BANSECR).
  13. Maintain various security grants and roles for the Oracle database structure and within the Banner security construct.
  14. 14. Provide backup support to other ITS personnel as assigned by supervisor.
  15. Assume all other reasonable professional duties and responsibilities as assigned by the supervisor.

ESSENTIAL FUNCTIONS:

  1. Must understand and support the mission of the community college.
  2. Must be able to communicate effectively by phone and email on a daily basis.
  3. Must be able to provide and understand verbal/visual orders from supervisor and to subordinates.
  4. Must have excellent technical writing skills.
  5. Must be able to operate computers.
  6. Must be able to work non-standard hours as needed.
  7. Position requires on-call availability in case of system malfunctions and must perform upgrades and maintenance during off-hours.

PERSONAL INTERACTION:

Frequent contact is made with all levels of College personnel, students, and outside organizations in relation to routine departmental services and duties in providing appropriate assistance and information as requested. Coordinates directly with the System Infrastructure Engineer and Technical Support Specialist-Programmer.

SUPERVISION EXERCISED:

No supervision required.

REQUIREMENTS:

Associate’s degree in computer science or related field and one year of relevant work experience required, with community college experience preferred. Strong oral and written communication skills required. Experience with database reporting tools and programming languages recommended. Experience with relational databases, SQL, and Oracle database structure preferred. Banner experience strongly preferred.

Revised:

7/18/18

TORT LIABILITY STATEMENT:

Coordinates the College Risk Management Program in a capacity appropriate to this position. This includes, but is not limited to, monitoring conditions, events and circumstances present through daily College operations, and communicating observations to the appropriate supervisor or taking necessary actions to correct, prevent or limit safety problems. May serve as a member of a committee that supports the health, safety and/or legal rights of visitors, students and staff. Such committees may include the AA/EEO, Sexual Harassment, and Safety/Loss Control committees. (Risk Management Categories I, III, IV. See Tort file.)


This description is intended to indicate the kinds and levels of work difficulty that will be required of the position that will be given the title and shall not be construed as declaring what specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of the supervisor to assign, direct, and control the work of employees under supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of a similar kind or level of difficulty.