DATABASE ANALYST 1
DEFINITION:
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.
EXAMPLES OF WORK:
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 analysis and design of databases.
Prepares clear, accurate, and concise technical reports containing findings, conclusions, and recommendations.
Maintains essential records and files.
Will be required to learn how to utilize various types of electronic and/or manual recording and information systems used by the agency, office, or related units.
REQUIREMENTS:
EDUCATION:
Graduation from an accredited college or university with an Associate's degree in Computer Science, Information Technology, or a closely related field.
EXPERIENCE:
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.
LICENSE:
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.
KNOWLEDGE AND ABILITIES:
Knowledge of electronic data processing platforms and software, and familiarity with Data Center practices, policies, and procedures.
Knowledge of database/data dictionary systems and applications including the software versions of at least one widely used database management system.
Knowledge of telecommunications systems as they relate to database management systems.
Knowledge of procedures and techniques involved in making estimates and analyses of the capabilities of existing and proposed databases used in application systems.
Ability to communicate effectively in writing and orally with various levels of data center and department personnel.
Ability to prepare clear, sound, accurate, and informative reports and documentation on database systems, including creation and maintenance of data dictionary documents.
Ability to maintain essential records and files.
Ability to learn how to utilize various types of electronic and/or manual recording and information systems used by the agency, office, or related units.
Ability to read, write, speak, understand, and communicate in English sufficiently to perform the duties of this position. American Sign Language or Braille may also be considered as acceptable forms of communication.
Persons with mental or physical disabilities are eligible if they can perform the essential functions of the job with or without reasonable accommodation. If the accommodation cannot be made because it would cause the employer undue hardship, such persons may not be eligible.
This job specification is applicable to the following title code:
