Work for Indiana

Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a range of opportunities across 60+ agencies. At the state, you'll find competitive compensation, a robust benefits package and a commitment to work-life balance. Most importantly, you'll have the chance to make a real and measurable impact on the lives of Hoosiers across Indiana.

About the Indiana Department of Transportation

The Indiana Department of Transportation (INDOT) provides a dynamic workplace that serves Indiana citizens, improves our state’s quality of life, and enhances its economic opportunity. INDOT has a number of innovative programs and projects, including Public-Private Partnerships, Green Initiatives, and cutting-edge uses of materials and assets. As part of the State of Indiana, INDOT offers a competitive total compensation package, as well as outstanding work/life balance. Whether you are an established professional in the transportation field or just starting your career, INDOT has exciting and challenging opportunities for you.

Role Overview

In this role you will be responsible for daily operation of the Indiana Department of Transportation's (INDOT) bridge inspection and inventory system for Bridge, Large Culvert, Tunnels, and Walls Assets. You will provide training, testing and troubleshooting as well as provide support to Bridge Systems Data Manager for bridge inventory and condition data management systems: iTAMS. Additionally this role requires you to work with other INDOT systems SPMS, GIS, ERMS, BRADIN, RCE, WMS, and any new bridge/culvert or related inventory systems that may be developed. Bridge data is required by Federal Regulations and is required to be up to date and accurate.

Location

This position is located in INDOT’s Indianapolis Central Office, Bridge Inspection Department.

Salary

This position traditionally starts at an annual salary of $49,114.00. Salary for this position may be commensurate with education and job experience.

A Day in the Life

The essential functions of this role are as follows:

Assists in the design, implementation, and maintenance of logical and physical databases.
Works with team to determine aggregation, partitioning, and indexing strategies for physical data.
Administers end-user access and security at the database level.
Ensures that data is appropriately protected via database backup and related strategies.
Assists in the load process of database software and application of fixes.
Assists with the evaluation and selection of infrastructure components.
Provides operational support for the database ensuring data integrity, database availability, and performance.
Creates and maintains general utility programs.
Provides technical assistance to application programmers as needed.
Monitors system performance in selected areas and implements necessary changes to improve performance when possible.
Studies hardware/software proposals to determine the impact on existing configurations.
Provides technical assistance to, and written guidelines for, operations personnel as needed.
Researches new techniques and technical developments to be utilized by operations to enhance systems performance.
Some essential functions of this position may be performed onsite at the agency’s worksite or other assigned worksites while some essential functions of this position may be eligible for work from home authorization in accordance with policy. Remote work authorization is not automatic and is dependent upon operational needs and agency approval.

The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time.

This position is exempt from overtime compensation for additional work hours which may be required to complete essential functions or other assigned work. Exempt employees may work more than 75 hours in a pay period without additional compensation and must report a minimum of 75 hours per pay period of work hours and/or paid leave taken to receive their base biweekly salary.

What You'll Need for Success

The ideal candidate in this role should minimally have either

a Bachelor’s Degree with 3+ years of experience, or
an Associate’s Degree with 5+ years of experience, or
at least 7+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role.

Related certifications and coursework may be considered for education or experience.

Working knowledge of relational database design techniques.
Working knowledge of a variety of computer languages.
Working knowledge of computer hardware/software capabilities and configurations.
Working knowledge in software and utilities related to supported Data Base Management Systems (DBMS) such as Reorg, Backup, Recovery, Load, Unload.
Ability to apply theories, principles and methodologies to existing and new computer hardware/software.
Ability to write database computer programs, macros, subroutines and utilities in a variety of languages.
Effectively communicate, both orally and in writing;
Ability to apply advanced logic.
Ability to participate in multiple hardware/software projects and priorities.
Ability to read and understand complicated technical manuals on programming and systems analysis.
Able to perform essential functions with or without reasonable accommodation.

Supervisory Responsibilities/Direct Reports

This role may be utilized in a supervisory capacity based on agency needs.

Benefits of Employment with the State of Indiana

The State of Indiana offers a comprehensive benefit package for full-time employees which includes:

Three (3) medical plan options (including RX coverage) as well as vision and dental plans
Wellness Rewards Program: Complete wellness activities to earn gift card rewards
Health savings account, which includes bi-weekly state contribution
Deferred compensation 457(b) account (similar to 401(k) plan) with employer match
Two (2) fully-funded pension plan options
A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:
150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers
Up to 15 hours of paid community service leave
Combined 180 hours of paid vacation, personal, and sick leave time off
12 paid holidays, 14 on election years
Education Reimbursement Program
Group life insurance
Referral Bonus program
Employee assistance program that allows for covered behavioral health visits
Qualified employer for the Public Service Loan Forgiveness Program
Free Parking for most positions
Free LinkedIn Learning access

Equal Employment Opportunity

The State of Indiana is an Equal Opportunity Employer and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process as well as perform the essential functions of a role. If you require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at jobs@spd.IN.gov.

Qualifications

Bridge data is required by Federal Regulations and is required to be up to date and accurate
Remote work authorization is not automatic and is dependent upon operational needs and agency approval
The ideal candidate in this role should minimally have either
a Bachelor’s Degree with 3+ years of experience, or
an Associate’s Degree with 5+ years of experience, or
at least 7+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role
Related certifications and coursework may be considered for education or experience
Working knowledge of relational database design techniques
Working knowledge of a variety of computer languages
Working knowledge of computer hardware/software capabilities and configurations
Working knowledge in software and utilities related to supported Data Base Management Systems (DBMS) such as Reorg, Backup, Recovery, Load, Unload
Ability to apply theories, principles and methodologies to existing and new computer hardware/software
Ability to write database computer programs, macros, subroutines and utilities in a variety of languages
Effectively communicate, both orally and in writing;
Ability to apply advanced logic
Ability to participate in multiple hardware/software projects and priorities
Ability to read and understand complicated technical manuals on programming and systems analysis
Able to perform essential functions with or without reasonable accommodation
This role may be utilized in a supervisory capacity based on agency needs

Benefits

At the state, you'll find competitive compensation, a robust benefits package and a commitment to work-life balance
As part of the State of Indiana, INDOT offers a competitive total compensation package, as well as outstanding work/life balance
Whether you are an established professional in the transportation field or just starting your career, INDOT has exciting and challenging opportunities for you
This position traditionally starts at an annual salary of $49,114.00
Salary for this position may be commensurate with education and job experience
Three (3) medical plan options (including RX coverage) as well as vision and dental plans
Wellness Rewards Program: Complete wellness activities to earn gift card rewards
Health savings account, which includes bi-weekly state contribution
Deferred compensation 457(b) account (similar to 401(k) plan) with employer match
Two (2) fully-funded pension plan options
A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:
150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers
Up to 15 hours of paid community service leave
Combined 180 hours of paid vacation, personal, and sick leave time off
12 paid holidays, 14 on election years
Education Reimbursement Program
Group life insurance
Referral Bonus program
Employee assistance program that allows for covered behavioral health visits
Qualified employer for the Public Service Loan Forgiveness Program
Free Parking for most positions
Free LinkedIn Learning access

Responsibilities

In this role you will be responsible for daily operation of the Indiana Department of Transportation's (INDOT) bridge inspection and inventory system for Bridge, Large Culvert, Tunnels, and Walls Assets
You will provide training, testing and troubleshooting as well as provide support to Bridge Systems Data Manager for bridge inventory and condition data management systems: iTAMS
Additionally this role requires you to work with other INDOT systems SPMS, GIS, ERMS, BRADIN, RCE, WMS, and any new bridge/culvert or related inventory systems that may be developed
Assists in the design, implementation, and maintenance of logical and physical databases
Works with team to determine aggregation, partitioning, and indexing strategies for physical data
Administers end-user access and security at the database level
Ensures that data is appropriately protected via database backup and related strategies
Assists in the load process of database software and application of fixes
Assists with the evaluation and selection of infrastructure components
Provides operational support for the database ensuring data integrity, database availability, and performance
Creates and maintains general utility programs
Provides technical assistance to application programmers as needed
Monitors system performance in selected areas and implements necessary changes to improve performance when possible
Studies hardware/software proposals to determine the impact on existing configurations
Provides technical assistance to, and written guidelines for, operations personnel as needed
Researches new techniques and technical developments to be utilized by operations to enhance systems performance
Some essential functions of this position may be performed onsite at the agency’s worksite or other assigned worksites while some essential functions of this position may be eligible for work from home authorization in accordance with policy
The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee
Other duties, responsibilities and activities may change or be assigned at any time
This position is exempt from overtime compensation for additional work hours which may be required to complete essential functions or other assigned work
Exempt employees may work more than 75 hours in a pay period without additional compensation and must report a minimum of 75 hours per pay period of work hours and/or paid leave taken to receive their base biweekly salary

Database Analyst Associate

Job Type