Information Technology Systems/Database Administrator Analyst II

The Information Technology Systems/Database Administrator Analyst II is an experienced Information Technology Systems/Database Administrator Analyst I, or equivalent who has primary responsibility for Systems and/or Database, administration across several major business systems, multiple Operating systems, multiple Database Management Systems, and with complex integration responsibilities. The Information Technology Systems/Database Administrator Analyst II is distinguished from the Information Technology Systems/Database Administrator Analyst I by the amount of supervision exercised, the complexity and scope of work performed, and the depth and breadth of knowledge and experience in the systems, database with supporting and/or administering systems and/or databases. The Information Technology Systems/Database Administrator Analyst II operates with moderate oversight.

For a detailed job description for this Los Rios Classified Employees Association (White Collar) posting click here.

This department maintains a focus on:
- Design, implementation, and maintenance of the enterprise data warehouse.
- Development and maintenance of Extract, Transform, Load (ETL) processes and data pipelines to ensure data quality, reliability and scalability.
- Supporting data governance and maintaining data architecture standards.
- Supporting master data management and API application integration administration.
- Development and support of database, data warehouse, and data pipeline technologies such as SQL, Python, Amazon Redshift, Amazon Glue, Snowflake, and Boomi to support analytics and artificial intelligence initiatives.
- Creating clear and comprehensive technical documentation.

In addition to the typical duties of Information Technology Systems/Database Administrator Analyst I. To view the full Information Technology Systems/Database Administrator Analyst job descriptionclick here.

Operations (including security, performance, problem resolution, & budgets):

• Maintains and administers multiple servers, databases and major application software, across multiple major systems (different Operating Systems, different applications, databases, integration between systems, etc.).
• Performs major upgrades and regular patching of servers, databases and college-wide or district-wide application software for development and production within the assigned area of responsibility.
• Recommends changes for future consideration to improve security, performance, capacity, reliability, and cost benefit for systems with large numbers of users and critical reliability and performance.
• Defines and implements Disaster Recovery and Business Continuity plans for assigned systems and databases.
• Recommends and implements Service Level Agreements (SLAs) in conjunction with Information Technology Management, Senior Information Technology Analysts, and business units for critical College-wide and/or District-wide systems.
• Provides technical support for business and technical analysts.
• Systems Administrator - configures, administers and maintains clustered, failover, redundant network servers providing file, print, application, web, and network services (DHCP, DCs, PXE, SAN, NAS, etc.).
• Systems Administrator - configures, administers and maintains clustered, failover, redundant host servers for virtual servers and assigns appropriate resources, vCPU, vMemory, vNetwork, vStorage, etc.
• Database Administrator - configures, administers and maintains databases, the DBMS and database servers providing redundant, failover, high availability database functions to application and web services.
• Database Administrator - configures, administers and maintains virtual database servers providing redundant, failover, high availability and assigns appropriate resources, vCPU, vMemory, vNetwork, vStorage, etc.

• Performs project management for server, database and application software upgrades and large-sized projects.

• Assists and provides coverage for other Information Technology staff, sometimes in either technical or functional roles (database, systems, configuration management).
• Provides assistance and guidance to Information Technology Analyst I, when needed, on more difficult technical problems or project tasks.

• Recommends changes to system architectures (server, database and software), policies, and procedures consistent with established plans.
• Develops and implements plans for College-wide or major College systems architecture and Business units.
• Performs related duties as required.

Applicants applying to this position are REQUIRED to complete and submit:

1. A Los Rios Community College District Application
2. Resume or Curriculum Vitae
3. Letter of Interest

• Applications submitted without all required documents, listed above, will be disqualified.
• Applicants indicating "see resume" on the application will not have that referenced experience considered for minimum qualifications, which may lead to the application being disqualified.
• Only information (education, experience, etc.) listed on the application will be considered for minimum qualifications.
• Applicants, including current Los Rios Community College District employees, are required to provide official transcripts, if required to meet the minimum qualifications for the position.
• Applicants are required to submit official transcripts within 60 days of the time of hire.
• Graduate advising documents and grade reports will not be accepted as official transcripts.
• Individuals who have completed college or university course work at an institution in a country other than the United States must obtain a complete evaluation of foreign transcripts, degrees, and other relevant documents.
• A foreign transcript evaluation is required any time foreign course work is used to meet minimum qualifications and/or salary placement even if the foreign transcript has been accepted by a college or university in the United States.
• Foreign transcript evaluations are ONLY accepted from AICE (Association of International Credential Evaluations, Inc.) or NACES (The National Association of Credential Evaluation Services) agencies or evaluators. For additional information on foreign transcript evaluations click here.