Information Technology Apprentice (Database Management)

State of Ohio • Columbus, OH

3d • Onsite

About The Position

Under direct guidance and supervision, works toward acquiring the knowledge, skills and abilities required to perform entry-level duties within an assigned information technology program area team. Serves as an apprentice to designated staff learning core information technology competencies. Attends 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, and completing customer requests. 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 including representing the agency and assigned program area to internal and external customers, scheduling meetings, preparing agendas, and taking meeting notes, and providing project support for database services projects.

Requirements

• 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.
• 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
• 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
• 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
• Must provide own transportation or in order to operate a state vehicle, you must have a valid driver’s license.

Nice To Haves

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

Responsibilities

• Database server and activity monitoring
• Database maintenance and patching
• Complete customer requests
• Documenting database inventory, process flows and procedures
• 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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed