IT Database Admin Analyst IV

State of Idaho

Office of the State Board of Education

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

STATE OF IDAHO EMPLOYEES: If you are a current or temporary State of Idaho employee you MUST apply through Luma Opportunities. Applying through the State of Idaho’s external career website will cause duplicate profiles and will slow the processing of your application for a new position.

NOTICE: Due to a recent system improvement, if you have previously applied for a position with the State of Idaho, select Reset/Forgot Password and follow the prompts to access your account. For additional assistance, refer to the Candidate Guide located under Candidate Resources on the State of Idaho Careers page.

About the Agency: The Idaho State Board of Education (Board) is established in the Idaho Constitution for the “general supervision of the state educational institutions and public school system.” State law charges the Board with the general supervision, governance and control of public schools and postsecondary institutions, including community colleges. The Board is comprised of eight members: seven appointed by the Governor, as well as the statewide elected superintendent of public instruction. The Office of the State Board of Education (OSBE) is charged with providing professional staff support to the Board and implementing the Board’s policies, programs, and initiatives.

Summary:

The IT Database Administrator (DBA IV) will provide leadership in the design, installation and maintenance of large, complex database management systems, encompassing the state’s K-20 education data. Incumbent will work collaboratively in a team environment supporting the data needs of the enterprise. This position will ensure the security, quality, and integrity of data resources and perform related work.

This senior-level position will provide essential enterprise-wide database administration functionality to the Office of the State Board of Education and to multi-agency systems supporting the Idaho State Board of Education, Idaho State Department of Education, Idaho Public Charter School Commission and Idaho Career Technical Education.

This position is located in Boise, Idaho and requires residency in Idaho. If relocating to Idaho, the Idaho State Board of Education does not reimburse the cost of relocation. The agency does not sponsor anyone with a work visa.

Responsibilities:

• Brings new information on security/data developments into the organization, including information on new tools, procedures and systems
• Analyzes complex business and competitive issues and discerns their implications for data systems and security
• Advises business partners on approaches to optimize business success, in consideration of data concerns
• Recommends strategic direction for long-term spending plans Includes database performance tuning and database storage forecasting Installs and maintains database software systems
• Performs data management and migration including data extraction, transformation and loading (ETLs)
• Monitors performance and proactively adjusts and tunes system
• Manages and maintains data system integrity and security
• Designs and implement appropriate backup and recovery strategies
• Performs related work, as required

Minimum Qualifications:

Experience:

• Installing, administering and monitoring production databases and database servers
• Developing procedures and controls to ensure database security, integrity and availability
• Researching IT database concerns and providing solutions
• Monitoring and tuning the performance of databases, queries and indexes
• Coordinating long-range planning teams and providing strategic solutions to senior leadership

Preferred Qualifications:

• Bachelor’s degree in computer science (or related STEM field), or an equivalent combination of education and relevant experience
• Five years of experience in a database administration position
• Extensive experience in Microsoft SQL server
• Proficiency in one or more additional Database Management Systems
• Extensive experience maintaining and migrating data through the use of ETLs and pipelines
• Ability to design and maintain efficient and scalable database schemas
• Experience with cloud database services (e.g., Azure SQL, AWS RDS, etc)
• Experience with scripting and automation technologies (e.g., Python, PowerShell)
• Knowledge of data warehousing principles and technologies
• Experience with database reporting services (e.g., SSRS, Power BI, Telerik reporting)
• Experience providing ad hoc reports and datasets
• Ability to effectively communicate with technical and non-technical stakeholders
• Strong skills in customer service, collaboration, problem-solving, and attention to detail
• Ability to manage multiple tasks, projects, and priorities effectively
• Ability to adjust to changing technologies and business requirements

Physical Demands:

• Approximately 90% of time is spent sitting at desk or workstation, up to 4 hours at a time.
• Approximately 10% of time is spent standing, walking, bending, and kneeling.
• Occasional lifting may be required, frequently less than 5 lb, but may be up to 20 lb.

Supplemental Information:

• This position typically does not travel, but may occasionally be requested to do so.

Application Procedure: Prepare a cover letter and resume and attach to your candidate profile.

Recruitment Contact: Questions about the position or the application process can be directed to Casie Silvia, Human Resource Business Partner I, at (208) 854-3014 or casie.silvia@dhr.idaho.gov

Special Notification: This position is exempt from the rules of classified service under the provisions of Section 67-5303, Idaho Code. This position is educational professional exempt from overtime. The successful applicant will be required to pass a background check.

Benefits:

The State of Idaho offers a robust total compensation and benefits package, including but not limited to:

• Medical, vision, and dental insurance benefits that become effective first of the month following your hire date. All contributions can be pre-tax
• 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
• Life insurance for self, spouse, and children
• Additional perks and discounts available through medical provider
• Public Service Loan Forgiveness (PSLF) Eligibility
• Employee assistance program
• Tuition reduction benefits

The State Board of Education requires participation in the Idaho Optional Retirement Plan (ORP) for benefited and non-classified staff who do not have previous credited service with PERSI. The Idaho ORP is a defined contribution plan (401(a)) where both the employer and employee make contributions to the individual employee's account. Employees are immediately vested when enrolled in the ORP. The record keeper for the ORP is Fidelity Investments, and the ORP plan is administered by the State Board of Education. The State Board of Education also provides supplemental deferred compensation (457(b)) and 403(b) plans. More information can be found here : https://boardofed.idaho.gov/data-research/finance-administration/retirement-plans/

Additional information related to benefits and/or State programs can be found here: https://dhr.idaho.gov/information-for-state-employees/

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 ada.coordinator@dhr.idaho.gov . (If you have a contact for applicant accommodations at your agency, please replace the contact information).

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