DESCRIPTION

The UCSD Department of Psychiatry is one of the most innovative and productive academic departments in the country, offering challenging career opportunities in the diverse areas of advanced educational programs, cutting-edge research, and state-of-the-art clinical services. The department is committed to offering a dynamic learning environment and growing opportunities to its talented and dedicated employees.

Under supervision, the incumbent will be performing research in behavioral genetics in mice, rats and humans within the Department of Psychiatry. The primary focus area of this position is within the Center for Genetic Studies on Drug Abuse in Outbred Rats (ratgenes.org). The main responsibility is to assist in database processes and routine quality control for data inputs and analysis outputs. This includes executing standardized queries for PosgreSQL database, assisting with data organization and backup.

MINIMUM QUALIFICATIONS

• Four years of related experience, education/training, OR a Bachelor's degree in related area.

• Basic knowledge of Linux, Windows, and SQL.

• Basic knowledge relating to the design and development of software. Linux-based workflow development, including Bash scripting. Experience in developing multistep analysis pipelines/workflows using scripting languages.

• Demonstrated ability to install software and troubleshoot basic problems with computing devices, peripherals and software. Basic understanding of system performance monitoring and actions that can be taken to improve or correct performance.

• Basic understanding of data management operations and database administration. Experience writing programming code, most commonly using SQL and R/ Python, to create database processes.

• Basic knowledge of computer security best practices and policies. Ability to put knowledge into practice.

• Ability to write technical documentation in a clear and concise manner.

• Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.

• Self-motivated and works independently and as part of a team. Demonstrates problem-solving skills. Able to learn effectively and meet deadlines.

• Experience in handling big data sets and experience in programming languages, including R/Python.

• Ability to program and maintain automated data collection, data quality control and data storage systems.

• Ability to report and summarize collected data and effectively present to team members.

• Ability to backup and restore data to prevent data loss.

• Ability to perform database maintenance operations for multiple projects.

PREFERRED QUALIFICATIONS

• Experience or academic courses in molecular biology, genetics, or computation biology.

• Experience in using software revision control systems (e.g. GIT).

SPECIAL CONDITIONS

• Employment is subject to a criminal background check.