IT Database Admin Analyst II - ITSD

State of Idaho-posted 27 days ago
Full-time • Mid Level
Hybrid • Boise, ID
51-100 employees
Executive, Legislative, and Other General Government Support
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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.
  • 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
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
IT Analyst Resume Examples
•
IT Analyst Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service