Database Analyst Associate

IN Auditor of State; Indianapolis (IN); On-site; USD 49,000 - 57,000; Full time

Job summary

Join the Indiana Department of Transportation (INDOT) to manage and enhance the bridge inspection database systems. This role requires database management skills, effective communication, and offers a competitive salary and benefits package. Ideal candidates will hold a relevant degree and possess strong experience in relational database applications, facilitating significant operational support for state infrastructure initiatives.

Benefits

Comprehensive medical plans

Wellness Rewards Program

Health savings account

Deferred compensation plan

Pension plan options

Paid vacation and holidays

Education Reimbursement Program

Employee assistance program

Free Parking for most positions

Access to LinkedIn Learning

Qualifications

• Bachelor's with 3+ years or Associate's with 5+ years of experience in related fields.
• Understanding of DBMS-related software is key.
• Must have ability to write programs and communicate effectively.

Responsibilities

• Manage daily operations of the bridge inspection database.
• Provide testing and troubleshooting support.
• Ensure data integrity and system performance.

Skills

Relational database design

Computer languages knowledge

Data integrity

Communication skills

Technical manuals comprehension

Education

Bachelor’s Degree

Associate’s Degree

Tools

DBMS utilities

Job description

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 to401(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 Parkingfor most positions
• Free LinkedIn Learningaccess

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 [e-mail].