Personnel Commission

CLASS TITLE: Database Administrator

To perform data base development and data base warehouse system and support to the County Office of Education and districts; to conduct data base needs assessments, to maintain existing data base 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, and to perform related duties as required.

A Data Base Administrator performs highly complex technical and specialized duties related to the effective implementation of data base systems designed to meet the information system needs of County Office of Education. Employees in this classification receive indirect supervision within a broad framework of policies and objectives.

• Designs and develops data base and data base warehouse 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 data base system to ensure proper data base 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, data base 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 MS/SQL table and usage; modifies or redesigns data base as needed and updates MS/SQL statistics and table indices 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 MS/SQL, Open Data Base Connection (ODBC) Driver, client-server application components, report writer servers, QSS 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 MS/SQL, 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

• Multiple operating systems and applications disciplines such as UNIX/Linux/Windows Server/Oracle/SAP

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

• C, GUI, .Net, PHP and 4GL programming languages

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

• SQL and Non-SQL data loading principles

• Data integration tools such as OLAP applications

• SQL Server Analysis Services (SSAS) delivering online analytical processing (OLAP) and data mining functionality for business intelligence applications

• Managing multi Tb (terabyte) data volumes.

Ability to:

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

• Design and develop data warehouse schemas and models

• 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

• Manage data across the enterprise through well established data design standards

• Develop and support conceptual, logical, and physical data models

• Support data access, acquisition and physical data base design

• Support architectural compliance and infrastructure coordination

• Verify data models reflect business requirements and data usage

• Develop and implement data model meta-data

• Develop and enforce metadata standards

• Define data archiving/purge standards

• Develop XML schemas for SOA entity services

• Provide timely estimation of data base/storage utilization and plan enhancements/upgrades required

• 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 MS/SQL or any other equivalent data base systems (ORACLE, SAP, DB2, Informix, Sybase, Business Objects) and UNIX/LINUX or Windows Server system administration is preferred.

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/LINUX/Windows Server system administration, data base system administration and design, programming development in a client-server environment specializing in data modeling and normalization as well as data warehouse schema design using OLAP and ETL tools.

BARGAINING UNIT: Office, Technical, and Business Services (OTBS) Unit

WORKING CONDITIONS: While performing the duties of this class, the incumbent regularly works in an indoor office; may be required to drive to various sites operated by the County Office of Education, and may be required to work extended hours as needed. The noise level in the work environment is usually moderate.

PHYSICAL DEMANDS: Hearing and speaking to exchange information; seeing to perform assigned duties; sitting or standing for extended periods of time; dexterity of hands and fingers to operate a computer keyboard and other office equipment; kneeling, bending at the waist, and reaching overhead, above the shoulders and horizontally to retrieve and store supplies; lifting and moving heavy objects.

Personnel Commission Approval: March 26, 1998
Revised: April 22, 1999; 7/8/2010