DATA BASE COORDINATOR 0516
DISTINGUISHING FEATURES OF THE CLASS
Under general supervision, an employee in this class maintains a data base system of specialized information for a Suffolk County department or jurisdiction. Work may include planning, assigning and supervising the work of support staff, determining priorities of the work, suggesting and/or implementing changes and new applications, and coordinating user needs with the system's ability. The work is reviewed by an administrative supervisor through conferences, reports and observation of the system's performance. Does related work as required.
TYPICAL WORK ACTIVITIES
Maintains, modifies and updates a specialized data base system to meet the needs of a County department or municipality;
Develops and implements standard and specialized reports by creating and implementing data exchange mechanisms among various software applications and other data sources;
Installs, maintains and develops SQL servers;
Updates and tests database application programs;
May review work of programmers and analysts to make changes to the database management system;
Reviews, corrects and updates programs in SQL, MS Access, Oracle, or in any other database language;
Establishes backup files and recovery procedures for databases;
Establishes forms and procedures for data entry and retrieval, including internet access;
Ensures license compliance, management and administration of databases;
Provides accounting documentation and statistical reports;
May supervise support staff;
May attend various training and user group meetings.
FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS
Good knowledge of the relevant computer science and mathematical principles and methods used in the maintenance and analysis of data base material; good knowledge of the relevant computer programming and job control languages; good knowledge of electronic data processing systems analysis; working knowledge of statistical analysis; ability to analyze and solve problems within the limitations of available equipment, operating time and the form of desired results; ability to write and validate computer programs; ability to plan, assign and supervise the work of personnel in a manner conducive to full performance and high morale; ability to establish and maintain effective working relationships with co-workers and users; ability to express oneself clearly and concisely, both orally and in writing; patience; physical condition commensurate with the demands of the position.
a) Graduation from a college with federally-authorized accreditation or registration by NY State with a Bachelor's Degree, including at least 30 credit hours in mathematics and/or computer sciences, and two (2) years of experience in data base maintenance; or
b) Graduation from a college with federally-authorized accreditation or registration by NY State with an Associate’s Degree, including at least 15 credit hours in mathematics and/or computer sciences, and four (4) years of experience in data base maintenance; or
c) An equivalent combination of education and experience as defined by the limits of a) and b).
One (1) year of permanent competitive status as a Data Control Specialist.