Los Angeles Community College District

Database Systems Specialist (#1041)

$54.37-$67.36 hourly / $9,423.64-$11,674.24 monthly / $113,083.68-$140,090.88 annual


Definition

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

Typical Duties

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.

 

Distinguishing Characteristics

A Database Systems Specialist 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 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 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 integrated database management systems

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

Analyze large quantities of data for discrete and common components

Analyze and interpret detailed database systems and procedures

Define database 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 database 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

Consistently use and promote professional standards and practices related to assignments

Maintain a focus on details, quality, and precision in the performance of duties

Actively contribute to a culture of constructive collaboration and innovation with colleagues

Build rapport with clients and maintain a professional demeanor while handling complex user issues

Maintain high levels of customer service and satisfaction

Maintain confidentiality of work-related information and materials

Work effectively and cooperatively with District staff

Learn and apply new concepts in information technology

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

Entrance Qualifications

Education and Experience:

A bachelor's degree from a recognized college or university, with a degree in computer information systems, management information systems, computer science, computer engineering, or a related field.

AND 

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 database analysis and management. Experience with an Enterprise Resource Planning (ERP) system is desirable.

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: 9/23/2020;