"Information Technology Systems/Database Administrator Analyst II"

Position Summary

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.

Typical Duties

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 description click 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.

Projects:

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

Organizational Support and Leadership:

• 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.

Strategy:

• 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.

Minimum Qualifications

EXPERIENCE/EDUCATION:A Bachelor's degree in computer sciences, management information systems, engineering or a closely related field and four years' experience directly related to job duties; OR, a Bachelor's degree and two years in class of Information Technology Analyst I; OR, a Bachelor's degree and six years' experience directly related to job duties; OR, an Associate's degree in computer sciences or a closely related field and eight years' experience directly related to the job duties.

*Please mention you saw this ad on CommunityCollegeJobs.*