Database Administrator II

Job Description

Job Description

The Database Administrator II is responsible for supporting the mission critical production, test, and development applications used for campus administration.

The Database Administrator II (DBA II) is responsible for supporting Oracle Database Administration, Apache Tomcat, Banner Administration, and middleware integrations. Further responsibilities include support of the data warehouse and ETL processes, troubleshooting errors generated by in-house or vendor provide software, building and configuring Banner modules to perform needed functionality according to documented processes and procedures, assisting with the implementation of new software and upgrades of existing software, and working with the application team to develop database architectures, coding standards, and quality assurance procedures.

Duties are performed on a variety of operating systems with a primary focus on Linux and Windows. The DBA II may be required to work evenings and weekends to ensure proper administration.

Duties & Responsibilities:

• Provides oversight on all operating budgets totaling over $500,000. Reviews quarterly budgets with all operating units to ensure operating activity is accurate, appropriate, and in line with the annual budget plan. Manages the summer budget. Monitors and manages all non-labor accounts and discretionary funds; including resource funds, overhead, endowments, and scholarship accounts. Manages joint affiliation payments/deposits. Manages scholarship funds. Reviews and approves Unimarket purchases. Manages computer purchases, including budgeting and purchasing.

• Conducts advanced Oracle Database Administration tasks, including database creation and maintenance, tuning, capacity planning, backup and recovery, program migrations, and security implementation/enforcement/audit. Provides technical leadership and guidance to less senior database administrators.
• Architects high availability systems and implements, documents, and tests Disaster Recovery solutions. Installs, maintains, and integrates Middle Tier technologies including Apache Tomcat.
• Coordinates with the Project and Portfolio Management Office (PPMO) to conduct project management duties such as research, scoping, resource planning, and risk analysis. Mentors team members, develops documentation and technical guidelines and diagrams.
• Researches emerging technologies and trends in the Oracle Database and applications market and develops proposals on how these trends impact the environment. Assist with the implementation of new software and upgrades of existing software.
• Works with module leaders to plan and implement Ellucian patches and upgrades. Build and configure Banner modules to perform needed functionality according to documented processes and procedures.
• Works with vendors to diagnose integration, functionality, and performance issues. Monitors and manages TDX tickets. Provides Banner application and functional support, maintains support tickets with Ellucian / Oracle / third party vendors.
• Performs administrative tasks / other duties as assigned.

Work Experience:

• Database Administration in Oracle or SQL Server, or Oracle-based ERP Administration
• Monitoring backup jobs and implementation of backup strategies
• Development and implementation of upgrade methodologies
• Project management duties – research, scope definition, resource and time estimation, risk analysis
• Professional expertise and working knowledge in Oracle Database Administration, Apache Tomcat, Ellucian Banner Administration, and middleware integrations.
• Professional expertise and working knowledge in Oracle Database Administration, Apache Tomcat, Ellucian Banner Administration, and middleware integrations.
• Experience with data warehousing and ETL processes.
• Experience with enterprise-level applications that include, but are not limited to, Ellucian Banner Workflow, Evisions, IBM Cognos Analytics, Axiom, Slate, and UKG Ready.

Education: Bachelor's Degree in Computer Science, IT or related field.