Database Administration Specialist 2
State of Ohio · Columbus, OH
- On site
- Full-time
- $115,000 / year
- Columbus, OH
Job highlights
- Administer complex databases like SQL Server, Oracle, Snowflake.
- Develop and support ELT code using Python and SAS.
- Implement high-availability and disaster-resilient solutions.
- Provide Tier II technical support for database issues.
- Design and support data warehouse and BI solutions.
About the role
About the Ohio Department of Taxation
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.Database Administration Specialist 2 - Information Technology Division
The Ohio Department of Taxation is seeking to fill one (1) Database Administration Specialist 2 position in the Information Technology Division.What you’ll do as an Database Administration Specialist 2:
- 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 and Secondary Technologies:
- Primary Technology: SQL Server
- Secondary Technology: Oracle, Snowflake
Accommodation for Disabilities:
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: Accessibility@tax.ohio.gov.Additional Information:
A full Position Description will be provided during the interview process.Required Experience:
- 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: 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.
Technical Skills:
Information TechnologyProfessional Skills:
Teamwork, Problem Solving, AdaptabilityAgency Contact Information:
Katie Schuler - Katie.Schuler@tax.ohio.gov For all other inquiries please contact the HR Mainline at 614-466-3020 or email the staffing team at HRStaffing@tax.ohio.govUnposting Date:
May 20, 2026, 11:59:00 PMWork Location:
Northland 1st FloorPrimary Location:
United States of America-OHIO-Franklin County-ColumbusCompensation:
$40.59-$59.70Schedule:
Full-timeClassified Indicator:
ClassifiedUnion:
OCSEAAgency Overview:
Creating a seamless and user-centric experience for all Ohio TaxpayersKey skills/competency:
- Database Administration
- SQL Server
- Oracle
- Snowflake
- ELT Code Development
- Python
- Data Migration
- Performance Tuning
- Tier II Technical Support
- Data Warehouse Design
Skills & topics
- Database Administration
- SQL Server
- Oracle
- Snowflake
- ELT
- Python
- Data Migration
- Performance Tuning
- Tier II Support
- Data Warehouse
- Business Intelligence
- Information Technology
- Columbus, OH
- State Government
How to get hired
- Tailor your resume: Highlight experience with SQL Server, Oracle, Snowflake, Python, and ELT development. Quantify achievements in performance tuning and data migration.
- Address required experience: Clearly demonstrate 60 months of combined experience, with at least 12 months in SQL Server.
- Showcase technical skills: Emphasize your proficiency in Information Technology, database administration, and relevant tools.
- Prepare for interviews: Be ready to discuss your problem-solving approach, teamwork, and adaptability.
- Understand the role: Review the position description thoroughly and be prepared to discuss your understanding of the responsibilities.
Technical preparation
Master SQL Server performance tuning and configuration.,Gain hands-on experience with Python and ELT tools.,Familiarize yourself with Oracle and Snowflake databases.,Practice creating data models and supporting Tier II issues.
Behavioral questions
Describe a complex database problem you solved.,How do you ensure data integrity and security?,Explain your approach to collaborative problem-solving.,How do you manage multiple priorities and deadlines?
Frequently asked questions
- What are the primary responsibilities of a Database Administration Specialist 2 at the Ohio Department of Taxation?
- As a Database Administration Specialist 2, you will be responsible for designing, developing, and supporting complex ELT code using tools like Python, SQL, and Snowflake. You'll also perform data migrations, implement high-availability solutions, tune system parameters for optimal performance, provide Tier II technical support, and design data warehouse and BI solutions, primarily focusing on SQL Server.
- What specific technologies are used in this Database Administration Specialist role?
- The primary technology for this role is SQL Server. Secondary technologies include Oracle and Snowflake. You will also be working with tools such as Python, SAS, StreamSets, and AWS Glue for ELT code development and data management.
- What qualifications are required for the Database Administration Specialist 2 position?
- You need a minimum of 60 months of combined work experience in performance tuning, configuration, data modeling, and Tier II database support, with at least 12 months specifically in SQL Server. Educational alternatives include an associate's or undergraduate core program in computer science or information systems, with reduced experience requirements.
- How can I apply for the Database Administration Specialist 2 job at the Ohio Department of Taxation?
- To apply, ensure your resume clearly details your experience with the required technologies, particularly SQL Server. Address the specific experience requirements outlined in the job posting. You can contact Katie.Schuler@tax.ohio.gov for direct inquiries or the HR Mainline at 614-466-3020 or HRStaffing@tax.ohio.gov for general staffing questions.
- What is the compensation for the Database Administration Specialist 2 role?
- The compensation for this position ranges from $40.59 to $59.70 per hour. This is a full-time classified position with the OCSEA union.
- Is this Database Administration Specialist position remote, hybrid, or on-site?
- The job posting indicates the work location is 'Northland 1st Floor' and the primary location is Columbus, Ohio. Therefore, this is an on-site position.
- What kind of benefits does the State of Ohio offer for this Database Administration Specialist role?
- The State of Ohio offers a competitive total compensation package including medical, dental, and vision insurance, tuition reimbursement, health and wellness programs, and work-life balance initiatives. Opportunities for career advancement are also available.