State of Idaho
IT Database Analyst 2
State of Idaho, Boise, Idaho, United States, 83708
Description
Career Opportunity
The Idaho State Tax Commission is seeking a database analyst 2 with solid skills in database design and maintenance to join our Property Tax team. This role may be perfect for you if you enjoy organizing and make sense of collections of information to create functional database systems. The successful candidate will be well-versed in database design, installation, and maintenance with a background in programming. Candidates should have strong problem solving and decision-making skills and be willing to troubleshoot problems and new requirements and offer solutions. The position is in the Boise Office in the Chinden Campus, 11321 West Chinden Blvd, Building 2. Applications will be accepted until a qualified candidate is selected. Minimum salary is $37.68 per hour, rate of pay will depend on qualifications and experience.
Responsibilities:
Interact with internal staff, various county staff, and third-party vendorsDesign databases and data access methods for softwareSQL Server supportIIS SupportMaintain the data dictionaryMonitor and optimize database usageAdminister and manage databases in production environmentsApply software releases/patches in countiesPlan for database upgrades and forecast storage and infrastructure needsParticipate in the evaluation and selection of database technologiesOccasional travel to counties in IdahoMinimum Qualifications
Good knowledge of each of the following:Relational database principles and data normalization. (Typically gained by completing the core requirements of an associate's degree or certification related to relational database concepts and data normalization OR at least one (1) year of experience (including combination of work experience and internships) regularly working with and supporting relational databases as part of your primary job responsibilities.)Structured Query Language (SQL). (Typically gained by completion of the core requirements for a certification related to Structured Query Language (SQL) design or administration AND at least one (1) year of experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities OR at least two (2) years of work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities.)
At least 1 year of experience in each of the following:Installing, administering, and monitoring production databases and database serversInteracting directly with clients to analyze customer needs
Why Join Us?
OUR VISION: Great people. Helping you. Serving Idaho.OUR MISSION: Benefit Idaho through courteous customer service, education, and fair tax administration.OUR VALUES: Fairness, Accountability, Integrity, Respect.What Do Our Employees Say About Us?
"I love the work-life balance at the Tax Commission because our managers and supervisors are awesome with flexibility.""We work a flexible schedule, Monday through Friday, 40 hours a week. So this schedule has allowed me to do other things in my life.""My favorite part about working for the Tax Commission are the people I get to work with. It's become a family, and I've made lots of lifelong friends."Follow us on or to learn more about us!
What's In It for You?*
Affordable benefits including medical, vision, and dental insurancePERSI defined benefit retirement planPaid sick and vacation leaves start accruing your first day11 paid holidays per yearPaid Parental Leave covering the birth or adoption of a child for up to 8 weeksPermanent, full-time classified employment status after successful completion of an entrance probationWorking in an office environment with other talented and highly motivated individualsBeautiful state campus with lots of free parking, walking paths, and centrally located in the valley on Chinden Blvd. in Boise (ISTC Recruiter should remove this bullet point if the position is for a field office)The State of Idaho is a qualifying employer for Public Service Loan Forgiveness (PSLF)
*Benefits may not be applicable for temporary or seasonal positions.
EEO/ADA/Veteran:
The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.
The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact (208) 334-2263 (TTY/TTD: 711), or email . (If you have a contact for applicant accommodations at your agency, please replace the contact information).
Preference may be given to veterans who qualify under state and federal laws and regulations.
Career Opportunity
The Idaho State Tax Commission is seeking a database analyst 2 with solid skills in database design and maintenance to join our Property Tax team. This role may be perfect for you if you enjoy organizing and make sense of collections of information to create functional database systems. The successful candidate will be well-versed in database design, installation, and maintenance with a background in programming. Candidates should have strong problem solving and decision-making skills and be willing to troubleshoot problems and new requirements and offer solutions. The position is in the Boise Office in the Chinden Campus, 11321 West Chinden Blvd, Building 2. Applications will be accepted until a qualified candidate is selected. Minimum salary is $37.68 per hour, rate of pay will depend on qualifications and experience.
Responsibilities:
Interact with internal staff, various county staff, and third-party vendorsDesign databases and data access methods for softwareSQL Server supportIIS SupportMaintain the data dictionaryMonitor and optimize database usageAdminister and manage databases in production environmentsApply software releases/patches in countiesPlan for database upgrades and forecast storage and infrastructure needsParticipate in the evaluation and selection of database technologiesOccasional travel to counties in IdahoMinimum Qualifications
Good knowledge of each of the following:Relational database principles and data normalization. (Typically gained by completing the core requirements of an associate's degree or certification related to relational database concepts and data normalization OR at least one (1) year of experience (including combination of work experience and internships) regularly working with and supporting relational databases as part of your primary job responsibilities.)Structured Query Language (SQL). (Typically gained by completion of the core requirements for a certification related to Structured Query Language (SQL) design or administration AND at least one (1) year of experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities OR at least two (2) years of work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities.)
At least 1 year of experience in each of the following:Installing, administering, and monitoring production databases and database serversInteracting directly with clients to analyze customer needs
Why Join Us?
OUR VISION: Great people. Helping you. Serving Idaho.OUR MISSION: Benefit Idaho through courteous customer service, education, and fair tax administration.OUR VALUES: Fairness, Accountability, Integrity, Respect.What Do Our Employees Say About Us?
"I love the work-life balance at the Tax Commission because our managers and supervisors are awesome with flexibility.""We work a flexible schedule, Monday through Friday, 40 hours a week. So this schedule has allowed me to do other things in my life.""My favorite part about working for the Tax Commission are the people I get to work with. It's become a family, and I've made lots of lifelong friends."Follow us on or to learn more about us!
What's In It for You?*
Affordable benefits including medical, vision, and dental insurancePERSI defined benefit retirement planPaid sick and vacation leaves start accruing your first day11 paid holidays per yearPaid Parental Leave covering the birth or adoption of a child for up to 8 weeksPermanent, full-time classified employment status after successful completion of an entrance probationWorking in an office environment with other talented and highly motivated individualsBeautiful state campus with lots of free parking, walking paths, and centrally located in the valley on Chinden Blvd. in Boise (ISTC Recruiter should remove this bullet point if the position is for a field office)The State of Idaho is a qualifying employer for Public Service Loan Forgiveness (PSLF)
*Benefits may not be applicable for temporary or seasonal positions.
EEO/ADA/Veteran:
The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.
The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact (208) 334-2263 (TTY/TTD: 711), or email . (If you have a contact for applicant accommodations at your agency, please replace the contact information).
Preference may be given to veterans who qualify under state and federal laws and regulations.