IT Database Admin Analyst II - ITSD

State of Idaho•Boise, ID

75d•Hybrid

About The Position

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 one IT Database Administrator Analyst 2 to 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 downtown Boise. 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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.

Benefits

We have one of the Nation's best state retirement systems (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
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 available through medical provider
Public Service Loan Forgiveness (PSLF) Eligibility
Employee assistance program