Database Administrator

Location Los Angeles Community College District Office

Salary $12,261.72 - $15,190.12/mo; $ - $/yr (Based on a full-time 12-mo position)

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

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

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

Integrates the database with existing software applications, portals, storage devices, analytics, and new cloud storage technologies.

Assists with the set up and development of Disaster Recovery sites and with Business Continuity Plans.

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

Monitors the database activities for performance, security and reliability.

Assists with database maintenance management and troubleshooting activities.

Assists with applying patches and updates.

Defines the various data elements of the database in standard terminology and assembles, compiles, and updates the dictionary as necessary.

Monitors and manages control logs, and archive logs and other database parameters.

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

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

Develops and is responsible for the security and system integrity to protect the database 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 database documentation including directories, architecture diagrams, 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.

A Database Administrator
is responsible for the integration of database elements into a common system for the purpose of improving data processing efficiency and maintenance related to applications and storage. 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 data integrity and security of each system.

A Chief Information Technology Manager, Engineering and Technology Services Delivery, is responsible for planning, coordinating, and managing the District-wide operations of application and system software, technology services support, server infrastructure, and technology project management.

General supervision is received from a Chief Information Technology Manager, Engineering and Technology Services Delivery . Work direction may be exercised over assigned technical staff.

Knowledge of:

Characteristics and capabilities of data processing equipment

Principles and methods of database integration

Database systems such as Oracle/Rdb, In Memory Database, Access, SQL Server, etc.

Concepts of Disaster Recovery and Business Continuity architecture and requirements

Principles and techniques of database systems analysis, design, and programming

Principles and procedures of database systems documentation

Principles, procedures, and methods used in data acquisition, storage, structuring, retrieval, and cross system interdependencies and relationships

Data warehousing technologies such as MS SQL Server, etc.

Principles and techniques of data security in complex environments

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

Information technology concepts and capabilities

New trends and developments in computer concepts, methodology, and technology

Characteristics of systems software

Principles of training

English usage, punctuation, and spelling

Ability to:

Design, analyze, implement and maintain…