Database Administration Specialist 2

Position Qualifications

The ideal candidate, at minimum, must have the following\:

Alternative 1\:

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.

Alternative 2\:

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.

Alternative 3\:

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.

Alternative 4:

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.

Primary Technology\: SQL Server

Technical Skills: Information Technology, Database Administration

Professional Skills: Critical Thinking, Customer Focus, Decision Making, Written Communication

Required Educational Transcripts

Official transcripts are required for all post-secondary education, coursework, or degrees listed on the application. Applicants must submit an official transcript before receiving a formal employment offer. Failure to provide transcripts within five (5) business days of the request will result in disqualification from further consideration. Transcripts printed from the institution’s website will not be accepted. OhioMHAS reserves the right to evaluate the academic validity of the degree-granting institution.

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.

Application Procedures

To be considered for this position, you must apply online through this posting website (careers.ohio.gov). We no longer accept paper applications. When completing your online Ohio Civil Service Application, be sure to clearly describe how you meet the minimum qualifications outlined on this job posting. We will not give credit for your qualifications, experience, education, and training in the job selection process if there is no evidence provided on your application. In addition, “see resume” is not a substitution for completing supplemental questions. Answers to the supplemental questions must be fully supported by the work experience/education sections of your application. You may check the status of your application by signing into your profile on this website (careers.ohio.gov). We will communicate with you through the email you provided in your profile and job application. Be sure to check your email regularly.

Background Check Notice

The final candidate selected for this 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.

If you require a reasonable accommodation for the application process, assessment &/or interview, please contact Andrew Seifert, EEO/ADA Administrator at or .

What you’ll do at OhioMHAS:

OhioMHAS Information Services is the technology arm of the third largest cabinet level agency in the state of Ohio. We develop and support technology for several critical business solutions used by the agency as well as by county and local behavioral health care providers across the state. We are seeking a highly skilled and motivated Database Administration Specialist 2, primary technology SQL Server, to join our IT team. This position is responsible for advanced-level database management, including performance tuning, data modeling, business intelligence support, disaster recovery, and technical mentorship.

The ideal candidate will possess deep knowledge of database systems and be capable of collaborating across teams to support scalable, secure, and efficient data environments.

Key Responsibilities:

Database Performance & Configuration\: Tune DBMS systems running on a single platform for optimal performance. Perform load testing and ensure scalability of database systems. Provide Tier II database support for issue resolution. Design and maintain data models and create entity relationship diagrams (ERDs). Conduct data normalization and write platform-specific code for data migrations. Monitor load balance and tune cluster parameters to maintain high availability and performance. Participate in the Change Review Board to assess and implement changes. Troubleshoot and resolve database performance and configuration issues.

Business Intelligence & Data Warehousing: Monitor and tune data warehousing processes and business intelligence performance. Support business intelligence activities and data analytics processes. Design and implement disaster recovery plans, including restoration of malicious deletions and system recovery. Manage data archiving, backup, and restore processes.

Technology Research & Standards Development\: Stay current with emerging technologies and research enhancements that align with business needs. Conduct proofs of concept and develop business cases for adopting new database technologies. Develop, document, and implement standards and best practices for installation, monitoring, security, configuration, and migration.

Business Analysis & Client Collaboration\: Collaborate with clients, business analysts, system programmers, and application developers to resolve data flow and content issues. Translate business requirements into effective, platform-specific database solutions. Develop database strategies to support evolving business goals. Participate in project planning using best practices in database design and administration. Provide informal mentorship to peers and junior staff through documentation, conversation, or technical guidance.

This is an hourly position covered by the OCSEA/AFSCME bargaining unit (union), with a pay range of 35 on the OCSEA Pay Range Schedule. Normal working hours are 1st shift (8\:00am to 5\:00pm). This position is located within our Office of Information Technology, headquartered at the James Rhodes State Office Tower, 30 East Broad Street, 33rd floor, Columbus, Ohio 43215.

Unless required by any applicable union contract and/or requirements of the Ohio Revised Code, the selected candidate will begin at Step 1 of the pay range schedule listed above, with an opportunity for pay increase after six months of satisfactory performance and then a yearly raise thereafter.

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.

Database Administration Specialist 2

Central Office

Who we are:

At the Ohio Department of Mental Health and Addiction Services (OhioMHAS), we strive to exemplify The Heart of Hope for individuals and families affected by mental health and substance use disorders.

We proudly employ over 2,800 dedicated employees across our six inpatient behavioral health hospitals, Ohio Pharmacy Services, Ohio's prison systems and the central office located in the James A. Rhodes State Office Tower in Columbus, OH.

OhioMHAS Values:

Service-Oriented (Person Centered, Solution Oriented, Customer Service Focused)

Collaborative (Approachable, Reasonable, Transparent)

Value Driven

Innovative (Yes Before No)

Strong Sense of Urgency

Our team of highly qualified professionals advances a critical system of behavioral healthcare in Ohio that helps people be well, get well, and stay well. Join our collaborative, service-oriented environment, where you will be respected and valued.

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.