$54.37-$67.36 hourly / $9,423.64-$11,674.24 monthly / $113,083.68-$140,090.88 annual
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 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.
General supervision is received from a Software Systems Engineering Manager. Work direction may be exercised over assigned technical staff.
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
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
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.
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.
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.