|
Design, analyze, code, document, and implement applications that support and enhance our campus Oracle-based administrative system, Banner and associated systems. This includes on-going support of these applications. This position is also responsible for custom application and report creation and maintenance, with a primary focus on critical advanced report creation, primarily using Hyperion, for functional areas. While not limited to this area, this position holds primary responsibility for being the key contact for the Banner student records and associated modules.
|
Works cooperatively with others and accepts direction from supervisors.
Must be able to work cooperatively with others and accept direction from supervisors.
Participate in installing purchased systems, programming in-house applications, integrating and testing applications, and if required, diagnosing production problems.
Undertake custom application development using various languages & tools to support and enhance campus systems, including but not limited to Banner. This includes web-based modules.
Develop and modify technical documentation to support operations and trainings.
Create database views, scripts, triggers and stored procedures. Proven ability to populate and test rule and validation tables, and develop test scripts. Additional responsibilities include assisting with module security planning and management, testing, software defect management and high-level module functional support, process oversight and scheduling. Must be able to carry out needs assessment, system integration and design support and general change management support.
Assist in the designing, planning, development, installation, operations and implementation of applications.
As needed, design and create appropriate Oracle tables and views to facilitate the creation of reports.
Support report development by campus users who work with institutional information systems and databases by providing expertise, analysis, data modeling, and programming in appropriate languages such as SQL, JavaScript, and/or SQR to support the development of reports. Applies user-centered design principles. Proactively supports users in the creation of reports from transactional databases and data marts.
As Senior Programmer/Analyst works closely with other Programmer/Analysts to deliver timely and cost-effective solutions. Must have strong communication and organization skills.
Work in partnership with functional leads in the various departments utilizing Banner, but a particularly deep knowledge-base is expected in the areas comprising the student records area for all programs, graduate and undergraduate (course registration, transcripts and grades, advanced placement credit, degree auditing, housing, room draw, mailboxes/phones, associated student mailings, etc. )
While not expected to prioritize departmental initiatives, once a project is approved and drafted, a senior programmer/analyst is expected to manage medium and larger-scale initiatives independently, with limited supervision.
- Performs other duties as assigned.
Key Principles: Library and Information Services is part of an educational community and shares in the responsibility for supporting teaching and learning as part of the College mission. We are committed to the following.
Proactive, responsive, respectful service to our constituents
Opportunities and expectations for ongoing employee education and development
Collaboration within the organization, across the college, and beyond
Effective and open communication
- Understanding the work of our customers
Key Relationships:
With the programming staff of Library & Information Services
With the functional leads in departments
With the leadership of LIS Systems & Infrastructure Cluster
Expected Outcomes:
Well documented code that meets a set of uniform standards
Data that is valid, consistent and secure
Applications that are well-supported and meet the needs of end-users
Application "add-ons" and custom programs that create functionality that is needed by end-users
- An information system which is able to provide end-users with the critical information needed to support the operations of the College
Applications that are reliable
|
|
Excellent written and oral communications skills and strong service orientation. The ability to work well with people from different academic and administrative disciplines with varying degrees of technical experience and knowledge. Strong functional and technical/back-end knowledge of Banner Student system required. A background in higher education is also highly desirable.
Working knowledge of network infrastructure components, web based application development tools, prototyping paradigms, security issues and production control. Must have a background in information systems analysis and design, systems integration and implementation and object oriented program design. Must have the ability to deliver quality systems that meet functional specifications on time and within budget.
Experience with the following required:
UNIX and UNIX shell scripting
Oracle databases and application development technologies (Oracle Forms, Discoverer, ETL tools, etc.)
SQL*PLUS, PL/SQL
C, ProC
Experience desired with reporting tools such as Hyperion, TOAD and SQR. Additional experience in data modeling, LDAP, Javascript, HTML, XML, and HTTP servers is helpful.
Must have logical, analytical, and problem-solving skills. Must have good interpersonal communication skills.
|