IT Database Admin Analyst III

IdahoPTV; Boise (ID); On-site; USD 50,000 - 56,000; Full time

Benefits offered by this job

State benefits package

Public Service Loan Forgiveness (PSLF)

PERSI retirement

Generous vacation and leave

Job summary

The State of Idaho is hiring a Database Administrator III to design, secure, and maintain data platforms powering statewide digital services. You will work primarily with Microsoft SQL Server, with opportunities to explore MySQL, PostgreSQL, and Oracle in modernization projects.

Join a collaborative team focused on performance, security, and reliability across agency databases. Fingerprint background checks apply; Boise on-site location; state benefits and long-term career growth.

Qualifications

• Experience installing, administering and monitoring production databases and database servers.
• Experience training and mentoring staff on the effective and secure use of data.
• Experience monitoring and tuning the performance of databases, queries and indexes.
• Experience developing procedures and controls to ensure database security, integrity and availability.
• Experience resolving complex database problems.
• Experience in database resource planning.

Responsibilities

• Install, configure, and maintain database server environments to support agency applications.
• Monitor availability, health, and performance across numerous production databases.
• Manage user permissions and data access across diverse agencies to meet security/compliance.
• Lead or support database migration efforts as infrastructure needs evolve.
• Design, implement, review, and update stored procedures, functions, and internal maintenance processes.
• Use SQL tracing and diagnostics tools to troubleshoot root causes of 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 deployments.
• Perform performance tuning, capacity planning, and storage forecasting.

Skills

Database administration

SQL Server

Performance tuning

Security & compliance

ETL processes

Stored procedures

Troubleshooting

Mentoring staff

Tools

Microsoft SQL Server

MySQL

PostgreSQL

Oracle

SSIS

SSRS

Azure Data Factory

Windows Server

Job description

USA:ID:Boise | IT And Computers | Full Time

36.16 - 41.00 USD per hour

Description

State of Idaho Opportunity

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
• Generous vacation and sick leave accrual beginning as soon as you start
• Eligibility for the Public Service Loan Forgiveness Program (PSLF)
• Paid parental leave
• Eleven paid holidays a year
• Participation in one of the nation’s best state retirement systems: PERSI
• 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 [phone] (TTY/TTD: 711), or email [e-mail].

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