Share this Job

Current Employee? Click here to apply.

Senior Database Administrator

Date Posted:  Jan 24, 2023
Requisition ID:  417117

Indianapolis, IN, US, 46204


Work for Indiana

Grow your career with the State of Indiana! With more than 50 executive branch agencies, the State of Indiana is a diverse workforce offering employees stimulating and challenging projects across a broad scope of career opportunities. As a State of Indiana employee, you impact the well-being of Indiana’s communities every day.


At the State of Indiana, we don’t just talk about diversity and inclusion – Our goal is to create a welcoming, accessible, and equitable workplace, with a workforce that is representative of the State of Indiana population. As a proud equal opportunity employer, reasonable accommodations may be available to enable individuals with disabilities to interview and to perform the essential functions of a role.


Next Level benefits at the State of Indiana are here! Be sure to review our expanded benefit package offerings below.


Agency Statement:

About the Indiana Department of Health (IDOH):
The Indiana Department of Health’s mission is to promote, protect, and improve the health and safety of all Hoosiers so that they can reach their optimal health regardless of where they live, learn, work, or play.

Salary Statement:

The salary for this position traditionally starts at $61,022, but may be commensurate with education or work experience.


About the Job:

As the Database Analyst Senior, you will be responsible for performing highly advanced database administration work. In this position, you will develop, maintain, and monitor integrated database systems. As the Database Analyst Senior, you will compile information from various databases and systems to provide reports and analysis based on data processing and analytical requirements.   You will coordinate changes to computer databases, test and implement the database by applying knowledge of database management systems and implement security measures to safeguard computer databases. 

A Day in the Life:

The essential elements of the job duties: 

  • Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment. 
  • Implement innovative procedures and methods through understanding of product capabilities and utilize those capabilities in unique ways to fully use products on the system and meet user’s goals and objectives. 
  • Assist management with identifying and exploring strategies for short and long-range planning for hardware, software changes, and additions. 
  • Evaluate technology and products to determine the feasibility of adding to agency standards. 
  • Develop work plans for assigned projects and manage the execution. 
  • Design and implement logical and physical databases of a moderately complex nature. 
  • Determine aggregation, partitioning and indexing strategies for physical data. 
  • Monitor and tune database performance, including SQL scripts, hints, execution plans, and materialized views. 
  • Administer end-user access and security at the database level. 
  • Ensure that data is appropriately protected via database backup and related strategies. 
  • Process database software and application of fixes dependent upon the complexity of the environment. 
  • Evaluate and advise on the selection of infrastructure components. 
  • Implement and maintain database catalogs and dictionaries. 
  • Develop integration of database systems through standardized database design techniques. 
  • Prepare reports which assist management in understanding the current hardware/software conditions, performance, and future trends. 


The job profile 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 with or without notice. 

What You'll Need for Success:

You must meet the following requirements to be considered for employment: 

  • A bachelor's degree from an accredited college or university with a major in one of the computer sciences or management information systems or equivalent work experience. 
  • A minimum of six (6) years of experience in computer systems analysis and/or computer programming. 
  • Extensive knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load and Unload. 
  • Extensive knowledge of capacity planning and disaster recovery. 
  • Extensive knowledge of relational database and data warehouse design techniques and dimensional modeling processes. 
  • Extensive knowledge of computer hardware/software capabilities and configurations. 
  • Extensive knowledge of and the ability to apply complex diagnostic, structure, logic, performance and tuning procedures relative to the operating system. 
  • Extensive knowledge of specialty area(s) of database administration and/or system software such as communication, storage management, operating systems or capacity planning. 
  • Extensive knowledge of applications development and maintenance. 
  • Knowledge of organizational business practices in areas of data quality improvement. 
  • Ability to analyze, communicate and recommend future needs and direction for agency’s data processing software/hardware environment. 
  • Ability to manage multiple hardware and software projects and priorities. 

Supervisory Responsibilities/Direct Reports:

This role does not provide direct supervision to direct reports.

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 program (offers premium discount for the medical plan and gift cards)
  • Health savings account, which includes bi-weekly state contribution
  • Flexible work scheduling options, including the potential for hybrid remote work for employees whose work may be performed outside state facilities
  • Deferred compensation 457B account (similar to 401k 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
    • 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.


Current Employee? Click here to apply.

Nearest Major Market: Indianapolis