UNIV - Database Administrator II - Department of PHS

UNIV - Database Administrator II - Department of PHS page is loaded## UNIV - Database Administrator II - Department of PHSlocations:
Charleston time type:
Full time posted on:
Posted Yesterday job requisition :
R
- ** Job Description Summary
** Implements changes to and maintains Common Data Models (CDMs) for a variety of research purposes across the department. Works with other organizations to obtain the data required to populate the CDMs as well as write and maintain Extract, Transform and Load (ETL) scripts for the CDMs. Partners closely with Project Management (PM) teams across MUSC to gather data requirements for new research projects.

Analyzes and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops, implements, and oversees policies and procedures to ensure the integrity and availability of databases and their accompanying software. Assists in developing and implementing long term data management plans. This position will also handle incoming requests for research data queries.
** Entity
* * Medical University of South Carolina (MUSC - Univ)
** Worker Type
** Employee
* * Worker Sub-Type
** Research Grant
** Cost Center
** CC000955 COM Biomedical Informatics Center CC
** Pay Rate Type
** Salary
* * Pay Grade
** University-07
** Pay Range
** 57,334.

- ** Scheduled Weekly Hours
** 40
* * Work Shift
**** Job Description
***
* Job Description:

** Implements changes to and maintains Common Data Models (CDMs) for a variety of research purposes across the department. Works with other organizations to obtain the data required to populate the CDMs as well as write and maintain Extract, Transform and Load (ETL) scripts for the CDMs. Partners closely with Project Management (PM) teams across MUSC to gather data requirements for new research projects.

Analyzes and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops, implements, and oversees policies and procedures to ensure the integrity and availability of databases and their accompanying software. Assists in developing and implementing long term data management plans. This position will also handle incoming requests for research data queries.
*
* Job Duties:

** 35% Data analyst tasks working on developing SQL for research data requests (serving as a data honest broker), which include developing and running queries and verifying results for research projects.
30% ETL Development:
Evaluate ETL (Extract, Transform, Load) tools/solutions as database sizes grow to include more data and different data types. Maintain, modify existing, and/or develop new ETL to support our projects.
10% Gathering data requirements for new and existing funded studies and working with various data owners to determine sources of needed data.
10% Evaluating products, working on committees and attending meetings.
15% Working on other data-driven research projects, which may include machine learning, natural language processing and other artificial intelligence projects.
** Additional

Job Description
*
* Minimum Requirements:

A bachelor's degree in computer science, information systems or a related field and three (3) years experience in systems development and maintenance, technical support or the support of complex database management systems.

Physical Requirements:

(

Note:

The following descriptions are applicable to this section: Continuous - 6-8 hours per shift; Frequent - 2-6 hours per shift; Infrequent - 0-2 hours per shift) Ability to perform job functions in an upright position. (Frequent) Ability to perform job functions in a seated position. (Frequent) Ability to perform job functions while walking/mobile. (Frequent) Ability to work indoors. (Continuous) Ability to work in confined/cramped spaces.

(Infrequent) Ability to bend at the waist. (Frequent) Ability to fully use both hands/arms. (Continuous) Ability to perform repetitive motions with hands/wrists/elbows and shoulders. (Frequent) Ability to reach in all directions. (Frequent) Possess good finger dexterity. (Continuous) Ability to maintain tactile sensory functions. (Continuous) Ability to lift, lower, push or pull objects 15 lbs. or more, unassisted. (Infrequent) Ability to maintain 20/40 vision, corrected.

(Continuous) Ability to see and recognize objects close at hand. (Continuous) Ability to see and recognize objects at a distance. (Continuous) Ability to match or discriminate between colors. (Continuous) Ability to determine distance/relationship between objects; depth perception. (Continuous) Good peripheral vision capabilities. (Continuous) Ability to hear and/or understand conversations. (Continuous) Ability to perform gross motor functions with frequent fine motor movements.

(Continuous) Ability to work in dusty areas. (Infrequent)
* If you like working with energetic enthusiastic individuals, you will enjoy your career with us!
* The…