ODB Database Administrator II

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

30 Corporate Woods, Brighton, New York, United States of America, 14623

Opening

Worker Subtype:

Regular

Time Type

Full time

Scheduled Weekly Hours

40

Department

900083 ISD Infrastructure

Work Shift

UR - Day (United States of America)

Range

UR URG 112

Compensation Range

$70,197.00 - $105,295.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities

GENERAL PURPOSE

Builds and maintains operational database, including Epic. Administers database utilities, monitors the relationships between the database users and applications, and maintains the organization's databases across multiple platforms and computing environments. Applies understanding of relational database concepts and query languages in order to design required summary or aggregation tables to support analyses. Collaborates with technology/infrastructure staff to identify data relationships and functional requirements. Analyzes and resolves issues related to information flow and content. Maintains database support tools, database tables and dictionaries and recovery and back-up procedures. Performs data modeling studies and develops detailed data models. Creates data model and entity relationship diagrams.

Essential Functions

• Performs software installations, maintenance, and configurations in a controlled environment that consists of thorough testing of the product. Ensures the implementation process is as seamless and non-disruptive to production systems as possible. Provides the necessary training to applications or computer operations staff. Designs, implements, tests, and monitors backup and recovery procedures for operating system, database software, databases, and application software. Ensures systems are recoverable. Evaluates new software products, new or enhanced features or installed software and recommends a direction for implementation. Provides Database Administration support, including data transformation duties for the various database management software packages installed, such as database design and/or database definition. Provides application level support as needed for Enterprise Applications that utilize supported Database Management System.
• Uses the operating system/database monitors installed to determine if all necessary components of the operating system and/or database system are functioning and accessible. Monitors end-user response time for production applications to ensure consistent and acceptable performance. Certifies service level agreements are being met. Reviews performance data from the operating system and the databases on at least a quarterly basis. Determines if performance objectives are being met. Recommends and implements performance-tuning changes based review. Monitors the performance, capacity, and usage of the disk storage subsystem. Monitors dataset placement and allocations to ensure established guidelines are followed, space is not being misused, and input/output rates are within acceptable limits.
• Collaborates with computer operations, applications development, end-users, and software vendors to provide first-level support for problems related to the operating system or database software environments. Assists application development with problem determination and resolution for application abends. Responds promptly to all problems, keeping in mind the computing environment supports a user community that requires access to critical business information 24 hours a day, 7 days a week. Rotates primary/secondary/backup on-call for off-hours support with other staff members.
• Maintains current knowledge of technology and an advanced level of software skills through self-study programs, reading technical journals, attending job related seminars, and personal development conferences that develop and strengthen skills. Functions as a technical resource for members of the operating system and database group, applications development, computer operations, and the end-user community. Develops and maintains operating system/database software documentation that is necessary to support the products installed. Maintains an awareness of current projects and deadlines and assigns priorities as required. Completes projects on-time and within budget constraints.
  
  

Other duties as assigned.

Minimum Education & Experience

• Bachelor's degree and 4 years of relevant experience required
• Or equivalent combination of education and experience
  
  

LICENSES

• EPIC - EPIC Certification upon hire required
  
  

EOE Minorities / Females / Protected Veterans / Disabled

The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University’s mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.