Database Administration Specialist 2

State of Ohio • Columbus, OH

2d • Onsite

About The Position

The State of Ohio Department of Taxation is seeking to fill one (1) Database Administration Specialist 2 position in the Information Technology Division. This role is responsible for designing, developing, testing, implementing, and supporting complex platform-specific ELT code, performing data migrations, and supporting various environments. The position also involves implementing high-availability solutions, monitoring system performance, providing technical support for database and ELT issues, and defining/supporting Data Warehouse business intelligence designs. The role requires building and supporting enterprise reporting, dashboards, and analytic applications, as well as developing and maintaining documentation. Collaboration with leadership to design solutions that meet enterprise requirements is also a key aspect of this position. The State of Ohio is a drug-free workplace and prohibits the use of marijuana. This position may be subject to additional restrictions per the State of Ohio Drug-Free Workplace Policy (HR-39). A criminal background check will be conducted on the final candidate, and certain felony convictions may disqualify an individual from holding this position. Additionally, employees are required to promptly file and pay tax returns.

Requirements

• 60 months 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 months work experience in SQL Server.
• Completion of an associate core program in computer science or information systems; 42 months 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 months work experience in SQL Server.
• Completion of an undergraduate core program in computer science or information systems; 36 months 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 months work experience in SQL Server.
• Equivalent of minimum class qualifications for employment noted above.
• Experience in the required, primary technology (SQL Server) listed in the position description & job posting.
• Information Technology Professional Skills: Teamwork, Problem Solving, Adaptability

Nice To Haves

• Experience with Python, Snowflake, StreamSets, AWS Glue, SAS, Oracle.
• Experience with enterprise reporting, dashboards, scorecards, and analytic applications (e.g., Python, R).

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.

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 (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)
• Tuition reimbursement
• Health and wellness programs
• Work-life balance initiatives
• Opportunities for career advancement

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree