Database Administration Specialist 2

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note 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.

The Ohio Department of Taxationis 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 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 youll do as an Database Administration Specialist 2:

• Design develop test implement and support complex platformspecific ELT code using tools such asPython SQL Snowflake StreamSets AWS Glue and SAS.
• Perform data migrations and design business process monitoring solutions; support development UAT performance and production environments.
• Implement highavailability and disasterresilient solutions across multiple data warehouse and reporting environments.
• Monitor load balancing and tune system parameters to ensure optimal performance across databases ( Server Oracle Snowflake).
• Provide Tier II technical support for database and ELT issues including performance availability data integrity security and customerreported 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 ( 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.

The final candidate selected for the position 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 the Ohio Department of Taxation employees to promptly file and pay tax returns.

At the State of Ohio we take care of the team that cares for Ohioans. We provide a variety of quality competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits visit ourTotal Rewards website! Our benefits package includes:

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

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

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.

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

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