IT Database Admin Analyst II - 20482

The Idaho Department of Fish and Game is seeking an IT Database Admin Analyst II. This position is within our Technical Services Bureau. The successful incumbent will be stationed at our Headquarters office situated adjacent to the Boise Greenbelt, the MK Nature Center, and Kristin Armstrong Municipal Park in Boise. 

Why IDFG? We are committed to creativity, innovation, and excellence as we cultivate opportunities for our customers to engage with our natural resources and become resource stewards for future generations. We are highly dedicated to our mission, committed to our team, and we know how to balance work/life commitments while loving the work we do.

What We Offer: 

• Excellent medical, dental, and vision insurance - employee only coverage for PPO $70.74/month for medical and vision & $12.08/month for dental
• Participation in one of the Nation's best state retirement systems
• Generous vacation and sick leave accrual that begins as soon as you start (accumulate approximately 3 weeks of vacation the first year, and increasing with state longevity)
• Eleven paid holidays in a year
• Eight weeks of Paid Parental Leave
• Multiple optional saving plans - 401k and 457 plans 
• Group Life Insurance/Disability Insurance/Supplemental Life Insurance - state provided basic life insurance coverage and affordable supplemental plans 
• Public Sector Student Loan Forgiveness (eligibility requirements may apply)
• Employee Assistance Program - confidential support, information, and resources for all of life's challenges
• State and Department Wellness Programs 
• Ongoing training opportunities 
• Potential flexible work schedule  

Responsibilities: 

• Administers and manages new or existing databases within production SQL Server including user permissions, maintenance of data dictionaries/documentation, monitor data usage, automate data processes and data transformation methods. The administration of databases will require the incumbent to build upon existing and establish new governance frameworks to ensure data are captured efficiently and accurately while adhering to data management standards.
•  Interacts directly with partners to gather data requirements and then redesign existing or design new databases and data products based on business needs.
•  Participates in the evaluation and selection of database technologies to fulfill business requirements.
• Plans and tests database upgrades for compatibility, forecasts storage and infrastructure needs. Analyzes and optimizes data usage and reporting to accommodate stakeholder digital data capture needs. Configures and supports SqlServer requirements tied to the ArcGIS Enterprise platform. 

Minimum Qualifications: (All qualifications listed below are required. To be considered for this position, applicants must meet the minimum experience and/or education standards as outlined in each of the typical qualification guidelines. A detailed resume or work history must be submitted, clearly demonstrating/supporting how you meet each requirement. This information is essential to our initial evaluation process. Incomplete applications or those lacking relevant details may not be considered for further review.)

• Good knowledge of relational database principles and data normalization. (Typically gained by obtaining an associate's degree or certification related to relational database concepts and data normalization OR at least one year of full-time work experience (including combination of work experience and internships) regularly working with and supporting relational databases as part of your primary job responsibilities.)
• Good knowledge of Structured Query Language (SQL). (Typically gained by current certification related to Structured Query Language (SQL) design or administration AND at least one year of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities OR at least two years of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities.)
• Experience installing, administering, and monitoring production databases and database servers. (Typically gained through at least one year of full-time work experience (including combination of work experience and internships) installing, administering and monitoring production databases and database servers as part of your primary job responsibilities.)
• Experience technically interacting directly with clients to analyze customer needs. (Typically gained by at least one year of full-time work experience (including combination of work experience and internships) interacting with clients to analyze customer needs as part of your primary job responsibilities.)

The ideal candidate is a detail-oriented and motivated mid-level database administrator with a working knowledge of SqlServer, geographic information systems software (particularly the ESRI suite), Python, RStudio, and Shiny. A background in and passion for biological and environmental science is an added plus. Strong communication and collaboration skills coupled with emotional intelligence will enable them to work effectively with their internal and external stakeholders. This candidate should be committed to continuous improvement, receptive to feedback, and able to establish and follow data standards and procedures aligned with Information Technology Infrastructure Library (ITIL) principles. Additional consideration may be given at the time of interview to candidates who have this training and/or experience. Please be sure to include within your application material any training and/or experience you may have.