Administrative Computing:
Database design and facilitation are critical components of MCC. The Programmer/Analyst is primarily responsible for assisting in the day-to-day operation of these systems. The Programmer/Analyst will be accountable for assisting the Director of Administrative Computing with the planning, definition, structure, documentation, operation, management, and maintenance of the College-wide database, including the daily management of security and integrity controls, enhancements for performance improvement, system reliability, and associated policies and procedures. The Programmer/Analyst is expected to have knowledge of SQL, Oracle, and Linux, and must be available during hours when system updates occur as well as emergency situations.
Job Description:
- Assist in the management of the day-to-day analysis and operations of the College database system to improve overall performance.
- Assist in performing troubleshooting, maintenance, and upgrades to optimize database performance.
- Analyze database design functions related to database information and resources, and make recommendations for improvement to the Associate Vice President for Technology/CTO.
- Apply knowledge in the area of physical database design, performance and tuning, backup and recovery procedures to resolve database performance issues, database capacity issues, replication, and other data issues.
- Maintain systems to include:
- Oracle database and application servers;
- Banner, EagleNet, Imaging, identification card, FormsPartner, and in-house developed software;
- State enrollment reporting;
- Disaster recovery planning;
- Door system software;
- Bookstore interfaces; and
- Canvas interfaces.
- In reference to the systems listed above, the Programmer/Analyst is responsible for personally addressing the following:
- Maintaining, upgrading, and patching all software applications;
- Monitoring the Oracle database and maintain optimum security.;
- End-user error resolution;
- Create and maintain custom reports for internal and external reporting;
- User support and training;
- Conduct data validation, correction, file submission, and error resolution;
- Backup data and periodic testing for data recovery; and
- Design, coordinate, and execute data migrations between systems.
- Research best practices and industry standards in effective database administration.
- Analyze large tables, maintain schemas, and develop queries and utilities to assist users.
- Develop automated frameworks to reliably support database implementations and interfaces.
- Communicate database administration issues to faculty, staff, and students in a timely manner.
- Develop project time lines, and map, document, and evaluate project improvements.
- Work closely with administrative computing personnel to analyze, develop, and implement policies and procedures for the administrative computing department.
- Liaise with administrative computing personnel to facilitate progress on project tasks, and compile project progress reports.
- Attend professional development sessions, seminars, webinars, conferences, etc. to remain abreast of current best practices.
- Provide user education opportunities for new systems, hardware, and software.
- Work with management personnel to define short-term and long-term objectives that align with project goals and potential gains.
Required Qualifications:
Bachelor’s Degree in computer science or closely related field
Preferred Qualifications:
Master’s Degree in in computer science or related field