Database Analyst Senior

State of Indiana

Database Analyst Senior

Indianapolis ,

Indiana

Apply Now

Begin 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 Office of Technology (IOT):
The Indiana Office of Technology provides cost-effective, secure, consistent, reliable enterprise-technology services to our partner agencies so that they can better serve our mutual customer, the Hoosier taxpayer. IOT will also act as the technology and solution enabler for the State, helping its partner agencies achieve business objectives and innovation.
This position traditionally starts at an annual salary of $61,022. Salary for this position may be commensurate with education and job experience.
Role Overview:
The Database Analyst Senior supports Oracle databases to ensure data integrity, security, and stability. You will provide adequate computer resources and up-to-date software environment to our various customers. You will monitor and tune database performance to ensure that data is appropriately protected via database backup and related strategies. The position loads, or assists in loading of, database software, upgrade and patching. This position will assist with the evaluation and selection of infrastructure components and provide operational support for the database, ensuring data integrity, database availability, and performance. The Senior Database Analyst is needed to provide the degree of support that our agency customers currently expect and to meet their future needs.
A Day in the Life:
The essential functions of this role are as follows:
Develop and advise on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
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 to large 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.
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 should minimally have:
The candidate should be a self-starter, have excellent communication skills, and work seamlessly in a team environment as well as independently.
Teamwork is a key element of the position, not just with the DBA team, but also with the developers and system owners when resolving issues as well as when planning and executing application deployments, bug fixes, and database or system enhancements.
Strong experience working with Oracle versions 11gR1/2, 12c, and 19c in a Windows and/or Linux environment.
Good observational and analytical skills.
Strong understanding of database architecture and performance tuning.
Extensive experience with Oracle Database version 19c.
Experience with virtualization platforms such as VMware, Citrix, App-V, and Terminal Services.
Expert in administering various multi-terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure Database Administrator required.
Experience with features such as Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Active Data Guard, Oracle Enterprise Manager (OEM), and Golden Gate replication.
Experience with Oracle Recovery Manager (RMAN).
Experience with Oracle Enterprise Manager 13c.
Experience with performing and deploying database code objects to Test and Production.
Ability to manage database security, users, groups, roles, and permissions.
Experience with Oracle backup and recovery methodologies and their implementation.
Extensive knowledge of 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.
Ability to analyze, communicate, and recommend future needs and direction for the agency’s data processing software/hardware environment.
Supervisory Responsibilities/Direct Reports:
This role may provide direct supervision for one or more staff members.
Benefits of Employment with the State of Indiana:
The State of Indiana offers a comprehensive benefits 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
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
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 [email protected] .
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?bplte_company=indianaoff) to apply.

#J-18808-Ljbffr