Database Specialist II

Cherokee Nation Systems Solutions (CNSS) provides a complete line of innovative services, consulting and products to government agencies, including application modernization, data utilization and advanced analytics, geospatial, GIS and remote sensing, information technology infrastructure, program professional services and scientific and research capabilities. CNSS offers an extensive selection of quality services and products at competitive prices. Additionally, CNSS collaborates with partners nationwide to provide the most complex services to clients.

For more information, visit our site at www.cherokee-federal.com

The Database Specialist II will support our federal clients and partners in their efforts supporting the Greater Everglades Ecological Research Program, engage in field-oriented research on populations of wetland faunal communities and their habitats.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Candidate should be a capable Database Specialist able to modify an existing PostgreSQL/PostGIS geospatial database that contains wildlife data for long-term storage and efficient retrieval of American Crocodile data.

We are seeking a team member to work directly with federal scientists, and the project managers to modify this database and the associated front-end (web-based) tools for data entry and access. The position will also work collaboratively with university scientists and natural resource managers.

• Modify existing wildlife database structure to support a spatial crocodile database on a secure server
• The will also compiling and publishing research of inherent scientific merit, contributing to knowledge of the life history, ecology, and systematics of Greater Everglades vertebrates.
• Such research is also of significance to the conservation and management of living vertebrate resources, particularly on behalf of partner DOI bureaus.
• Modify existing wildlife database structure to support front-end access tools for non-experts (biologists and natural resource managers)
• Integrate existing environmental data with crocodile data to facilitate spatial analyses
• Adopt an existing workflow for managing and updating the database
• Train, mentor, and learn from other team members on technical topics
• Fully document the database design, functionality, and security

• All data integrated into new SQL database
• Recreation of queries and scripts for QA/QC purposes
• Recreation of queries and scripts for research question-specific queries (e.g., capture-mark-recapture analyses)
• Database construction done with reporting as scheduled
• Intermediate and final summaries on schedule
• A monthly report describing the progress and status of work

SUPERVISORY/MANAGEMENT AUTHORITY

N/A. Will defer to the CNSS Program Manager and CNT Site Lead, may coordinate with client representative (Task Order Manager)

EDUCATION and/or EXPERIENCE

A relevant undergraduate degree will be preferred.

KNOWLEDGE, SKILLS AND ABILITIES

Use of custom SQL database and proficiency with pgAdmin, R, and RStudio is required. Experience with Shiny app is preferred.

Required expertise/skills:

• Experience utilizing enterprise-level geospatial database systems, particularly in PostgreSQL/PostGIS
• Experience working with spatial data and map products in ESRI ArcGIS or QGIS
• Experience utilizing web-based front-ends for data entry and querying
• Experience collaborating with data analysts or scientists
  

Preferred skills:

• • Experience migrating legacy data from flat spreadsheets to relational databases
  • Experience leveraging open data sources and mapping tools
  • Familiarity with remotely sensed data
  • Familiarity with preparing data for quantitative analyses using R
  • Familiarity with geography, natural resources, or spatial ecology
    

WORK ENVIRONMENT

Office and/or teleworking environment. Some overnight travel will be required. A driver's license will be required for local travel

About Cherokee Federal
Cherokee Federal – a division of Cherokee Nation Businesses – is a team of tribally owned federal contracting companies focused on building solutions, solving complex challenges, and serving the nation's mission around the globe for more than 60 federal clients. Our team of companies manages nearly 1,000 projects of all sizes across the construction, consulting, engineering and manufacturing, health, and technology portfolios.

Since 2012, the Cherokee Federal team of companies has won more than $5 billion in government contracts. Our 3,000+ employees work in 26 countries, 50 states and 2 U.S. territories.

Why choose Cherokee Federal? Visit our website and learn about the great reasons to join our team. cherokee-federal.com

Compliance

Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information.

We are an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected Veteran status, gender identity and sexual orientation. If you'd like more information about your EEO rights as an applicant under the law, please copy and paste the links to the following two sites: EEO Statement | EEO Poster ; https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf and https://www.dol.gov/ofccp/regs/compliance/posters/pdf/ofccp_eeo_supplement_final_jrf_qa_508c.pdf

If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may e-mail CNB.Compliance@cn-bus.com for assistance. This email address is for accommodation requests only and cannot be used to inquire about the application process or status.

For Pay Transparency Non Discrimination provision, please copy and paste the following link: Pay Transparency Nondiscrimination Provision ; https://www.dol.gov/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf

We maintain an Affirmative Action Plan for proactively seeking employment and advancement for qualified protected veterans and individuals with disabilities. Upon request, we will schedule time to make our Affirmative Action Plan accessible. If you are interested, please submit a written request with the email subject line: 2020 Request to View Affirmative Action Plan to the Compliance Administrator at "Compliance@cn-bus.com" This email box is not for resumes or follow up on job applications.

#CNSS

The Database Specialist II will support our federal clients and partners in their efforts supporting the Greater Everglades Ecological Research Program, engage in field-oriented research on populations of wetland faunal communities and their habitats.