Database Administrator

Type of Appointment: Full Time Probationary

Job Classification:Operating System Analyst

Anticipated Hiring Range: $8500 $9583 per month

Work Schedule:Monday Friday 8:00 a.m. 5:00 p.m.


THE DEPARTMENT:

The mission of the IT&IP Division is to provide stewardship leadership and service in support of the teaching and learning mission of the university. IT&IP provides learning technologies strategies leadership and support all of which enhance teaching learning the quality of the student experience personal productivity and administrative effectiveness. The Cloud and Support Services department provides central technology support for the design development security and maintenance of campuswide computing infrastructure including: email web services intranet services directory services account management for technology access as well as various server operating system environments and databases including UNIX Linux and Windows for the support of campus applications such as PeopleSoft Blackboard CBORD Odyssey Oracle and network management.

DUTIES AND RESPONSIBILITIES:

Oracle Database Administration

• Ensure campus Oracle databases are managed and maintained in a reliable and secure manner and comply with campus standards for security
• Research plan coordinate and install new releases of Oracle database software and critical patch updates (CPUs) in both nonproduction and production databases working with other technical staff (DBAs developers and server administrators) and functional contacts.
• Participate in teams to plan develop and execute database disaster recovery plans including regularly scheduled backup recovery procedures to ensure data integrity.
• Execute regular data integrity analysis on databases and application systems using predefined processes. Make appropriate action plans based on results for management review.
• Plan and implement new Oracle databases including the related supporting mechanisms such as requesting backup configuration integrity checks monitoring etc.
• Stay current on Oracle enhancements and related supporting technologies and make recommendations for improvement areas to management. Incumbent may be required to respond to inquiries from staff outside of normal business hours in support of campus operations.

Planning Coordinating and Project Support

• Provide support for campus projects relying on Oracle databases and related infrastructure
• Participate in planning new developments releases upgrades or implementation projects including developing and maintaining project plans in coordination with other team participants; responding to project issues; collaborating with other project participants in accomplishing tasks; communicating issues to management and other project participants to ensure resolution.
• Provide Oracle assistance to campus technical and functional staff who are maintaining or troubleshooting applications or processes. Interpret information to perform root cause analysis. Prepare recommendations and documentation regarding the results of the analysis.
• Gather functional requirements of proposed projects to understand the data classification being stored database design and storage requirements. Document the needs and ensure the database design meets campus standards for securing sensitive data.
• Communication and coordination of maintenance support and changes to the Oracle infrastructure in a distributed environment across a diverse audience including: technical staff (DBAs developers server administrators) functional departments and IT&IP management to plan changes identify issues and to mitigate unintended service impacts.
• Assist with technical testing in a distributed environment to ensure endtoend testing across interdepartmental groups. Provide technical expertise to developers and endusers to ensure comprehensive testing. Document and communicate results of testing. Track issues to resolution.
• Ensure adequate documentation for ongoing support and maintenance with all involved parties.

Performance and Security Monitoring

• Evaluate level of systems operation and recommend measures to improve overall performance and security.
• Monitor and maintain the Oracle infrastructure for trends (usage performance growth etc.) to ensure longterm stability and maintainability of the Oracle infrastructure and related services.
• Provide ongoing performance and security analysis for databases and database operational environment.
• Utilize database performance and monitoring tools for the database environment.
• Maintain data confidentiality integrity and availability by implementing security policy and management guidelines including database encryption using Oracle Transparent Database Encryption (TDE) and other technologies.

Cloud Infrastructure Support

• Evaluate and support the campus cloud migration plan by evaluating and recommending technologies and strategies for databases that can be migrated to cloud hosting providers:
• Assess the needs of individual databases and make recommendations to management about which databases would support migration to cloud hosting environments particularly Amazon AWS RDS.
• Understand and communicate the benefits and design decision points for migrating Oracle workloads to a cloud environment and communicate those to other IT staff and management.

QUALIFICATIONS:

• The career level is broad and includes intermediate through senior level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically incumbents have acquired the requisite skills and knowledge through a combination of education training and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems solving a wide range of problems and developing practicable and thorough solutions and using effective communication and listening skills.
• Providing technical support to technical and nontechnical users including involvement in significant projects involving core enterpriselevel infrastructure and/or services.
• Experience in supporting Oracle databases and related applications running in a Linux environment.
• Knowledge of and experience with Oracles network transport protocols and other associated networking protocols.
• Experience with utilizing backup technologies in an Oracle environment to insure recoverability of Oracle databases and systems including the use of RMAN.
• Experience and knowledge of maintaining the security of Oracle databases including the use of firewalls Oracle Transparent Data Encryption etc.
• Experience with common scripting languages used in a Linux Oracle environment such as shell scripts Oracle PL/SQL JAVA Perl etc.
• Ability to work in a team to debug complex technical problems with modern database management systems applications and networks.
• Ability to interact with others and to communicate technical information to both technical and nontechnical users.

PREFERRED QUALIFICATIONS:

• Oracle and/or AWS certifications Experience working in an academic environment
• Experience with the following: Amazon Web Services MSSQL MySQL and/or MariaDB Linux OS management

Out of State Work

The California State University (CSU) system is a network of twentythree public universities providing access to a quality education through the support of California taxpayers. Part of CSUs mission is to prepare educated responsible individuals to contribute to Californias schools economy culture and future. As an agency of the State of California the CSUs business operations almost exclusively reside within California. The CSU OutofState Employment Policy prohibits hiring employees to perform CSUrelated work outside California. For more information go to theCalifornia State University OutofState Employment Policy.

Background Check

Cal Poly Pomona will make a conditional offer of employment to final job candidates pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature gravity and recency of the conviction the candidates conduct performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information go to theCalifornia State University Background Check Policy.

CSU Classification Salary Range

This position is part of the CSUEU bargaining unit 9. The CSU Classification Standards for this position are located on theCSU Classification Standards website. The CSU Salary Schedule is located on theCSU Salary Schedule website. The classification salary range for this position according to the respective skill level is: minimum $5158 and maximum $12730 per month. Please refer to the anticipated hiring range for the appropriate salary rate for this particular position.

Employment Eligibility Verification

Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. For more information go theI9 Acceptable Documents website.

University Driving Requirement

Positions that require driving for university business by using a personal or state vehicle must comply with the Authorized University Driver Policy. Driving records are monitored and evaluated by the Risk Management Department. The Risk Management Department evaluates a good driving report based on the following criteria. The driver must: 1. Have a valid California or other State Drivers license. 2. Have no more than 3 motor vehicle violations or been the cause of 3 accidents in a 12month period (or any combination of 3 thereof) 3. Not have more than 3 DMV Points if their license is Class C or 4. Not have more than 5 DMV Points if their license is Class A B or C with endorsements. For more information go to theAuthorized University Driver Policy.

Conflict of Interest

This position is a designated position in the California State Universitys Conflict of Interest Code. The successful candidate accepting this position is required to file financial interest disclosure forms subject to state regulations. For more information go to theConflict of Interest policy.

Security & Fire Safety

In compliance with state and federal crime awareness and campus security legislation including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act California Education Code section 67380 and the Higher Education Opportunity Act (HEOA) Cal Poly Pomonas Annual Security Report and Annual Fire Safety Report are available for viewing at theCal Poly Pomonas Annual Security ReportandCal Poly Pomonas Annual Fire Safety Report.

Pay Transparency Nondiscrimination

As a federal contractor Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about discussed or disclosed their own pay or the pay of another employee or applicant. For more information see thePay Transparency Nondiscrimination Provision poster.

Reasonable Accommodation

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at. For more information go toEmployment Notices.

Equal Employment Opportunity

Consistent with California law and federal civil rights laws Cal Poly Pomona provides equal opportunity in employment without unlawful discrimination or preferential treatment based on race sex color ethnicity or national origin. Our commitment to equal opportunity means ensuring that every employee has access to the resources and support they need to thrive and succeed in a university environment and in their communities. Cal Poly Pomona complies with Title VI of the Civil Rights Act of 1964 Title IX of the Education Amendments of 1972 the Americans with Disabilities Act (ADA) Section 504 of the Rehabilitation Act the California Equity in Higher Education Act Californias Proposition 209 (Art. I Section 31 of the California Constitution) other applicable state and federal antidiscrimination laws and CSUs Nondiscrimination Policy. We prohibit discriminatory preferential treatment segregation based on race or any other protected status and all forms of discrimination harassment and retaliation in all university programs policies and practices.

Other Notices

For other important employment notices we invite you to visitCal Poly Pomonas Employment Noticesweb page.