Database Admin Analyst III

Information Technology Services (ITS) currently has an opening for an IT Database Administration Analyst III (DBA III) position in our Chinden office in Boise.

• Installs and configures new database server environments
• Monitors and maintains the availability of databases across numerous servers
• Manages permissions and access of data across various State agencies
• Plans and coordinates database migration efforts as environmental requirements and support scopes change over time
• Designs, implements, reviews and updates stored procedures and functions as required to facilitate state-wide database maintenance efforts
• Uses SQL tracing to identify root-cause of process breaks
• Writes SQL scripts to fulfill maintenance needs as they arise
• Designs, implements, or reconfigures ETL processes as agency needs change
• Coordinates with development and hosting teams to implement new enterprise-level systems and services
• Database performance tuning and database storage forecasting

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

• Experience managing Microsoft SQL Server
• Experience managing MySQL environments
• Experience creating and managing SSIS packages
• Experience designing, deploying and managing SSRS reports
• Experience setting up or maintaining SQL failover cluster environments
• Experience managing Windows servers in a virtual environment
• Experience creating and maintaining Azure Data Factory (ADF) workflows and instances

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

The State of Idaho offers a robust total compensation package, including medical, vision, and dental insurance; PERSI retirement benefits; paid sick, vacation, and parental leave; and 11 paid holidays per year. For additional information related to benefits and/or State programs, please visit (Use the "Apply for this Job" box below). Employees/Benefits.html.

The State of Idaho is committed to providing equa