SDSU Research Foundation

  • Webserver Administrator/Database Manager

    Req No.
    2018-8195
    Category
    Research/Project
    Type
    Full-Time Contract
    Salary
    $33.46/hour
    Dept/Proj Name
    Electrical & Computer Engineering
    Close Date
    1/7/2019
  • Overview

    FUNCTION OF THE UNIT
    The goals of the SDSU HealthLINK Center for Transdisciplinary Health Disparities Research are to enhance capacity and improve infrastructure at SDSU, and its partner organizations, to advance minority health and health disparities research among racially/ethnically diverse, sexual and gender minority, and lower-income populations using a community-engaged transdisciplinary research approach. The Center includes 23 tenured/tenure-track faculty and represents four colleges at SDSU. The Center will bring together existing infrastructure support and researchers from diverse yet overlapping disciplines to develop a Research Infrastructure Core (RIC), which will offer a wide range of research services. The RIC will house expertise in using wireless technology (e.g., personal and ambient sensors) and big data (e.g., electronic health record, ecological momentary assessment, US Census) to refine intervention approaches to increase their effects. A Health Data Analytic Portal and a Health Science Knowledge Repository will be created for the RIC that provides easy access to state-of-the art analytic tools and resources to support transdisciplinary research.

     

    PURPOSE OF THE POSITION
    The Webserver Administrator/Database Manager will create the Health Data Analytic Portal and Health Science Knowledge Repository under the direction of and in collaboration with Drs. Tsou and Castillo, applying the user-centered design process with SDSU researchers to ensure the usability and accessibility of both the Health Data Analytic Portal and Health Science Knowledge Repository. Additionally, the Webserver Administrator/Database Manager will maintain both the Health Science Knowledge Repository and the Health Data Analytic Portal. This person will work closely with Drs. Tsou, Castillo, Wells, and Ayala and the Center’s Administrative Director and Center Research Manager to design the framework of the Center’s website which will be housed in the Health Science Knowledge Repository. Once developed, this person will provide technical support to maintain the website. The Webserver Administrator/Database Manager will be responsible for creating and maintaining interfaces on the repository for the SDSU community, Community Engagement Core (CEC) partners, and the general public to access: the profiles of investigators; profiles of minority health and health disparities research at SDSU; archives of the Center’s workshops and seminars; webinars and online training materials; recharge service price list and request forms (e.g., for focus group development, data analysis, data storage, etc.). The Webserver Administrator/Database Manager will establish systems so that Center personnel can easily archive many other resources for use by other SDSU researchers and CEC community partners in the Health Science Knowledge Repository, including: project research updates, technical reports, lab protocols, surveys, analytic code, EMA templates, data models, and publications. The Webserver Administrator/Database Manager will create and maintain the database for the Center’s evaluation conducted by the investigators and staff on the Administrative Core. Finally, the Webserver Administrator/Database Manager will work with Drs. Tsou and Castillo and with the Data Analyst to develop the systems and protocols to interface with the Health Data Analytic Portal to extract data for use by Research Projects (RPs), Pilot Projects (PPs), and other researchers.

    Responsibilities

    The Webserver Administrator/Database Manager is responsible for but not limited to:

     

    The Webserver Administrator Responsibility 40%

     

    • Windows server and Amazon EC2 server administration.
    • Create and maintain the Center’s website (using a web content management system with customized functions)
    • Create and maintain the Health Science Knowledge Repository (using a web-based knowledge management tool) for archiving project updates, technical reports, lab protocols, surveys, analytic code, EMA templates, data models, and publications.
    • Build searchable SDSU investigator profiles and related health disparities research project profiles at SDSU.
    • Archive and update the Center’s workshops and seminar materials, webinars, and online training materials.
    • Create and update a recharge service price list and web-based request forms (e.g., for focus group development, data analysis, data storage, etc.).
    • Create and maintain comprehensive technical documents for maintaining and customizing the Center’s website and the Health Science Knowledge Repository.
    • Test and evaluate the usability and accessibility of the Knowledge Repository and the Center’s website.
    • Collaborate with other campus technical staff to coordinate application integration with identity management systems (SDSU-ID) for SDSU researchers.  
    • Work with IT staff to manage applications, upgrades, third-party application software, and application security, including detection and prevention.
    • Work with IT staff to apply security patches and update software tools and applications as necessary to ensure secure and optimal server performance.
    • Work with IT staff to troubleshoot applications, including investigation and resolution of reported server problems.

     

    The Database Manager Responsibility 40%

     

    • Responsible for the design, implementation, security, and management of the Health Data Analytic Portal with four components (including a HIPAA compliant Data Center, an Open Data Center, Data Integration Toolboxes and Mobile Apps, and Data Analytics and Visualization Toolboxes).
    • Create and maintain the HIPAA compliant Data Center and an Open Data Center for RPs and PPs.
    • Create and maintain the database for the Center’s evaluation conducted by the investigators and staff in the Administrative Core
    • Design web-based user interfaces for extracting data from Data Centers for use by RPs, PPs, and other researchers.
    • Assist the design and implementation of health data visualization and analytics tools inside the Analytic Portal.
    • Create and maintain technical documents for maintaining and customizing the Data Analytic Portal.
    • Test and evaluate usability and accessibility of the Health Data Analytics Portal.
    • Apply security patches and update software tools and applications as necessary to ensure secure and optimal database performance.
    • Troubleshoot applications, including investigation and resolution of reported database problems.

     

    Assist RPs and PPs in the Center 20%

    • Assist the development of data analytic tools for the RPs and PPs.
    • Assist in the data collection and data integration tasks using the Health Data Analytics Portal for the RPs and PPs.

    Qualifications

    • Strong web programming skills in JavaScripts (JQuery, D3.js, NodeJS), HTML5, and Python.
    • Strong database skills in SQL, MongoDB, and PostgreSQL.
    • Knowledge of Windows web server operating systems.
    • Comprehensive knowledge of the application of a user-center design approach for website development.
    • Strong verbal and written communication skills, including ability to adapt messages for both technical and non-technical audiences. 
    • Ability to cultivate working relationships at all levels of an organization, including with PI's, Co-leads, project staff, and students.
    • Highly motivated self-starter and self-learner, with a high energy level and strong interpersonal skills.
    • Well organized, ability to meet deadlines, detail oriented, possesses good judgement and common sense.
    • Skilled in record keeping and quality control.
    • Ability to work flexible hours including nights and weekends for required maintenance and testing.
    • Demonstrate a high level of cross-cultural sensitivity.

     

    Minimum Experience and Education

    • Bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience.
    • Working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques.

    Preferred Qualification

    • Bilingual (English/Spanish)

     

    A background check (including a criminal records check) must be completed satisfactorily before any candidate can be offered a position with SDSU Research Foundation

     

    San Diego State University Research Foundation is an EEO/AA/Disability/Vets Employer

     

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed