Database Administration Specialist 1 - PN

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.

36 mos. combined work experience in any combination of the following\: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.

-Or completion of associate core program in computer science or information systems; 18 mos. combined work experience in any combination of the following\: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.

-Or completion of undergraduate core program in computer science or information systems; 12 mos. combined work experience in any combination of the following\: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.

-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.

Job Skills: Database Administration

Technical Skills\: Application Design, Computer Literacy, Data Analytics, Database Administration

Professional Skills\: Adaptability, Analyzation, Critical Thinking, Attention to Detail, Time Management

The Ohio Industrial Commission (OIC), Office of Information Technology, is seeking a talented Database Administration Specialist 1. The ideal candidate will design and implement processes for the efficient transfer of (ETL/ELT) between systems within and outside the agency; design and develop dashboards, summaries and visualizations using agency data and solutions such as MS Power BI; and assist with data model designs and physical data model implementations. Additionally, this position will assist with the development and maintenance of OIC’s data warehouse using cloud solutions such as Snowflake and Azure Data Factory. At the full performance level of the position, the candidate should be able to collaborate with systems administrators to set table access security, provide some data governance, write platform specific code for data migrations and visualizations (Python, SQL, Java, Dax), and monitor cloud and on-premise databases and stores utilizing logs, load test results, and performance monitoring tools. A strong knowledge of RDBMS tools such as MS SQL Server and schemaless/no-SQL solutions is required. This role demands a solid understanding of agency business processes, along with strong organizational, problem-solving, and communication skills.

Under the direction of the Information Technology Supervisor, advises & consults with users on accessing various databases & to resolve data conflicts & inappropriate use of data.

Resolves Tier I issues.

Promotes system security & awareness by adhering to the Agency’s &/or State’s IT security policy(s) & standards.

Provides performance tuning for query language statements.

Reads & interprets query plans. Provides monitoring using vendor supplied & 3rd party utilities. Restores from disaster recovery plan.

Monitors disaster recovery plan.

Sets security & validates all updates through database connections.

Collaborates with system administrator to set table access security.

Assists with data model design Implements physical data models.

Assists with tuning a single RBMS system on a single platform.

Assists with writing platform specific code.

Designs & implements processes for the efficient transfer of data (ETL/ELT).

Monitors data transfer processes.

Resolves data conflicts & inappropriate use of data. Provides ETL & data warehouse support.

See the attached position description for more details regarding this position.

This position is filled through an assessment consisting of a structured interview. The interview will be administered in person at the William Green Building in Columbus, Ohio.

This position may require travel, therefore the person occupying this position must be able to provider his/her own transportation &/or legally operate a state-owned vehicle.

The hourly wage for this position is not negotiable. For applicants who are not current State of Ohio employees, the starting wage will be the hourly rate listed on this posting. Successful employees will move up a step in the salary range within one year, and in most cases within four to six months, with subsequent step increases occurring annually.

For internal applicants, the position will be filled pursuant to legislation or the provision of the OCSEA/AFSCME Contract.

ADA Statement\: The Industrial Commission 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. To request a reasonable accommodation due to a disability please contact the ADA Coordinator, at (voice) or by email to\:, as-soon-as possible but at least 14 days prior to the scheduled event

Background Check Information Statement\: The final candidate selected for the position will be required to undergo a criminal background check. Criminal convictions do not necessarily preclude an applicant from consideration for a position. An individual assessment of an applicant's prior criminal convictions will be made before excluding an applicant from consideration.

Our mission is to serve injured workers and Ohio employers through expeditious and impartial resolution of issues arising from workers’ compensation claims and through the establishment of adjudication policy.

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.

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.