Information Technology Specialist VI (COBOL & Oracle SQL) Honolulu

Position Specific Description

Recruitment Number 26-004TO Information Technology Specialist VI (COBOL and Oracle SQL) $6535 to $7351 per month (SR-26 step D to G)

• Honolulu Oahu.
• The s tarting salary may be at the minimum and maximum salary listed above and will be determined by the hiring program based on qualifications

Summary of Duties

This position is located in the Applications Production Support Branch which is responsible for the creation enhancement and maintenance of the Judiciarys 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.

Minimum Qualification Requirements

Education Requirement : Graduation from an accredited college or university with a Bachelors 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.

Specialized Experience Requirement : 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.

Selective Certification Requirement - COBOL and Oracle SQL : 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 developers code; and creating detailed documentation.

Staff Specialist Experience : 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 or system in resolving or assessing controversial or precedent setting issues concerning the specialty area.

Supervisory Aptitude : For the IT Specialist VI level supervisory aptitude rather than actual supervisory experience may be accepted. Supervisory aptitude is the demonstration of aptitude or potential for the performance of supervisory duties through successful completion of regular or special assignments which involve some supervisory responsibilities or aspects; by serving as a group or team leader or in similar work in which opportunities for demonstrating supervisory capabilities exist; by completion of training courses in supervision accompanied by application of supervisory skills in work assignments; or by favorable appraisals by a supervisor indicating the possession of supervisory potential.

Substitutions Allowed :

1) Possession of a bachelors degree from an accredited college or university in computer science or in another major which included completion of course work comparable to a major in computer science may be substituted for six (6) months of the required Specialized Experience.

2) Partial completion of a masters degree program in computer science from an accredited college or university may be substituted on a month-for-month basis up to a maximum of one (1) year for the required Specialized Experience.

3) Possession of a masters degree in computer science from an accredited college or university may be substituted for one and one-half (1½) years of the required Specialized Experience.

4) Possession of a Ph.D. in computer science from an accredited college or university may be substituted for two and one-half (2½) years of the required Specialized Experience.

Note - there is no substitution for the COBOL / Oracle SQL selective certification requirement.

Supplemental Information

Any additional information may be attached to your online application submitted by email to or mailed to the following address : Hawaii State Judiciary Human Resources Department 426 Queen Street First Floor Honolulu Hawaii 96813.

Education : If you are using education as a substitute for experience you must submit a copy of your official transcripts or diploma at the time of application. If you are selected you will need an official transcript (not a copy) indicating the completion of the training or the awarding of the appropriate degree.

CLICK HERE for other important information about the Merit or Civil Service System Citizenship and Residency requirements Accommodations Veterans Preference Examination process Administrative Review and more.

Required Experience :

IC

Key Skills

Computer Hardware,IT Experience,Network Administration,Network Support,LAN,Computer Networking,Computer Skills,Windows,Sharepoint,Teaching,Operating Systems,Leadership Experience

Employment Type : Full Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 78420 - 111624