Application Support Specialist

Oversees, assists, and develops database designs, content management, identity management, maintenance and applications that provide information services to support all divisions of the school district. Consults and works with District staff on projects to develop, implement and support administrative and instructional computer systems. Vetting and implementation of educational and operational applications., * Creates reports or database extracts from commercial systems using SSIS or SSRS.

• Create and oversee data transfer processes to and from 3rd Party Vendors using SFTP or other methodology.
• Administers, maintains, develops and implements procedures for ensuring the security and integrity of the program database.
• Oversees and develops database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.
• Develops strategies for data acquisitions, archive recovery, and implementation of a database. Maintains the database by removing and deleting old data.
• Troubleshoots issues with existing systems and works with the appropriate resources to resolve them. Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Make recommendations for new functionality based on analysis of required functionality.
• Creates and implements project plans that follow the district approved systems development life cycle (SDLC).
• Do initial testing, development, and coordinate user testing, leading to sign-off by users and final implementation.
• Documents all work completed for review. Explains concepts used in development strategy to other team members.
• Informs staff of outages to applications including code, hardware, operating systems and patches.
• Keeps abreast of emerging developments in IT/IS through continuing education, professional reading, forums, and participation in conferences, workshops and professional groups.
• Assumes any additional responsibilities as assigned.

Bachelor’s Degree in Information Systems, Computer Science, Data Engineering, or a closely related field (or equivalent combination of education and professional experience)., * Three (3) years experience with various software including Microsoft technologies, ERP, SIS and other environments.

• Three (3) years of SQL Server database experience, including SSIS and SSRS.
• Prior experience in IT software support required.
• Demonstrated experience in large scale Student Information Systems(Infinite Campus) and ERP Systems (Tyler Munis) with exposure to payroll, Human Resources, benefits, procurement, and/or financial applications a plus.
• Data transfer experience with SFTP is a plus.

Knowledge, Skills & Abilities:

• Working knowledge of SQL Server, SQL, Powershell, Javascript, HTML. Desirable to have working knowledge of, ECM, Microsoft Power Automate, Google Workspace, Office 365 and Azure infrastructure.
• Knowledge and experience with reporting tools and/or retrieval systems (i.e.SQL Server Integration Services, SQL Server Reporting Services, Access, Excel, and Data Warehouse concepts and maintenance).
• Extensive knowledge of ETL, systems analysis and design.
• Knowledge and experience with Identity and Access Management integrations.
• Knowledge of all commonly used Operating Systems.
• Well developed oral and written communication skills and the ability to work closely with District and outside agency employees to understand their job related information technology requirements.
• Positive work attitude with the ability to work as part of a team as well as work independently and manage multiple assignments concurrently.
• Demonstrates strong problem-solving and troubleshooting abilities, along with sound judgment and decision-making skills.
• Knowledge of security and access controls within various IT systems and applications., Years of Experience 3 Degree Bachelor