Information Technology Programmer​/Analyst

Overview

Shasta-Tehama-Trinity Joint Community College District (Shasta College) is located in Redding, California. The college enrolls more than 11,000 students annually and provides educational services to students with a wide range of skills and abilities.

• Writes, tests, implements, modifies, and maintains a variety of complex computer programs using the District’s information systems, and third party vendor software and database designs.
• Analyzes existing programs and makes necessary program modifications; assists or leads in analyzing new releases of ERP applications and tools and evaluating the impact of custom modifications.
• Configures, administers and maintains databases and database servers related to the District’s ERP systems.
• Performs installation and updating of servers, databases and application software for the District’s ERP systems.
• Identifies and corrects program logic errors; prepares solutions that fit available timelines and resources.
• Researches and analyzes federal, state, and local requirements, policies and procedures to design and implement computer solutions for District needs.
• Identifies details of analysis studies; determines and locates sources for collecting data and information.
• Develops, understands, and communicates future direction of systems including cost–benefit analysis.
• Performs project leader responsibilities; monitors and coordinates activities of the project; constructs time and cost estimates; provides project reports, updates, and recommendations.
• Writes and revises technical manuals using proper operating procedures for use of software.
• Conducts training sessions for end users.
• Operates a variety of computers and related equipment including mainframe and file servers, printers, and network related equipment.
• Keeps abreast of technical developments and information system trends; anticipates changing needs by self‑study and participation in courses, seminars, and conferences.
• Assesses workload implications and feasibility of new system requirements; analyzes existing systems performance in relation to specified requirements to ensure proper integration of new programs.
• Evaluates change requests to ensure proper integration within existing ERP systems.
• Reviews, redesigns, or modifies existing systems to improve effectiveness and efficiency.
• Learns and implements new languages and technologies as required.
• Communicates with District users and technology services staff to ensure information needs are being met.
• Serves as a resource person to the District with users, vendors, and other community college consortia members.
• Supports a “Data Warehouse” capability to meet the information needs of the District, both as‑scheduled data extracts and on an as‑needed request basis.
• Supports the District’s State MIS and Federal reporting needs.
• Provides support and writes queries and creates reports for ad‑hoc, operational or general data reporting needs.
• Works in cooperation with the Office of Research and Planning to assess and meet the data needs for departments, staff, faculty, and students.
• Attends various meetings, conferences, and seminars related to data processing operations and serves on various district committees as resource person.
• Supervises other staff as needed.
• Performs other related duties similar to the above in scope and function as required.

• Principles, concepts, practices, terminology of operating systems, client/server architectures and related services.
• Techniques and practices of computer programming, database management, and software support.
• Principles, techniques, and tools for effective and efficient troubleshooting and performance monitoring.
• Emergency and disaster preparedness and recovery for information and communication systems.
• Computer operating systems, hardware, network systems, LAN and internet computing technologies.
• SQL and other related enterprise database management system (DBMS) architectures.
• Principles and practices for design, integration, and transition to/from an enterprise DBMS.
• Current industry information, vendor direction, new products and new technical architectures.
• Computer languages as specified.
• Supervisory methods…