The Senior Database Administrator (DBA) is responsible installation, maintenance and upgrades for the Colleges Oracle database systems and supporting tools including but not limited to: Oracle RDBMS, Oracle Application Servers, Oracle Reports and Forms and the Ellucian (Banner) ERP.
This position is a member of the Resources and Access (RA) Department, which focuses on direct services and support for students, faculty and staff.
ESSENTIAL JOB FUNCTIONS:
•Install, administer, maintain, support, monitor the performance and upgrades to the Oracle infrastructure to include but not limited to: RDBMS, related Oracle tools, Ellucian Banner software, Oracle Application Servers, Oracle Portal, and Oracle Forms and Reports.
•Manage upgrades, patches and fixes to the Oracle RDBMS and related tools.
•Develop, execute and verify Oracle database backup and restoration strategies, policies and procedures.
•Install, administer, maintain, support and monitor the performance of the ERP and related integrated applications.
•Automate processes to monitor resource utilization and performance of Oracle and ERP-related applications and tools.
•Diagnose and resolve problems and errors related to the Oracle RDBMS, the ERP and related software applications and tools.
•Serve as a technical subject matter expert for application developers and other technical staff. Provide and maintain appropriate Oracle and ERP test and development environments for the use of developers, other technical staff, and members of client offices. Provide assistance in application integration and problem resolution.
•Implement and maintain highly reliable, available, secure systems and make recommendations for improving operational efficiencies.
This position frequently interacts closely with business office staff and college occasionally with college faculty, providing technical support, training and gathering specifications for work to be completed. It may interact with outside vendors for service, preventative maintenance, or acquiring software and/or hardware components.
SUPERVISORY RESPONSIBILITIES None
REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:
Individuals must possess these knowledge, skills, and abilities or be able to explain and demonstrate that the individual can perform essential functions on the job, with or without reasonable accommodations, using some other combination of skills and abilities.
•Proficiency in Oracle database administration. At least several years of experience with Oracle Database and Oracle Application Server (IAS 9i and above).
•Programming experience with SQL and PL/SQL.
•Oracle Certified Professional training or equivalent combination of education and experience.
•Experience with ERP administration. Experience with Ellucian’s (Banner) administration highly preferred, specifically managing and implementing Banner upgrades.
•Ability to implement or modify complex application systems, coordinate significant projects, expensive resources, and collaborative effort to achieve organizational goals – with great attention to detail
•Ability to make prudent, fair, and sound decisions while anticipating results, direct and indirect
•Self-motivation and self-direction; ability to work independently; ability to work effectively in a team environment; willingness to take direction; ability to participate in group planning processes; ability to prioritize and coordinate multiple assignments, initiatives and priorities; ability to meet deadlines.
•Demonstrated ability to rapidly learn and apply new technologies, tools, techniques and methodologies. Open to change.
•Poise and polished interpersonal skills, and the ability to listen carefully and patiently to disparate concerns of multiple constituencies. Strong oral and written communications skills. Candidates must be able to communicate effectively with colleagues with different areas and levels of technical expertise.
•Work experience in higher education and an understanding of higher education business practices preferred.
•Strong familiarity with a broad range of information technology concepts—including concepts associated with enterprise level information technology infrastructure.
•Bachelor’s degree, in computer science or a related field preferred
•A minimum of three years working as a database administrator using Oracle, Oracle Tools, and Oracle development languages;
•An equivalent combination of education and experience may be considered.
•Demonstrated experience or professional training/education with UNIX, C, ProC, HTML, Banner software, Apache, Evisions, Oracle