Database Administrator 2 - Cincinnati, OH

Current UC employees must apply internally via SuccessFactors · Next Lives at the University of Cincinnati · Founded in 1819, the University of Cincinnati ranks among the nation's best urban public research universities. Home to more than 53,600 students, 12,000 faculty and staff ...

Job description

Current UC employees must apply internally via SuccessFactors

Next Lives at the University of Cincinnati

Founded in 1819, the University of Cincinnati ranks among the nation's best urban public research universities. Home to more than 53,600 students, 12,000 faculty and staff, and over 360,000 living alumni, UC, a Carnegie 1 institution, combines research prowess with a physical setting The New York Times has called "the most ambitious campus design program in the country." UC's momentum has never been stronger as the anchor of the Cincinnati Innovation District, the oldest cooperative education (co-op) program in the country with students earning $94 million annually through paid experiences, an academic health system, and as a member of the Big 12 Conference. The university contributes $10.6 billion in economic impact to the city and $22.7 billion to the state of Ohio. At UC, next is all of us. Learn more at

UC is a mission-driven organization where we are committed to student success and positively transforming the community through scholarship and service. We thrive on innovation, making an impact, and fostering an environment where staff and faculty are key contributors to UC's success.

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.

Compensation and Benefits

UC offers an exceptional benefits package designed to support your well-being, financial security, and work-life balance. (UC Benefits) Eligibility may vary by position and FTE status. Highlights include:

Salary/Hourly Pay Rate Information:

Comprehensive Tuition Remission

UC provides tuition remission for you and your eligible dependents, covering tuition costs for nearly all undergraduate and graduate programs offered by the university.

Robust Retirement Plans

As a UC employee, you won't contribute to Social Security (except Medicare). Instead, you'll choose between state pension plans (OPERS, STRS) or an Alternative Retirement Plan (ARP), with UC contributing 14–18% of your salary based on position.

Real Work-Life Balance

UC prioritizes work-life balance with a generous time-off policy, including:

Vacation and sick time

11 paid holidays and additional end-of-year paid time off (Winter Season Days)

6 weeks of paid parental leave for new parents

Additional Benefits Include:

• Competitive salary based on experience
• Comprehensive health coverage (medical, dental, vision, prescription)
• Flexible spending accounts & wellness programs
• Professional development & mentorship opportunities

To learn more about why UC is a great place to work, please visit our Careers Page.

UC is an E-Verify employer. If hired into this position, you will be required to provide satisfactory proof of employment eligibility by providing acceptable, original forms of identification for employment verification via the Federal I-9 employment verification process. Click here for a list of acceptable documents.

Important: To apply you must create a profile and submit a complete job application through the UC applicant portal. We are unable to consider "easy apply" applications submitted via other websites. For questions about the UC recruiting process or to request accommodations with the application, please contact UC HR at

Equal Opportunity Employer. Building a workplace where all qualified applicants will receive consideration for employment, including Individuals with Disabilities and Protected Veterans.

REQ: 101573