Database Administration Specialist 1 - PNs 20064742, 20064762

State of Ohio

Columbus (OH)

Sur place

USD 39 000 - 56 000

Plein temps

Il y a 2 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

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

Qualifications

  • 36 mos. combined work experience in database administration and Tier I support.
  • Experience with data modeling and performance tuning.
  • Proficiency with MS SQL Server and data governance.

Responsabilités

  • Design and implement ETL/ELT processes.
  • Develop dashboards and visualizations with Power BI.
  • Assist with data warehouse using Snowflake and Azure Data Factory.
  • Collaborate with system admins on security and data migrations.
  • Monitor databases and ensure data integrity.

Connaissances

Database Administration

Outils

MS SQL Server

Description du poste

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

Who We Are

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.

What You'll Do

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.

  • Provides performance tuning for query language statements.
  • Reads & interprets query plans.
  • 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.
  • Database security.

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

Additional Information

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.

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

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

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

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.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Database Administration Specialist 1
Database Administration Specialist 1

State of Ohio • Columbus (OH)

Sur place
USD 48 000 - 70 000
Medical Coverage
Dental & Vision Insurance
Paid Time Off
+1
Program Administrator 1 - PN 20063859 - Medical Services
Program Administrator 1 - PN 20063859 - Medical Services

State of Ohio • Columbus (OH)

Sur place
USD 32 000 - 45 000
Information Technology Manager 1
Information Technology Manager 1

Ohio Department of Behavioral Health • Columbus (OH)

Sur place
USD 41 000 - 69 000
Customer Service Assistant 1 -PNs 20065931, 20065928 - Cleveland
Customer Service Assistant 1 -PNs 20065931, 20065928 - Cleveland

State of Ohio • Cleveland (OH)

Sur place
USD 26 000 - 37 000
Medical Coverage
Paid time off
11 paid holidays per year
+1
Enterprise Modernization Manager (IT Manager 1)
Enterprise Modernization Manager (IT Manager 1)

State of Ohio • Columbus (OH), Akron (OH), North Dayton (OH)

Sur place
USD 56 000 - 79 000
Medical Coverage
Dental, Vision and Life Insurance
Paid time off + holidays
+1
Enterprise Modernization Manager (IT Manager 1)
Enterprise Modernization Manager (IT Manager 1)

State of Ohio • États-Unis

Sur place
USD 58 000 - 77 000
Information Technology Supervisor 3 (PN 20079216)
Information Technology Supervisor 3 (PN 20079216)

State of Ohio • Columbus (OH)

Sur place
USD 56 000 - 79 000
Customer Service Assistant 1 -PN 20065996 - Cincinnati
Customer Service Assistant 1 -PN 20065996 - Cincinnati

State of Ohio • Cincinnati (OH)

Sur place
USD 26 000 - 37 000
Information Technology Manager 1-PN 20064754- Information Technology
Information Technology Manager 1-PN 20064754- Information Technology

State of Ohio • Columbus (OH)

Sur place
USD 56 000 - 79 000
Information Technology Apprentice (Database Management)
Information Technology Apprentice (Database Management)

State of Ohio • Columbus (OH)

Sur place
USD 28 000 - 40 000
Medical Coverage
Dental/ Vision/ Life Insurance
Paid time off and holidays
+1