MUNICIPAL CIVIL SERVICE COMMISSION

1 Larkin Center

2nd Floor

Yonkers, N.Y. 10701

A NON-REFUNDABLE $40.00 APPLICATION FEE IS REQUIRED FOR EACH SEPARATELY NUMBERED EXAMINATION FOR WHICH YOU APPLY

CONTINUOUS EXAMINATION PROGRAM FOR DATABASE ADMINISTRATOR

APPOINTING AUTHORITY VACANCIES SALARY RANGE (per annum)

City of Yonkers As they occur $67,453 – 109,817

RESIDENCY REQUIREMENT WAIVED

DUTIES:

This is a technical position that is responsible for coordinating changes to computer databases, testing and implementing database management systems. The work includes planning, coordinating and implementing security measures to safeguard computer databases. General direction is received from administrative personnel. Does related work as required.

TYPICAL WORK ACTIVITIES: (Illustrative Only)

Develops data model describing data elements and how they are used;

Establishes and calculates optimum values for database parameters;

Oversees and modifies existing databases and database management systems;

Plans, coordinates and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure;

Develops and reviews procedures in database management system manuals for making changes to database;

Reviews project requests describing database user needs to estimate time and cost required to accomplish project;

Reviews workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records;

Selects and enters codes to monitor database performance and to create production Database;

Specifies users and user access levels for each segment of database.

MINIMUM QUALIFICATIONS:

Candidates must meet the following requirement on or before the date of the written test.

OPEN-COMPETITIVE: Either

A) Graduation from a regionally accredited or New York State registered four year college or university with a Bachelor’s Degree in Computer Science or related field and two (2) years of experience as a Database Administrator; or

B) Graduation from a regionally accredited or New York State registered two year college or university with an Associate’s Degree in Computer Science or related field and four (4) years of experience as described in (A); or

C) An equivalent combination of education/training and experience as defined by the limits of (A) and (B).

SUBJECT OF EXAMINATION:

The examination will consist of two parts: a rated evaluation of training and experience and a qualifying pc-administered test. You must pass the evaluation of training and experience in order to take the qualifying pc-administered test. You must pass both tests in order to be considered for appointment. Only your rating on the evaluation of training and experience will be considered when computing final scores.

RATED EVALUATION OF TRAINING AND EXPERIENCE

You will complete a questionnaire that asks for specific information on your information technology education (formal degrees, IT-related training courses, certifications) and experience. You will also be asked to briefly describe a significant achievement in each of the job’s areas and to provide the name and contact information for someone who can verify your information. The information you provide about your experience will be rated against the following areas:

Computer Programming

Business/Systems Analysis

Qualifying pc-administered written test will be designed to test for knowledge, skills and/or abilities in such areas as:

Logical Reasoning and Interpreting Instructions for Computer-Related Positions

These multiple-choice questions test for ability to reason logically and interpret instructions in a computer-related context. They cover verbal and quantitative reasoning, flowchart interpretation and applying written directions. The verbal and quantitative reasoning questions include logical implications (e.g., if A and B, then C) and relations (e.g., greater than). Knowledge of addition, subtraction, multiplication and division is necessary, but neither mathematical sophistication nor computational speed is needed. The interpreting instruction questions provide the instructions and specific rules for applying them. All the information needed to answer the questions is presented with the questions.

Working Effectively with Others to Solve Job-Related Problems

This simulation exercise requires candidates to assume the role of a staff member in an Information Technology work group who is working with colleagues during a time of change in policy or procedure, in a particular agency. During the exercise, candidates will be required to deal with obstacles within the working environment, which includes peer relations and the demands of handling multiple tasks. Candidates will be required to demonstrate the ability to be flexible, creative and persistent as a team player. They will also need to demonstrate the ability to cooperate, show initiative, and establish positive working relationships with peers and administrators.

Qualifying test scores may be banked and applied to future examinations for titles that require the same test plan