Database Analyst Date Posted: Sep 24, 2024 Requisition ID: 450086 Location: Indianapolis, IN, US, 46219 Work for IndianaBegin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a diverse 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. At the State of Indiana, we don’t just talk about diversity and inclusion—we make it our goal to create a welcoming, accessible, and equitable workplace with a workforce that is representative of Indiana's population. As a proud equal opportunity employer, 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. 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. Salary: This position traditionally starts at an annual salary of $55,224.00. Salary for this position may be commensurate with education and job experience. Location: This position is located in INDOT’s Central Office, Indianapolis. A Day in the Life: The essential functions of this role are as follows:
Designs and implements logical and physical databases of a moderately complex nature;
Determines aggregation, partitioning and indexing strategies for physical data;
Monitors and tunes database performance;
Administers end-user access and security at the database level;
Ensures that data is appropriately protected via database backup and related strategies;
Loads, or assists in load, process of database software and application of fixes dependent upon the complexity of the environment;
Assists with the evaluation and selection of infrastructure components;
Provides operational support for the database ensuring data integrity, database availability and performance;
Implements and maintains database catalogs and dictionaries;
Develops integration of database systems through standardized database design techniques;
Provides resolutions to technical problems;
Implements innovative procedures and methods through understanding of product capabilities and utilizes those capabilities in unique ways to fully use products on the system and meet user’s goals and objectives;
Assists management with short/long-range planning for hardware and software changes and additions;
Serves as a project lead for software products;
Provides technical assistance to lower-level staff;
Prepares reports which assist management in understanding the current hardware/software conditions, performance and future trends.
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. What You'll Need for Success: The ideal candidate in this role should minimally have either
a Master’s degree with 2+ years of experience, or
a Bachelor’s Degree with 5+ years of experience, or
at least 9+ 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.
Advanced knowledge in the technology of both the DBMS and the operating system chosen for the data warehouse or data mart;
Advanced knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load and Unload;
Advanced knowledge of capacity planning and disaster recovery;
Advanced knowledge of relational database and data warehouse design techniques and dimensional modeling processes;
Advanced knowledge of computer hardware/software capabilities and configurations;
Advanced knowledge of a variety of computer languages;
Advanced knowledge of and the ability to apply complex diagnostic, structure, logic, and performance and tuning procedures relative to the operating system;
Advanced knowledge of specialty area(s) of database administration and/or system software such as communication, storage management, operating systems or capacity planning;
Advanced knowledge of applications development and maintenance;
Ability to analyze, communicate and recommend future needs and direction for agency’s data processing software/hardware environment;
Ability to apply theories, principles and methodologies to existing and new computer hardware/software;
Ability to manage multiple hardware/software projects and priorities;
Ability to guide and coordinate the work of others;
Effectively communicate, both orally and in writing;
Ability to perform advanced logic analysis.
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
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 and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Our policy is to provide equal employment opportunity to all people in all aspects of employer-employee relations without discrimination because of race, color, creed, religion, sex, national origin, ancestry, age, sexual orientation, gender identity, physical or mental disability, or veteran status. We will comply with the spirit as well as the letter of all applicable state and federal laws.
If you are a qualified individual with a disability and require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at [emailprotected] .
The State of Indiana has established a culture that welcomes equity, inclusion, and opportunity for all employees and applicants. We encourage you to apply if you feel you have the transferrable skills to be successful in this position and we look forward to reviewing your application.
Current Employee? Click here (https://performancemanager8.successfactors.com/sf/careers/jobsearch?bpltecompany=indianaoff) to apply.