IT Database Admin Analyst III - ITS

Idaho Division of Human Resources • Boise, ID • 2h ago

Information Technology Services - ITSState of Idaho Opportunity

If you have previously applied for a position, 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.

State of Idaho Employees: When searching for a new career within the state, browse and apply through Luma Opportunities . Applying through the State External Career website will cause duplicate profiles and will slow the processing of your application for a new job. Internal candidates should always use Luma Opportunities.

Summary:

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

The selected individual must possess an in-depth knowledge of how to install and manage large, complex database management systems to ensure the security, quality, and integrity of data resources. Work will be performed in a MS SQL Server and MySQL environment supporting the missions of State of Idaho agencies and citizen digital services.

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

Example of Duties:

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

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

Special Consideration for:

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.

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 ada.coordinator@dhr.idaho.gov.

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

Similar Jobs

Software Engineer - Data Platform

R1 RCM • Boise, ID • 41min ago

IT & Engineering

Phare is building healthcare's first Revenue Operating System - a platform that uses AI to make hospital billing and reimbursement effortless, accurate, and fair. We're part of R1, one of the largest companies managing h...

41min ago

Go to Apply

Intern -AWS Cloud Infrastructure- SRE

SitusAMC • Boise, ID • 2h ago

IT & Engineering

SitusAMC is where the best and most passionate people come to transform our client's businesses and their own careers. Whether you're a real estate veteran, a passionate technologist, or looking to get your start, join u...

2h ago

Go to Apply

Permit Technician

Cushing Terrell • Caldwell, ID • 1d ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2519314 \ Position Title: Permit Technician\ \ **Description\ \ Position Description** As a Permit Technician,...

1d ago

Go to Apply

Permit Technician

Cushing Terrell • Boise, ID • 1d ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2519313 \ Position Title: Permit Technician\ \ **Description\ \ Position Description** As a Permit Technician,...

1d ago

Go to Apply

IT Compliance Specialist, SISP

Sedgwick • Boise, ID • 1d ago

IT & Engineering

By joining Sedgwick, you'll be part of something truly meaningful. It's what our 33,000 colleagues do every day for people around the world who are facing the unexpected. We invite you to grow your career with us, experi...

1d ago

Go to Apply

RDA/Metrology Shift Process Engineer

Micron Technology, Inc. • Boise, ID • 1d ago

IT & Engineering

Our vision is to transform how the world uses information to enrich life for all . Micron Technology is a world leader in innovating memory and storage solutions that accelerate the transformation of information into int...

1d ago

Go to Apply

Reticle Manufacturing Process Engineer

Micron Technology, Inc. • Boise, ID • 2d ago

IT & Engineering

2d ago

Go to Apply

Mechanical Engineer (Generation)

WSP USA • Boise, ID • 2d ago

IT & Engineering

This Opportunity WSP is currently initiating a search for a Mechanical Engineer (Generation) to join our Power & Energy team in Houston, TX . The following locations will also be considered: New York, NY , Seattle, W...

2d ago

Go to Apply

Facilities Mechanical Engineer

Farnsworth Group • Boise, ID • 2d ago

IT & Engineering

Position: Facilities Mechanical Engineer Location: Boise, ID Job Id: 3413 of Openings: 1 Farnsworth Group is seeking a Facilities Mechanical Engineer, supporting semiconductor process equipment installation projects in t...

2d ago

Go to Apply

Sr Data Scientist

The Hertz Corporation • Boise, ID • 2d ago

IT & Engineering

A day in the life: At Hertz, our senior data scientists are responsible developing and defining best practices for analytical methods to generate informative research, reports, visualizations, and dashboards using intern...

2d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.