Database Administrator - JR25940-3800

University of Chicago - Chicago, IL

Full-time - Entry Level

Chicago, IL

Educational Services

About the position

The University of Chicago Biological Sciences Division (BSD) is seeking a Database Administrator (DBA) to join its Information Technology team. The DBA will play a crucial role in the implementation, configuration, maintenance, and performance of SQL Server and Oracle RDBMS systems. This position is essential for ensuring the availability and consistent performance of applications that support clinical, translational, and basic science research. The successful candidate will possess solid technical skills complemented by excellent interpersonal and communication abilities, enabling them to work effectively within a collaborative environment. In this role, the DBA will be responsible for the operational readiness of database instances, which includes managing security, health, and performance. The DBA will execute data loads, deploy application code, and manage SQL Server databases across multiple product lifecycle environments, from development to production systems. Additionally, the DBA will manage Oracle database instances on Linux, configure and maintain database servers, and monitor system health and performance to ensure high levels of performance, availability, and security. The DBA will also analyze, solve, and correct issues in real-time, providing end-to-end problem resolution. They will refine and automate regular processes, track issues, and document changes. Assisting developers with query tuning and schema refinement will be part of the responsibilities, as well as installing and configuring SSRS reporting instances. The DBA will define and interpret existing data, populate the database with new data from external sources, and participate in the development of queries and retrieval systems. Monitoring the database storage system to securely store and organize datasets is also a key responsibility. The DBA will perform other related work as needed to support the department's mission.

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.
• Analyze users' requirements and solve routine database problems to ensure users and related applications can access necessary data sets.
• Define and interpret existing data and populate the database with new data from external sources.
• Participate in the development of queries and retrieval systems.
• Monitor the database storage system used to securely store and organize datasets.
• Perform other related work as needed.

Requirements

• Minimum requirements include a college or university degree in a related field.
• Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.

Nice-to-haves

• Familiar with Oracle Database Administration.
• Familiar with Linux OS.
• Familiar with ksh scripting.
• Familiar with Windows Administration.
• Independent problem-solving skills.
• Strong communication skills involving translating complex technical terminology and functional processes into layman's terms.

Benefits

• Health insurance coverage
• Paid time off
• Retirement savings plan
• Professional development opportunities
• Flexible work arrangements