Information Technology Specialist VI; COBOL & Oracle SQL - Honolulu

Recruitment Number 26-004TO

Information Technology Specialist VI (COBOL and Oracle SQL), $6,535 to $7,351 per month (SR-26, step D to G)*, Honolulu, Oahu.
* The starting salary may be at the minimum and maximum salary listed above and will be determined by the hiring program based on qualifications

The position is located in the Applications Production Support Branch which is responsible for the creation, enhancement and maintenance of the Judiciary's statewide integrated case management system. The position is responsible for overseeing the day-to-day functional and technical support of the production environment for the statewide court system, Judiciary Information Management System (JIMS). The assigned duties include analysis, system specifications, design, programming, conversion, testing, implementation, and on‑going support services for the various Judiciary applications and system of applications;

and perform other related duties as assigned.

In order to satisfactorily perform the duties and responsibilities at job entry, candidates must possess knowledge and experience with COBOL and databases using SQL for relational databases such as Oracle, DB2 or SQL Server.

Graduation from an accredited college or university with a Bachelor's degree, or

Excess experience of the types and quality described below or any administrative, professional, analytical, technical, or other responsible work which provided knowledge, skills and abilities comparable to those acquired in four (4) years of successful study while completing a college or university curriculum leading to a baccalaureate degree may be substituted on a year‑for‑year basis. To be acceptable, the experience must have been of such scope, level, and quality as to assure the possession of comparable knowledge, skills and abilities.

The education or experience background must also demonstrate the ability to write clear and comprehensive reports and other documents; read and interpret complex written material; and solve complex problems logically and systematically.

Three and one‑half (3½) years of progressively responsible professional work experience in information technology which involved the analysis, design, programming, security and access management, database design and management, consulting, and/or installing and maintaining computer software applications, hardware, telecommunications, web or network infrastructure equipment. The work must have demonstrated knowledge and understanding of information technology principles, methods, techniques and practices; computer hardware, software and peripheral equipment;

and personal computer, server, mini and/or mainframe operating systems.

Of the required three and one‑half (3‑1/2) years of specialized experience, one (1) year of experience must have included work with a database such as Oracle, DB2 or SQL Server using SQL; and two (2) years of specialized experience in COBOL.

The experience should include analyzing SQL code; data correction and database updating; and the extraction of data to create database reports. The COBOL experience should include analysis, design, coding and testing; solving problem tickets; code review and testing of other developer's code; and creating detailed documentation.

One (1) year of professional work experience as a staff specialist in a highly specialized area of information technology which involved providing services for a variety of programs and systems; such as database management, telecommunications, networking, operating systems, IT security or other comparable area, or for a highly complex and major system involving integrating multiple systems and/or multiple system components that have a major effect on the work of the organization;

the delivery of multiple purposes or functions, servicing multiple users and/or jurisdictions with differing needs, is utilized by large groups of users, requires on‑line (real‑time) interfaces, etc.; and is regarded as the technical expert by other agencies for the specialized IT area…