Student Tech Support Services

About the Job

Position Summary

The Department of American Indian Studies at the University of Minnesota is seeking a temporary student SQL Programmer for the Ojibwe People’s Dictionary ().

This is an online, searchable, talking dictionary that reaches 50,000 - 60,000 monthly visitors including scholars, Ojibwe community members, and the Minnesota public who benefit from this heritage language.

This position supports a one-year project grant focused on enhancing public access, streamlining and speeding the editorial workflow, and creating a new avenue for community-engagement.

A successful candidate will bring development capabilities to best support the design, implementation of design, and migration of data to a MySQL database that will allow the Ojibwe People’s Dictionary to improve access and services to the dictionary.

Demonstrable experience with structured query language (SQL) is necessary. The candidate needs to understand these aspects of SQL : data definition language (DDL), data manipulation language (DML), and data query language (DQL) is required for this project.

This project was made possible in part by the people of Minnesota through a grant funded by an appropriation to the Minnesota Historical Society from the Minnesota Arts and Cultural Heritage Fund.

Job Responsibilities

The student SQL programmer will be responsible for writing SQL using DDL, DML, and DQL to create and interact with a new database in a MySQL environment.

The programmer will write SQL scripts to migrate data from the existing database into the newly designed database by reading and following detailed instructions (e.

g. software requirements document, database design document) to properly map old data to new tables. The programmer will work with existing staff, other student programmers and UMN systems to create and configure the database to support the larger project and will respond to testing feedback and ensure completeness of project technical documentation.

Qualifications

About the Department

The Department of American Indian Studies at the University of Minnesota strives to cultivate Native leaders

and allies by providing a critical and comprehensive education in the field of Native American and Indigenous

Studies. American Indian Studies majors receive training in contemporary Native literary and artistic

expression, legal and political issues, and historical experiences.

This critical and comprehensive education prepares our students to pursue a multitude of career paths in policy,

education, community development, as well as cutting edge graduate programs. Our nationally-renowned

faculty are committed to challenging conventional academic approaches while also giving students strong

backgrounds in in critical areas of policy, law, history, social theory, education, literary criticism, film, and

environmental studies. All of this is complemented by a thriving Native community on campus, in the Twin

Cities, and throughout the state of Minnesota.

Benefits

Working at the University

At the University of Minnesota, you’ll find a flexible work environment and supportive colleagues who are interested in lifelong learning.

We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work.

The University also offers a comprehensive benefits package that includes :

• Competitive wages, paid holidays, and generous time off
• Continuous learning opportunities through professional training and degree-seeking programs supported by the
• Low-cost medical, dental, and pharmacy plans
• Healthcare and dependent care flexible spending accounts
• University HSA contributions
• Disability and employer-paid life insurance
• Employee wellbeing program
• Excellent retirement plans with employer contribution
• Public Service Loan Forgiveness (PSLF)
• Financial counseling services
• Employee Assistance Program with eight sessions of counseling at no cost
• with free or reduced rates in the Twin Cities metro area
30+ days ago