Database /API Designer

Posting Details

Posting Information Posting Number PG193476EP Internal Recruitment No Working Title Database / API Designer Anticipated Hiring Range Commensurate with experience ($110,000 - 125,000) Work Schedule Monday-Friday, 8AM-5PM Job Location Athens, GA Department Crop and Soil Sciences About the Department 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, , 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 () 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, , 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 Recruitment Dates and Special Instructions Job Open Date 06 / 21 / 2024 Anticipated Close Date Open until filled Special Instructions to Applicants Please attach a Cover Letter, resume / CV, and contact information for at least three professional references.

Position Details Position Number 00110879 Position Type EHRA Non-Faculty Full Time Equivalent (FTE) (1.0 40 hours / week) 1.

00 Appointment 12 Month Recurring Mandatory Designation - Adverse Weather Non Mandatory - Adverse Weather Mandatory Designation - Emergency Events Non Mandatory - Emergency Event Department ID 110901 - Crop and Soil Sciences AA / EEO NC State University is an equal opportunity and affirmative action employer.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, gender identity, age, sexual orientation, genetic information, status as an individual with a disability, or status as a protected veteran.

Individuals with disabilities requiring disability-related accommodations in the application and interview process are welcome to contact to speak with a representative at the Office of Institutional Equity and Diversity.

If you have general questions