Traffic/Rate Analyst jobs in Mississippi

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:

1. Assist in the management of the day-to-day analysis and operations of the College database system to improve overall performance.
2. Assist in performing troubleshooting, maintenance, and upgrades to optimize database performance.
3. Analyze database design functions related to database information and resources, and make recommendations for improvement to the Associate Vice President for Technology/CTO.
4. 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.
5. Maintain systems to include:
6. Oracle database and application servers;
7. Banner, EagleNet, Imaging, identification card, FormsPartner, and in-house developed software;
8. State enrollment reporting;
9. Disaster recovery planning;
10. Door system software;
11. Bookstore interfaces; and
12. Canvas interfaces.
13. In reference to the systems listed above, the Programmer/Analyst is responsible for personally addressing the following:
14. Maintaining, upgrading, and patching all software applications;
15. Monitoring the Oracle database and maintain optimum security.;
16. End-user error resolution;
17. Create and maintain custom reports for internal and external reporting;
18. User support and training;
19. Conduct data validation, correction, file submission, and error resolution;
20. Backup data and periodic testing for data recovery; and
21. Design, coordinate, and execute data migrations between systems.
22. Research best practices and industry standards in effective database administration.
23. Analyze large tables, maintain schemas, and develop queries and utilities to assist users.
24. Develop automated frameworks to reliably support database implementations and interfaces.
25. Communicate database administration issues to faculty, staff, and students in a timely manner.
26. Develop project time lines, and map, document, and evaluate project improvements.
27. Work closely with administrative computing personnel to analyze, develop, and implement policies and procedures for the administrative computing department.
28. Liaise with administrative computing personnel to facilitate progress on project tasks, and compile project progress reports.
29. Attend professional development sessions, seminars, webinars, conferences, etc. to remain abreast of current best practices.
30. Provide user education opportunities for new systems, hardware, and software.
31. 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