IT Database Analyst 2

IT Database Analyst 2 at Idaho Division of Human Resources in Boise, Idaho, United States Job Description IT Database Analyst 2 Posting Begin Date: 2024/10/08 Posting End Date: 2024/11/05 Category: IT And Computers Sub Category: Software Work Type: Full Time Location: Boise, ID, United States Minimum Salary: 28.56 Maximum Salary: 28.56 Pay Rate Type: Hourly 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 vendors + Design databases and data access methods for software + SQL Server support + IIS Support + Maintain the data dictionary + Monitor and optimize database usage + Administer and manage databases in production environments + Apply software releases/patches in counties + Plan for database upgrades and forecast storage and infrastructure needs + Participate in the evaluation and selection of database technologies + Occasional travel to counties in Idaho Minimum 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 servers + Interacting 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 onLinkedIn (orFacebook (to learn more about us What's In It for You? + Affordable benefits including medical, vision, and dental insurance + PERSI defined benefit retirement plan + Paid sick and vacation leaves start accruing your first day + 11 paid holidays per year + Paid Parental Leave covering the birth or adoption of a child for up to 8 weeks + Permanent, full-time classified employment status after successful completion of an entrance probation + Working in an office environment with other talented and highly motivated individuals + Beautiful 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[email protected]. (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. To view full details and how to apply, please login or create a Job Seeker account