Information Technology Apprentice (Database Management)

Administrative Services; Columbus (OH); On-site; USD 28,000 - 40,000; Full time

Job summary

Administrative Services in Columbus, OH is seeking an Information Technology Apprentice (Database Management) to gain hands-on experience in database administration, SQL, and IT support. You will work under supervision, attend training, and contribute to database monitoring and maintenance tasks.

The program emphasizes learning core IT competencies, documentation, and collaboration with the program area team to deliver customer-focused database services projects.

Qualifications

• 1 course or 2 months experience in Information Systems/Information Technology, or related field.
• Familiar with database administration concepts and SQL.
• Experience with ticketing software such as ServiceNow.
• Knowledge of state IT policies, procedures and applicable laws.
• Strong problem solving and time management skills.
• Ability to document database inventories and processes.

Responsibilities

• Apprentice to designated staff learning core IT competencies.
• Attend training courses relevant to information technology program area.
• Assist daily tasks such as database server monitoring and maintenance.
• Learn IT Change Management policies and procedures.
• Assist documenting database inventory, processes and procedures.
• Build foundational knowledge of database management concepts.
• Provide project support for database services projects.

Skills

Information Technology

Database Administration

Problem Solving

Time Management

Technical writing

SQL

Tools

ServiceNow

Job description

Job Description - Information Technology Apprentice (Database Management) (260007L5)

Information Technology Apprentice (Database Management) (260007L5)

Organization

Administrative Services

Agency Contact Name and Information : Alexis Hill ([e-mail])

Primary Location : United States of America-OHIO-Franklin County-Columbus

Compensation : $24.88

Schedule : Full-time

Union : OCSEA

Primary Job Skill : Information Technology

Technical Skills : Database Administration, Information Technology

Professional Skills : Problem Solving, Time Management

Primary Technology : Not Applicable

Agency Overview

The Ohio Department of Administrative Services (DAS) takes great pride in its work to support the priorities of the DeWine-Tressel administration to ease access for those doing business with the state, secure state data and technology resources, and create efficiencies for our state government partners while keeping costs in check.

DAS is the engine of state government, providing innovative solutions and supporting the efficient operation of state agencies, boards, and commissions. DAS program areas serve our Ohio government customers, who in turn directly serve the interests of Ohioans. We help procure goods and services, deliver information technology and mail, recruit and train personnel, promote equal access to the state workforce, lease and manage office space, process payroll, print publications, and perform a variety of other services.

The Office of Information Technology (OIT) delivers enterprise information technology and telecommunication services as well as IT policy and standards, lifecycle investment planning, and privacy and security management.

TheInfrastructure ServicesDivision(ISD) operates the IT infrastructure for the state, which includes hardware, software and telecommunications. The division also develops and manages a variety ofenterprise IT services. ISD consists of the following program areas: Application Infrastructure & Operations Solutions; Customer Service Center; Data Center Co-Location; Disaster Recovery and Business Continuity; Enterprise Cloud Smart Solutions; Enterprise Mainframe Computing and Database Services; Enterprise Servers; Enterprise Storage; and Unified Network Services.

What you’ll do:

Under direct guidance and supervision, works to-ward acquiring the knowledge, skills and abilities required to perform entry-level duties within an as-signed information technology program area team:

• Serves as an apprentice to designated staff learning core information technology competencies
• Attend training courses relevant to assigned information technology program area
• Assists assigned information technology program area team with daily tasks such as: Database server and activity monitoring, database maintenance and patching, complete customer requests, etc.
• Learns IT Change Management policies and procedures
• Assists documenting database inventory, process flows and procedures
• Builds foundational knowledge of database management concepts and strategies
• Leverages appropriate resources to build problem solving skills
• Learns foundational concepts of SQL and scripting

Performs other related duties as needed:

• Representing the agency and assigned program area to internal and external customers
• Scheduling meetings, preparing agendas, and taking meeting notes
• Providing project support for database services projects

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

Minimum Qualifications:

1 course or 2 months experience in Information Systems/Information Technology, or a related field including but not limited to: Software Engineering/Development, Data Analytics/Business Intelligence, Database Administration, Network, IT Security and Help Desk/Customer Support -Or equivalent of Minimum Class Qualifications for Employment noted above.

Job Skills:

• Information Technology

Knowledge:

• Computer hardware and software
• Ticketing software (e.g. Service Now) *
• Customer Service techniques and standards*
• State IT policies, procedures and applicable laws *
• Operations and processes for diagnosing common or recurring system problems*
• Database procedures used for querying prior incidents to gather information *
• Relational database management systems and structured query language (SQL)
• Incident response and handling methodologies*
• Principal methods, procedures, and techniques of gathering information and producing, reporting, and sharing information*
• Organization's core business/mission processes*

Skills:

• Technical writing and documentation practices (e.g standard operating procedures, training documents, workflow diagrams) *
• Reading/verbal comprehension (i.e. comprehend and apply written & verbal instructions)
• Operating PC Hardware and Software (e.g. MS Word, Excel, PPT, Outlook)
• Critical thinking (i.e. impact analysis, troubleshooting)
• Conducting open-source research for troubleshooting network and client-server issues*
• Basic operation of computers
• Basic Scripting capabilities*
• Data protection strategies*

Abilities:

• Communication (e.g. Oral, Written, Active Listening)
• Problem sensitivity/problem solving
• Time Manage (e.g. organization and prioritization)
• Active learning
• Match the appropriate knowledge repository technology for a given application or environment*
• Accurately define incidents, problems, and events in the trouble ticketing system*
• Developed after employment

Supplemental Information

All answers to the supplemental questions must be supported by the work experience/education provided on your civil service application. Attachments will not be considered as part of your application.

Travel required, as needed. Must provide own transportation or in order to operate a state vehicle, you must have a valid driver’s license.

Selection devices such as a structured interview, proficiency instrument, and/or assessment may be required for this position. Applicants must demonstrate proficiency with a passing score of applicable selection device to be considered for this position. Regardless of a passing or failing score, all results will be maintained for 6 months. Applicant with a passing score will be retained and utilized for a 6-month period. Applicant with a failing score in the same position may not re-take the same selection device for a 6-month period.

The Ohio Department of Administrative Services does not provide employment-based visa sponsorship.

Location Requirements: DAS’s core hours of operation are Monday to Friday from 8 a.m. to 5 p.m., however, daily start/end times may vary based on operational need across DAS divisions. Employees may begin as early as 7 a.m. and as late as 9 a.m., based on supervisory approval. This position performs work on-site daily at DAS’s office space.

Pay Information: Unless required by legislation or union contract, the starting salary is step 1 of the salary range associated with this position. New hires advance to the next step in the range after 6 months and annually thereafter. Based on collective bargaining and legislative activity, there may be cost of living increases awarded annually. Additional longevity supplements begin after 5 years.

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.