Database Administration Specialist 2, Office of Database, PN 20064563

High Availability Architecture: Designs and configures high-availability solutions, including cluster nodes, standby servers, log shipping, and replication to ensure maximum system uptime. BI & Data Warehousing: Manages ETL processes using SSIS for SQL Server to handle data replication, transformation, and monitoring of warehouse data loads. Performance Optimization: Tunes system configurations and data models across various platforms to improve efficiency and performance. Standards & Security: Establishes data exchange standards, defines security models, and maintains comprehensive technical documentation. Strategy & Mentorship: Develops database strategies that align with business requirements and provides technical guidance and mentorship to colleagues. Additional Information

This position is overtime eligible based on FLSA Standards.

All bargaining unit new hires must serve a one (1) year probationary period.

Position will be filled pursuant to the provision of the OCSEA/AFSCME Contract.

The final candidate selected for this position will be required to undergo a criminal background check. 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, Job Skills: Database Administration 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.

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

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)