Job Details

Sierra College
  • Position Number: 5189158
  • Location: Rocklin, CA
  • Position Type: Computer and Information Technology


Database Systems Administrator

Salary: $44.45 Hourly
Job Type: Full-Time
Job Number: 2324-00056
Closing: 5/6/2024 11:59 PM Pacific
Location: Rocklin, CA
Division: Student Services

Description
SUMMARY DESCRIPTION
Under administrative direction of a manager, serves as a technical expert and coordinate the development, installation, implementation, administration, development and support of the District's Enterprise Resource Planning (ERP) systems and associated database, operating systems and related software for District servers. Administers District systems, databases, application access, and systems security procedures; and coordinates assigned activities with other divisions and departments and performs a variety of tasks relative to assigned area of responsibility. The Database Administrator assumes primary technical responsibility for protecting District business data against loss or corruption due to factors such as equipment failure, unauthorized access, natural disaster and human error.

Examples Of Functions and Tasks
REPRESENTATIVE DUTIES -The following duties are typical for this job classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.
  1. Assumes responsibility for the development, installation, implementation, administration and support of District database management operating system and related software for District servers.
  2. Participates in the development and implementation of goals, objectives, policies and priorities for assigned programs; recommends and administers policies and procedures.
  3. Serves as a leader for projects by coordinating and otherwise involving staff members from multiple organizational units; follows systems development life-cycle techniques, utilizes joint application development processes, employs project management techniques and is knowledgeable about specialized software packages and applications.
  4. Provides technical leadership and mentoring for Analyst/Programmers and other District staff. Reviews design work including data structures, programs and documentation for adherence to performance, maintainability and security standards. Provides developer and end-user support for test systems and database development tools and procedures.
  5. Participates in and facilitates planning and implementation of long range systems goals; researches and participates in the development of system requirements, and evaluation and selection of information systems.
  6. Defines the scope and objectives for applications, along with constraints and system requirements; analyzes and defines current organizational functions, processes, sources and uses of information, and other data to determine application needs and requirements.
  7. Analyzes user business processes and designs applications and solutions to optimize their use of systems; documents work and information flow using organization and data flow charts and other related materials; designs and produces application design specifications and documentation on inputs, outputs, and data structures.
  8. Coordinates and implements data conversions, integration, and transitions; develops user and system documentation; plans and conducts user training, including preparation of training materials.
  9. Designs and implements custom applications using batch processing tools or appropriate programming languages, such as shell and kernel-level programming.
  10. Reviews and evaluates District computer systems and database software; consults with District technical staff members regarding computer software requirements; reviews software release notes and installation documentation; schedules system downtime with end users and technical staff members.
  11. Designs, develops and implements logical and physical database structures; defines and secures efficient connectivity relationships for host computers, desktop computers and network systems; installs, configures, tests and implements District host computer operating software.
  12. Monitors system and database performance; analyzes performance statistics and modifies system/database operating parameters; restarts system/database; formulates and implements system/database tuning strategies.
  13. Analyzes database requirements with District technical staff members; develops logical and physical database designs and specifications; reviews with District technical staff members and implements database designs; reviews software with District technical staff members and/or end users making modifications, as necessary; evaluates and recommends third party software for District computers.
  14. Analyzes and monitors District database systems with regard to standard and local security policies; works with District staff to formulate and review District database security policies and procedures.
  15. Plan for and support the processing of upgrades, patches and major releases for District's database systems and ERP applications.
  16. Coordinate administration and operation of ERP systems with outside vendors and users to integrate third party software into District databases; serve as liaison between users, managers, IIT staff, consultants and vendors.
  17. Manage end-user and developer accounts and maintain account security and confidential information.
  18. Researches issues related to District databases, system software, and industry trends in computing technologies; functions as a technical advisor and resource to District technical staff members and provides assistance with technical questions.
  19. Serves as the liaison for the database administration and systems security with other divisions and departments; negotiates and resolves sensitive and controversial issues.
  20. Serves as staff on a variety of committees and/or task forces; prepares and presents staff reports and other necessary correspondence.
  21. Provides responsible staff assistance to manager; conducts a variety of organizational studies, investigations, and operational studies; recommends modifications to database administration programs, policies, and procedures as appropriate.
  22. Attends and participates in professional group meetings; maintains awareness of new trends and developments in the field of database administration and security; incorporates new developments as appropriate.
  23. Performs related duties as required.


Minimum Qualifications
QUALIFICATIONS -The following generally describes the knowledge and ability required to enter the job and/or be learned within a short period of time in order to successfully perform the assigned duties.

Knowledge of:
  • Experience in Oracle RDBMS (current releases) / Linux operating systems, PL/SQL, SQL*Plus.
  • Computer database management system concepts, methodologies, analysis and design.
  • Computer system software concepts, installation, configuration and maintenance.
  • Principles and practices of computer network design, installation, configuration, and maintenance.
  • ERP (i.e. BANNER, etc) system and database (Oracle) concepts, data warehouse and reporting, design and programming with PL/SQL.
  • UNIX operating system (commercial and open source) concepts, installation, configuration, tools and operation.
  • Logical and physical database structures and relationships, including those for desktop computer and network systems.
  • Desktop and server computer system architecture to component level.
  • Principles, theories, methods and techniques of computers and network equipment.
  • Principles and practices of program development and project administration, including object-oriented design, integrated development environments, version control systems, build tools.
  • High-level general programming languages (C#, Java, Visual Basic, C/C++)
  • Principles and methods of change management and change control.
  • Methods and techniques of computer and database security.
  • Relational database management systems (Oracle and SQL Server RDBMS), computer network topologies and the security implications of each.
  • Network transport protocols and hardware.
  • Database definition and manipulation languages (SQL).
  • Help desk, trouble ticket and work order management methods and practices.
  • Scripting languages and system configuration methods and practices.
  • Project management methods and tools.
  • Information Technology Service Management best practices (ITIL)
  • Office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, and databases.
  • Pertinent federal, state, and local laws, codes, and regulations.

Ability to:
  • Participate in the management of a comprehensive database administration program.
  • Participate in the development and administration of goals, objectives, and procedures.
  • Administer host computer systems and databases.
  • Install, configure and troubleshoot system operating, database and application software.
  • Design host computer logical and physical database structure and relationships, including those for desktop computer and network systems.
  • Design and code database and system software applications using appropriate languages and tools.
  • Act as project manager for implementation of software application features or subsystems.
  • Translate user requirements into computer programs and systems.
  • Write program and system documentation.
  • Read and interpret technical manuals and other documentation.
  • Analyze problems, identify alternative solutions, project consequences of proposed actions and implement recommendations in support of goals.
  • Implement system software and data changes in accordance with security and change control policies.
  • Provide back-line support to end users, using work order tracking systems.
  • Interpret and apply federal, state, and local policies, laws, and regulations.
  • Operate office equipment including computers and supporting word processing, spreadsheet, and database applications.
  • Plan and organize work to meet changing priorities and deadlines.
  • Communicate clearly and concisely, both orally and in writing.
  • Establish and maintain effective working relationships with those contacted in the course of work.

Education and Experience Guidelines: Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

  • Education/Training: A Bachelor's degree from an accredited college or university with major course work in computer science, information technology or a related field.
  • Experience: Eight years of increasingly responsible database and systems administration experience.

PHYSICAL DEMANDS AND WORKING ENVIRONMENT - The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.
  • Environment: Work is performed primarily in a standard office setting.
  • Physical: Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally walk, stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information.
  • Vision: See in the normal visual range with or without correction; vision sufficient to read computer screens and printed documents; and to operate assigned equipment.
  • Hearing: Hear in the normal audio range with or without correction.


Supplemental Information
WHY SIERRA?
  • One of Aspen Institute's Top 150 Community Colleges in the nation
  • The Accrediting Commission recognized Sierra "for its exemplary practice of providing personnel with opportunities for continued professional development in order to meet its mission." This includes providing students and employees with a robust set of programs, events, and conferences related to equity-mindedness and supporting the success of our students, etc.
  • Public Employee's Retirement System (PERS)
  • 18 paid holidays (including extended time off during the winter break)
  • 12 accrued paid vacation days per year (vacation accrual increases over time)
  • Competitive benefits package
  • Flexible work schedules may be available
  • Currently during summers, some employee groups participate in 4x10 schedules
  • Qualifying Employer for Public Service Loan Forgiveness (in most cases)

Sierra College is a Community College located near Sacramento, California where a heavy emphasis is placed on academic excellence and student success. Since its founding in 1936, Sierra College has focused on quality instruction and meeting the evolving needs of the students and communities that it serves. The Sierra Community College District covers more than 3,200 square miles and serves the Northern California foothill counties of Placer and Nevada, as well as parts of El Dorado and Sacramento. We serve over 17,000 students throughout the region in both on-ground and online courses, including students at our main Rocklin Campus as well as at three centers located in Grass Valley, Tahoe/Truckee, and Roseville. Our District prides itself on academic excellence.

Sierra College has a strong commitment to the achievement of equity and inclusion among its faculty, staff, and students and values the rich, diverse backgrounds that make up the campus community. A strong candidate for this position must demonstrate a profound understanding of and experience with successfully supporting individuals with varying backgrounds. This includes persons with disabilities, various gender identities and sexual orientations, as well as individuals from historically underrepresented communities and other groups. Our District is committed to providing strategies for success and proactive student-centered practices and policies focused on eliminating equity gaps to ensure the District provides an inclusive educational and employment environment focused on strategies for success and equitable outcomes for all.

As an institution, Sierra College is committed to eliminating the equity gap in all student populations with dynamic, learner-centered practices and policies that fully engage the college community. The ideal candidate will share the College's commitment to helping its racially and socioeconomically diverse students succeed in their degree and career objectives. Currently, Sierra College enrolls 17,800 students per term, where approximately: 23% of Sierra College's students are Latin(o)(a)(x)(e), 3% are African-American/Black, 2% are Filipino, 6% are Asian, 1% are American Indian/Alaskan Native, 8% are Multiethnic and 55% are White.

The successful candidate will join a College dedicated to the use of culturally responsive strategies and methods that meet the varying needs of our students, faculty, staff, and surrounding community. Sierra College demonstrates its commitment to equity by supporting ongoing professional development for students, faculty, and staff. These opportunities include trainings and workshops on equity and inclusion, active Academic Senate standing committees concerned with student success and equity, a Presidential Equity Advisory Committee (PEAC), culturally responsive student engagement centers, support for our undocumented and AB540 students, campus-wide equity summits, a robust set of programs, events, and conferences related to equity-mindedness and supporting the success of our diverse students.

Need Help With Your Online Account?
  • Use the online Help Guide or contact the NEOED Applicants Support Line at 855-524-5627 if you need assistance with your online applicant account.
  • Applicant Support is available between 6 a.m. and 5 p.m. Pacific Time, Monday through Friday.


Helpful Tip:
Please note that as described above a strong candidate for this position must demonstrate a profound understanding of and experience with successfully supporting individuals with varying backgrounds; and therefore, hiring committees assess candidates for these knowledge, skills, and abilities.
Applicants may want to consider incorporating culturally-inclusive/equity-minded strategies practiced and/or evidence of the responsiveness to and understanding of the racial, socioeconomic, and cultural diversity of community college student populations throughout their application materials (including application and documents uploaded, if any).

Please see the Sierra College website for additional helpful tips and tools for prospective applicants.
Travel expenses may be partially reimbursed for candidates traveling beyond a 150 mile radius for second round interviews. All other travel expenses will be borne by the candidate (if in person interviews).

Terms and Conditions of Employment:

Other terms and conditions of employment are specified in the applicable collective bargaining agreements on file in the District Human Resources Department. Position description of record on file in the Human Resources Department.
*Sierra Community College District currently operates campuses in Rocklin, Roseville, Truckee and Grass Valley. In its management of a multi-campus environment, the District reserves right of assignment including the right to change assignment locations and shift assignments based on District need. Although this position may currently reside at the Rocklin campus, the assignment location may be subject to change as needed. Additionally, the district reserves the right to cancel, revise or re-announce this position as well as any and all positions at any time.

EEO/TITLE IX EMPLOYER
Sierra College is an equal employment opportunity employer committed to nondiscrimination and the achievement of diversity and equity among its faculty, staff, and students.

Persons with inquiries about the application of Title IX and/or EEO may contact the Director of Diversity, EEO & Title IX (Title IX Coordinator) at the address below, at (916) 660-7006 or via email at EEOT9@sierracollege.edu.

Persons with questions regarding reasonable accommodation of physical and other disabilities should contact the Sierra College Human Resources Department at (916) 660-7105.

If you have limitations hearing or speaking, the State of California offers a specially-trained Communications Assistant (CA) that can relay telephone conversations for all of your calls. Dial 711 to reach the California Relay Service (CRS). Dialing 711 is for everyone, not just those who have difficulty hearing on a standard phone. If you prefer having your calls immediately answered in your mode of communication, dial one of the toll-free modality and language-specific numbers below. The call will be routed to the CRS provider.

TTY/VCO/HCO to Voice
English 1-800-735-2929
Spanish 1-800-855-3000

Voice to TTY/VCO/HCO
English 1-800-735-2922
Spanish 1-800-855-3000

From or to Speech-to- Speech
English & Spanish 1-800-854-7784



To apply, visit https://www.schooljobs.com/careers/sierracollege/jobs/4462007/database-systems-administrator






Copyright 2024 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency

jeid-23e90e32fe8d374c94b4bb125a09b267