Assistant Systems and Database Manager
Job posting number: #7092268
Posted: January 14, 2022
Application Deadline: Open Until Filled
Job DescriptionPosition Summary:
Are you an IT guru that is a jack of all trades? Are you looking for a position that will help you grow your skills and has a clear career path? Facilities Services is looking for an Assistant Systems and Database Manager that is proficient in MS SQL Server, MS Access, FoxPro, Oracle, and programming. Come support one of the hardest working teams on campus. In return, we can offer a strong benefits package, including tuition benefits for you and your dependents. We look forward to working with you!
Course Developer and Instructor: Develops course training schedules, creates and prepares course content and materials on a wide variety of hardware and software programs. Performs classroom presentations and work shops for audiences with varied levels of knowledge, education, and position status. Maintains classroom environment and computing requirements. Provide customer support ensuring end users receive appropriate assistance; identifying, prioritizing and resolution of desktop problems, including monitoring, tracking and coordinating all help desk functions. Perform System Administrator and other Database Manager functions as needed and/or required. Actively maintain currency and effectiveness of technical skills by learning emerging technologies and expanding their technical knowledge through University or vendor provided training and/or self study.Design, develop, and manage UAF Facilities Services internet and intranet websites to ensure compliance and consistency. Coordinate all aspects of the website production, maintenance, and content; performing routine daily, weekly and periodic major and minor updates of online text, photographs, and forms. Review website requests and project requirements with customer and/or staff, provide feasibility assessment and identify options, evaluate technology solutions and create strategy, provide estimate and timeline, design development site and review with requestor, analysis and modify site as needed ensuring compliance with all appropriate governances, implement, integrate, and deploy site. Create and maintain data source programming and user guide documentation.Under the general supervision of the Database Administrator, design, develop, implement, maintain, and manage departmental databases, including web-based, data-driven applications, libraries, and web pages. Develop and maintain a control and tracking/inventory database for search, identification of, and locating of records. Create program documentation and user manuals. Develop and perform end user training through classroom presentation. Specific tasks vary from project to project and may include the following: project definition and strategy, system requirements analysis, software design and implementation, system integration and deployment as well as system operations and maintenance. Duties also include creation of data source programming and user guide documentation. Perform problem analysis and resolution of existing programs, databases, and processes using MS SQL Server and MS Access.
1. Proficiency and experience with MS SQL Server, MS Access, Oracle, and various text based databases and programming.
2. Knowledge of database construction and document tracking systems.
3. Knowledge of Internet and ColdFusion servers and their management.
5. Proficiency and experience in recent releases of AutoCAD and AutoCAD management.
6. Knowledge and experience in document management. Includes archival, electronic files, standards, and standard and hybrid filing systems.
7. Knowledge of general departmental office techniques, methods, and equipment.
8. Proficiency and experience with Microsoft Windows desktop and server operating systems.
9. Proficiency and experience with computer and peripheral hardware installation and maintenance.
10. Knowledge of PC hardware and components.
11. Knowledge of networking.
Drafting - Minimum one year experience using CAD in a production environment.
Web Programming/Computer skills: Minimum of one year experience ColdFusion, one year experience HTML web page construction. Minimum of one year experience managing web server and file server accounts and accessibility. Experience with installation/maintenance of software programs (Windows 7 through 10, Microsoft Office 2010 through 365, Anti-virus software, Outlook and Thunderbird email clients, etc.).
REQUIRED EDUCATION OR TRAINING:
Bachelor's degree in Information Technology or other related field and 6 months experience, or an equivalent combination of training and experience.
This position requires coursework or production experience in MS SQL Server, MS Access, FoxPro, and database management and programming. Other database types helpful.
This position requires coursework or production experience in Drafting Technology with an emphasis on architectural, civil, electrical, and mechanical drafting.