Oracle Database Administrator; Database Admin Specialist

Overview

The Office of Information Services (OIS) supports the business functions and 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. Learn more about the Office by visiting the ODJFS OIS webpage.

The Ohio Department of Job & Family Services (ODJFS) is strengthening its enterprise data capabilities and is seeking an 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 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.

• 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 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 quickly.
• 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. The determination will consider proximity to the applicant s home address. Addresses include:
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): .

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…