Loading...
Share this Job

UC COMMITMENT TO HEALTH & SAFETY

To promote the health and safety of our university community, UC currently has a mandatory mask requirement for all buildings on campus for faculty, staff, students, and visitors. Additionally, successful applicants for this position must be fully vaccinated against COVID-19 as a condition of employment. Vaccine verification will be required by November 15, 2021. Newly hired individuals will be required to provide proof of their COVID-19 vaccination. There is an opportunity to request an exemption from the vaccine requirement for medical reasons, sincerely held reasons of conscience, or religious beliefs.

Database Administrator 2, ERP

Current UC employees must apply internally via SuccessFactors > http://bit.ly/UCEMPL

 

Founded in 1819, the University of Cincinnati embarks upon its third century – building on the past and defining the future by leading urban, public universities into a new era of innovation and impact through its strategic direction, Next Lives Here. Underscoring the power of creativity, ingenuity, invention and inclusion, what’s Next will accelerate our unrivaled momentum, evidenced by eight straight years of record enrollment and rankings that include placement among America’s top 100 public universities by U.S. News & World Report. Home to a diverse student body of nearly 47,000 and more than 4,200 distinguished faculty, the university combines its Research 1 (Very High Research Activity) Carnegie Classification with a physical setting that The New York Times recently acclaimed as “the most ambitious campus design program in the country.

 

Job Overview

Administer, maintain, develop, and implement policies and procedures for ensuring the security and integrity of the university's ERP databases. Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data issues.

Essential Functions

  • Support multiple ERP databases of medium to high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data. Increased skill in multiple technical environments.
  • Support integration of changes in test, preproduction, and production environments, evaluating problems and determining required course of action.
  • Work with analysts to understand university needs.
  • Translate logical data models into physical database designs and develops physical databases and assists in establishment of database system flows.
  • Develop and maintain enterprise data documentation, metadata models and database requirements that are provided to system administrators.
  • Code, edit and install stored procedures and functions for accessing, maintaining, and populating databases. Recommends solutions to support data integrity efforts.
  • Monitor, analyze, troubleshoot, and resolve application and database performance and calibrate Database Management Systems (DBMS) parameters ensuring optimal database performance and availability.
  • Maintain development, production and multiple testing environments.
  • Perform upgrades of databases, adding new structures or elements.
  • Plan and manage the migration of databases.
  • Install, configure and maintain the database management systems software.
  • Build scripts automating the daily operations of database management.
  • Monitor transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
  • Implement database backup and recovery procedures.
  • Control privileges and permissions to database users and assure appropriate information security is applied in all tasks.
  • Provide production support/database access 24 hrs. X 7 days a week. Conducts level 2 support.
  • May coach team members.
  • Research and evaluate emerging database technologies.
  • Perform related duties based on departmental need. This job description can be changed at any time.

Required Education

  • Bachelor’s Degree in Computer Science, Information Systems or Mathematics.
  • Six (6) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.

Required Experience

  • Two (2) years of ERP database administration experience working with various database management systems.
  • Knowledge of ERP applications and the role databases play in a web application stack.
  • A broad level of understanding surrounding information systems and application and/or ERP standards.

Physical Requirements/Work Environment

  • Office environment/no specific unusual physical or environmental demands.

 

The University of Cincinnati, as a multi-national and culturally diverse university, is committed to providing an inclusive, equitable and diverse place of learning and employment. As part of a complete job application you will be asked to include a Contribution to Diversity and Inclusion statement.

 

As a UC employee, and an employee of an Ohio public institution, if hired you will not contribute to the federal Social Security system, other than contributions to Medicare. Instead, UC employees have the option to contribute to a state retirement plan (OPERS, STRS) or an alternative retirement plan (ARP).

 

The University of Cincinnati is an Affirmative Action / Equal Opportunity Employer / Minority / Female / Disability / Veteran.

 

REQ: 67622 

SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN

Database Administrator 2, ERP

Date:  Sep 11, 2021
Location: 

Cincinnati, OH, US

Facility:  Main Campus


Nearest Major Market: Cincinnati

Job Segment: System Administrator, Database, ERP, DBA, Developer, Technology