IT Database Admin Analyst II - ITS Posting Begin Date: 2025/01/22 Posting End Date: 2025/02/09 Category: IT And Computers Work Type: Full Time Location: Boise, ID, United States Minimum Salary: 28.56 Maximum Salary: 32.50 Pay Rate Type: Hourly Description Information Technology Services - ITS State of Idaho Opportunity Applications will be accepted through 4:59 PM MST on the posting end date. Summary: Information Technology Services is a team of dedicated professionals providing core technology and cybersecurity services to agencies statewide, enabling state employees to serve Idaho's citizens. The ITS Database Administration team has an opening for a Database Administration Analyst II in our Boise, Idaho office. This position offers comprehensive database administration support to a diverse set of State of Idaho agencies. Key duties include providing direct customer support for database maintenance, management, and administration. Responsibilities involve troubleshooting, disaster recovery, problem resolution, database design and development, alongside the creation and management of SQL scripts and stored procedures. The selected individual must possess in-depth knowledge of Microsoft SQL Server support. Excellent time management skills and the ability to maintain multiple priorities are crucial to success in this role. Please note: The successful candidates will be required to pass multiple, comprehensive fingerprint-based background checks specific to the agencies ITS supports. Applicants must be authorized to work for any employer in the United States. The Idaho Office of Information Technology Services is unable to sponsor or assume sponsorship of an employment visa or participate in Optional Practice Training (OTP). Example of Duties + Provides daily support for multiple enterprise database platforms (Microsoft SQL Server, MySQL); + Manages the design, development, and upgrades of databases; + Troubleshoots issues and performs SQL scripting development; + Develops stored procedures, backup and recovery plans, and other database management functions; + Develops a variety of reports (SSRS, PowerBI); + Participates in on-call rotation for after-hours support; + Works closely with software developers in support of application development and integration activities; + Implements database changes and enhancements from user requirements; + Monitors and optimizes database performance; + Monitors, manages, and tests backup, restore, and database functions to maintain data integrity and availability. Minimum Qualifications + Good knowledge of relational database principles and data normalization. Typically gained by obtaining an associate's degree or certification related to relational database concepts and data normalization OR at least one (1) year of full-time work experience (including combination of work experience and internships) regularly working with and supporting relational databases as part of your primary job responsibilities. + Good knowledge of Structured Query Language (SQL). Typically gained by current certification related to Structured Query Language (SQL) design or administration AND at least one (1) year of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities OR at least two (2) years of full-time work experience (including combination of work experience and internships) writing, testing, and utilizing SQL as part of your primary job responsibilities. + Experience installing, administering, and monitoring production databases and database servers. Typically gained through at least one (1) year of full-time work experience (including combination of work experience and internships) installing, administering and monitoring production databases and database servers as part of your primary job responsibilities. + Experience technically interacting directly with clients to analyze customer needs. Typically gained by at least one (1) year of full-time work experience (including combination of work experience and internships) interacting with clients to analyze customer needs as part of your primary job responsibilities. Benefits: 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 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.