Job DetailsWest Virginia School of Osteopathic Medicine
Banner Oracle Database Administrator Senior
WVSOM Information Technology Department
Job Summary: The Banner Oracle Database Administrator Senior (DBA) is responsible for the maintenance and support of the Banner Student Information System (SIS) and related Oracle database components, including Oracle Application Server, on a Red Hat Linux operating system. This position reports to the Director of Information Technology.
Duties and Responsibilities:
• The Banner Oracle Database Administrator Senior (DBA) will be responsible for maintenance and support of a Banner Student Information System (SIS) and related Oracle database components, including Oracle Application Server, on a Red Hat Linux operating system. This will include operating in virtual environments. The DBA will perform duties to insure that the Banner system is online and accessible to the campus constituents 24/7. This includes instances for production, reporting, development and multiple testing instances.
• The DBA will keep the database managed to peak performance, monitor daily system performance, tune the database when necessary, and be responsible for backup and disaster recovery strategies including Oracle standby servers. Additional responsibilities will include cloning and refreshing databases from the production environment to development and testing environments. Cloning and refresh strategies will include utilization of RMAN and active archive logs.
• The DBA will also manage patches and upgrades to the Linux Operating System, Oracle database, and the Banner Student Information System. Patch and upgrade management may require the DBA to work outside the normal work week schedule. It will also include multiple Linux servers in support of production, development, and testing database instances.
• It will be necessary for the DBA to work closely with other IT staff to insure that State interfaces are working properly. In many cases, it will be necessary for the DBA to work with different IT technologies to resolve issues including batch programs, ProC, Cobol, Perl, and Web services (IIS and Apache) on multiple servers. Ability to maintain Evisions MAPS/FormFusion server in a windows environment performing print services is also required.
• The DBA will be required to troubleshoot various areas of the operating system in conjunction with the Linux Administrator oversight. The DBA position will be occasionally tasked with SQL scripting and package, procedure and trigger writing in support of Oracle automations. Linux shl scripting will also be required for new automations and maintenance of existing processes. Shell scripting may include GREP, AWK and SED with a necessary understanding of how to utilize regular expressions. Web development for Banner XE will be enhanced by a knowledge of HTML(5), XML and .NET. Banner XE will require the position to focus on the Groovy object oriented programming language using Java Classes and Grails, an open source web application framework.
• A knowledge of Oracle and Banner security methods will be required in addition to database performance tuning and disaster backup/recovery procedures of all database instances (production, testing, and staging). DBA duties will require maintaining the various security grants and roles for the Oracle database structure and within the Banner Student Information System security construct. This may require defining new user classes and setting users up in the correct baseline and customized user classes. It will require ongoing maintenance as new staff is added to the database and new modules expand the current installation.
• The position will be involved in technology projects which require a high level of organization and project management. The various projects will include the entire software development life-cycle including design, development and test phases on multiple database instances and servers. This includes documenting functional work flows with end users and translating that information into technical specifications for program development.
• The position will work very closely with the Banner database team and departmental users to perform upgrades and patch management. The position will shadow the Linux Administrator responsible for maintenance and upgrades to the operating system in support of the Banner Oracle database environment.
• The DBA will act as a technical consultant and trainer when necessary. The ability to communicate verbally and in writing is essential to the job function.
• Other related duties as assigned or directed.
• BS degree in Computer Science or Information Technology
• Banner Administration and Higher Education experience is preferred
• Oracle 12c DBA experience
• Oracle Application Server 12c
• PL/SQL scripting as well as Oracle package and procedure development
• Familiarity with Metalink.oracle.com
• Use of database utility and editing tools (i.e. TOAD, UltraEdit, VI, Eclipse)
• Linux shell scripting and ability to develop batch automations using the CRON service with knowledge of a variety of programming platforms (i.e. Perl)
• Knowledge of TCP/IP networking environment, Apache, IIS web services
• Understanding of web development
• Ability to take on deployments and maintenance of new applications
• Ability to handle multiple tasks simultaneously
• Ability to grasp new concepts quickly
• Ability to read and utilize technical manuals, as well as document technical processes
• Ability to work independently, and think clearly, creatively and logically
• Ability to communicate orally and in writing with faculty, staff and students in an effective and appropriate manner
• Ability to contribute in a positive manner with the Banner database team as well as other peers in the IT Department, while respecting management oversight
This position requires a minimum of 4-6 years in Oracle Database Administration, preferably in an Ellucian Banner environment.
This is a full-time non-classified position with full state benefits and is exempt from FLSA provisions regarding overtime. As a non-classified employee this person will serve at the will and pleasure of the President of WVSOM.
Not all activities of this position occur within the confines of an 8:00-4:30 schedule and will require regular evening and weekend scheduling. Some travel including overnight travel will be required. The weekly schedule for this position will be established between the supervisor and the employee and approved given the needs of the department and the institution.
This position has been designated as Essential. This means that when WVSOM is faced with an institutional emergency, employees in such positions may be required to remain at their work location or to report to work to protect, recover and continue operations at WVSOM.
How to apply
Application: Interested applicants should apply online at: http://www.wvsom.edu/employment
Applications are considered confidential and references are not contacted until later in the search process. The search committee will begin its review of applications upon receipt and the search will remain open until the position is filled.
West Virginia School of Osteopathic Medicine is an equal opportunity employer and is committed to enhancing diversity among its faculty and staff.