1E68
DATA BASE ADMINISTRATOR

This is second-level supervisory computing work directing through subordinate supervisors, the project management, implementation and administration of multi-database software products such as SYBASE, ORACLE, DB2, SAGA, FAMIS-Data Warehousing and PARS, for the Mayor's Office of Information Services (MOIS). The employee in this class is responsible for establishing and enforcing the standards for access and use of the data base, defining program logic protocols that interface with the data base, and ensuring the security and disaster recovery of the data base system. Work includes reviewing, refining and approving requests for data base design of data storage and retrieval processes. Work also includes directing through in house staff: data base performance analyses, software installation, and maintaining optimum availability of the data for the user population. Interacting with consultants, departmental officials, and technical agencies are significant aspects of the work.

Work is performed under the direction of the Chief Information Office of the Mayor's Office of Information Services.

1. The work must be performed in the Mayor's Office of Information Services.
2. The position must have responsibility for the various data base system software maintained by the Mayor's Office of Information Services (MOIS).
3. The position must supervise, through subordinate supervisors, a project management staff engaged in maintaining data base systems administered by the Mayor's Office of Information Services (MOIS).
4. Only one position can be allocated to this class.

• Plans, assigns and reviews the work of a technical project management staff engaged in the administration of the data base system including physical design of the data base, data structure, storage structure and mappings, and search strategies and access methods; ensures maximum availability of data base system to users; monitors data base system performance and fine tunes the system to achieve optimum efficiency.
• Devises security standards for the confidentiality of data, for unauthorized updating or modification, removal or destruction of data, or inadvertent disclosure of information; designs integrity system to guard against inaccurate, invalid, or missing data; designs and implements a data recovery system; resolves problems with systems development staff; implements security access levels according to specifications from departments; sets standards for the input of data into the system; enforces programming standards for systems development personnel in order to achieve uniformity in coding and data retrieval; develops the elements incorporated into the data dictionary.
• Interfaces with systems programming staff to ensure system configuration changes work in conjunction with the data base system; reviews requests from users and balances their competing data base needs; installs improvements and enhancements to the data base system; works in unison with applications programming staff to ensure uniformity with coding standards and efficiency of system operation.
• Designs, plans, and manages data base conversion projects; meets with users and examines specifications, job control languages, space and field requirements, and resources, such as disc space, terminals and printers.
• Participates in the agency's steering committee; reviews hardware and software under consideration for acquisition; Maintains the City's database system by monitoring industry trends to stay informed of newly developing database technologies; implements, maintains, and administers any new database systems that the department may purchase; monitors usage of the total computing system; evaluates need for increased future capacity; maintains documentation for data base, including data dictionary, data listings, help guides and cross referencing protocols. Interacts with vendors concerning software enhancements and new products; interacts with other municipalities to exchange information on data base management packages.
• Performs related work as required.

KNOWLEDGE OF:
• the development and application of data software applicable to data base management, such as SYBASE, ORACLE, DB2, SAGA, FAMIS and PARS
• principles, practices and techniques used in systems analysis and design
• modern administrative and management techniques with particular emphasis on a large scale data processing environment
• supervisory and project management methods and techniques
• the differing characteristics of hierarchal and relational data bases
• the principles, practices and techniques used in an on-line data processing system with remote data retrieval
• the principles, practices and techniques employed in integrating competing needs and resources in a data processing environment
• the various aspects of data base administration, including defining data dictionaries, setting security levels, and monitoring the efficiency of system performance
SKILL IN:
• evaluating data base system performance and effecting proper tuning techniques and resolutions
• analyzing user requests and refining them for proper assimilation into the data processing environment
• integrating various user requests with system capabilities
ABILITY TO:
• supervise a staff of technical project management personnel engaged in the various aspects of data base management
• plan, organize and direct the operations of a city-wide centralized automated data base system
• design, develop and implement data base systems to provide maximum availability to users.
• develop and implement a security access plan to offer accessibility to authorized users while maintaining the confidentiality of secure data
• effectively advise management of the latest changes of the data base system and their effect on the entire centralized data processing environment
• communicate effectively both orally and in writing
• establish and maintain effective working relationships with associates and departmental officials

EDUCATION
• Completion of a Bachelor's Degree program at an accredited college or university which has included major course work in computer science, information science, or a closely related field.
AND
GENERAL EXPERIENCE
• Five years of experience in systems programming or applications programming in a mainframe computing environment.
AND
SPECIFIC EXPERIENCE
• Two years of experience, at the first supervisory level, supervising programmer analysts or systems programmers in a mainframe environment.

OR

Any equivalent combination of training and experience that has included the Bachelor's Degree and the specific experience described above.

• Ability to physically perform the duties and to work in the environmental conditions required of a position in this class.