Consider a career with one of the nation’s most prestigious Universities! Health Sciences Technology (HST) at the University of Minnesota is currently hiring for a Database Developer. HST is responsible for supporting the University’s clinical research staff working on life changing medical research. We offer work-life balance, competitive benefits, professional development, and a commitment to inclusion and collaboration. The Database Developer will be part of a dynamic team that maintains a clinical data repository (CDR) used for clinical research activities at the University of Minnesota. The individual will work closely with other DBAs, Clinical Data Analysts and Project Managers to provide expertise on data collection, extraction and delivery. Ideal candidates will
University paid contribution (10% of your salary) to your retirement account - vested immediately.
22 paid vacation days per year, in addition to sick leave and 11 paid holidays.
Reduced tuition opportunities covering 75% - 100% of eligible tuition.
Excellent and affordable health care benefits.
Wellness program with opportunity to earn lower health care rates.
Free disability insurance.
Annual merit increase program.
Database Development 60%
Interact with other technical team members to analyze source system data to understand the data structure, definitions and anomalies.
Developing and optimizing SQL statements, stored procedures and views using industry best practices for security and efficiency.
Mentoring colleagues in the writing and optimizing of SQL queries.
Performance optimization, including query tuning, process structuring/scheduling, schema adjustments, code refinements, and scaling analysis.
Perform extract, transformation and load (ETL) functions.?
Application Development / Support 20%
Develop internal web applications to interact with and manage large databases and systems.
Implement and support enterprise level research applications.
Systems Support and Maintenance 20%
Develop and maintain technical design documents.
Assist in the research and selection of tools, products, and frameworks as necessary to support business initiatives.
Support existing applications and databases and serve as a resource for customer questions and problem resolution.
Monitor systems to ensure research applications and databases are running at peak performance.
Remediate failures of automated jobs quickly.
Bachelor’s degree in a related field and 2 years of relevant experience, or a comparable combination of education, experience, and/or training.
Experience working with a major relational data management system. (e.g. Oracle, MS SQL Server)
Experience working with ETL tools. (e.g. Pentaho, SQL Server Integration Services, and / or IBM Data Stage).
Experience in systems design and administration.
Previous experience in the design and maintenance of database systems.
Familiar with source control tools, such as Git, and continuous integration systems (Jenkins).
Internal Number: 326554
About University of Minnesota, Twin Cities
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.