Database Administration Specialist 2 (20044475)

State of Ohio
Columbus, OH, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$86,965.0 - $127,899.0
Working hours
Regular working hours
Job source

Tech stack

Multitier Architecture Cyber Security Information Systems Databases Data Normalization Performance Tuning Software Engineering Information Technology

Job description

The Ohio Environmental Protection Agency wants you to be our newest database admin spec in our Office of IT Services located at our Central Office in beautiful downtown Columbus, Ohio.

Finally. There you are!

As a database admin spec, you will conduct performance tuning and configuration and tune DBMS systems running on a single platform. You will design and maintain various versions of data models and participate in the Change Review board. You will create Entity Relation Diagrams (ERD) and conduct data normalization and write platform specific code.

You will perform data migrations and business process monitoring, report business intelligence, and monitor warehouse processes. You will research product enhancement and capabilities and stay current with emerging technologies. You are going to work closely with clients and business analysts and software development staff to define and resolve information flow and content issues.

You will also develop knowledge of principles, theories, practices, and techniques for project planning - and answer questions and present to peers and staff.

Let’s recap:

  • Conduct performance tuning and configuration and tune DBMS systems running on single platforms.
  • Design and maintain versions of data models.
  • Participate in Change Review board.
  • Create Entity Diagrams (ERD) and conduct data normalization, writing platform specific code.
  • Perform data migrations and business process monitoring.
  • Develop knowledge of principles, theories, practices, and techniques for project planning.

Requirements

  • 60 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support 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; AND 42 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support 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; AND 36 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support 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, Information Technology, Cybersecurity, Equipment Operations, Leading Others, Customer Focus

Benefits & conditions

Pulled from the full job description Loan forgiveness Health insurance Paid time off Vision insurance Dental insurance Life insurance Paid holidays, 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)

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:47 min

Exploring career opportunities and recruitment open positions

Kurt Eder · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

4:11 min

Introduction to cloud-native application developer security

Micah Silverman · WWC 2022

3:02 min

Formatting and normalizing data into tensor structures

Håkan Silfvernagel · LIVE

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all