This role involves analyzing, designing, implementing, and maintaining the District's integrated database management systems. The Database Administrator is responsible for integrating database elements into a common system to improve data processing efficiency and maintenance related to applications and storage.
Responsibilities
Analyze, design, implement, maintain, and modify integrated database management systems for the District
Plan, organize, and schedule the activities necessary to implement and maintain database management systems
Integrate the database with existing software applications, portals, storage devices, analytics, and new cloud storage technologies
Assist with the set up and development of Disaster Recovery sites and with Business Continuity Plans
Analyze 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
Monitor the database activities for performance, security, and reliability
Assist with database maintenance management and troubleshooting activities
Assist with applying patches and updates
Define the various data elements of the database in standard terminology and assemble, compile, and update the dictionary as necessary
Monitor and manage control logs, archive logs, and other database parameters
Coordinate the development, installation, and revision of database management systems with applications and software systems and programming staff
Administer the implementation, maintenance, modification, and utilization of database management systems
Develop and be responsible for the security and system integrity to protect the database elements from unauthorized access, use, change, or removal
Provide technical assistance to system users in detecting and resolving problems related to the database
Develop and maintain database documentation including directories, architecture diagrams, glossaries, and cross-reference listings
Participate in the evaluation and selection of data storage and retrieval equipment and systems software
Plan, organize, schedule, and participate in the training and orientation of staff relative to the requirements and utilization of the integrated database management system
Perform related duties as assigned
Requirements
Knowledge of characteristics and capabilities of data processing equipment
Knowledge of principles and methods of database integration
Knowledge of database systems such as Oracle/Rdb, In Memory Database, Access, SQL Server, etc.
Knowledge of concepts of Disaster Recovery and Business Continuity architecture and requirements
Millions of jobs, with real people getting hired every day
200,000+
New jobs added daily
7,000,000+
Verified job listings
1,000,000+
Tailored applications submitted
Knowledge of principles and techniques of database systems analysis, design, and programming
Knowledge of principles and procedures of database systems documentation
Knowledge of principles, procedures, and methods used in data acquisition, storage, structuring, retrieval, and cross-system interdependencies and relationships
Knowledge of data warehousing technologies such as MS SQL Server, etc.
Knowledge of principles and techniques of data security in complex environments
Knowledge of data warehouse concepts and applications including extraction, transformation, load concepts, modeling, cleansing, and query tuning
Knowledge of Enterprise Resource Planning (ERP) systems such as SAP, Peoplesoft, Oracle, etc.
Knowledge of query and reporting tools
Knowledge of information technology concepts and capabilities
Knowledge of new trends and developments in computer concepts, methodology, and technology
Knowledge of characteristics of systems software
Knowledge of principles of training
Knowledge of English usage, punctuation, and spelling
Ability to design, analyze, implement and maintain database systems
About the Company
Los Angeles Community College District Office analyzes, designs, implements, and maintains the District's integrated database management systems.