Salary: $7,732.03 Monthly Location : Lancaster, CA Job Type: Classified Job Number: RN23-77 Department: Information Technology Services Opening Date: 05/30/2024 Closing Date: 6/20/2024 11:59 PM Pacific
RANGE: 30 ANTICIPATED START DATE: July 2024 ADDITIONAL REQUIRED DOCUMENTS: Letter of Intent Current Resume Scanned Copy of Transcripts WORK SCHEDULE: Hours not to exceed 40 hours per week. Exact work schedule is Monday – Thursday 7:30 am to 5:00 pm and Friday 7:30 am to 11:30 am. Schedule may be subject to change by supervisor based on department needs and college hours of operation. DESCRIPTION Position fills the role of the Database Administrator for core enterprise applications and databases. Under the direction of the Director of Enterprise Applications and Data Protection, incumbent plans, prioritizes and manages various district database management duties, including; security, data warehousing, client access, manages ERP related web applications, system upgrades, tuning and performance optimization, designing forms, writing complex queries, training users to effectively access and use the available data and campus-wide data integrity, and perform other related work as assigned. REPRESENTATIVE DUTIES E = indicates essential duties of the position Recommend and assist in the implementation of Ellucian Banner, associated policies and procedures. (E) Manage, supervise, and manipulate the Oracle and Ellucian Banner system. (E) Application management for Ellucian application suite, track and document all modules and patching cycles. (E) Tracks on recommended regulatory/security patching cycles, and upgrades from Ellucian and Oracle, and coordinate with key staff and departments leads on testing and deployment of patches. (E) Prepare and maintain system specific documentation, including the design of backup and recovery procedures. (E) Manages the deployment and maintenance of Ellucian Banner Admin Pages and Self-Service Banner. (E) Recognize and repair security flaws and enforce compliance of security standards. (E) Coordinate the security of an Oracle client/server distributed environment; administer user privileges, approvals and encryption keys, including role and class security. (E) Provide end-user training in security issues as necessary. (E) Manage access to rules tables, query and update security; including assigning Unix operating system and Oracle user ID’s and passwords. (E) Perform table maintenance as necessary. (E) Create and update electronic approval queues. (E) Participate in meetings related to assignment; attend staff and college committee meetings as necessary. (E) Manages software, including but not limited to Oracle, Microsoft SQL, and MySQL databases. (E) Develop processes for optimizing database security. (E) Performance tuning of database systems. (E) Create automation for repeating database tasks. (E) Knowledge of database security, backup and recovery, and performance monitoring standards. (E) Performs other related duties as may be assigned. MINIMUM QUALIFICATIONS EDUCATION AND EXPERIENCE : EDUCATION: Bachelor’s degree in computer science or computer information systems, or closely related field. AND EXPERIENCE: Any combination equivalent to seven (7) years of increasingly responsible experience in database administration; including three (3) years of experience with large relational database systems and Unix and three (3) years of experience with other database platforms, including but not limited to Oracle, Microsoft SQL, and MySQL. OTHER INFORMATION KNOWLEDGE OF : Principles and techniques of systems analysis, data processing and documentation. Programming languages including SQL (PL/SQL a definite plus), C or C++, Unix shell scripts Deploying, tuning, and managing of Tomcat web applications. Cloud technologies including AWS and Google Cloud Workflow analysis techniques and models Documentation, records storage, and handling techniques. Providing user training. ABILITY TO: Analyze administrative and data processing systems, identify problems, and assess procedural impact, develop logical and effective solutions. Collaborate with peers to develop work plans and timelines for projects and proposed systems. Manage system security resources in a client/server distributed environment. Maintain security systems for Unix and Oracle. Train staff. Communicate clearly and concisely, both orally and in writing. Establish and maintain cooperative working relationships WORK DIRECTION, LEAD AND SUPERVISORY RESPONSIBILITIES : Not applicable – no permanent full-time staff to supervise. CONTACTS : Co-workers, other departmental staff, administrators, key application experts/users across departments, technical analysts, and vendors. PHYSICAL EFFORT : Dexterity in the use of fingers, limbs and body in the operation of office equipment. Standing for extended periods of time Sitting for extended periods of time Reaching in all directions Bending and twisting Lift and carry 25 pounds WORKING CONDITIONS : Normal office environment. APPLICATION PROCESS – PLEASE READ SUPPLEMENTAL INFORMATION It is the responsibility of each applicant to have all the requested documents submitted through NEOGOV by the deadline date in order to continue in the application process for this position. Each recruitment is conducted independently from others; therefore, interested parties need to submit separate complete application packages for each position they apply for. It is important the applicants submit ALL documents requested for the application package to be deemed complete and given consideration. This position requires the following documents to be attached to your online application in order to be considered: Application Letter of Intent (Cover Letter Current resume Copy of Transcripts of all degrees and Supplemental Coursework. All out of the country, transcripts must be evaluated prior to submitting them with applications. Any evaluation service member of the National Association of Credential Evaluation Service (NACES) is acceptable. Applicants may be subject to passing an examination (written/technical), as appropriate to the requirements of the position. Residency within a reasonable geographical area of the college may be necessary. Travel expenses for pre-employment interviews and employment processing will not be authorized Your application and any required attachments must be submitted by June 20, 2024. Applications with incomplete information (i.e., statements such as “see resume”) or missing documents will not be considered. VISA AVC does not sponsor visas. Equal Employment Opportunity and Commitment to Diversity Antelope Valley College is committed to employing administrators, faculty, and staff members who are dedicated to student success. AVC recognizes that diversity in the academic environment fosters cultural awareness, promotes mutual understanding and respect, and provides suitable role models for all students. AVC is committed to hiring processes that support equal opportunity, diversity, and provide equitable consideration for all candidates as required in federal and state law. To find out more about AVC, please visit our website at avc.edu ACCOMMODATIONS If you have, any questions or concerns/if you require accommodations for the application process in compliance with the Americans with Disabilities Act, please contact the Human Resources Office at (661)722-6311. Thank you for your interest in employment opportunities with Antelope Valley Community College District. COMMITMENT TO DIVERSITY AND EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER Antelope Valley Community College District (AVC) is committed to employing administrators, faculty, and staff members who are dedicated to student success. AVC recognizes that diversity in the academic environment fosters cultural awareness, promotes mutual understanding and respect, and provides suitable role models for all students. AVC is committed to hiring processes that support equal opportunity, diversity, and provide equitable consideration for all candidates as required in federal and state laws and regulations. Annual Security Report is provided by Antelope Valley College for prospective students and employees. A copy of this report is available at Antelope Valley Community College District offers a comprehensive benefit package including sick leave, medical, dental, vision, and life insurance. More detailed information regarding benefit package eligibility will be presented at the time of employment offer. about our organization.
Unix C ERP Amazon Web Services (AWS) Tomcat PL/SQL Microsoft SQL Server Oracle C++ Google Cloud Platform (GCP) SQL Database Administrator MySQL