Oracle Database Manager

State of Indiana•Indianapolis, IN

1d•Onsite

About The Position

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. The Oracle Database Manager leads and oversees the administration, integrity, security, and performance of enterprise Oracle database environments. This role is responsible for managing a team of database professionals, guiding architectural decisions, ensuring compliance with standards, and optimizing database operations to support organizational goals. The Oracle DBA Manager collaborates closely with application teams, infrastructure groups, security, and business stakeholders to deliver highly available and scalable Oracle database solutions. They provide strategic direction and hands‑on expertise to maintain current platforms, modernize legacy systems, and support future growth across mission‑critical workloads.

Requirements

Broad knowledge of cost project management, benefit analysis, risk analysis, risk determination, budgeting, funding, and estimation resources.
Broad knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load, Unload.
Broad knowledge of capacity planning and disaster recovery.
Broad knowledge of relational database and/or data warehouse design techniques and dimensional modeling processes.
Broad knowledge of computer hardware/software capabilities and configurations.
Basic knowledge of computer programming, including computer languages and testing of programs.
Broad knowledge of data communications, including networking, Mainframe Connectivity, and Communications Server.
Broad knowledge of the most recent technical developments in the database administration field.
Ability to perform logic analysis.
Ability to read and understand complicated technical manuals.
Ability to apply theories, principles and methodologies to existing computer software.
Ability to supervise and manage diverse human resources.
Ability to lead, encourage and influence others to perform.
Ability to communicate effectively orally and in writing.
Working knowledge of database systems development, information technology, computer terminology, systems analysis and design, programming, and tools and approaches to systems analysis and design.
Thorough knowledge of database project management theories and practices.
Ability to delegate work, set clear direction, and manage workflow.
Ability to effectively give feedback, provide guidance or corrective action, coach, and develop employee skillsets.
Individuals should have the ability to perform essential functions with or without reasonable accommodation.

Nice To Haves

A degree is not required. However, at least 11+ years of experience applying the outlined knowledge, skills, and abilities in a similar role may be considered.

Responsibilities

Plans, manages, organizes, and controls all operations and activities of agency database projects.
Ensures that supported databases have well documented maintenance plans and recovery procedures and that qualified staff are available to maintain current database systems.
Evaluates and selects infrastructure components.
Consults with agency users on functional aspects of requirements, schedules, and implementation strategy.
Determines staffing needs and arranges for manpower assignments to meet schedule requirements.
Creates and maintains a team atmosphere and work environment to promote project work productivity.
Ensures concurrence with organization’s standards and procedures including system development methodology, design and programming standards, reporting standards, work standards.
Reviews and approves database project documentation, measures progress against project schedule and budget, takes corrective action and resolves issues as appropriate.
Prepares database project activity and status reports regarding the database management section and advises higher level management of problem areas requiring their action.
Engages with agency management to discuss project status, prioritization of changes and/or enhancements, and project concerns.
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.

Benefits

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