Senior Oracle Database Administrator

State of Indiana; Indianapolis (IN); Presencial; USD 63.000 - 77.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical plans

Wellness program

HSA contributions

Pension plans

Paid leave program

Education reimbursement

LinkedIn Learning access

Free parking

Descripción de la vacante

The State of Indiana, through the Indiana Office of Technology, seeks a Senior Oracle Database Administrator to ensure data integrity, security, and performance of Oracle databases. This onsite role in Indianapolis requires loading, upgrading, and tuning the database stack while supporting the broader IT ecosystem.

With 7+ years of relevant experience, you will mentor junior DBAs, implement RAC/ASM/OEM/GoldenGate solutions, and collaborate with developers and IT staff.

Formación

• Expert in administering multi-terabyte Oracle databases with 24x7 uptime.
• Experience with Oracle RAC, ASM, RMAN, OEM, and GoldenGate.
• Strong capacity planning, disaster recovery, and data warehouse concepts.

Responsabilidades

• Lead design and maintenance of high-availability Oracle database systems.
• Tune performance via indexing, SQL optimization, and resource management.
• Develop and maintain backup/recovery plans to protect data integrity.
• Enforce robust security measures and monitor for breaches.
• Provide documentation and mentorship to junior DBAs.
• Collaborate with developers, sysadmins, and stakeholders on new projects.

Conocimientos

Oracle DBA expertise

24x7 uptime

Security & integrity

Performance tuning

Team collaboration

Herramientas

Oracle RAC

ASM

RMAN

OEM

GoldenGate

Descripción del empleo

Work for Indiana

Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a 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.

Work for Indiana

Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a 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.

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.

Role Overview

The Senior Oracle Database Administrator ensures data integrity, security, and stability of Oracle databases. You will provide the knowledge needed to maintain and support current technologies and promote future growth within the Oracle Database stack. You will monitor and tune database performance to ensure data is appropriately protected via database backup and related strategies. The Administrator loads, or assists in loading, database software, upgrades, and patches. You will assist with evaluating and selecting infrastructure components and provide operation support for the database, ensuring data integrity, availability, and performance.

This is an onsite role at the Indiana Government Center in Indianapolis, Indiana.

Salary

The salary for this position traditionally starts at $70,122.00 but may be commensurate with education and work experience. Use our Compensation Calculator to view the total compensation package.

A Day In The Life

The essential functions of this role are:

• Lead the design, development, deployment, and maintenance of complex database systems to ensure high availability and quality.
• Develop and implement strategies for database performance tuning, and optimization of database systems, including indexing, query optimization, and resource management.
• Develop, manage, and enhance backup and recovery strategies to protect data integrity and availability.
• Implement and enforce robust database security measures, including access controls and monitoring for potential security breaches.
• Ensure data integrity, accuracy, and consistency across databases through regular audits, validations, and quality checks.
• Provide advanced support to end-users, diagnose and resolve complex database-related issues on database-related issues and queries.
• Create and maintain detailed documentation of database configurations, policies, and procedures.
• Work closely with developers, system administrators, IT staff, and other stakeholders to design and implement new database-related 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.

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.

Required

What You'll Need for Success:

• Expert in administering multi-terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure Database Administrator.

Expertise In

• Software and utilities related to supported DBMS such as Reorg, Backup, Recovery. Load, and Unload.
• Capacity planning and disaster recovery.
• Relational databases and data warehouse design techniques and dimensional modeling processes.
• Features such as Oracle Real Application Clusters (RAC), Automatic Storage Movement (ASM), Active Data Guard, Oracle Enterprise Manager (OEM), and Golden Gate replication.

Additional Qualifications

• Self-starter with excellent communication skills.
• Ability to work seamlessly in a team environment including DBA team, developers, and systems owners.
• Strong knowledge and skills working with Oracle versions 11gR1/2, 12c, and 19c in a Microsoft Windows and Linus environment.
• Strong understanding of database architecture and performance tuning.
• Experience with virtualization platforms such as VMware and Citrix.
• Experience with Oracle Recovery Manager (RMAN).
• Ability to perform essential functions with or without reasonable accommodation.

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

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 benefits package for full-time employees that 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
• 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 in 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. 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. If you require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at [e-mail] .