API/Database Designer

Posting Number : PG193111EP

PG193111EP

Internal Recruitment :

Working Title :

API / Database Designer

Anticipated Hiring Range :

$110,000 - 125,000

Work Schedule :

Monday-Friday, 8 AM-5 PM

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.

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

The incumbent will be stationed in Beltsville, Maryland, or Raleigh, North Carolina. The incumbent must relocate to one of these locations based on business needs.

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.

Minimum Education and Experience :

• MS with 2 years experience, BS with 4+ years experience, or 6 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 directly related experience

Required License(s) or Certification(s) :

N / A

Valid NC Driver's License required :

Commercial Driver's License required :

Job Open Date : 12 / 21 / 2023

12 / 21 / 2023

Anticipated Close Date :

Open until filled.

Special Instructions to Applicants :

Please attach a Cover Letter, resume / CV, and contact information for three (3) professional references.

Position Number : 00110555

00110555

Position Type : EHRA Non-Faculty

EHRA Non-Faculty

Full Time Equivalent (FTE) (1.0 40 hours / week) :

Appointment : 12 Month Recurring

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 919-515-3148 to speak with a representative at the Office of Institutional Equity and Diversity.

If you have general questions about the application process, you may contact Human Resources at (919) 515-2135 or workatncstate@ncsu.edu .

Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks.

Degree(s) must be obtained prior to start date in order to meet qualifications and receive credit.

NC State University participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.