Database Administrator (Re-advertised, Deadline extended)

Company: Antelope Valley College
Location: Lancaster
Posted on: November 19, 2022

Job 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. E = indicates essential duties of the positionRecommend 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 andOracle 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.EDUCATION AND EXPERIENCE:EDUCATION:Bachelor's degree in computer science or computer information systems, or closely related field.ANDEXPERIENCE: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.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 scriptsDeploying, tuning, and managing of Tomcat web applications.Cloud technologies including AWS and Google CloudWorkflow analysis techniques and modelsDocumentation, 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 relationshipsWORK 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 timeSitting for extended periods of timeReaching in all directionsBending and twistingLift and carry 25 poundsWORKING CONDITIONS:Normal office environment.______________________________________________________________________SUPPLEMENTAL INFORMATIONIt 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.APPLICATION INSTRUCTIONS - PLEASE READEach 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 includes, but is not limited to, submitting transcripts for all college coursework or degrees when requested to do so within a job announcement.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)http://www.naces.org/is acceptable.If letters of recommendation are required, letters must be current within two years, signed and dated from individuals having knowledge of your professional experience.Typing certifications must be current within one year and must include name, date and net words per minute (NWP).For those disciplines with established Academic Senate's approved equivalency: complete the Supplemental Equivalence Request form (If applicant is applying based on an equivalency and is requesting review)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.If you have, any questions or concerns please feel free to contact the Human Resources Office.EQUAL OPPORTUNITY EMPLOYER:Antelope Valley College prohibits discrimination and harassment based on race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, marital status, sex, age, or sexual orientation. Upon request, we will consider reasonable accommodations to permit individuals with protected disabilities to (a) complete the employment_______________________________________________________________________Annual Security Report is provided by Antelope Valley College for prospective students and employees. A copy of this report is available at http://www.avc.edu/administration/police/ recblid d0a6rgpr7c5wv3sv49s95d5jyers09

Keywords: Antelope Valley College, Lancaster , Database Administrator (Re-advertised, Deadline extended), IT / Software / Systems , Lancaster, California