Under the direction of a designated supervisor, manager, or director, incumbents assigned to this classification performs all aspects of functional application administration and technical application integration for assigned applications including enterprise resource planning (ERP). This position is responsible for performing the daily Database Administration duties for a large enterprise environment, including Ellucian/Banner and other enterprise software. This position works closely with the designated supervisor, manager or Director to coordinate and plan future upgrades and projects that will benefit the entire institution including identifying infrastructure and support service needs. 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. The incumbent in this position will also architect, develop, integrate, monitor, maintain, and troubleshoot applications delivered in a cloud environment. Pasadena City College (PCC) operates within a managed cloud environment and is planning a migration to SaaS.
EXAMPLE OF DUTIES:
Develop and manage integrations between the college's Enterprise System (Banner), portal, and both local and cloud-based third-party applications and systems including Ellucian Ethos Integration, Ellucian User Provisioning (EUP), Ellucian Ethos Identity (EEI), Ethos Identity Federation Service (EIFS) and other modern access management tools in addition to ensuring that Active Directory data is accurate and Single Sign-On to Banner system is operating normally.
Develops or validates deployment scripts for database software changes and deploys, databases and database changes in testing, training, preproduction, and production environments. Coordinates with cloud teams for deployment into non-production and production environments. Validates enterprise updates applied by cloud teams.
Coordinates with technical staff in multi-tiered technology environment to establish system operation procedures, change control procedures, capacity planning, systems documentation, and update plans.
Document integration processes and maintain records for compliance and auditing purposes.
Installs, configures, and manages web-based applications including the setup and configuration of Apache, Internet Information Services (IIS), Tomcat, PHP and the installation of SSL/TLS certificates.
Installs and configures enterprise software, including upgrades, patches, and third-party tools. Maintains enterprise application software and related software. Coordinates with cloud application support and campus partners when applicable to execute these tasks.
Participates in testing and debugging of enterprise software applications systems when escalated through established channels.
Selects or assists in the selection of enterprise software application 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 application requirements, specifications, configuration, and deployment plans for performance, maintainability, scalability, operations impact, and conformance to architectural standards.
Analyzes query plans and monitors database system performance to identify and address performance problems and analyzes code written by developers to assess impact on the enterprise application systems and application performance.
Monitors and maintains third-party application design and implementation, including data structures.
Monitors data quality, data integrity, and database availability.
Assists staff in resolving operations problems found in applications programs as it relates to enterprise software applications.
Monitoring and optimizing system performance.
Performs other related duties as assigned.
MINIMUM QUALIFICATIONS:
Bachelor's degree, or equivalent, from an accredited college or university in business, computer science, management information technology or a related field.
Five years of hands-on experience with enterprise applications, web application servers, serverless multi-tier 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, in a Cloud or SaaS environment.
KNOWLEDGE, SKILLS, AND ABILITIES:
Understanding the principles and methods of database design, development, and integration, including proficiency in database languages such as SQL.
Ability to apply techniques of data systems analysis, design, and programming effectively.
Skill in implementing, configuring, customizing, and integrating software solutions using APIs and managing source/version control systems such as git.
Ability to follow customer service protocols with a priority on providing excellent service, including effective communication in a multi-cultural environment.
Knowledge of Oracle DBMS, Postgres, Ellucian Ethos Integration, Ellucian Ethos Identity, Ellucian User Provisioning, Ethos Identity Federation Service (EIFS), and other modern access management tools.
in installing, configuring, and managing web-based applications, including Apache, Internet Information Services (IIS), Tomcat, PHP, and installing SSL/TLS certificates.
Understanding cybersecurity best practices surrounding enterprise applications, including data security.
Ability to plan and schedule complex projects, maintainaccurate records, and track the status of assignments effectively.
Proficiency in making oral and written presentations of proposed systems to both technical and non-technical personnel and communicating complex technical concepts clearly.
Skill in establishing and maintaining cooperative and effective working relationships with staff, administrators, faculty, students, and others, and assisting ITS personnel in applying new concepts related to data integration.
CORE COMPETENCIES - The District has identified the following essential skills and attributes needed for success in this position.
Technical Proficiency
Application and System Integration
Cloud and SaaS Environment Management
Data Integrity and Security
Project Planning and Coordination
Problem Solving and Troubleshooting
Communication and Collaboration
Strategic Planning and Innovation
SALARY RANGE CFT-65
APPLICATION AND SELECTION PROCESS
Pasadena City College (PCC) utilizes an online application process. Hard copy, e-mailed, or faxed resumes are not accepted. Job postings will not be reopened due to failure to submit an application before the closing date for any reason. You can apply for a position from any computer with Internet access. Please keep in mind the following:
If you do not follow the process or your application/resume is incomplete, your information will not be processed.
If you need to update any submitted information, you will need to reapply in full. When HR sees duplicate applications, we archive the oldest and the most recent application and materials are considered.
The selection advisory committee will review, evaluate, and consider applications and supporting materials received by the deadline. Meeting the minimum qualifications for a particular position does not assure the applicant an interview.
While the acceptance of the application packet is done through PCC's Applicant Tracking System (ATS), all hiring decisions are made by a hiring committee.
Once applications are submitted, they are final. Please carefully review your application and the documents which you are attaching to make sure that they are free from errors and complete. If you require assistance with your application, please refer to the application guide or you may contact NeoEd Customer Support at 855-524-5627. Customer Support is available Monday - Friday, 6 a.m. - 6 p.m. (PST).
All materials listed below may be required for your application packet to be considered complete:
Resume or Curriculum Vitae
Cover Letter
After a review of applications received, the District may require the completion and submission of supplemental documents prior to the interview process.
ADDITIONAL INFORMATION
Successful applicants must provide proof of eligibility to work in the United States.
Successful completion of background check including Live Scan and Tuberculosis (TB) assessment/screening.
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.
Applicants who have disabilities may request that accommodations be made in order to complete the selection process by contacting the Office of Human Resources directly at (626) 585-7388.
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. (Public Law 101-542).
The Pasadena Area Community College District is an equal opportunity employer. The District encourages applications from underrepresented minorities and the disabled.
An applicant, who attempts to contact individual Board members or members of the screening committee with the intent of influencing the decision of the committee or the Board, will be disqualified. General inquiries regarding the position and/or District employment should be directed to the Office of Human Resources.
PASADENA AREA COMMUNITY COLLEGE DISTRICT Equal Opportunity, Title IX, Section 504 Employer
