Database Administration Specialist 2

Schedule: Full-time

The Ohio Department of Taxation is responsible for the administration of individual and business taxes across the state. Guided by our Mission Statement, we are ONE TEAM providing education, innovation, outreach, and exceptional service to our customers through courtesy, accuracy, and responsiveness in each interaction. Taxation is committed to building a strong and skilled workforce. We invest in the development of each employee through comprehensive training, a competitive total compensation package that includes benefits (medical, dental, and vision insurance), tuition reimbursement, health and wellness programs, work-life balance initiatives, and opportunities for career advancement.

The Ohio Department of Taxation is seeking to fill one (1) Database Administration Specialist 2 position in the Information Technology Division.

What you’ll do as an Database Administration Specialist 2:

Design, develop, test, implement, and support complex platform specific ELT code using tools such as Python, SQL, Snowflake, StreamSets, AWS Glue and SAS.

Perform data migrations and design business process monitoring solutions; support development, UAT, performance and production environments.

Implement high availability and disaster resilient solutions across multiple data warehouse and reporting environments.

Monitor load balancing and tune system parameters to ensure optimal performance across databases (e.g., Sql Server, Oracle, Snowflake).

Provide Tier II technical support for database and ELT issues, including performance, availability, data integrity, security, and customer reported concerns.

Define and support Data Warehouse business intelligence designs; assist in implementing Data Warehouses and data marts.

Build and support enterprise reporting, dashboards, scorecards, and analytic applications (e.g., Python, R).

Develop and maintain documentation, including installation procedures, monitoring guides, security policies, configuration changes, and migration processes.

Collaborate with leadership to design solutions that meet enterprise requirements and support evolving business needs.

Create, monitor, and resolve trouble tickets, ensuring timely updates and communication of remediation progress.

Primary Technology: SQL Server ; Secondary Technology: Oracle, Snowflake

To request a reasonable accommodation due to disability for the application or interview process, please contact ADA Coordinator J.D. Hawkins by phone: or by email to: .

A full Position Description will be provided during the interview process.

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.

Technical Skills: Information Technology

Professional Skills: Teamwork, Problem Solving, Adaptability