Database Administration Specialist 1

State of Ohio

Columbus (OH)

On-site

USD 48,000 - 70,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical Coverage
Dental & Vision Insurance
Paid Time Off
Holidays

Job summary

The State of Ohio is seeking a Database Administration Specialist 1 in Columbus, Ohio. The role focuses on SQL Server architecture, maintenance, backup, and performance tuning in a permanent full-time capacity.

The position requires strong database administration skills, heavy emphasis on data lake/ETL processes, and experience with cloud data technologies. Adherence to state policies and participation in background checks are expected.

Qualifications

  • 36 mos. combined work experience in database administration including Tier I support and data modeling & performance tuning.
  • Associate core program in computer science or information systems with 18 mos. combined work experience including the above.
  • Undergraduate core program in computer science or information systems with 12 mos. combined work experience including the above.

Responsibilities

  • Design the SQL Server architecture for databases and install, configure, upgrade and maintain.
  • Assist with performance tuning of the database system and application.
  • Assist with database refreshes and automate the refresh process.
  • Work with database utilities like load, unload, reorg, runstats.
  • Conduct database backups and assist with recovery procedures.

Skills

Database Administration

Tools

SQL Server

Job description

All job postings will expire at 11:59 PM Eastern Time on the application deadline.

Organization: Taxation

Work Location: 4485 Northland Ridge Boulevard, Columbus, Ohio, 43229, United States

Compensation: $34.53 - $50.66

Schedule: Permanent - Full Time

Work Hours: 8:00am - 5:00pm

Classified Indicator: Classified

Union: OCSEA

Primary Job Skill: Database Administration

Primary Technology: SQL Server

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.

The Ohio Department of Taxation is seeking one (1) Database Administration Specialist 1.

What You’ll do a Database Administration Specialist 1:
  • Design the SQL Server architecture for the databases and install, configure, upgrade and apply maintenance.
  • Assisting with and conducting the performance tuning of the database system and the application.
  • Assist with database refreshes and automating the refresh process.
  • Conversant with database utilities like load, unload, reorg, runstats etc.
  • Conduct database backup and assist with recovery procedures to be more efficient and effective.
  • Assist with Data Lake and ETL processes, preferably working with tools like Amazon Glue
  • Understand Analysis services (SSAS). Reporting services (SSRS), Integration services (SSIS)
  • Conversant in the power shell scripting to set up alerts and automate the repetitive DBA tasks.
  • Respond to and resolve "production down" and critical system and application problems and issues on a 24-hour basis, create Root Cause Analysis for the incident and take measures to prevent similar incidents in the future.
  • Experience with cloud based database technologies such as snowflake.
Additional Information

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. 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 and tax history 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, pursuant to section 5703.081 of the Ohio Revised Code, the Ohio Department of Taxation requires all current and prospective employees to be current and compliant with all state tax laws.

Why Work for the State of Ohio

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 our Total 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.

Qualifications

36 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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 18 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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 12 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration 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: Database Administration

Professional Skills: Attention to Detail, Critical Thinking, Teamwork

ADA Statement

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.

Drug-Free Workplace

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Program Administrator 3
Program Administrator 3

State of Ohio • Columbus (OH)

On-site
USD 56,000 - 79,000
Medical Coverage
Dental, Vision and Basic Life Premiums
Paid time off and holidays
+2
Database Administration Specialist 1 - PNs 20064742, 20064762
Database Administration Specialist 1 - PNs 20064742, 20064762

State of Ohio • Columbus (OH)

On-site
USD 39,000 - 56,000
Information Technologist 2
Information Technologist 2

State of Ohio • Columbus (OH)

On-site
USD 43,000 - 63,000
Health and wellness programs
Education and development
Paid time off and holidays
Enterprise Modernization Manager (IT Manager 1)
Enterprise Modernization Manager (IT Manager 1)

State of Ohio • Columbus (OH), Akron (OH), North Dayton (OH)

On-site
USD 56,000 - 79,000
Medical Coverage
Dental, Vision and Life Insurance
Paid time off + holidays
+1
Information Technology Apprentice (Database Management)
Information Technology Apprentice (Database Management)

State of Ohio • Columbus (OH)

On-site
USD 28,000 - 40,000
Medical Coverage
Dental/ Vision/ Life Insurance
Paid time off and holidays
+1
Application Development Manager - .Net (Information Technology Supervisor 2 - PN 20098531)
Application Development Manager - .Net (Information Technology Supervisor 2 - PN 20098531)

State of Ohio • Columbus (OH)

On-site
USD 61,000 - 65,000
Exempt from union
Flexible schedule
Information Technology Manager 1
Information Technology Manager 1

Ohio Department of Behavioral Health • Columbus (OH)

On-site
USD 41,000 - 69,000
Information Technologist 2 - HYBRID
Information Technologist 2 - HYBRID

State of Ohio • Columbus (OH)

On-site
USD 65,000 - 96,000
Telework eligibility
Information Technology Supervisor 3 (PN 20079216)
Information Technology Supervisor 3 (PN 20079216)

State of Ohio • Columbus (OH)

On-site
USD 56,000 - 79,000
Enterprise Modernization Manager (IT Manager 1)
Enterprise Modernization Manager (IT Manager 1)

State of Ohio • United States

On-site
USD 58,000 - 77,000