Senior Oracle Database Administrator

State of Indiana•Indianapolis, IN

2d•Onsite

About The Position

The Senior Oracle Database Administrator ensures the integrity, security, stability, availability, and performance of Oracle databases. The role maintains and supports current database technologies while promoting future growth within the Oracle Database stack. It monitors and tunes database performance, protects data through backup and recovery strategies, loads or assists with loading database software, upgrades, and patches, and supports evaluation and selection of infrastructure components. The position is onsite at the Indiana Government Center in Indianapolis, Indiana, with a traditionally starting salary of $70,122.00 that may be commensurate with education and work experience. A degree is not required; at least seven years of relevant experience in a similar role may be considered in place of one. The position leads the design, development, deployment, and maintenance of complex database systems and provides advanced support for database-related issues. It works with developers, system administrators, IT staff, and other stakeholders on database projects, maintains documentation, ensures compliance with vendor license agreements and industry regulations, and may provide guidance to junior administrators. The role may be used in a supervisory capacity based on agency needs.

Requirements

Expert-level experience administering multi-terabyte, 24x7-uptime Oracle databases as a Systems/Infrastructure Database Administrator.
Expertise with software and utilities for supported DBMS, including reorganization, backup, recovery, load, and unload.
Expertise in capacity planning and disaster recovery.
Expertise in relational databases, data warehouse design techniques, and dimensional modeling processes.
Expertise with Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Active Data Guard, Oracle Enterprise Manager (OEM), and GoldenGate replication.
Strong knowledge and skills with Oracle versions 11gR1/2, 12c, and 19c in Microsoft Windows and Linux environments.
Strong understanding of database architecture and performance tuning.
Experience with Oracle Recovery Manager (RMAN).
Self-starter with excellent communication skills.
Ability to work effectively in a team environment with the DBA team, developers, and systems owners.
Ability to perform essential functions with or without reasonable accommodation.
A degree is not required; at least 7 years of experience applying the outlined knowledge, skills, and abilities in a similar role may be considered.

Nice To Haves

Experience with virtualization platforms such as VMware and Citrix.

Responsibilities

Lead the design, development, deployment, and maintenance of complex database systems to ensure high availability and quality.
Develop and implement database performance-tuning and optimization strategies, including indexing, query optimization, and resource management.
Develop, manage, and enhance backup and recovery strategies to protect data integrity and availability.
Implement and enforce database security measures, including access controls and monitoring for potential security breaches.
Ensure data integrity, accuracy, and consistency through regular audits, validations, and quality checks.
Provide advanced end-user support and diagnose and resolve complex database-related issues and queries.
Create and maintain documentation of database configurations, policies, and procedures.
Work with developers, system administrators, IT staff, and other stakeholders to design and implement database projects and initiatives.
Ensure compliance with database vendor license agreements and industry regulations.
Provide guidance and mentorship to junior database administrators and other IT staff.
Maintain and support current Oracle technologies and promote future growth within the Oracle Database stack.
Monitor and tune database performance and protect data through database backup and related strategies.
Load, or assist in loading, database software, upgrades, and patches.
Assist with evaluating and selecting infrastructure components and provide database operations support.
Other duties, responsibilities, and activities may be assigned or changed at any time.

Benefits

Three medical plan options, including prescription coverage, plus vision and dental plans.
Wellness Rewards Program with gift card rewards for completed wellness activities.
Health savings account with a bi-weekly state contribution.
Deferred compensation 457(b) account with employer match.
Two fully funded pension plan options.
Leave policies including 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.
12 paid holidays, or 14 in election years.
Education Reimbursement Program.
Group life insurance.
Referral Bonus program.
Employee assistance program with covered behavioral health visits.
Qualified employer for the Public Service Loan Forgiveness Program.
Free parking for most positions.
Free LinkedIn Learning access.