Kevin Steel's responsibilities at my School District
I have automated all the database systems. It took a lot of work to get the system built, get it in place and make it happen. It was completely designed from the bottom up to make this happen. I know that this could be marketable at other schools, and even though it sounds remarkably complicated, it is totally the reverse - quite simple.
Ensure that organizational data is secure
Back up and restore data to prevent data loss
Identify users needs to create and administer databases
Ensure that the database operates efficiently and without error
Make and test modifications to the database structure when needed
Maintain the database and update permissions
Merge old databases into new ones
Author, update and change SQL Query programming language and Follett DB programming
- Student Computer Accounts & Usernames K-12
- Gaggle student accounts 2-12
- Clever Dashboard and Student Single sign-on portal
- myLexia student accounts K-8
- Renaissance Learning K-8
- Google Faculty and Student accounts 2-12
- Follett Destiny Library patrons K-12
- Follett Asset Manager LHS
- Follett Shelf web-based Library patrons K-12
- OVERDRIVE Digital Library patrons K-12
- MCS Food Service patrons PS-12
- VersaTrans Transportation student information PS-12
- Gifted Education Student information in FileMaker K-12
- Special Education Student information in FileMaker (retired system this school year)
- Information Systems physical equipment Inventory in FileMaker
- I provide one-time new school year student and faculty information for various systems
- Asigra On-line and Off-Site Backup System
- Filemaker PeopleWerks Human-Resources client/server database application
- Monitor Network and Servers using Passeler PRTG Monitoring and Alert system
- Co-operator for iBoss Web Internet Filtering (system is off-site at our ITC)
- Updated/Accessible Student List provided securely to Principals, School Curriculum, & Student Services
- Managing MediaCast Video Servers
A lot of repeated typing, manual data manipulation, faxing from building to building and telephone calls have all been eliminated thanks in part to this system. Many other accomplishments have been done by other departments that have also contributed to students conveniences.
I have also completely upgraded the Transportation VersaTrans system once, the MCS Food Service system twice and the Follett Destiny System four times. I moved the Food Service applications to a multi-blade server with battery and generator backup.
My work also increased throughput by dedicating a Primary and Standby database servers for Library, Transportation and Food Service databases.
In addition to my tasks, I am gradually working more with my supervisor's duties to become aware and gain familiarity especially for times of his absence on vacation or sick leave.
A number of important systems, Windows Update Services, and AVG Anti-virus programs run their database on the same centralized database system. We have over 15 different database systems that need attention.
Database systems utilized are Microsoft SQL Server 2008/2012 R2, Follett and MySQL.
Uninterruptible Power Systems Management
I maintain, monitor and report power-related issues and server room temperature readings. I also replace batteries in the districts UPS Systems, including American Power Conversion, LIEBERT Emerson, Tripplite and ULTRA Products. Each new school building has an Emerson rack UPS system, older buildings have Tripplite SMART-UPS ON-LINE rack-mountable UPS systems that had up to six batteries replaced in each. Three buildings have American Power Conversion UPS systems, including Stanbery, Downtown ESC building and Lancaster High School with equipment, American Power Conversion Symettra LX and APC UPS On-line, respectively.
Network Routers and Switches
I previously repaired a select line of AMER computer network switches power supplies to avoid replacing them with Cisco Networking equipment after the Phase 1 of building new schools. I monitor equipment and data traffic. I also co-manage the switches and routers by logging reporting to SNMP and Syslog systems. I have procured my professional development funds to purchase three Cisco routers and three Cisco network switches to perform Cisco lab tests to review and prepare myself for the major network upgrade at the Lancaster High School for the new 1:1 Apple iPad project and the newly built elementary buildings. As a result, I added Cisco networking and Meraki Wireless for my personal home environment in order to be closer to the technology implemented by my employer.
Students are checking out books and downloading e-books, logging onto computers, taking the bus, eating lunch (and sometimes breakfast), checking their student Google Email for Education, and where necessary, being restricted from these systems, where needed.
With the onset of Cloud based systems, I have become personally involved with Amazon AWS Network S3 R3, SES, SNS, DNS and Off-site storage systems and VoIP phone systems. I managed an AVAYA IP Office phone system at my former position.
Thanks for allowing me to take part in it.
I've found that when I have recommended Cisco Networking equipment, it fell of deaf ears, but when the local ITC person mentions it, then it becomes an epiphany. I'm not invisible. I am here.
Updated: October 19, 2016