Database Administration Specialist 3

Ohio Department of Insurance; Columbus (OH); On-site; USD 90,000 - 110,000; Full time

Job summary

Ohio Department of Insurance seeks a Database Administrator to design high-availability database solutions and optimize enterprise data environments in Columbus, OH. You will collaborate with IT leadership, developers, and business partners to ensure secure, scalable data systems while guiding database strategy.

The role requires strong Oracle, PL/SQL, SQL Server, and data warehousing expertise, with a focus on performance tuning and BI integration for enterprise reporting.

Qualifications

• 60 months combined experience designing high-availability database solutions and performance tuning.
• Experience with data warehousing concepts and BI environments.
• Strong knowledge of Oracle, PL/SQL, SQL Server and data modeling.
• Education alternatives include associate or undergraduate core programs as described.

Responsibilities

• Design and implement high-availability database solutions and performance tuning.
• Configure replication, log shipping, and standby servers for disaster recovery.
• Collaborate with IT leadership to design solutions and resolve Tier III issues.
• Define BI data needs and design data warehouses and data marts.
• Implement BI tools, dashboards, scorecards, and analytic apps.
• Develop standards and procedures for installation, monitoring, security, and migrations.
• Perform performance tuning across platforms including data models.
• Design secure data-exchange standards and align DB strategies with business.
• Mentor peers by providing guidance and training.

Skills

Oracle

PL/SQL

SQL Server

Data modeling

Enterprise data warehousing

Education

Associate degree in computer science or information systems

Undergraduate core program in computer science or information systems

Equivalent combination of education and experience

Job description

Position Overview

The Database Administrator (DBA) supports the agency’s enterprise data environment by designing high‑availability database solutions, developing data warehouse and business intelligence structures, optimizing system performance, and guiding database strategy. This role works closely with IT Architecture, CIO leadership, developers, and business partners to ensure secure, reliable, and scalable data systems. The position requires strong technical expertise in Oracle, PL/SQL, SQL Server, data modeling, and enterprise data warehousing concepts.

Key Responsibilities

• Design and implement high‑availability clustered database solutions, including hardware planning, node configuration, cluster ware installation, and performance tuning.
• Configure replication, log shipping, and standby servers to support business continuity and disaster recovery requirements.
• Collaborate with IT Architecture, the CIO, and IT Managers to design technical solutions, contribute to business case development, and resolve Tier III database issues.
• Define business intelligence data needs and design data warehouse and data mart structures to support enterprise reporting and analytics.
• Implement business intelligence tools, dashboards, scorecards, and analytic applications.
• Develop and document standards, best practices, and procedures for installation, configuration, monitoring, security, and system migrations.
• Perform performance tuning and configuration optimization across multiple platforms, including data manipulation models and multidimensional data models.
• Design standards for secure data exchange between systems and develop database strategies aligned with business needs.
• Serve as a mentor to peers and junior staff by providing technical guidance, documentation, and training.

Qualifications

• 60 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 a project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of database systems, including 12 months work experience in the primary technology specified by the agency in the position description & job posting.
• Or completion of an associate core program in computer science or information systems; 42 months combined work experience in the same areas as above, including 12 months work experience in the primary technology.
• Or completion of an undergraduate core program in computer science or information systems; 36 months combined work experience in the same areas as above, including 12 months work experience in the primary technology.
• Or equivalent of minimum class qualifications for employment noted above. Note: The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position. Only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.

Primary Technology

ORACLE

Location

50 W Town St, United States of America-OHIO-Franklin County-Columbus

Compensation

46.00