UNIV - Database Administrator I - IS Research Applications

Job Description Summary

Participates in the support of database products and applications.

Entity

Medical University of South Carolina (MUSC - Univ)

Worker Type

Employee

Worker Sub-Type​

Research Grant

Cost Center

CC005549 IS - Research Applications

Pay Rate Type

Salary

Pay Grade

University-06

Pay Range

46,655.00 - 66,488.00 - 86,321.000

Scheduled Weekly Hours

40

Work Shift

Job Description

This position is a junior level position as part of a team responsible for developing and managing the extraction, transformation and loading of data to and from electronic medical records, data repositories and other complex healthcare IT systems and solutions for research. The individual will have a basic understanding of data warehousing and/or database concepts. The position will take direction from more senior members of the team and will help them manage incoming data requests and inquiries. This position includes the ability to grow and learn advanced database concepts. The individual must handle confidential and sensitive healthcare data. HIPAA security and privacy regulations must be applied to existing and developed systems and processes.

Knowledge, Skills and Abilities: 

Proficient in SQL and using relational databases (MS-SQL, MySQL, Oracle)

Familiarity and experience with the Microsoft Azure Cloud platform
Practical experience with ETL and data integration tools (Pentaho Kettle, Microsoft SSIS).
Practical experience developing data models and marts.
Aware of common data warehouse design principles and methodologies.
Basic understanding of Linux environments and navigational skills.
Very organized, high attention to detail, able to work independently.
Strong analytical and problem-solving skills.
Strong interpersonal and communications skills (written/verbal).
Experience working with large sets of healthcare data.
Experience with XML and web services.
Experience with open-source technologies.
Experience utilizing Agile methodology for development projects.  

Job Responsibilities:

Honest Broker: Support research at MUSC by securely brokering patient data to researchers. Assist investigators in defining data requirements to support longitudinal research. Manage multiple concurrent priorities and work under the direction of senior technical staff. Ensure that HIPAA guidelines are strictly followed and that all data provided is approved by the IRB and/or the data request committee. 35%

Data Analyst: Actively contribute to project tasks such as data analysis, reporting dashboards, data integration across data sources, data ETL (extract, transform, load) design / development, and data import and export. Define and deploy DataMarts for research or quality improvement. Support database platforms in multiple environments (Windows, Linux, MS-Azure) 25%

Request Fulfillment: Active participation in data services delivery, planning, and organization – contribute to team Kanban, documentation, workflows, data dictionaries and diagrams. Provide visibility into individual and team status via recurrent communication channels. 25%

Administrative: Learning of new technologies and procedures as they become available at the organization. Assist with database administration, backups, monitoring, and optimization. Assist with migration and deployment to Microsoft Azure Cloud infrastructure. 10%

Other duties as required. 5%

Physical Requirements:

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. (