The ERP Database Administrator (DBA) is a senior technical position that leads database and application administration for the Ellucian Banner enterprise resource planning (ERP) system and additional applications and supports all Banner modules. The DBA leads ERP operations, the installation, configuration, and upgrade of Banner modules, database software, and other applications, and ensures that the Banner database is tuned and operates efficiently. The DBA coordinates with ERP analysts, system administrators, functional office staff, service providers, and others to plan installation, upgrades, or assess performance or cybersecurity issues. This position consults and advises campus leadership as it relates to critical software functionality, improvements in business processes, and the capabilities of new software and upgrades.
This is a full-time position and the DBA reports to the Director of Enterprise Applications (EAS) in the Division of Information Technology (DoIT). The position works across functional and technical offices to ensure that Banner and related applications function at a high level of effectiveness.
Job Duties: - Lead administration and support of the Ellucian Banner applications and database, as well as other applications and databases. T
- Support all Banner modules, manage the Banner database, and support multiple Banner instances used for production and testing
- Support business intelligence tools for reporting (such as ARGOS) and databases.
- Lead efforts to organize and coordinate upgrades or the installation and integration of new applications with functional offices including Budget and Planning, Procurement, Accounting, Treasurer, Talent Solutions, Classification and Compensation, Benefits, Registrar, Enrollment Management, Financial Aid, Undergraduate Admissions, Graduate College, and others.
- Works with service providers to monitor and tune application and database performance, manage backup and recovery processes, and ensure that business continuity and disaster recovery procedures are tested and function correctly.
- Manages scheduling tools that manage automated processes, maintains Oracle database security, assists in the management of Banner application security, ensures logs and records provide a clear and comprehensive audit trail of database access and updates, and works with system administrators to manage server security.
- Assigns tasks to junior staff, monitors the work, and makes recommendations to the director as needed. The DBA serves as a technical resource for application analysts, programmers, and power users.
- Software Deployment, Upgrades, and Development - The DBA serves as a critical team member during the deployment of new applications, upgrade of existing applications, and development of new software. This position provides Banner technical and database expertise to ensure that these applications or upgrades are implemented successfully. The DBA serves as a technical resource to functional and technical staff and ensures that new applications or upgrades are integrated with existing applications.
- Project Management - The DBA serves as a critical member of project teams and may serve as a project manager or coordinator.
- Additional Duties - The DBA provides input on end-user training, service design, metrics, and monitoring, and supports other IT staff and additional applications as needed. This position trains junior technical and student staff as needed. This position works with clients and other IT staff on special projects as needed and ensures that change control procedures are followed. Other duties may be assigned to meet the needs of the university or the division.
Qualifications: - A master's degree in computer science, Information Technology, or a related field with three (3) years of progressive related experience, or a bachelor's degree in computer science, Information Technology, or a related field with five (5) years of progressive related experience, or an equivalent combination of education, certifications, and relevant experience.
- Advanced technical troubleshooting knowledge and proficiency in Banner and Oracle databases.
- Expertise in Oracle SQL with the ability to tune database operations, configurations, and advanced queries.
- Practical experience in data exchange and transformation.
- Practical understanding of the software development lifecycle including technical design, unit testing to user testing, and to production migration.
- Familiarity with change control procedures and compliance and ensuring software stability and data integrity.
- Proficiency in training and mentoring junior technical staff to enhance their skills and contribute to a collaborative team environment.
- Effective communication skills, including the ability to provide instructions and training through explanations and demonstrations suitable for both technical and non-technical audiences.
- Strong customer service skills, driven by a genuine desire to assist others.
- Proactive and optimistic mindset coupled with a diligent and responsible work ethic.
Requirements: - Knowledge of higher education administrative processes
- Experience in managing projects from inception to completion, including developing project plans, coordinating timelines, and ensuring that projects meet objectives and timelines.
- Strong skills for process documentation and developing Standard Operating Procedures (SOP).
