Working Title: Database Applications Programmer
Department: Information Technology
Technical and professional work in planning, developing, testing and documenting computer application programs and internal systems.
Nature of Work:
The Database Applications Programmer regularly creates database programs and reports needed by faculty and staff. This person also acts as a technical contact for the campus regarding issues related to the Banner database system and other systems, other related programs or applications.
Duties & Responsibilities:
- Design, code, test and document application programs and ad-hoc reports for Admissions, Financial Aid, Institutional Research, and Records
- Assist in installing new versions of Oracle/Unix/Banner software including monthly upgrades
- Assist DBA with various Banner, Oracle, Unix, PeopleSoft, and other departmental duties as assigned
- Develop and assist with development of reports using Crystal Reports and Oracle Reports
- Plan, design, create and maintain new systems, processes, applications, and programs
- Banner functional support for Admissions, Financial Aid, Institutional Research, and Records
- Interpreting database data needs of faculty and staff to extract data from the Banner database.
- Create ad-hoc Banner reports, web based reports, and/or raw data.
- Convert database related reports from legacy systems/programs (such as COBOL, Crystal Reports) to web based Banner reports.
- Install and provide technical support for the EMAS Telecounseling/Recruitment system used by the Admissions department for recruiting purposes.
- Provide database administration for the EMAS Telecounseling/Recruitment system. Creating and maintaining a data bridge between the Banner database and the EMAS database to ensure concurrency.
- PeopleSoft Certified Trainer - Ensuring that all Faculty/Staff are properly trained to use the PeopleSoft application to submit expenses related to flexible spending accounts, work related travel, and business expenses.
- PeopleSoft Security Administrator – create and maintain all user accounts, roles, and privileges for campus personnel.
- PeopleSoft Technical Contact – campus contact person for PeopleSoft technical issues and problem solving
- Manually execute recurring database programs on a set schedule to ensure that Banner is properly updated with pertinent student data including grades, GPA, learning support status, test scores, etc.
- Technical contact for the Emergency Notification System used by the college to notify campus subscribers of critical information regarding a crisis or emergency. Created and maintains the data bridge between the system and the Banner database to ensure concurrency.
- Creating and processing of all student technology account letters. (Created several times each semester, contains student account access information for campus computer access, email accounts, web portal accounts, and online course accounts)
- Banner database technical contact – providing technical support and troubleshooting for faculty and staff.
- Create and maintain database applications that allows campus population to log usage of specific campus services including tutoring labs, training centers, and physical fitness facilities.
- Install, configure, and maintain specialized server based applications and hardware used by the campus.
- Administrate campus computer log-in tracking server.
- Provide Banner, PeopleSoft, and other application related training classes for the campus population.
- Provide client side updates to the college portal website for server access and self-service help documents and tutorials.
Required/Desired Knowledge, Abilities & Skills:
- Expert knowledge of SQL, PL/SQL, Pro C, C, or C++
- Experience with UNIX operating system such as LINUX, Solaris, or HPUX
- Experience with programming scripting languages, Perl, & web
- Knowledge of Banner and PeopleSoft
- Knowledge of the concepts and issues involved with client/server implementations
- Excellent communication skills needed - both oral and written.
- Must be able to effectively communicate with campus population regarding database and computer related issues.
- Competent knowledge of data networking systems.
- Competent technical knowledge of Microsoft Office applications (Excel, Access, Word, Outlook, PowerPoint)
- Competent knowledge of computer/printer hardware and basic troubleshooting and repair.
- Ability to manage multiple tasks efficiently and effectively.
Required Education and/or Experience:
Bachelor's Degree in Computer Science or related field preferred, minimum of two years experience writing programs using a Structured Query Language (SQL) and procedural programming (PL/SQL or equivalent).
The Database Applications Programmer reports to the Database Administrator and the Chief Information Officer.
Contacts: Robbin Burriss
Any corrections/updates to information listed on these pages are required to go through the contacts listed above.