Job Description

Job Summary/Basic Function
The Database and Applications Administrator (3 year position) is responsible for the administration and support of various local and cloud-based database systems used by Dickinson College. Primary responsibility includes the management of Oracle, MySQL, and SQL Server database environments running on Linux and Windows servers in support of the Ellucian Banner ERP system, the associated Data Warehousing environment, and various ancillary and custom applications. Other responsibilities include managing application maintenance activity in support of systems comprising the ERP including: upgrades and patch installations, account maintenance, database backup and recovery, database security, system and database monitoring, database performance tuning, 3GL programming and compilation, data architecture, database programming, and capacity planning.
The Database and Applications Administrator will also have primary responsibility and focus on the installation, administration, integration, and support of various local and cloud-based technology packages deployed on behalf of the administrative areas of campus. The Database and Applications Administrator is responsible for the ongoing installation, upgrade, configuration, issue resolution, and support of various administrative software solutions deployed on campus. The individual must have a clear understanding of the various upstream/downstream dependencies of the applications supported. Proactive and reactive support of the applications is required. Proactive support includes identifying application upgrade paths, identifying manual processes and working to get them automated. Reactive support includes troubleshooting issues and problems, providing technical assistance, and escalating and coordinating problem resolution. The Database and Applications Administrator will work closely with other operational and support groups to increase synergies. The Database and Applications Administrator will routinely act as the point of contact with vendor support to facilitate issue resolution. The Database and Applications Administrator will serve as subject matter expert regarding the technical limitations and capabilities of deployed administrative technology solutions.

Essential Functions:

Support application and database systems which comprise the campus ERP.
a.Perform backup and recovery processes.
b.Ensure quality assurance, quality control, standardization, change management, and strategic planning for all database systems.
c.Research and recommend new methodologies and technologies to maintain a state of the art system, infrastructure, and team dynamics.
d.Tune and monitor database environments to increase processing performance and manage space utilization to ensure production procedures are optimally tuned.
e.Provide training as needed.
Perform database architecture, design, creation, and support for data-driven web-based applications.
Participate in an on-call rotation which addresses system-related emergencies which occur during non-business hours.
Develop and implement the most efficient methods for performing recurring tasks and generating consistent results, e.g. building views, making use of Banner Operational Data Store (ODS) views, Cognos, PL/SQL scripting.
Perform system and application programming.
Respond to relevant Helpdesk service requests.
Manage security for all systems comprising the college’s ERP system.
Contribute to the maintenance of technical documentation.
Preferred Qualifications
Required:

High School Diploma or GED

Preferred:

Bachelor’s Degree – Bachelor’s degree in information science or related field

Experience may substitute for all or some of the Education

•Demonstrate a thorough knowledge of relational database concepts.
•Experience with the administration and management of an Oracle or other relational database is required.
•Experience with PL/SQL preferred.
•Experience with data warehousing technologies preferred.
•Experience with Ellucian Banner, IBM Cognos, and enterprise class document imaging systems is preferred.
•Experience with Linux, UNIX, and Windows operating systems preferred.
•Experience in a college or university setting is preferred.
•Demonstrate a thorough knowledge of relational database concepts.
•Demonstrate ability to apply knowledge in solving new and varied problems.
•Demonstrate a thorough knowledge of all phases of database design and programming language constructs.
•Demonstrate a thorough knowledge of relational database concepts.
•Experience with the administration and management of an Oracle or other relational database is required.
•Experience with PL/SQL preferred.
•Experience with data warehousing technologies preferred.
•Experience with Ellucian Banner, IBM Cognos, and enterprise class document imaging systems is preferred.
•Experience with Linux, UNIX, and Windows operating systems preferred.
•Experience in a college or university setting is preferred.
•Demonstrate a thorough knowledge of relational database concepts.
•Demonstrate ability to apply knowledge in solving new and varied problems.
•Demonstrate a thorough knowledge of all phases of database design and programming language constructs.
•Demonstrate good oral and written communication skills with both technical and non-technical users required.
•Demonstrate ability to work within a team oriented environment and with users/administrators who are not technically skilled.