Classified Personnel Services
Santa Clara County Office of Education

Bargaining Unit: Office, Technical, and Business Services

JOB TITLE: Data Base Administrator

To perform data base development and data base support to the County Office of Education and districts; to conduct data base needs assessments, to maintain existing database systems; to ensure the integrity of database systems; to find software solutions for the integration of data base systems; and to perform the installation and upgrade of data base related products. Employees in this classification receive indirect supervision from the Senior Systems Administrator within a broad framework of policies and objectives. Employees in this classification perform highly complex technical and specialized duties related to the effective implementation of database systems designed to meet the information system needs of County Office of Education.

• Designs and develops data base systems; provides data base analysis and data modeling, and performs normalization procedures to ensure an integrated database system for existing and new applications; sets-up and tests production environments for business applications

• Maintains production and test data bases, ensures proper data base performance and operation

• Ensures data integrity, referential constraints, trigger, and procedures for database system to ensure proper database operation

• Analyzes and diagnoses data base system problems and takes appropriate corrective action for resolution

• Develops technical policies and specifications for data importing and exporting, database system development, maintenance, backup, and recovery; and coordinates their implementation

• Oversees data base security related to applications and operations

• Maintains network system standards in data base system development that optimize system integration and functionality

• Researches, reviews, and provides consultation on software to determine the advisability and functionality of its use by COE internal departments and client districts

• Provides assistance in attaining software solutions which ensure high quality and cost effective operations; recovers lost data from data base backup.

• Oversees the daily operation of backups for logical logs and physical data base systems

• Participates in the analysis of data requirements in the program development cycle and assists in the creation of Entity Relationships (ER) and Data Flow Diagrams (DFD)

• Monitors, evaluates, and analyzes Informix table and usage; modifies or redesigns data base as needed and updates Informix statistics and table endices as scheduled to ensure proper data base performance indexes

• Interfaces with system administration and operations staff to ensure efficient use of data base systems; serves as second level user support

• Performs the installation and upgrade of Informix, Open Data Base Connection (ODBC) Driver, client-server application components, report writer servers, IFAS software, and data base related products

• Supports customer service staff in data access or data base system related problems

• Remains abreast of current database system technologies related to Informix, systems administration, and SQL

• Serves as the backup to the Senior Systems Administrator

• Performs related duties as required.

Knowledge of:

• relational data base design methods, techniques, characteristics, and practices

• proper programming development procedures in a client-server environment

• relational data base techniques for performance monitoring and tuning, indexing, security, recovery, data segmentation, locks arrangement, and data integrity

• UNIX operating systems and related software applications

• networking concepts technology and related components of a client server environment

• C, GUI, and 4GL programming languages

• proper SQL and programming skills for writing data base trigger and stored procedures

Ability to:

• design and develop data base system, provide data modeling table normalization, and performance

• conduct data base needs assessments

• develop proper specifications related to data base systems administration

• effectively analyze and evaluate data base systems and modify data base systems to meet office needs

• remain abreast of current data base system technologies

• quickly identify data base problems, evaluate causes and take correction action for resolution

• communicate effectively in both oral and written form

• perform application programming

• establish and maintain accurate records and files and prepare reports

• work independently with minimal supervision

• work various shifts to meet the needs of the assigned duties

• establish and maintain effective relationships with those contacted in the performance of assigned duties

Certification in data base administration specializing in Informix, Sybase, or another equivalent data base system or UNIX system administration is preferred.

EDUCATION AND EXPERIENCE

Generally, any combination of education and experience that could provide the required knowledge and abilities would be qualifying. A typical method of demonstrating these requirements would be:

• Education: A bachelor's degree in computer science, information systems, or a related field from an accredited college or university.

• Experience: Three years of directly related experience in UNIX system administration, data base system administration and design, programming development in a client-server environment specializing in data modeling and normalization.

• Acceptable Substitutions: The preferred data base/UNIX system certification and/or additional years of directly related work experience may be substituted for maximum of two years of the educational requirement. Additional educational substitutions may be considered on a case by case basis. There will be no substitutions for the required experience.

Personnel Commission Approval: March 26, 1998
Revised: April 22, 1999