Database Analyst

Department: Administrative Services/Information Technologies

Location: Atlantic City

Hours: 8 hours/week and up to 20 hours/week, as needed

Union/Mgmt: Mgmt

NJCSC Test

Required:

No

Grant Funded: No

Under general supervision in one of the Data Centers, is responsible for the analysis, physical design, coding, testing, migration, and implementation of databases in various platforms; coordinates efforts with systems and programming staff assigned to application development projects; creates and updates data dictionaries for applications; does other related duties as required.

NOTE:

The examples of work for this title are for illustrative purposes only. A particular position using this title may not perform all duties listed in this job specification. Conversely, all duties performed on the job may not be listed.

Graduation from an accredited college or university with an Associate's degree in Computer Science, Information Technology, or a closely related field.

Three (3) years of systems analysis, applications programming, design, systems programming and/or database administration or analysis experience in the data processing field, one (1) year of which shall have been in database design, analysis, and/or implementation.

NOTE:

A general Bachelor's degree can be substituted for one (1) year of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.

NOTE:

A specific Bachelor's degree in Computer Science, Information Technology, or a closely related field can be substituted for two (2) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.

NOTE:

A Master's degree in Computer Science, Information Technology, or a closely related field may be substituted for three (3) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.

Special Note Substituting Experience for

Education:

Experience in the study of work methods and processes, the analysis of varied types of data, the design and preparation of systems and programs, the operation of multi-tiered computer systems and work in the data processing support areas of reporting or reliability support may be substituted for the required education on a year-for-year basis with thirty (30) semester hour credits being equal to one (1) year of experience.

NOTE:

Evidence of formal training in Computer Science or Information Technology received from or evaluated by an accredited institution of higher learning may be submitted with your application. Applicants must provide documentation from the accredited institution that clearly outlines the training course(s) that are acceptable and the corresponding number of credit hours for the training to be accepted. In-house courses (such as training provided on the job or through the appointing authority) will not be accepted.

Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.

• Consults with staff and provides advice to systems administrators and developers in the design, development, testing, and implementation of information systems using database technology.
• Codes, tests, and implements specialized routines for loading, accessing, updating, and retrieving modules or programs for databases.
• Designs, programs, tests, and implements data integrity and control procedures and programs for databases.
• Performs analysis and mapping of data elements to extract, transform, and load in preparation for migration of data between systems.
• Conducts analyses of processing requirements on the proposed database applications and reports results.
• Conducts analyses of database performance and problem incidents, and provides resolution; reports to higher levels of database administration staff for resolution of more complex problems.
• Provides technical assistance to various levels of data center staff in the…