IT Database Admin Analyst III

Information Technology Services - ITS

State of Idaho Opportunity

Applications will be accepted through 11:59 PM MST on the posting end date

About the Role: Information Technology Services (ITS) is seeking an experienced and motivated Database Administrator III to help design, secure, and maintain the data platforms that power essential digital services for the State of Idaho. This is a high‑impact role supporting systems used by agencies statewide that directly benefits Idaho’s residents, businesses, and public‑service operations. You’ll join a collaborative team of database professionals working primarily in a Microsoft SQL Server environment, with opportunities to contribute and learn other database platforms such as MySQL, PostgreSQL, and Oracle as needed. This position is ideal for a seasoned DBA who enjoys a mix of operational stability, technical ownership, and modernization projects.

Please note: The successful candidates will be required to pass multiple, comprehensive fingerprint-based background checks specific to the agencies ITS supports.

Core Responsibilities:

• Install, configure, and maintain database server environments to support agency applications and statewide services.

• Monitor availability, health, and performance across numerous production databases.

• Manage user permissions and data access across diverse agencies to meet strong security and compliance requirements.

• Lead or support database migration efforts as infrastructure and business needs evolve.

• Design, implement, review, and update stored procedures, functions, and internal maintenance processes.

• Use SQL tracing and diagnostics tools to troubleshoot and identify root causes of system or process failures.

• Write SQL scripts to support maintenance, automation, or data integrity initiatives.

• Design or refine ETL processes as agency requirements change.

• Partner with development, infrastructure, and hosting teams during deployment of new enterprise‑level systems and modernization efforts.

• Perform performance tuning, capacity planning, and storage forecasting for mission‑critical databases.

Minimum Qualifications:

• Experience installing, administering and monitoring production databases and database servers.- Typically gained by a minimum of one year of full-time work experience where installing, administering and monitoring production databases and database servers was part of your primary job functions.

• Experience training and mentoring staff throughout the organization on the effective and secure use of data.- Typically gained by a minimum of one year of full-time work experience where training and mentoring staff throughout the organization on the effective and secure use of data was part of your primary job responsibilities.

• Experience monitoring and tuning the performance of databases, queries and indexes.- Typically gained by a minimum of one year of full-time work experience where you regularly monitored and tuned the performance of databases, queries and indexes as part of your primary responsibilities.

• Experience developing procedures and controls to ensure database security, integrity and availability.- Typically gained by a minimum of one year of full-time work experience where you developed procedures and controls to ensure database security, integrity and availability.

• Experience resolving complex database problems.- Typically gained by a minimum of two years of full-time work experience where you resolved complex database problems as part of your primary job functions OR at least one year of full-time work experience where you resolved various level-three database escalation tickets as your primary job responsibility

• Experience in database resource planning.- Typically gained by a minimum of one year of full-time work experience where database resource planning was part of your primary job responsibilities

Preferred Knowledge and Experience:

• Administration of Microsoft SQL Server in production environments.

• Exposure to or interest in MySQL, PostgreSQL, or Oracle systems (training available as part of the role).

• Creating and maintaining SSIS packages.

• Designing, deploying, or managing SSRS reporting solutions.

• Experience with SQL Server failover clusters or high‑availability configurations.

• Experience managing Windows server environments, especially in virtualized or cloud‑ready infrastructures.

• Familiarity with Azure Data Factory or similar ETL/ELT orchestration tools.

Why Join ITS?

• Work on systems that directly support the State of Idaho and its citizens.

• Stable, long‑term career growth opportunities within the state IT ecosystem.

• A collaborative DBA team that values knowledge sharing, mentorship, and ongoing professional development.

• Exposure to multiple database technologies and modernization initiatives (cloud adoption, ETL modernization, automation, etc.).

• Competitive benefits, retirement contributions, and work‑life balance that are hard to match in private‑sector roles.

Benefits:

This position is eligible for the state benefits package, including:

• Excellent low-cost medical, dental, and vision insurance (https://ogi.idaho.gov/)

• Generous vacation and sick leave accrual beginning as soon as you start

• Eligibility for the Public Service Loan Forgiveness Program (PSLF)

• Paid parental leave (https://dhr.idaho.gov/wp-content/uploads/2025/01/DHR-10\_Paid-Parental-Leave.pdf)

• Eleven paid holidays a year

• Participation in one of the nation's best state retirement systems: PERSI (https://www.persi.idaho.gov/)

• Multiple retirement plans

• Life insurance

• Wellness programs; ongoing training opportunities; and more

https://dhr.idaho.gov/StateEmployees/Benefits.html

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.