"Alerted.org

IT Database Admin Analyst II - ITSD

Posting Begin Date: 2025/11/24

Posting End Date: 2025/12/22

Category: IT And Computers

Work Type: Full Time

Remote: Flexible Hybrid

Minimum Salary: 29.72

Maximum Salary: 40.00

Pay Rate Type: Hourly

Description

DEDICATED TO STRENGTHENING THE HEALTH, SAFETY, AND INDEPENDENCE OF IDAHOANS

*THIS ANNOUNCEMENT WILL BE OPEN UNTIL FILLED. APPLICANTS ARE ENCOURAGED TO APPLY AS SOON AS POSSIBLE TO BE CONSIDERED.*

The Idaho Department of Health and Welfare, IT Services Division has an opportunity for oneIT Database Administrator Analyst 2to join the Applications Development Team. This position provides an opportunity to serve the citizens of Idaho. We seek candidates who have excellent interpersonal and teamwork skills, a positive attitude with the skills to move forward in the ever changing world of Technology. The State of Idaho allows for Work/Life balance, and flex schedules. This position is located in downtownBoise.

If you have previously applied for IT Database Analyst Il and wish to be considered for this vacancy, you must reapply under this announcement. Previous scores will not be used. This announcement may be used to fill future vacancies. If relocating to Idaho, the Department of Health & Welfare does not reimburse the cost of relocating. The department does not sponsor anyone with a work visa.

This position may be eligible for limited telework after successful completion of probation and necessary training. Approval to telecommute is not guaranteed and subject to termination at any time.

BENEFITS:

The State of Idaho offers a robust total compensation and benefits package, including but not limited to:

+ We have one of the Nation's best state retirement systems (https://www.persi.idaho.gov/members-1/) (PERSI) that offers a lifetime benefit at retirement.

+ 11 paid holidays

+ Paid sick and vacation that begins accruing on your first day of employment; can be used immediately after accruing (no waiting time)

+ Paid parental leave (https://dhr.idaho.gov/information-for-state-employees/)

+ Medical, vision, and dental insurance benefits that become effective first of the month following your hire date. All contributions can be pre-tax (full-time/30+ hours per week)

+ 2 voluntary supplemental retirement plans including both pre-tax and Roth options

+ Deferred compensation plan

+ Life insurance for self, spouse, and children

+ Short and long-term disability insurance

+ Flexible Spending Accounts (FSA)

+ Wide variety of training opportunities

+ Some positions offer flexible hours and/or telecommuting

+ Additional perks and discounts (https://www.regence.com/producer/tools-for-members/advantages-discounts) available through medical provider

+ Public Service Loan Forgiveness (PSLF) Eligibility (https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service)

+ Employee assistance program

Additional information related to benefits and/or State programs can be found here: https://dhr.idaho.gov/StateEmployees/Benefits.html.*

EXAMPLE OF DUTIES:

+ Monitor health of SQL Server instances and production databases; perform backups, index tuning, integrity checks, and job management.

+ Diagnose and resolve performance issues using query plans, DMVs, and system metrics.

+ Maintain Always On Availability Groups, WSFC clusters, and off-site replication; validate DR readiness.

+ Manage user roles, permissions, and ensure compliance with security policies.

+ Develop and maintain PowerShell scripts for routine tasks, monitoring, and reporting.

+ Apply SQL Server patches; coordinate with infrastructure teams on VM and storage optimization.

+ Participate in planning for system upgrades, architecture improvements, and technology evaluations.

+ Create and maintain technical documentation; support internal knowledge transfer and training.

+ Contribute to modernization initiatives, application integration, and cross-functional projects.

+ Participate in on-call rotation to support production systems up 24/7.

MINIMUM QUALIFICATIONS:

You must possess all the minimum qualifications below to pass the exam for this position. Please make sure your resume or work history supports your meeting the minimum qualifications for this position. Failure to do this may disqualify you from being considered for this position. It is highly recommended to attach a one-page cover letter to your application to demonstrate how you meet the requirements below.

+ Good knowledge of relational database principles and data normalization.

+ Good knowledge of Structured Query Language (SQL).

+ Experience installing, administering, and monitoring production databases and database servers.

+ Experience interacting directly with clients to analyze customer needs.

• Below is preferred experience. It is not required for the position but applicants with this experience may receive consideration over other applicants.

+ Experience as a SQL Server DBA in a Windows Server Environment.Typically gained by 3 years of work experience.

+ Experience with Performance Tuning and Optimization (PTO) of databases.Typically gained by 3 years of work experience.

+ Backups, Restores, recovery models including High Availability (HA) and Disaster Recovery (DR) options for SQL Server in a clustered environment.Typically gained through a minimum of 2 years work experience.

+ Securing Data at Rest, Masking Data, patching SQL databases that run on Windows Servers.Typically gained by at a minimum of 2 years work experience.

+ Please provide any experience in administration in the following SQL areas: SQL Server Reporting Services (SSRS), SQL Server Integrated Services (SSIS), Data Warehousing and Azure SQL Database.Typically gained by a minimum of 2 years experience.

Learn About a Career with DHW (https://healthandwelfare.idaho.gov/about-dhw/dhw-careers)

If relocating to Idaho, the Department of Health & Welfare does not reimburse the cost of relocating and the department does not sponsor anyone with a work visa.

***PLEASE NOTE: application assistance is not available after the business hours listed below, on the weekends, or on holidays and you must apply before 4:59 pm on the closing date. When applying, use CHROME as your browser to avoid complications.

If you have questions, please contact us at:

Email is the quickest way to get an answer to your questions.

(answered Monday through Friday during business hours MST)

EMAIL: [email protected]

PHONE: (208) 334-0681

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].

Preference may be given to veterans who qualify under state and federal laws and regulations.