Database and Systems Administrator

Database and Systems AdministratorIn an ever-changing and evolving global and technology-driven landscape, the role data plays in education is paramount. The Database and Systems Administrator is a person who constantly redefines themselves and their position in order to fully support the district and school personnel in the use of student data and the student database system. This person monitors the student database, designs and maintains tables and reports for local, state, and federal use, and provides ongoing training and technical support to district and school personnel. This position will play a critical role in supporting the district's commitment to eliminate the racial, ethnic, and linguistic achievement and opportunity gaps among all students, provide equitable funding and resources among the district's diverse schools, and engage families with courtesy, dignity, respect, and cultural understanding.Primary Responsibilities:Oversee and manage district data systems; establish and ensure accuracy and efficiency in data collection, maintenance, reporting, analysis, and interpretationUnderstand and facilitate data storage and retrieval methods and understand the current trends and directions of database management systemsEstablish procedures and protocols for the initial entry and ongoing maintenance of all student informationMaintain accurate and up-to-date student data and oversee the transmission of this data to the Massachusetts Department of Elementary and Secondary Education (DESE) as directed, as well as meet all Federal reporting requirementsFacilitate data entry of student scores on all assessment programs included, but not limited to MCAS, ACCESS, and internal benchmark assessments into identified management systemsAssist the administration and faculty, as needed, in the production and management of various reports of student achievementWork closely with departments to prepare for and roll out SIF integrationServe as district contact for all data management systems, and act as the contact and point person for logon and troubleshooting for staff with these data systemsCollaborate with administrators to develop and expand the current data systems and write/revise, in collaboration with the data system vendors, new modules and systems for efficiencyProvide training, as needed, for staff regarding use and functionality of data systems and provide feedback for reducing redundancy and ensuring efficiencyDesign and support reporting procedures for district and school usersSupport public agencies as requested by the Director of Research & AccountabilityPerform other responsibilities as assigned by the Director of Research & Accountability, Assistant Superintendent for Schools & Leadership, and/or Superintendent of SchoolsEstablish and maintain effective working relations with a diverse populationGeneral Duties:Exports data to be used with other databases or applications and software, including but not limited to lunch programs, library, school picture/id cards, student file network serversPrepares data needed prior to importing into other applicationsControls user access to databases and sets permissions based upon roleDesigns and maintains database tables and reports.Trains and supports users throughout the school districtAnalyzes and tests new and modified software in relation to installation requirementsAttends training and conferences as required to fully perform duties and stay up to date on the latest technological advancesActs as a point of contact for all staff and software developersCommunicates technical guidance and instruction to end-usersSpecific Duties:Provides district and school users with specific and ongoing information regarding database operations, including use, maintenance, data manipulation, data download, data viewing and analyzing, and report building.Adds database users to the system by:Setting up IDs and passwords for user loginsAssigning security levels, privileges, and restrictions to users that control access to specific schools, school years, modules, and operationsObtains and distributes state identification numbers for all new students and staffPrepares informative reports and instructional materials for all staff using the student databaseEnsures district compliance with state and federal reporting requirementsResearches and troubleshoots issues with the student database system, and makes support requests with the hosting companySupports district and school users (provides suggestions, answers questions, solves problems).Ensures that district and school users have appropriate database reference manualsConducts database training for district and school usersResearches user problem resolution through forums, help desk, tech support lines, new groups, website, etc.Designs and creates district and school-wide reports from databaseWorks with other data personnel to standardize procedures and protocols across the districtRecognizes and implements efficiencies within the database to support end usersManages and implements system data rollovers at appropriate times during the yearSupports school administrators and school improvement teams in scheduling courses and obtaining and representing relevant data for school improvement plansCollaborates in the production of report cards, including design, training on data entry, communication of expectations, and troubleshooting issuesEdits code in Aspen to address unique needs of the districtThe above descriptions and requirements are intended to describe the general nature of the work required of the Database and Systems Administrator. The description and duties are not intended to be an exhaustive list of all of the roles and responsibilities expected from the position. The role and set of responsibilities will change frequently over time. The ideal candidate should recognize this as the nature of the work, and always formulate a vision of where the district needs to go to use our data wisely and in the best interest of education.Qualifications:A bachelor's degree (preferred) from an accredited college or universityThree to five years of relevant experienceWorking knowledge of Aspen, Microsoft Office, Google SuiteWorking knowledge of Connect Ed, Nutri-kids, Virtual Gateway, Versa Trans, and Teach PointThree to five years of experience in development, analysis and submission of DESE reportsStrong analytical, quantitative and interpersonal skillsExperience with staff developmentWorking knowledge of XML, HTML, Java and SQLReports To: Director of Research and AccountabilityTerms of Employment: Non-affiliated, 12-month positionSalary: $95,000 - $105,000 per year