Database Administration Specialist 2 (20044475)

State of Ohio • Columbus, OH

11d • Onsite

About The Position

The Ohio Environmental Protection Agency is seeking a Database Administration Specialist 2 for its Office of Information Technology Services in Columbus, Ohio. This role is crucial for maintaining the integrity and performance of the agency's database systems, ensuring compliance with environmental laws and supporting public health initiatives. The State of Ohio is a drug-free workplace and may have additional restrictions related to marijuana use. This position is also part of Ohio's Disability Inclusion initiative, promoting accessibility and reasonable accommodations.

Requirements

• 60 months 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 months work experience in the primary technology specified by the agency.
• Associate core program in computer science or information systems; AND 42 months 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 months work experience in the primary technology specified by the agency.
• Undergraduate core program in computer science or information systems; AND 36 months 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 months work experience in the primary technology specified by the agency.
• Equivalent of minimum class qualifications for employment.
• Experience in the required, primary technology listed in the position description & job posting.

Nice To Haves

• Database Administration
• Information Technology
• Cybersecurity
• Equipment Operations
• Leading Others
• Customer Focus

Responsibilities

• Conduct performance tuning and configuration of DBMS systems running on a single platform.
• Design and maintain various versions of data models.
• Participate in the Change Review board.
• Create Entity Relation Diagrams (ERD) and conduct data normalization.
• Write platform-specific code.
• Perform data migrations.
• Monitor business processes and warehouse processes.
• Report on business intelligence.
• Research product enhancements and capabilities.
• Stay current with emerging technologies.
• Work closely with clients, business analysts, and software development staff to define and resolve information flow and content issues.
• Develop knowledge of principles, theories, practices, and techniques for project planning.
• Answer questions and present to peers and staff.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree