Log In
Sign Up
- Position Information
-
Designs and develops electronic data processing systems and procedures for functionally distinct activities of an organization where a variety of problems and processes, some of which are complex, are involved; analyzes and evaluates operating methods and practices relative to the information needs of specific programs and activities; develops plans for the implementation of recommended systems and procedures; and performs other related duties as required.
Current Vacancy:
There is one vacancy with the Department of Information Technology, Applications Division. Under the supervision of the Data Base Administrator (Data Processing Analyst III or IV), this position performs a variety of data base related systems development tasks including the analysis of user requirements and systems design, modification, implementation, and maintenance. Works with the senior analyst to ensure that the application and system data bases and related files are operating efficiently and to provide the necessary service to all who access the City’s data bases. Also assists the senior analyst to provide the technical recommendations, assistance and support to other divisions within the department.If you qualify for the position, your name will be placed on an eligible list. This list may be used to fill current and future vacancies in this and/or other departments.
- Additional Job Information
-
Applications must be submitted online by August 26, 2023, 11:59 p.m., Hawaii Standard Time (HST) to be accepted.Some notifications may be sent via e-mail. You are responsible for monitoring instructions and correspondence from this office by checking your email account in a timely manner. To ensure proper delivery, please make sure you:
– use a valid e-mail account;
– verify your e-mail address is entered correctly on your GovernmentJobs account;
– are subscribed to e-mail notices;
– check your spam folders; and
– add [email protected] and [email protected] to your contact list.Notifications may also be sent via text message if opted into the service. Data and text messaging fees apply.
- Minimum Qualification Requirements
-
At time of application, you must be a citizen, national or permanent resident alien of the United States or a non-citizen eligible under federal law for unrestricted employment.
EDUCATION REQUIREMENT:
Equivalent to graduation from a regionally-accredited college or university with major work in public or business administration, accounting, mathematics or a related field.Education obtained outside of the United States must be comparable to a degree earned at a regionally-accredited college/university in the United States. In order to receive credit for the education, a foreign credential evaluation (FCE) must be provided. We also reserve the right to request further information about your academic program, evidence of comparability, or an original transcript.Verification Requirement: Please attach an electronic copy of your diploma and/or official transcript which shows the embossed seal or applicable FCE to your application. Or mail a photocopy of your documents to the following address: Department of Human Resources, 650 South King Street, 10th Floor, Honolulu, HI 96813. Copies will not be returned. Unofficial transcripts will not be accepted. All information on your documentation must be legible and complete in order to be given credit.
Work experience may be substituted for a bachelor’s degree on a year-for-year basis. Such experience must have provided the knowledge, skills, and analytical ability normally gained from attainment of a bachelor’s degree.
EXPERIENCE REQUIREMENT:
Two years of experience in the analysis of operating practices, methods and procedures, one of which shall have involved the conduct of feasibility studies and the analysis and design of systems for the electronic processing of data AND six months of the two years of experience described above must have been in the applicable specialty area of database management.Substitution:
1) A Bachelor’s degree in Computer Science or MIS from a regionally-accredited four year college or university may be substituted for six months of experience in the analysis of operating practices, methods, and procedures.
2) A Master’s degree in Computer Science or MIS from a regionally-accredited four year college or university may be substituted for one year of experience in the analysis of operating practices, methods, and procedures.
There is NO substitution for the one year of experience which shall have involved the conduct of feasibility studies and the analysis and design of systems for the electronic processing of data or for the six months of experience in database management.
Education obtained outside of the United States must be comparable to a degree earned at a regionally-accredited college/university in the United States. In order to receive credit for the education, a foreign credential evaluation (FCE) must be provided. We also reserve the right to request further information about your academic program, evidence of comparability, or an original transcript.
Verification Requirement: You must submit evidence of your education in order to be given credit for the substitution. Please attach an electronic copy of your diploma and/or official transcript which shows the embossed seal or applicable FCE to your application. Or mail a photocopy of your documents to the following address: Department of Human Resources, 650 South King Street, 10th Floor, Honolulu, HI 96813. Copies will not be returned. Unofficial transcripts will not be accepted. All information on your documentation must be legible and complete in order to be given credit. - Examination Process
-
EDUCATION AND EXPERIENCE EVALUATION:
In addition to meeting the above minimum qualifications, your application will be further evaluated. Your score will be based on the quality and quantity of your education, experience and/or other related job requirements and competencies applicable to the position. Failure to provide sufficient information may result in your application being rejected or your receiving a lower score.EXAMINATION WEIGHT:
Education and Experience Evaluation………………………………..100%
-
What are the benefits of being a City Employee?
— Vacation: Employees may earn up to 21 days per year.
— Sick Leave: Employees may earn up to 21 days per year.
— Holidays: 13 days a year; 14 days during election years.
— Training and Development: Computer, career, and personal enhancement courses are offered; curriculum designed for employee, supervisory, and management development.
— Medical, Dental, Prescription Drug, and Vision Care: Various health insurance plans are available. Premiums are subsidized by the City and deductible from pre-tax income for participants of the Premium Conversion Plan (PCP).
— Group Life Insurance: No cost for eligible employees.
— Deferred Compensation Plan: Invest in your future…choose to defer part of your pre-tax income for retirement.
— Retirement Plan: The Employees’ Retirement System (ERS) of the State of Hawaii administers retirement benefits for State and County employees. Employee contribution required.
— Commuter Choice Pre-Tax Benefits: Employees may designate certain transportation expenses (TheBus, LOTMA, Vanpool Hawaii, etc.) as a pre-tax item
— Parking: Some job locations offer parking on-site; others may have access to parking at low monthly rates.
— Direct Deposit: Direct deposit of paychecks to a designated financial institution is available.
— Employee Assistance Program (EAP): Confidential, professional counseling and resource referral.
— Public Service Loan Forgiveness (PSLF) Program: A federal program forgiving the balance of federal student loans for individuals working in public service. For program requirements and additional information, please visit: https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service
To view additional information, please visit our Benefits of City Employment page.
* All benefits as stated above, are subject to eligibility requirements and to legislative and/or negotiated changes. Individuals are responsible for any related fees or charges that may apply.
-
01
When applying for this position, please thoroughly complete the Education, Work Experience, and Supplemental Question sections of your application. The information provided in these sections, particularly the job-specific Supplemental Questions, will be used to determine whether you meet the qualification requirements for the job and your final score. Failure to provide detailed and complete information or submit any required documentation may result in your application being rejected or you receiving a lower score. If you have no experience in a particular area, indicate “none.” Please do not submit resumes in place of completing any of these sections.- I certify that I have read and understand the above statements.
02
EDUCATION REQUIREMENT: The Data Processing Systems Analyst II (Database) position requires applicants to have the equivalent of a bachelor’s degree from a regionally-accredited four year college or university with major work in computer science, public or business administration, accounting, mathematics or a related field.Education obtained outside of the United States must be comparable to a degree earned at a regionally-accredited college/university in the United States. In order to receive credit for the education, a foreign credential evaluation (FCE) must be provided. We also reserve the right to request further information about your academic program, evidence of comparability, or an original transcript.
Verification Requirement: Please attach an electronic copy of your diploma and/or official transcript which shows the embossed seal or applicable FCE to your application. Or mail a photocopy of your documents to the following address: Department of Human Resources, 650 South King Street, 10th Floor, Honolulu, HI 96813. Copies will not be returned. Unofficial transcripts will not be accepted. All information on your documentation must be legible and complete in order to be given credit.
Do you meet this education requirement?
- Yes
- No
03
EXPERIENCE REQUIREMENT: In addition to meeting the education requirement, applicants must have two years of experience in the analysis of operating practices, methods and procedures, one of which shall have involved the conduct of feasibility studies and the analysis and design of systems for the electronic processing of data AND six months of the two years of experience described above must have been in the applicable specialty area of database management.Do you meet this experience requirement?
- Yes
- No
04
Substitution:- A Bachelor’s degree in Computer Science or MIS from a regionally-accredited four year university or college may be substituted for six months of experience in the analysis of operating practices, methods and procedures.
- A Master’s degree in Computer Science or MIS from a regionally-accredited four year university or college may be substituted for one year of experience in the analysis of operating practices, methods, and procedures.
There is NO substitution for the one year of experience which shall have involved the conduct of feasibility studies and the analysis and design of systems for the electronic processing of data or for the six months of experience in database management.
Education obtained outside of the United States must be comparable to a degree earned at a regionally-accredited college/university in the United States. In order to receive credit for the education, a foreign credential evaluation (FCE) must be provided. We also reserve the right to request further information about your academic program, evidence of comparability, or an original transcript.
Verification Requirement: You must submit evidence of your education in order to be given credit for the substitution. Please attach an electronic copy of your diploma and/or official transcript which shows the embossed seal or applicable FCE to your application. Or mail a photocopy of your documents to the following address: Department of Human Resources, 650 South King Street, 10th Floor, Honolulu, HI 96813. Copies will not be returned. Unofficial transcripts will not be accepted. All information on your documentation must be legible and complete in order to be given credit.
Do you have any of the above mentioned degrees?
- Yes, I have a Bachelor’s degree in Computer Science or MIS and will submit evidence of my degree.
- Yes, I have a Master’s degree in Computer Science or MIS and will submit evidence of my degree.
- No, I do NOT have any of the above mentioned degrees.
05
Describe in detail your professional (i.e., post-Bachelor’s degree, non-clerical) data processing systems analysis work experience.Indicate which position listed in the Work Experience section of your application where you had such experience and provide the following information:
1) your specific duties and responsibilities in analyzing operating practices, methods and procedures including:
- a) a brief description of the project/assignment
b) your role and level of responsibility (i.e., trainee/helper, independent journey-level worker, project supervisor)
c) the data and/or manual operating processes you analyzed
d) the duration of the project/assignment2) a brief description of the feasibility studies you conducted, the factors considered to determine the decision, and the recommendations made based on results of the study; and
3) the systems you analyzed and designed for the electronic processing of data.
06
Describe in detail your professional (i.e., post-Bachelor’s degree, non-clerical) work experience in database management.Indicate which position listed in the Work Experience section of your application where you had such experience and include your specific duties and responsibilities in:
1) designing and creating/building databases;
2) coding applications that interfaces with the databases (include the programming languages you utilized);
3) database access control and security;
4) migrating and updating databases;
5) backing up and restoring databases;
6) extracting and correcting data;
7) creating database reports;
8) providing technical and functional database support; and
9) working with various operating system software (i.e., Microsoft Windows, UNIX, Linux, etc.).07
I am proficient in the following Database Management Systems (DBMS): (Check all that apply and describe in the next question)- MySQL
- MariaDB
- PostgreSQL
- Microsoft SQL Server
- Oracle Database
- IBM IMS
- MongoDB
- VSAM
- Other (describe below)
08
For each item you checked off in the question above, describe your level of knowledge and indicate your starting and ending dates and years of experience.09
I am proficient in the following Database Languages: (Check all that apply and describe in the next question)- Data Control Language (DCL)
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Structured Query Language (SQL) (combination of DDL, DML & DQL)
- Object Query Language (OQL)
- XQuery
- SQL/XML (combination of SQL & XQuery)
- JavaScript Object Notation Language (JSON)
- JSON Query
- Other (describe below)
10
For each item you checked off in the question above, describe your level of knowledge and indicate your starting and ending dates and years of experience.* Required Question
