Job Seekers, Welcome to The Builders, a chapter of the AGC Career Center
Search Filters
Use this area to filter your search results. Each filter option allows for multiple selections.
NEW! NEW!
NEW! NEW!
University of Maryland Medical System
Baltimore, Maryland
NEW! NEW!
NEW! NEW!
Cushman Wakefield Multifamily
Special capital Region of Jakarta, Indonesia
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
NEW! NEW!
Loading... Please wait.
Details
Posted: 16-Nov-24
Location: Carlisle, Pennsylvania
Internal Number: 7858
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:
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.
Department: Infrastructure Systems
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.
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
About Dickinson College
Known for its innovative curriculum, Dickinson is a highly selective, private liberal-arts college. One of the nation's oldest colleges, and named in honor of a signer of the U.S. Constitution, Dickinson became the first college chartered in the newly recognized United States in September 1783. Dickinson has just under 900 full and part-time employees - administrators, faculty and staff - and its 144-acre campus is populated by students from 43 U.S. states and territories and 40 foreign countries. More than half of students study abroad through the school's 50 programs in 24 countries on six continents. Dickinson is recognized as a leader among institutions committed to sustainability and green initiatives and is continually recognized by such groups as the Association for the Advancement of Sustainability in Higher Education, Sierra Club, Sustainable Endowments Institute, Princeton Review and Second Nature. Dickinson's stunning campus - featuring beautiful landscaping and buildings made of limestone - is located in the heart of the historic central Pennsylvania town of Carlisle, a key marker in Civil War activity. Founded in 1751, Carlisle, named a "most livable city" by Forbes, i...s a cosmopolitan town of 20,000 people, nestled between mountains that have long been a destination for outdoor enthusiasts. The Appalachian Trail and several mountain lakes are within easy reach of the campus, as are Hershey Park and historic Gettysburg. The town is a transportation hub linked by highway, rail and air to prominent East Coast cities, with driving times that make these cities readily accessible: Harrisburg, 20 minutes; Gettysburg, 30 minutes; Baltimore, 90 minutes; Washington, D.C., two hours; Philadelphia, two hours; New York, three hours; Pittsburgh, four hours. Dickinson takes pride in its campus wellness and professional development programs, offering an array of opportunities to faculty and staff.
Show more
Show less
https://careers.thebuildersagc.com/jobs/20810561/applications-and-database-administrator
Loading. Please wait.