Database Administration Specialist 2

About the role

The Ohio Department of Taxation seeks to fill one (1) Database Administration Specialist 2 position in the Information Technology Division. This position involves designing, developing, testing, implementing, and supporting complex platform-specific ELT code using tools such as Python, SQL, Snowflake, StreamSets, AWS Glue, and SAS. It also includes performing data migrations, designing business process monitoring solutions, supporting development, UAT, performance, and production environments, implementing high-availability and disaster-resilient solutions, monitoring load balancing, tuning system parameters, providing Tier II technical support for database and ELT issues, defining and supporting Data Warehouse business intelligence designs, building and supporting enterprise reporting, dashboards, scorecards, and analytic applications, developing and maintaining documentation, creating trouble tickets, and collaborating with leadership to design solutions that meet enterprise requirements and support evolving business needs.

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.
• Maintain and 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.
• Create, monitor, and resolve trouble tickets, ensuring timely updates and communication of remediation progress.

Requirements

• 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.
• Completion of an 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.
• Completion of an 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.
• Equivalent of minimum class qualifications for employment noted above, with the official position description on file with the designated agency listing the required, primary technology directly relating to the duties of the position.

Qualifications

• Information Technology Professional Skills: Teamwork, Problem Solving, Adaptability.

Skills

• Technical Skills: SQL Server; Secondary Technology: Oracle, Snowflake.

Benefits

• 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.
• Opportunities for career advancement.

Pay

$40.59 - $59.70 per hour

Schedule

Full-time

Contact

Katie Schuler - Katie.Schuler@tax.ohio.gov