University of Rochester Database Administrator, Cancer Control - 233666 in Rochester, New York
Database Administrator, Cancer Control Job ID 233666Location School of Medicine & Dentistry Full/Part Time Full-Time Favorite Job Regular/Temporary Regular Opening
Full Time 40 hours Grade 053 Surgery- Cancer ControlSchedule
8 AM-4:30 PMResponsibilities
The Database Administrator reports to the Cancer Control Research Base Lead Analyst Programmer, under general guidance and with considerable latitude for independent judgment and initiative, with projects regarding the design/maintenance/optimization of critical databases for multicenter and local research studies, web-based applications used as portals to interface with 100+ affiliated sites nationwide. The individual will analyze problems, recommend and implement modifications to improve database systems as well as program data collection and quality assurance systems and procedures. They will also supervise and mentor the activities of the IT team. Work responsibilities include: multiple database administration, Laboratory Inventory Management System administration, coordinating with multiple investigators, research/data entry team members to optimize data collection and processing.
Database administration (60%), Data collection systems (Scripting/Troubleshooting) (20%), Laboratory Inventory Management System (15%), Manuals/Documentation and other tasks as assigned (5%)
Confers with Lead Analyst Programmer to assess and design complex data collection systems for multicenter and local clinical trials. Design, manage, secure and maintain databases for various projects; troubleshoot and resolve data issues.
Consults with users to assess data preparation, program design, and testing. Offers solutions/suggestions to provide optimum efficiency and implement them
Develops and tests user roles, access, and configuration. Design, maintain and monitor audit trail systems.
Provides consultation support on the application(s) and instructs groups on such applications and systems.
Programs difficult and complex parts of application systems. Enforces standard program change policies and procedures, reviews test results, and insures that documentation is kept current and complete.
Biospecimen tracking system: Using Freezerworks, design implement and maintain solution to track thousands of biospecimen samples for multiple nationwide and local studies, create interfaces for efficient end-user interaction with records. Integrate with other systems (Biospecimen automatic strawing system, biospecimen testing systems)
Coordinates and instructs the testing/troubleshooting of data collection systems with the Analyst/Programmer Jr, Tech support specialist and data entry team.
Works in concert with the rest of the IT team (Web Designer - Analyst Programmer Jr. and Information Technology Specialist)
Oversees the use of Cardiff Teleform (paper questionnaires) by the Tech Support Specialist to create and implement various local and NCORP Cancer studies. Work with Researchers to make sure study successfully implements forms. Troubleshoot and fix problems with the system as they arise. Work with APJ/ BasicScript/ SQL code to manipulate electronically stored data.
Design user-friendly graphical interfaces for data management team to interact with SQL server databases and implement complex queries, forms and reports for multiple projects using Microsoft Access and SQL.
Design, maintain and the Electronic Query System used to track and insure timely data submission.
Consult, and take the lead, with biostatistician to interpret statistical analyses, prepare and disseminate reports based on analyses for several projects at a time.
Keep abreast of trends as they relate to the computer field by self-study, participating in online trainings/courses, in order to enhance personal development and strengthen skills necessary for constantly evolving responsibilities.
Attend and assist in the organization of the annual 2-day Research Base meeting.
Performs other related duties as required, including presentation of seminars, courses, and instruction on computer services as required.
Bachelor's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering, and 2-3 years of related experience; or an equivalent combination of education and experience.
Excellent communication, organizational skills, attention to detail and problem-solving skills are highly essential.
Ability to handle several projects simultaneously, prioritize and shift priorities quickly.
Ability to demonstrate flexibility, initiative, creativity, and a willingness to work in an evolving technological environment.
Knowledge of the following:
Database Administration: SQL server, PHPMyAdmin/MySQL, MS Access, MongoDB
MS Office (Access, Excel, PowerPoint)
Operating systems: Windows 10, MacOS, Linux
Computer hardware/software Installation, maintenance and troubleshooting expertise
How To Apply
All applicants must apply online.
EOE Minorities/Females/Protected Veterans/Disabled