• Job Description

  Req#: R117582

  Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. If you have questions while submitting an application, please review these frequently asked questions.

  Current Employees and Students:

  If you are currently employed or enrolled as a student at The Ohio State University, please l og in to Workday to use the internal application process.

  Welcome to The Ohio State University's career site. We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following:

  • Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.
  • Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.

  Job Title:

  Associate Database Administrator

  Department:

  Arts and Sciences | Center for Human Resource Research

  Job Description

  The Center for Human Resource Research (CHRR) at The Ohio State University, within the College of Arts and Sciences, seeks Associate Database Administrator to join our team. The College of Arts and Sciences is the largest college and the academic heart of the university. The College hosts 81 majors. With 38 departments, 20+ world-class research centers, and more than 2,000 faculty and staff members, students have the unique opportunity to study with the best artists, scholars, and scientists in their field. The College values diversity and offers a supportive, open, and inclusive community.

  The Associate Database Administrator assists with administration of 30+ Oracle databases and Cloudera (Impala/Hive) environments. The position performs installation, configuration, operation, maintenance, and support of database management system (DBMS) software to ensure stability, reliability, recoverability, and acceptable performance. Works with the Database team to ensure daily Oracle database operations run smoothly and ensure tuning, maintenance, backup, recovery tasks are executed promptly.

  The Associate Database Administrator manages datasets and writes and maintains custom SQL and PL/SQL blocks to perform various data-related tasks, including Exchange, Transform, and Load (ETL) processes. The position also works directly with the team to assist CHRR users with database-related tasks, including creating custom reports and running database jobs.

  Minimum Education Required

  Bachelor’s degree in computer science or similar or the equivalent combination of education and experience is required.

  Required Qualifications

  Experience working with databases and a strong foundation of DBMS knowledge and expertise. Advanced knowledge of SQL. Communicates effectively, permitting information exchange with technical and non-technical colleagues, and can multi-task and work on multiple projects simultaneously.

  Desired Qualifications

  Prior relevant experience working with DBMS, including loading, creating, and updating data and various database objects, and a strong background in SQL. Experience working within a Linux environment. Experience with ETL processes. Experience automating data jobs, reports, and database procedures. Experience using RDBMS management tools (e.g., Toad, SQL Developer, OEM). Experience using or supporting statistical software packages (e.g., SAS, SPSS, Stata, R) in research environments; experience with Apache Hive and/or Impala in Cloudera environment.

  Additional Information:

  The pay range for this job profile is $24.52 - $32.31. The offer for this position will fall within this range based on internal equity, unit's available budget, and the candidate's qualifications.

  Location:

  OSU Center for Human Resource Research (0967)

  Position Type:

  Regular

  Scheduled Hours:

  40

  Shift:

  First Shift

  Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process.

  Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions .

  The Ohio State University is an equal opportunity employer.

  All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability, ethnicity, gender identity or expression, genetic information, HIV/AIDS status, military status, national origin, race, religion, sex, gender, sexual orientation, pregnancy, protected veteran status, or any other basis under the law.

  Applicants are encouraged to complete and submit the Equal Employment Identification form.

• About the company

  The Ohio State University, commonly Ohio State or OSU, is a public land-grant research university in Columbus, Ohio.

Notice