Database /Api Designer

The Precision Sustainable Agriculture program is a network of researchers across the country collaborating to develop integrated knowledge-intensive sustainable agriculture practices into a precision framework to maximize farm productivity, and sustainability through the use of an information ecology that connects farms, data, tools, and people for optimal, real-time decision making. The PSA program is housed within the Department of Crop and Soil Sciences which encompasses diverse disciplines in research extension and teaching.

The department's mission is to develop future leaders in crop, soil, and environmental sciences, improve crop plants and products, devise effective and sustainable crop production systems, devise effective and sustainable soil management techniques in both agriculture and urban settings; and disseminate crop, soil, and environmental science knowledge for the benefit of users and producers of food, feed turf, biofuels and fiber in North Carolina, the nation, and the world.

Essential Job Duties

This position will focus on overhauling the back end of current apps, designing a centralized database for storing user interactions between apps, and creating an API to interact with the centralized databases.

Primary duties include but are not limited to the following:

• Set up CI/CD for React, Node.js, Python, etc. applications hosted on various Azure services (App Service Plans, Virtual Machines, Functions).

• Develop new APIs using modern frameworks to interact with various databases.

• Create testing pipelines using Github actions and/or Jenkins.

• Create pipelines to roll out data releases from Airtable (a database spreadsheet hybrid we use to have experts easily edit data) into a more traditional database.

• Present the pros and cons of different solutions to our development team.

• Other projects as assigned.

This position is stationed in Athens, Georgia, and the duty station is the University of Georgia.

You Belong Here! At NC State, our goal is for all employees to reach their fullest potential at work. As you consider this opportunity, we encourage you to review our Employee Value Proposition (https://news.hr.ncsu.edu/you-belong-here/) and learn more about what makes NC State the best place to learn and work for everyone.

Other Responsibilities

• Other duties as assigned

Qualifications

Minimum Education and Experience

• BS and 4+ years experience or MS with 2 years experience or 5+ years directly related experience converting existing hosted databases.

• Experience developing APIs.

Other Required Qualifications

• Strong proficiency with PostgreSQL/MongoDB, Node.js.Python, Linux, Bash/shell scripts, Azure services, Github actions, Jenkins.

Preferred Qualifications

• 3 + years of directly related experience

Required License(s) or Certification(s)

n/a

Valid NC Driver's License required No Commercial Driver's License required No