COLORADO COMMUNITY COLLEGE SYSTEM (CCCS)
INFORMATION TECHNOLOGY
JOB DESCRIPTION – ORACLE DBA Title: Oracle Database Administrator (Oracle DBA) Effective Date: 7/1/5
Reports To: Director of Infrastructure Revision Date: 5/11/5
Position Code:
Salary Range:
Department: Information Technology, CCCS
FLSA: Exempt Unit Description: Applications Management is a department under the CCCS Information Technology division, and is responsible for supporting mission-critical, state-wide and campus-wide, computer-based applications such as Student Information System (Banner SIS), Financial Information System (Banner Finance), Financial Aid, Human Resources & Payroll, and the Enterprise Data Warehouse (EDW). The department also provides database administration support for implementation, upgrades and maintenance of Oracle-based, campus-wide applications for 13 community colleges, CCCS system office, CCC Online university and 4 (four) Area Vocational Schools (AVS) in the state of Colorado. Summary Statement: Under the direction of the IT Director, the Oracle Database Administrator will have primary responsibility for the Oracle database implementation, performance-tuning and support on Linux operating system in a clustered configuration, including high-availability configuration such as RAC (Real Application Cluster), Security configuration such a Virtual Private Database, Interface and Integration configuration with Luminis portal and other third-party products. Major technical duties include installation and upgrade of Oracle products and application system software, monitoring and tuning system performance, establishing user access controls, database security, defining new/modified database tables, and device configuration and planning. The DBA will also perform more complex analysis, programming, and implementation of scripts and programs needed in support of applications. Major Functional Areas and Description of Duties:
Percent
Of Time Tasks 40% Production Support:
1. Provide primary DBA design and support services for establishing, upgrading and maintaining the Oracle software environments, which support the CCCS systems. These include SCT Banner Finance, HR, Financial Aid, Student Administration and Enterprise Portal systems, as well as other vendor-supplied and locally developed systems. 2. Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. 3. In conjunction with the network security administrator, establish and manage user access, and design and implement security architecture. 4. Create, maintain and refresh required Oracle instances/databases for development, test and production environments. 5. As required, help resolve application problems. Act as liaison between application programmers and DBMS vendor to report and resolve problems. 6. Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to insure that application problems do not adversely affect production operations. 7. Monitor system resources of database servers to assure production systems meet performance & availability requirements and hardware enhancements are scheduled in a timely fashion. 8. Provide after hours on-call support for critical database issues. 20% Development, Tuning & Diagnostics: 1. Provide expert assistance in setting up instances, table-spaces, tables, indices and views. 2. In conjunction with programmer/analysts, define new objects or modifications to existing objects. 3. Provide expert assistance in SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes. 4. Using software packages (e.g., OEM, Diagnostics Pac, Tuning Pac) and/or local scripts, monitor performance, space, Oracle database parameters and tune as required. 20% Planning & Implementation: 1. Install, upgrade and maintain Oracle software products/versions for DBMS, server software and various tools software as appropriate for the project. 2. Following standards, write, maintain and document Linux scripts needed in support of applications. 3. Monitor disk usage; plan acquisition and replacement of disk devices as needed. 4. Act as project liaison and coordinate with Linux system administrators for application of OS patches and maintenance required for database servers. 20% Other tasks as needed: 1. Work with ERP project team (or other project teams as required) to determine needs, set priorities, create project plans and determine schedule for AIS installations/upgrades and other local AIS tasks. 2. Implement standards as defined by DBA team as applicable to the ERP and other systems. 3. Understand and maintain documentation of dependencies between versions of application vendor software, Oracle software, Linux Operating System and compilers. 4. Work independently to track outstanding tasks and projects, monitor progress, plan workload and dependencies, resolve resource conflicts and provide status reports to the IT Director. 5. Provide DBA training and support for other DBAs. Qualifications: MS degree in Computer Science, Mathematics or Physics preferred. BS degree required. Certification in Oracle highly desired. Relevant education and experience in the appropriate technical areas may be considered as a substitute for formal education. Expert knowledge of and substantial experience with Oracle RDBMS:
1. Oracle database administration on servers for mission critical applications
2. Installation and upgrades of multiple Oracle software products/versions for DBMS, server software and various tools software
3. Development, maintenance and documentation of procedures and standards for effective database software use
4. Analysis and management of Oracle problems/defects using TARs and or Metalink with Oracle Corporation and installation of patches
5. Use of software and locally developed tools to monitor Oracle databases
6. Definition of entity and referential integrity constraints, stored packages, procedures and functions, database links, triggers, snapshots and other internal database objects
7. Management of role-based security Expert hands on knowledge of and experience with Unix or Linux, preferably Red Hat Linux Enterprise Version:
1. Write and modify complex Linux shell scripts to manage Oracle environment and application processes
2. Problem analysis involving interactions/dependencies between Linux and Oracle
3. Production support for Oracle running on Linux
4. Set up, testing and implementation of backup/recovery strategies using Oracle's Recovery Manager (RMAN) Experience in installing, upgrading and providing production support for Oracle on UNIX-based operating systems:
1. Ability to install and manage multiple versions of Oracle in a common Unix or Linux environment
2. Plan, document, coordinate and implement complex vendor upgrades to Oracle applications while protecting integrity of the production environment
3. Document upgrade problems and communicate/resolve with application vendor
4. Design and implementation of local table changes Experience in Oracle DBA design and support for multiple, complex applications:
1. Management of technical tasks required to meet project goals (upgrades, enhancements, etc.)
2. Development and tracking of technical project timelines Ability to:
1. Work effectively on concurrent, multiple tasks and projects
2. Work independently to coordinate, organize and track tasks effectively and meet project deadlines
3. Keep current on technology by identifying, reading and using technical manuals and other resources
4. Communicate and collaborate effectively with staff of varying technical expertise
5. Excellent oral and written communication skills Preferred Qualifications:
1. Experience supporting 24x7 environments
2. Experience with other RBDMS such as MySQL and/or MS SQL Server installation, configuration & management.
3. Experience with SunGard SCT Banner, WebCT or Blackboard products. Information About The Job: The Colorado Community College System is the state's largest and fastest growing system of higher education. We are unique in the country in terms of our governance and oversight responsibilities. The System has governance responsibility for 13 state community colleges offering a variety of career and academic programs. Additionally, the System assists the State Board for Community College and Occupational Education in exercising certain curriculum and funding authority over 4 area vocational schools, 2 local district community colleges, and career and technical programs in over 150 school districts throughout the state. Application Process: Submit a current resume and cover letter addressing the position requirements, and a list of three professional references and phone numbers to: Jobs@cccs.edu
Fax: 303-620-4030
Mail: 9101 E. Lowry Blvd.
Denver, CO 80230 A review of applications will begin immediately and will continue until the position is filled.
Incomplete applications may not be considered. Candidates will be evaluated on the basis of their qualifications as related to the duties and responsibilities of the position. • Equal Opportunity Employer -The Colorado Community College System is an equal opportunity employer and does not discriminate on the basis of age, race, religion, color, national origin, sex, or disability in its activities, programs, or employment practices as required by Title VI, Title IX, and Section 504, Age Discrimination Act, and Title II of the ADA. Written inquiries may be referred to the Director of Affirmative Action, 9101 E. Lowry Blvd., Denver, CO 80230-6011, or by phone at 303-620-4000.
• Former employees of the Colorado Community College System or one of its 13 colleges, who were disciplinarily terminated or resigned in lieu of termination, must disclose this within your application materials.
• This position may require irregular hours, including nights and weekends, as well as working more than eight (8) hours per day at certain times.
• Candidates must successfully pass a criminal/credit background check prior to hire. |
