Database Administration Specialist 2

Job Title Database Administration Specialist 2 (260003DY) Organization Taxation Work Location Northland 1st Floor 4485 Northland Ridge Boulevard Columbus 43229 Primary Location United States of America-OHIO-Franklin County-Columbus Compensation $40.59-$59.70 Schedule Full-time Union

OCSEA

Primary Job Skill Database Administration Technical Skills Information Technology Professional Skills Adaptability, Problem Solving, Teamwork Primary Technology SQL Server Agency Overview Creating a seamless and user‑centric experience for all Ohio Taxpayers Job Description 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. We are seeking to fill one Database Administration Specialist 2 position in the Information Technology Division. Responsibilities 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 Accommodation To request a reasonable accommodation due to disability for the application or interview process, please contact ADA Coordinator J.D. Hawkins by phone: View phone number on click.appcast.io or by email to View email address on click.appcast.io. Position Description A full Position Description will be provided during the interview process. 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 (e.g., OPERS, STRS, SERS, HPRS) and optional Deferred Compensation (Ohio Deferred Compensation) Qualifications 60 months combined work experience involving 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. Or completion of an associate core program in computer science or information systems, with 42 months combined work experience involving 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. Or completion of an undergraduate core program in computer science or information systems, with 36 months combined work experience involving 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. Or equivalent minimum class qualifications meeting the stated experience requirements. Technical Skills: Information Technology Professional Skills: Teamwork, Problem Solving, Adaptability Supplemental Information The final selected candidate will be required to undergo a criminal background check. Section 2961 of the Ohio Revised Code prohibits individuals convicted of a felony, including but not limited to fraud, deceit, or theft, from holding a position that has substantial management or control over the property of a state agency. Additionally, Section 5703.081 of the Ohio Revised Code requires Ohio Department of Taxation employees to promptly file and pay tax returns. 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. Drug‑Free Workplace The State of Ohio is a drug‑free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). 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. #J-18808-Ljbffr State of Ohio