Oracle Database Administrator (Database Admin Specialist 3)

State of Ohio; Kentucky; On-site; USD 96,000 - 141,000; Full time

Benefits offered by this job

Medical Coverage

Paid time off

Job summary

The Ohio Department of Job and Family Services (ODJFS) is seeking an Oracle Database Administrator to support enterprise data platforms. The role focuses on Oracle and OCI, designing resilient databases, implementing security controls, and collaborating with cross-functional teams.

Location options include Columbus, Akron, or Dayton with travel within Ohio. Strong emphasis on reliability, performance, and cost optimization across diverse platforms.

Qualifications

• Experience designing and managing Oracle database environments.
• Knowledge of Oracle Data Guard, Golden Gate, and Oracle Cloud Interface.
• Experience with capacity planning and performance tuning of databases.

Responsibilities

• Manage Oracle database environments with Oracle Data Guard and Golden Gate.
• Virtualize infrastructure across Unix, Linux, and AIX OS.
• Design, develop, and integrate complex database systems for internal/external users.
• Plan capacity and resource expansion to ensure scalability.
• Ensure best practices in database planning, design, configuration, and resilience.
• Lead incident resolution and drive corrective actions; perform root cause analysis.

Skills

Database Administration

Information Technology

Analyzation

Innovation

Strategic Thinking

Written Communication

Continuous Improvement

Tools

Oracle Database

Microsoft SQL Server

IBM IMS

IBM Db2

Job description

Job Description - Oracle Database Administrator (Database Admin Specialist 3) (260006HG)

Oracle Database Administrator (Database Admin Specialist 3) ( 260006HG )

Organization

Job & Family Services

Agency Contact Name and Information : [e-mail]

Unposting Date

Ongoing

Primary Location

United States of America-OHIO

Compensation : $44.66

Schedule

Full-time

Union : OCSEA

Primary Job Skill

Database Administration

Technical Skills : Database Administration, Information Technology

Professional Skills : Analyzation, Innovation, Strategic Thinking, Written Communication, Continuous Improvement

Primary Technology : ORACLE

Agency Overview

Who We Are

The Ohio Department of Job and Family Services (ODJFS) supports Ohioans and their families through the following programs:

• Cash and Food Assistance
• Employment Services and Workforce Development
• Unemployment Insurance
• Adult Protective Services
• Child Support

Public service is an honorable way to serve the community in a hands-on dedicated way. You can make a difference in someone’s world!

Guiding Principles

• We will be a leader in customer satisfaction.
• We will have a reputation that attracts and retains talented, diverse, and dedicated employees.
• We get better at what we do every day.

Job Description

Office of Information Services

The Office of Information Services (OIS) works to support the business functions and the delivery of health, human, and employment services through the application of information technology. OIS supports the delivery of programs to millions of recipients through the development and round-the-clock operation of automated information systems. Due to the number of end-users and technologies supported, OIS is one of the largest and most complex IT organizations within Ohio state government. Learn more about the Office by visiting the ODJFS OIS webpage .

What You Will Do

The Ohio Department of Job & Family Services (ODJFS) is strengthening its enterprise data capabilities and is seeking a dedicated Oracle & Oracle Cloud Infrastructure (OCI) Database Administrator to support our expanding database environment. This is a unique opportunity to help shape and optimize the agency's mission-critical data platforms, working alongside experienced database professionals across multiple technologies.
This role is ideal for someone with strong foundational Oracle and OCI expertise and a passion for high-quality database design, reliability, and security. You will play a key role in designing and supporting resilient database solutions, implementing best-practice security controls, and collaborating with technical teams as we continue to modernize our data footprint.
You will work closely with fellow database administrators across several platforms, including Oracle Database, Microsoft SQL Server, IBM Information Management System (IMS), and IBM Db2, ensuring ODJFS applications are supported by stable, secure, and well-architected data environments.

Duties include but are not limited to:

• Manage Oracle database environments including Oracle Data Guard Broker, Oracle Golden Gate processes, and Oracle Cloud Interface.
• Virtualize infrastructure running various Unix, Linux, and AIX operating systems.
• Design, develop, and integrate highly complex database systems for internal and external users/clients.
• Plan and implement capacity and resource expansion to ensure scalability of databases.
• Ensure best practices in database planning, design, configuration, performance, and resilience.
• Evaluate and propose design and process improvements to achieve performance and cost optimization.
• Implement effective risk management controls and own adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control).
• Plan and participate in disaster recovery exercises, system failover planning, and testing.
• Lead incident resolution efforts and engage appropriate resources to complete corrective actions as quickly as possible.
• Manage root cause analysis and problem management activities for continuous improvement initiatives, incident reduction, and performance enhancements.
• Provide technical expertise in the development of technical, structural, and organizational specifications. Determine appropriateness of data for storage and optimum storage organization.
• Create, document, and implement standards and/or complex modeling to monitor and enhance the capacity and performance of the database. Code complex programs and derive logical processes on technical platforms.
• Provide technical leadership that fosters database innovation and champions automation.

Schedule: Full-time.

Hours: Standard workdays are Monday through Friday. Hours are between 7:00 a.m. and 6:00 p.m.

Location: This position will be headquartered in an ODJFS Facility in one of the following cities - Columbus, Akron, or Dayton. This determination will take into account the proximity to the applicant's home address.

Rhodes State Officer Tower - 30E Broad Street, Columbus, OH 43215
Akron - 172 S. Broadway Street, Akron, OH 44308
Dayton - 6680 Poe Avenue, Dayton, OH 45414

Travel: Occasional travel within the state of Ohio.

PN(s): 20038893.

Why Work for the State of Ohio

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits, visit our Total Rewards website ! Our benefits package includes:

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) &Optional Deferred Compensation ( Ohio Deferred Compensation )

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

The ideal candidate, at minimum, must have the following:

OPTION 1

• 60 months of combined work experience in any combination of the following: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems;
• AND 12 months of work experience in the primary technology specified by the agency in the position description & job posting (Oracle).

OPTION 2

• Completion of associate core program in computer science or information systems;
• AND 42 months combined work experience in any combination of the following: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems;
• AND 12 months work experience in the primary technology specified by the agency in the position description & job posting (Oracle).

OPTION 3

• Completion of undergraduate core program in computer science or information systems;
• AND 36 months combined work experience in any combination of the following: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems;
• AND 12 months work experience in the primary technology specified by the agency in the position description & job posting (Oracle).

OPTION 4

• Equivalent of minimum class qualifications for employment noted above.

Tips For Your Application

When completing the different sections of this application, be sure to clearly describe how you meet the minimum qualifications outlined in this job posting. We cannot give you credit for your Work Experience and Education & Certifications if you do not provide that information in your online application. Information in attached resumes or cover letters must be entered into your application in the appropriate Work Experience or Education & Certification sections to be considered.

Pay Information

This position is in the State of Ohio’s OCS EA Pay Schedule, Pay Range 36. Unless required by legislation or union contract, starting salary will be the minimum salary of that pay rang e (step 1, currently $46.00per hour). The se ranges provide a standardized pathway for pay increases. With continued employment, new hires move to the next step in the range after 6 months and annually thereafter. Cost of Living Adjustments increase wages in these ranges each fiscal year. The current step progression wages are in the table below.

Pay Range 36

Step 1

$46.00

Step 2

$48.28

Step 3

$50.66

Step 4

$53.13

Step 5

$55.72

Step 6

$58.55

Step 7

$61.46

Step 8

$64.52

Step 9

$67.75

Hourly

$46.00

$48.28

$50.66

$53.13

$55.72

$58.55

$61.46

$64.52

$67.75

Annual

$95,680

$100,422

$105,373

$110,510

$115,898

$121,784

$127,837

$134,202

$140,920

Months of Employment

At Hire

6 Months

18 Months

30 Months

42 Months

54 Months

66 Months

78 Months

90 Months

Supplemental Information

ADA Notice

If you require an accommodation based on a disability for any step of the selection process, please contact [e-mail] .

Selection Priority Notice

Current employees of ODJFS in the OCSEA union have selection rights before all other applicants. Applications from all other candidates will only be considered if an internal OCSEA applicant is not selected for this position.

Background check information

The final candidate selected for this position will be required to undergo a criminal background check. Some positions may require drug testing and/or fingerprinting. Criminal convictions do not necessarily disqualify candidates from consideration.

Sponsorship/H-1B Information

This position is not eligible for sponsorship.

Selection Process Information

Final candidates will be required to participate in an in-person assessment at 30 E Broad St, Columbus OH 43215 prior to offer of employment.

ADA Statement

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

Drug-Free Workplace

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.