Villanova University
Database Administrator
Villanova University, Villanova, Pennsylvania, 19085
Posting Details (Default Section) Posting Number: 20244144S Position Title: Database Administrator Position Type: Staff Location: Villanova, PA Recruitment Type: Internal/External Applicants Work Schedule: full-time/12-months Avg Hours Week Department: 721-UNIT - UIS - Enterprise-Wide Systems Position Summary: Please Note: To be considered for this role, candidates must live within a commutable distance to Villanova University in Villanova, PA. Ignite Your Career at Villanova University Whether undergraduate or graduate, faculty or staff, each community member brings with them a wealth of experiences that enrich our university and shift our perspectives. As a part of this community, your work will improve lives and ignite change Why work at Villanova? Join a mission-driven organization. Since Villanova University's founding in 1842, we have been inspired by the values of truth, unity, and love, and are a community dedicated to service to others. We believe that an inclusive community fosters an understanding and appreciation for diversity among our students, faculty, staff, and administrators. The Office of Diversity, Equity, and Inclusion works to address issues of equity and justice in a variety of ways including workshops, events, and employee resource groups. Villanova's most precious asset is our people. As an employee, you will receive a holistic benefits package, generous paid time off, a competitive retirement savings plan, flexible work options, wellness programs including gym membership, professional development, tuition assistance, and more. The Database Administrator ( DBA ) is responsible for the design, implementation, maintenance, and optimization of Oracle databases within the Ellucian Banner ERP system. This role requires a combination of technical expertise and strong organizational and time management skills to ensure optimal database performance, security, and availability. The DBA will serve as a key technical resource, providing support for both Ellucian Banner applications and the underlying database infrastructure. The DBA will collaborate closely with the Lead DBA and the Banner team to support a diverse range of applications from the Ellucian suite of products as well as other 3rd party products. They will work directly with functional stakeholders to optimize and upgrade these applications, ensuring they meet evolving business needs. Additionally, the DBA will provide support to our BI and Analytics teams, enabling data-driven decision-making. Villanova is a Catholic university sponsored by the Augustinian Order. Diversity and inclusion have been and will continue to be an integral component of Villanova University's mission. The University is an Equal Opportunity/Affirmative Action employer and seeks candidates who understand, respect and can contribute to the University's mission and values. Duties and Responsibilities: Database Design and Implementation: Maintain Oracle based database systems, primarily related to the Ellucian Banner ERP and related products Serve as a technical expert for troubleshooting issues and problem resolution escalating functional, technical, and organizational issues where appropriate Create and maintain database documentation, including those for, standards, and policies. Database Administration and Maintenance: Perform routine database administration tasks, such as backups, restores, patches and security updates. Monitor and maintain the day-to-day operations of the Banner ERP and related application performance and health, identifying and resolving issues proactively Manage user access and permissions, ensuring data security and integrity. Technical Support and Troubleshooting: Provide technical support for Ellucian Banner applications and database-related issue Collaborate with stakeholders, developers and operations teams to troubleshoot and resolve complex issues. Diagnose and resolve database performance problems, ERP application issues, and other technical difficulties. Perform other duties and assist with projects as assigned. Minimum Qualifications: Formal Education Bachelor's degree Work Experience Minimum 3 years of related database administration and application infrastructure experience Experience with Ellucian Banner products and Oracle databases. Experience with projects involving multiple technologies and functions. Work Skills (e.g., written and verbal communication skills) Must be able to work independently, as well as in a collaborative, cross-functional team environment. Possesses interpersonal and communications skills to work with technical and non-technical personnel at various levels in the organization and can speak about technology through the lens of the functional area and in terms appropriate for the audience Possesses excellent organizational and technical skills to diagnose problems in an environment with constantly changing priorities. Knowledge of related security best practices Specific Job Knowledge (e.g., knowledge of principles and procedures related to field and area) Competence with Linux, SQL , and PL/ SQL Preferred Qualifications: Formal Education Master's degree Work Experience Experience working in higher education Specific Job Knowledge (e.g., knowledge of principles and procedures related to field and area) Experience serving on campus task forces/committees as technical lead/technical advisor Experience in PL/ SQL and other developer tools used to support programming that include new functionality, automated interfaces, and/or enhancements to vendor-provided software Proficiency with Linux scripting Experience with Ellucian ODS and EDW Experience with Evisions and Automic Experience with cloud applications/systems, including Ellucian Experience, Advise, Degree Works Advanced professional expertise and working knowledge in Oracle Database Administration, Apache Tomcat, Banner Administration, and middleware integrations. Ability to perform upgrades, clones, and conversions Physical Requirements and/or Unusual Work Hours: Standard work hours required and off work hours as necessary. Special Message to Applicants: Posting Date: 09/09/2024 Closing Date (11:59pm ET): Salary Posting Information: Commensurate with experience. Salary Band: 17 Job Classification: exempt