Database Administrator - Tiffin, United States - Heidelberg University

Description

Reporting to the Chief Information Officer, the Database Administrator will be responsible for the maintenance and operation of the Cloud Data Warehouse and Visualization software.

The U.S. Department of Education's Title III Grant Award to Heidelberg University (Grant Award Number P031A230004, CFDA 84.031A, Data Integration and Storage to Support Student Access and Success ) will pay this five-year grant-funded position at Heidelberg University, starting no sooner than October 1, 2023, and retained no longer than September 30, 2028. The total grant awarded for year one is $421,255; the total award amount estimated over five years is $2,165,318 (estimated at 74% of the total project). Nonfederal grant match toward this federal award is estimated at $770,974 (26% of the total project) over the five-year grant performance period.

SUPERVISION RECEIVED:

The Database Administrator is directly supervised by the Chief Information Officer and may receive indirect supervision from the Title III Project Director.

SUPERVISION EXERCISED:

None

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Install and maintain the performance of Heidelberg's cloud data warehouse;

Serve as Heidelberg's primary point of contact for the cloud data warehouse vendor

Enforce University policies for data access through maintaining user account permissions in Banner and associated applications.

Develop processes for optimizing database security;

Set and maintain database standards;

Performance tuning of database systems;

Install, upgrade, and manage database applications.

Diagnose and troubleshoot database errors.

Create and manage database reports, visualizations and dashboards.

Create automation for repeating database tasks.

Maintain high accountability for project outcomes;

Develop and maintain the necessary procedures to allow the interfacing of Banner with University approved 3rd party products.

Collaborate with the Owen Center for Teaching and Learning, Computer Network & Information Technology, Student Affairs, and other campus offices and stakeholders to advance Title III project goals and objectives;

Provide data and input on all Title III reports;

Perform other duties as assigned in support of the Title III project.

CORE VALUES AND PERSONAL ATTRIBUTES:

• Core values – models leadership values of integrity, honesty, humility, transparency, respectfulness, diversity, caring, loyalty and accountability in all work.

• Intellectual dynamism – demonstrates mental sharpness, capability and agility.

• Self-knowledge – gains insight from successes and mistakes.

• Personal learning – seeks feedback and counsel to improve managerial behavior.

• Peer relationships – encourages collaboration and cooperation across the organization.

• Teamwork – performs most effectively as a hard-working member of a team.

• Constituency focus – completes work to meet constituencies' expectations and requirements.

• Community focus – brings a spirit of enthusiasm and energy to the campus and town.

DESIRED ATTRIBUTES AND QUALIFICATIONS:

Education and Professional Experience:

Bachelor of Science degree in Computer Science or related field from an accredited 4-year university;

Experience with Cloud Data Warehousing;

Experience querying and creating reports in advanced computer databases; and

Familiarity with cybersecurity.

Preferred Education and Experience:

Master's degree in Computer Science or related field from an accredited 4-year university;

Three (3) three years of experience in higher education;

Experience working with a relational database;

Experience working with an ERP platform; and

Experience working with a reporting platform.

Necessary Knowledge, Skills, and Abilities:

Ability to maintain an Oracle database (19c+)

Ability to write SQL commands to query and extract data

Familiarity with ERP administration (Banner)

Demonstrated interpersonal, organization, and oral and written communication skills and the ability to multitask and manage competing priorities

Demonstrated ability in effective collaboration with college community

Ability to analyze, explain, and present complex statistical data

Proficiency with various computer applications including word-processing, spreadsheets, presentation software, and data visualization software.

Ability to work both independently as well as cooperatively in a team setting.

Exceptional self-motivation, integrity, and creativity.

Ability to manage multiple tasks and adhere to strict deadlines.

Ability to interact professionally, effectively, and in collaboration with faculty, staff, students, and alumni.

TOOLS AND EQUIPMENT USED:

Knowledge of operation and use of various office equipment including, but not limited to: personal computer (including spreadsheet and word processing software), integrated database software, fax machine, copier, telephone, scanner, printers, and adaptive technologies.

PHYSICAL DEMANDS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position.

While performing the duties of this job, the employee is frequently required to use arms, hands and fingers to operate and manipulate equipment generally found in an office setting. The employee may be frequently required to be mobile, communicate, and hear.

The employee must frequently lift and/or move up to ten (10) pounds and occasionally lift and/or move more than twenty-five (25) pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. Mental demands include varied degrees of occasional stress while performing job duties.

WORK ENVIRONMENT:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

While performing the duties of this job, the employee frequently works in an office setting. The noise level in the work environment will range from moderately quiet to moderately loud.

SELECTION GUIDELINES:

The Title III Project Director will be selected after a formal application procedure, education and experience rating, oral interview, and reference check. Job-related tests may be required. All offers of employment are contingent upon a satisfactory criminal background screen, motor vehicle record search, drug and alcohol screen, physical and / or psychological examination at the University's discretion.

View or Apply

To help us track our recruitment effort, please indicate in your email – cover/motivation letter where ) you saw this job posting.