Home Post About Contact

Find Jobs
Job Title Description
State

 Job Description
Database Administrator
Pasadena, CA
Posted Jul 10, 2013 by Pasadena City College
Category: Computer and Information Technology

THIS JOB POSTING HAS EXPIRED.



Pasadena City College

DATABASE ADMINISTRATOR

Information Technology Services
100% - 12 months
#005

FINAL DATE TO FILE DISTRICT APPLICATION – Friday, August 16, 2013 by 12:30 p.m

Monthly Salary Range:
$5922.08 - $7558.24 (Starting Salary $5922.08)

Work Schedule: Monday through Friday, 40 hours per week

BASIC FUNCTION
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.

REPRESENTATIVE DUTIES: (Illustrative Only)
1. 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.
2. Ensures District-wide data and technical requirements, including data definition, data structure, documentation, operational guidelines, and data protection are met.
3. Installs and configures database management software, including upgrades, patches, and third-party tools. Maintains database management software and related software.
4. 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.
5. Participates in testing and debugging of new District database systems and programs.
6. 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.
7. 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.
8. 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.
9. Develops or validates deployment scripts for database software changes and deploys, databases and database changes in testing, training, preproduction, and production environments.
10. 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.
11. Trains programming staff and users in database subjects as it relates directly to their respective assignments.
12. 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.
13. Consults with users and vendors in diagnosing and solving all database software and data-related problems.
14. Participates in the formulation of database strategies, and evaluation of new technologies in database management.
15. 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.
16. 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.
17. Maps legacy data to new database design, performs database backup and database recovery, manages disk space for database systems, and conducts capacity planning.
18. Monitors and maintains third-party database design and implementation.
19. Monitors data quality, data integrity, and database availability.
20. Assists staff in resolving operations problems found in applications programs as it relates to District database.
21. Plans, analyzes, supports and maintains 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.
22. Installs, configures, and maintains Oracle based technologies including Oracle Database, Oracle Warehouse builder, Oracle Internet Application Server, Oracle Fusion Middleware and any required Oracle technologies.
23. Installs, configures, and maintains Ellucian Banner upgrades including CALB upgrades. Coordinates upgrades with users and carefully ensures compatibility with all installed components.
24. Specifies 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.
25. Monitors the database access security and specifying which users can have specific privileges and which data can be accessed outside the ERP applications.
26. Monitors and optimizing system performance using index tuning, disk optimization, and other methods.
27. Performs other related duties as assigned.

KNOWLEDGE AND ABILITIES
Knowledge of:
• 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

Ability to:
• 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 multicultural environment.
• Make oral and written presentations of proposed systems to both technical and nontechnical 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.

DESIRABLE QUALIFICATIONS
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 and maintain, a valid California Driver’s.

PHYSICAL DEMANDS
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.

ENVIRONMENTAL ELEMENTS
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.

APPLICATION PROCEDURES
A DISTRICT application, cover letter, resume and transcripts are required and must reach Human Resources by 12:30 p.m. on the final filing date. A postmark is not acceptable for this purpose. Applications or supporting documents cannot be submitted electronically or by FAX transmission.

To request the District application by telephone, please call 626.585.7257.

A complete application package
MUST include:
1. Official District application
2. Cover letter
3. Resume
4. Official transcripts of undergraduate work are required.
Foreign transcripts and degrees require official certification of equivalency to U.S. transcripts and degrees by a certified U.S. review service at the time of application.
5. Other information considered pertinent to the application (optional)

Note: All supporting documentation should include position name and/or position number. All materials submitted are for this position only and become the property of the District. As such, they will not be returned or copied.

Submit District application and supporting documents to:
Human Resources (C204)
Pasadena City College
1570 East Colorado Boulevard
Pasadena, CA 91106

The hiring committee will review, evaluate, and consider applications and supporting materials received by the deadline. Meeting the minimum qualifications does not assure the candidate an interview. It is, therefore, important the application be thorough and detailed. The District reserves the right to readvertise, delay, or choose not to fill, one or all of the positions.

BENEFITS
Generous fringe benefits include fully paid medical, dental, and vision insurance for employees and their families, along with life insurance for the employee. In addition, there are sixteen (16) paid holidays per fiscal year. Confidentially designated employees receive 22 vacation days per fiscal year.

PROBATIONARY PERIOD: One year.

ADDITIONAL INFORMATION
The Immigration Reform & Control Act of 1987, Public Law 99-603 requires that employers obtain documentation from every new employee which authorizes that individual to accept employment in this country. This requirement applies to both United States citizens and aliens. Individuals who are unwilling/unable to fulfill this requirement will not be employed.

Pasadena Area Community College District will not sponsor any visa applications.

Applicants must be available for interviews at Pasadena City College at no cost to the District.

If accommodations are needed for the application process in compliance with the Americans with Disabilities Act, please inform the Human Resources office. The application/interview process may involve speaking, reading, writing, and answering questions or other test-taking procedures. If you believe you may need reasonable accommodation to perform any of these tasks, need to inquire as to the specific nature of the tasks, or to assure physical access to the interview site, please contact Human Resources at 626.585.7388 and ask for the individual responsible for the scheduling and monitoring of employment interviews.

The Pasadena Area Community College District does not discriminate in the educational programs and activities operated by the District or in employment procedures and practices of the District. The Policies of Title IX as developed to date are available for inspection during normal business hours at the District office at 1570 E. Colorado Blvd., Pasadena, CA 91106.

Crime awareness and campus security information are available from Campus Police and Safety. (Public Law 101-542)

The Board of Trustees reserves the right to extend time limits or reinstate the search process at any time.

The Pasadena Area Community College District is an equal opportunity employer. The District encourages applications from underrepresented minorities and the disabled.

General inquiries regarding the position and/or District employment should be directed to the Human Resources office.

PASADENA AREA COMMUNITY COLLEGE DISTRICT
Equal Opportunity, Title IX, Section 504 Employer

To view full job description and to apply, visit:
http://www.pasadena.edu/HR/classified-jobs.cfm




jeid-74c6ed4100fb873e6063c50f8f141d54
 

 

HOME  |  POST A JOB  |  PRIVACY POLICY  |  RETURN POLICY  |  CONTACT US

RSS / XML Feed Add to My Yahoo! Add to Google! Add to My MSN!

Copyright ©2014 HispanicsinHigherEd.com