Une candidature complète en une minute
Un CV et une lettre de motivation personnalisés, prêts à envoyer.
The Ohio Industrial Commission (OIC), Office of Information Technology, is seeking talented Database Administration Specialists. The ideal candidates will design and implement ETL/ELT processes between systems; design and develop dashboards, summaries and visualizations using Power BI; and assist with data warehouse development using Snowflake and Azure Data Factory.
At full performance, candidate should collaborate with system administrators to set access security, provide data governance, and
Organization: Industrial Commission
Agency Contact Name and Information: Human Resource, 614-466-2765
Work Location:
30 West Spring Street, 9th Floor
Columbus, Ohio, 43215-2233
United States
Compensation: $34.53, (Step 1)
Schedule: Permanent - Full Time
Work Hours: 8:00 am - 5:00 pm
Classified Indicator: Classified
Union: OCSEA
Primary Job Skill: Database Administration
Primary Technology: MS SQL Server
The OhioIndustrial Commission's mission is to serve the injured workers and Ohioemployers through expeditious and impartial resolution of issues arising from workers' compensation claims and through the establishment of adjudicationpolicy.
The Ohio Industrial Commission (OIC), Office of Information Technology, is seeking talented Database Administration Specialist 1's. The ideal candidates 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.
Review the attached position description for more details regarding this position.
This is an on-site position and in-office presence is required.
This position may require travel; therefore, the person occupying this position must be able to provide 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.
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 614-466-2765 (voice) or by email to: diversity@ic.ohio.gov, 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.
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:
*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 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, DatabaseAdministration
Professional Skills: Adaptability, Analyzation, Critical Thinking, Attention to Detail, Time Management
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.
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.