Database Administration Specialist

Job Title

Database Administration Specialist 2 (260003DY)

Taxation

Northland 1st Floor 4485 Northland Ridge Boulevard Columbus 43229

United States of America-OHIO-Franklin County-Columbus

$40.59-$59.70

Full-time

OCSEA

Database Administration

Information Technology

Adaptability, Problem Solving, Teamwork

SQL Server

Creating a seamless and user‑centric experience for all Ohio Taxpayers

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.

• Design, develop, test, implement, and support complex platform‑specific ELT code using tools such as Python, SQL, Snowflake, Stream Sets, 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: 614‑387‑1782 or by email to Accessibilityo.gov.

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

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

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