Database Administrator

Department

BSD BIS - Business Intelligence Services

About the Department

About the Department

The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and translational research, education, and patient care come together in a single campus. Its mission is to create new knowledge of living systems, train the next generation of leaders in biology and medicine, and advance the forefront of health through innovative patient care. The Biological Science Division is divided into 10 basic science and 13 clinical departments that provide academic homes for nearly 900 full-time faculty. The BSD Information Technology team provides advanced, secure technologies and services to enable clinical, translational, and basic science research.

Job Summary

The DBA will be responsible for the implementation, configuration, maintenance, and performance of our SQL Server and Oracle RDBMS systems. The DBA will help ensure the availability and consistent performance of our applications. The position requires solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for the operational readiness of the database instances (security, health and performance), executing data loads, and deploying application code.

Responsibilities

• Manage SQL Server databases through multiple product lifecycle environments, from development to production systems.

• Manage Oracle database instances on Linux.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

• Refine and automate regular processes, track issues, and document changes

• Assist developers with query tuning and schema refinement.

• Install and configure SSRS reporting instances.

• With moderate direction from others, analyzes the users' requirements and solves routine database problems that ensures users and related applications can access necessary data sets.

• Defines and interprets existing data and populates the database with new data from external sources. Plans own resources such as documentation on data models, data dictionaries, physical database configuration, and daily database maintenance functions.

• Participates in the development of queries and retrieval systems.

• Monitors the database storage system used to securely store and organize datasets.

• Performs other related work as needed.

Minimum Qualifications

Education:

Minimum requirements include a college or university degree in related field.

• --

Work Experience:

Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.

• --

Certifications:

• --

Preferred Qualifications

Technical Skills or Knowledge:

• Familiar with Oracle Database Administration.

• Familiar with Linux OS.

• Familiar with ksh scripting.

• Familiar with Windows Administration.

Preferred Competencies

• Independent problem-solving.

• Strong communication skills involving translating complex technical terminology and functional processes into layman's terms.

Working Conditions

• Hybrid remote and occasional in-person (subject to change per university policy).

• Daily team scrum (virtual).

• Occasional deployment activities after business hours.

Application Documents

• Resume (required)

• Cover Letter (required)

When applying, the document(s) MUST be uploaded via the My Experience page, in the section titled Application Documents of the application.

Job Family

Information Technology

Role Impact

Individual Contributor

FLSA Status

Exempt

Pay Frequency

Monthly

Scheduled Weekly Hours

40

Benefits Eligible

Yes

Drug Test Required

No

Health Screen Required

No

Motor Vehicle Record Inquiry Required

No

Posting Statement

The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, national or ethnic origin, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.

Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via Applicant Inquiry Form.

We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.

All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.

The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: http://securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.