Pathology - IT Infrastructure Support & User Services

80657BR

Database Administrator

None - Not included in the union (Yale Union Group)

Full time

Regular

Administration & Operations

Manager; Program Leader (P6)

Click here to see our Wage Ranges

Computing and Information Systems

37.5

Standard (M-F equal number of hours per day)

Medical School Campus

310 Cedar Street
New Haven, CT 06510

On-site

Yale Pathology Informatics and Cancer Data Science section plays a critical role in the implementation of modern technology in Diagnostic Pathology. We are looking for a highly motivated computer technology expert to join the Infrastructure Support team as a Database Administrator. This position reports to the Manager of IT Infrastructure Support & User Services within the group.
The Database and System Administrator coordinates the planning and development of new, complex relational databases.
Job responsibilities include:
Ensures adherence to data standards across the University environment. Develops and documents database procedures and policies and resolves complex protocol deviations in existing databases. Maintains and administers database systems to ensure effective implementation and use of databases including software testing, debugging, and data quality assurance projects. Implements technical solutions including installation, configuration, and resolution of issues with multiple layers of products and technologies. Works directly with University departments to troubleshoot problems, create reports, identify and resolve technical issues. Communicates directly with staff to understand goals and solve user problems. Documents end user's experience and develops methodologies and assessment techniques that address usability goals. Provides training on database, appropriate use and facilitates user groups. Performs various coding, debugging and unit testing tasks in support of assigned projects. Assists in evaluating University business and administrative processes and needs and develops solutions to technical problems. Assists in developing and implementing database security procedures, including access authorization, logins, and permissions. Applies current programming standards and methodologies to all relevant projects and activities. May perform other duties as assigned.

Work Location: On-site

1. Coordinates the planning and development of new, complex relational databases. 2. Ensures adherence to data standards across the University environment. 3. Develops and documents database procedures and policies and resolves complex protocol deviations in existing databases. 4. Maintains and administers database systems to ensure effective implementation and use of databases including software testing, debugging, and data quality assurance projects. 5. Implements technical solutions including installation, configuration, and resolution of issues with multiple layers of products and technologies. 6. Works directly with University departments to troubleshoot problems, create reports, identify and resolve technical issues. Communicates directly with staff to understand goals and solve user problems. 7. Documents end user's experience, and develops methodologies and assessment techniques that address usability goals. 8. Provides training on database, appropriate use and facilitates user groups. 9. Performs various coding, debugging and unit testing tasks in support of assigned projects. 10. Assists in evaluating University business and administrative processes and needs and develops solutions to technical problems. 11. Assists in developing and implementing database security procedures, including access authorization, logins, and permissions. 12. Applies current programming standards and methodologies to all relevant projects and activities. 13. May perform other duties as assigned.

Bachelor's Degree in a related field and five years of related work experience or an equivalent combination of education and experience.

Proven experience maintaining and administering database systems such as Postgres, MySql, MongoDB, and Elastic stack.

Proven experience working with various scripting languages to code, debug and unit test in support of assigned projects.

Proven experience developing and implementing database security procedures, including access authorization, logins, and permissions.

Proven experience with database upgrades and migrations; ability to identify and troubleshoot technical issues.

Knowledge of cloud based technologies such as AWS or Azure.

No

No

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

Thank you for your interest in employment at Yale University. Please also note that the university has a COVID-19 vaccination and booster requirement for all students, staff & faculty which is described in the COVID-19 Vaccine Program. As you search our open positions, you will see that all postings list their on-site addresses which gives more detail on the on-campus work location of the role.

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.

University policy is committed to affirmative action under law in employment of women, minority group members, individuals with disabilities, and protected veterans. Additionally, in accordance with Yale’s Policy Against Discrimination and Harassment, and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.

Inquiries concerning Yale’s Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).

W.L. Harkness Hall, 3rd Floor, Room 303
100 Wall Street, New Haven CT 06511
203-432-0849
equity@yale.edu

Yale University is a tobacco-free campus