CBA DESIGNATION: Represented
Under the direction of a designated supervisor, manager or Director, incumbents assigned to this classification administer the structure of the District’s databases and integrates the database elements into a common enterprise level database management system for the purpose of improving efficiency of knowledge and applications development, design, implementation and maintenance activities. Analyzes many systems for discrete and common elements and integrates these elements into an operable database architecture, which satisfies the needs of all systems. Additionally, incumbents maintain the integrity of the data for each system function. Additional duties include: installing, configuring, and maintaining Ellucian Banner upgrades including CALB upgrades. Coordinates upgrades with users and carefully ensures compatibility with all installed components.
SUPERVISION RECEIVED AND EXERCISED
Receives general direction from an appropriately designated manager. Will not act in the capacity of a supervisor.
REPRESENTATIVE DUTIES: (Illustrative Only)
- Designs and maintains the District databases and the data element dictionary; implements controls necessary for access to the database; and, defines various elements of the database in standard terminology.
- Ensures District-wide data and technical requirements, including data definition, data structure, documentation, operational guidelines, and data protection are met.
- Installs and configures database management software, including upgrades, patches, and third-party tools. Maintains database management software and related software.
- Analyzes application programs and systems, proposed and installed to define their data elements and the inter-relationships and commonality of data elements in program usage.
- Participates in testing and debugging of new District database systems and programs.
- Monitors the use and availability of on-line database storage resources; participates in the evaluation and selection of data storage and retrieval and database system software.
- Selects or assists in the selection of new database management systems including design, feasibility studies, cost estimates, impact analysis, data conversion functions, and reduction of redundant data.
- Assists in the selection of new application systems by reviewing database design, database technologies, hardware specifications, and configuration and deployment plans for performance, maintainability, scalability, operations impact, and conformance to architectural standards.
- Develops or validates deployment scripts for database software changes and deploys, databases and database changes in testing, training, preproduction, and production environments.
- Analyzes query plans and monitors database system performance to identify and address performance problems, and analyzes database code written by developers to assess impact on the database system and application performance.
- Trains programming staff and users in database subjects as it relates directly to their respective assignments.
- Provides assistance to others in the use of District databases; acts as a resource to others in the use of specific databases in project development and program maintenance assignments.
- Consults with users and vendors in diagnosing and solving all database software and data-related problems.
- Participates in the formulation of database strategies, and evaluation of new technologies in database management.
- Provides programmer and user documentation on District databases, prepares documentation for computer operations and database management. Writes stored procedures, functions, triggers, scripts for database system management, and batch jobs in the database system.
- Writes policies and procedures pertaining to database standards, management, security and maintenance; and assists in the development of database system related standards and methodologies and the selection of a standard DBA toolset.
- Maps legacy data to new database design, performs database backup and database recovery, manages disk space for database systems, and conducts capacity planning.
- Monitors and maintains third-party database design and implementation.
- Monitors data quality, data integrity, and database availability.
- Assists staff in resolving operations problems found in applications programs as it relates to District database.
- Planning, analyzing, supporting and maintaining the LancerPoint Ellucian Banner System including its components such as: Luminis portal, Operational Data Store, Workflow, XtenderSolutions, Relationship Management, UC4, Touchnet, and any other district applications.
- Installing, configuring, and maintaining Oracle based technologies including Oracle Database, Oracle Warehouse builder, Oracle Internet Application Server, Oracle Fusion Middleware and any required Oracle technologies.
- Specifying the user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data to ensure the database integrity.
- Monitoring the database access security and specifying which users can have specific privileges and which data can be accessed outside the ERP applications.
- Monitoring and optimizing system performance using index tuning, disk optimization, and other methods.
- Performs other related duties as assigned.
KNOWLEDGE AND ABILITIES:
- Principles and methods of database design, development and integration.
- Techniques of data systems analysis, design and programming.
- Structure and use of database languages such SQL.
- Computer software including programming languages, programmer productivity aids, utilities and commercial software for microcomputers through mainframes.
- Customer service protocol with a customer-service oriented priority.
- Oracle DBMS
- Plan and schedule complex projects.
- Establish and maintain cooperative communication with staff, administrators, faculty, students and others contacted in the course of performing assigned duties in a multi-cultural environment.
- Make oral and written presentations of proposed systems to both technical and non-technical personnel regarding database concepts; communicate complex technical concepts effectively orally and in writing.
- Read and digest technical materials relating to database packages and their application to the District.
- Integrate data from a wide variety of systems into a cohesive database management system.
- Define database elements in an effective manner.
- Establish and maintain cooperative and effective working relationships with members of the college community and with outside contacts.
- Assist ITS personnel in the application of new concepts related to the integration of data elements.
- Maintain accurate and effective records of projects and the status of assignments.
- Follow oral and written directions; work independently with little direction.
EDUCATION AND EXPERIENCE:
A typical manner in which to gain the requisite education and experience is through the completion of a four-year degree at a university in Computer Science or a related field and five years of hands-on experience with databases, database application servers, Web application servers, and n-tier systems architecture administration in a large-scale data-computing environment, two years of which must include planning, designing, implementing, and administering server-based, scalable databases.
The ability to remain current with changing technology by reading professional publications, participating in professional organizations and by attending seminars and classes as needed.
Licenses and Certifications:
Possession of, or ability to obtain, a valid California Driver’s License by time of appointment.
Must possess mobility to work in a standard office setting and use standard office equipment, including a computer; to operate a motor vehicle and to visit various District and meeting sites; vision to read printed materials and a computer screen; and hearing and speech to communicate in person, before groups, and over the telephone. This is primarily a sedentary office classification although standing and walking between work areas may be required. Finger dexterity is needed to access, enter, and retrieve data using a computer keyboard, typewriter keyboard, or calculator and to operate standard office equipment. Positions in this classification occasionally bend, stoop, kneel, reach, push, and pull drawers open and closed to retrieve and file information. Employees must possess the ability to lift, carry, push, and pull materials and objects up to 25 pounds with the use of proper equipment.
Employees work in an office environment with moderate noise levels, controlled temperature conditions, and no direct exposure to hazardous physical substances. Employees may interact with upset staff and/or public and private representatives in interpreting and enforcing departmental policies and procedures.
PROBATIONARY PERIOD: One year.
Pasadena City College
1570 East Colorado Boulevard, Pasadena, CA 91106
(626) 585-7361 direct ⋅ (626) 525-7924 fax