Location: Albany, NY Category: Research Foundation Posted On: Tue Jul 30 2024 Job Description:

Title: Database Administrator II

Unit: Environmental Biology

Salary Range: $58,459 - $63,000/annual; commensurate with experience

Duration: through March 31, 2027

Location: Albany, NY (in New York State DEC Headquarters)

Brief Description of Duties: This position will be embedded with the New York State DEC Bureau of Wildlife (BoW) in their Albany headquarters and function to maintain the overall integrity and quality of various databases associated with statewide and regional game harvest surveys, wildlife population monitoring, wildlife conflict monitoring and permit issuance, hunter education program, and research activities that are integral to New York's wildlife management programs. The position involves the development, maintenance, and enhancement of data sets derived from various harvest reports, population and user surveys, and registration systems. Because data may be entered by various sources and/or individuals, standard operating procedures for data review, correction and editing must be developed and enforced to ensure accuracy and validity. Duties include development and testing of scannable forms, development and maintenance of ESRI Survey123 forms and visualization of resulting data, development and maintenance of MS Access relational databases, and modernization of data storage. Duties also include data stream mapping to identify efficiencies and enhancements. The position will serve the needs of both the Game Management Section and Wildlife Diversity Section, and the incumbent will work closely with a SUNY-ESF biostatistician based at DEC in Albany, in support of his/her work.

Primary responsibilities include, but are not limited to:

• Create, manipulate, and maintain MS Access and ESRI Survey123 databases associated with various wildlife harvest surveys, population monitoring programs, hunter education programs, and research.

• Design, configure, deploy, and support scannable forms using Teleform software to streamline data entry from various user surveys and other data sources.

• Maintain and update computer programs used to analyze game harvest and survey data and help identify and correct sources of errors that occur in telephone, internet and scannable form reporting systems.

• Provide data visualization products, user-friendly reports, and perform standardized and ad-hoc queries from the above databases as needed for management or public information purposes.

• Provide oversight, training, and troubleshooting for mobile data collection processes of BoW and serve as a technical expert in Survey123 form development and data organization.

• Work with program staff to assess and optimize data collection processes and data flows.

• Communicate directly with software and hardware vendor support services to resolve issues that require immediate attention and advocate for fixes/patches/updates to applications when appropriate.

• Identify and help resolve database related issues and provide back up and data recovery services. Work with the DEC "help desk" as needed to assist other BOW staff experiencing database related problems.

• Provide support and training for BOW staff in the use of data collection applications, including orientation for technical and clerical staff, specialized training in response to program upgrades and data quality assurance and validation procedures.

  Job Requirements:

Required Qualifications:

• Bachelor degree in data science, database management, computer science, or related subjects.

• Professional experience creating and manipulating large databases using MS Access or similar software packages.

• Experience creating ESRI Survey123 and Survey123 Connect forms and using ArcGIS and QGIS to automate data visualization.

• Experience with programming or editing code in MS Access, Excel, and R.

• Demonstrated ability to manipulate databases efficiently and resolve problems effectively.

• Strong interpersonal skills, including ability to establish and maintain satisfactory working relationships and collaborate with diverse personalities on project teams.

Preferred Qualifications:

• Education and experience with natural resources or environmental sciences.

• Working knowledge of State or Federal wildlife agency management programs.

• Familiarity with wildlife surveys and the management of biological field data.

• Experience developing, optimizing and verifying scannable forms.

• Experience mapping and optimizing data flows.

• Experience with programming or editing code in SQL, Visual Basic, Oracle, Program R, Python or other software languages.

• Experience with ArcGIS Online products, including Field Maps, Collector, and Dashboards.

• Experience building web applications with R-Shiny.

  Additional Information:

In accordance with the "Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act" institutions of higher education are required to prepare an annual report containing information on campus security policies and campus statistics. This report includes statistics for the previous three years concerning reported crimes that occurred on-campus; in certain off-campus buildings or property owned or controlled by SUNY-ESF; and on property within, or immediately adjacent to and accessible from the campus. The report also includes institutional policies concerning campus security, such as policies concerning sexual assault, and other matters. You can obtain a printed copy of this report by contacting SUNY-ESF University Police at 315-470-6667 or by accessing the following web site: https://www.esf.edu/safety/annual-security-reports.php

SUNY ESF is a Smoke and Tobacco Free campus and is dedicated to providing a healthy and safe environment for the entire campus. For more information you can visit our Tobacco and Smoke Free Policy https://www.esf.edu/employees/policies/policy-smoking.php

As an Equal Opportunity / Affirmative Action Employer, The Research Foundation for SUNY will not discriminate in its employment practices due to an applicant's race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender identity or expression, transgender status, age, national origin, marital status, citizenship, physical and mental disability, criminal record, genetic information, predisposition or carrier status, status with respect to receiving public assistance, domestic violence victim status, a disabled, special, recently separated, active duty wartime, campaign badge, Armed Forces service medal veteran, or any other characteristics protected under applicable law.

The Research Foundation for The State University of New York offers exceptional benefits such as healthcare, dental, vision, pension plans, competitive pay, generous paid time off, life insurance and long-term disability insurance.

The Research Foundation for the State University of New York is not an agency or instrumentality of the State of New York. Employees of the Research Foundation for the State University of New York are not state employees, do not participate in any state retirement system, and do not receive state fringe benefits. The Research Foundation for the State University of New York operates under a contract with The State University of New York and receives no directly appropriate state funding.