Los Angeles Community College District

Data Base Systems Specialist (#1041)

$52.83-$65.45 hourly / $9,157.44-$11,344.46 monthly / $109,889.28-$136,133.52 annual


Definition

Analyzes, designs, implements, and maintains the District's integrated data base management systems.

Typical Duties

Analyzes, designs, implements, maintains, and modifies integrated data base management systems for the District.

Plans, organizes, and schedules the activities necessary to implement and maintain data base management systems.

Analyzes applications programs and systems to determine their data elements and the interrelationships and commonality of the date base management system and the controls necessary for access to the data elements of the system.

Defines the various elements of the data base in standard terminology and assembles, compiles, and updates a dictionary of data elements.

Coordinates the development, installation, and revision of data base management systems with applications and software systems and programming staff.

Administers the implementation, maintenance, modification, and utilization of data base management systems.

Develops and is responsible for a security and integrity system to protect the data base elements from unauthorized access, use, change, or removal.

Provides technical assistance to system users in detecting and resolving problems related to the database.

Develops and maintains data base documentation including directories, glossaries, and cross reference listings.

Participates in the evaluation and selection of data storage and retrieval equipment and systems software.

Plans, organizes, schedules, and participates in the training and orientation of staff relative to the requirements and utilization of the integrated database management system.

Performs related duties as assigned.

 

Distinguishing Characteristics

A Data Base Systems Specialist is responsible for the integration of data base elements into a common system for the purpose of improving the efficiency of the data processing components related to applications and software systems and programming. An employee of this class analyzes many systems for discrete and common elements and integrates these elements into an operable system which satisfies the needs of all systems while maintaining the integrity of the data of each system.

A Software Systems Engineering Manager is responsible for managing the work of technical staff engaged in evaluating, installing, customizing, optimizing, troubleshooting, and monitoring the District's computer and network system software and Wide Area Network.

Supervision

General supervision is received from a Software Systems Engineering Manager. Work direction may be exercised over assigned technical staff.

Class Qualifications

Knowledge of:

Characteristics and capabilities of data processing equipment

Principles and methods of data base integration

Data base systems such as Rdb, Access, SQL Server, etc.

Principles and techniques of data base systems analysis, design, and programming

Principles of data base systems documentation

Principles, procedures, and methods used in data acquisition, storage, structuring, and retrieval

Data warehousing technologies such as MS SQL Server, etc.

Data warehouse concepts and applications including extraction, transformation, load concepts, modeling, cleansing, and query tuning

Enterprise Resource Planning (ERP) systems such as SAP, Peoplesoft, Oracle, etc.

Query and reporting tools

New developments in computer concepts, methodology, and technology

Characteristics of systems software

Ability to:

Design, analyze, implement and maintain integrated data base management systems

Integrate data from a wide variety of systems into data base management systems

Analyze large quantities of data for discrete and common components

Analyze and interpret detailed data base systems and procedures

Define data base elements in an effective manner

Cope with novel and difficult problems

Recognize significant factors and relationships

Provide technical assistance to users and staff members with lower-level skills

Respond to data base systems problems accurately and take appropriate action

Train data processing employees in the application of new concepts related to integration of data elements

Communicate highly complex technical concepts both orally and in writing

Write clear and comprehensive reports and instructions

Meet project schedules and deadlines

Work effectively and cooperatively with District staff

Learn and apply new concepts in information technology

Learn the characteristics of new data base systems and update skills to adapt to changing technology

Entrance Qualifications

Education:

Graduation from a recognized four-year college or university, with a degree in management information systems, computer science, computer engineering, or a related field.

Experience:

Four years of recent full-time paid experience in business applications analysis, design and programming for medium or large scale, multi-programmed computers, including two years of experience in data base analysis and management. Experience with an Enterprise Resource Planning (ERP) system is desirable.

Special:

A valid California Class "C" driver's license. Travel throughout the District may be required.

Reasonable Accommodations

Our class specification generally describes the duties, responsibilities, and requirements characteristic of the position(s) within this job class. The duties, responsibilities, and requirements of a particular position within this class may vary from the duties of other positions within the class.

In accordance with the Americans with Disabilities Act (ADA), the Los Angeles Community College District provides reasonable accommodation to qualified individuals with covered disabilities on a case-by-case basis throughout the application, examination, and hiring processes and throughout employment. If an individual is in doubt about his or her ability to perform the duties and responsibilities of a position or possession of any other requirement noted in a class specification or job announcement, he or she should always apply for a position and request reasonable accommodation at the appropriate time.

 


CLASS: 1041; EST: ; REV: 2/26/2013;