What are the responsibilities and job description for the Assistant Database Administrator position at Lexington Public Schools?
Position Title: Assistant Database Administrator
FLSA: Exempt
Evaluation: The Assistant Database Administrator will be supervised and evaluated by the Database Administrator
Terms of Employment: 12 month position, 40 hours per week (260 days) with benefits according to the LEA Tech Unit collective bargaining agreement.
August 18, 2025 start date. Salary range: $64,630 - $85,581
Qualifications:
- Extensive experience with a student information system
- Experience with importing and exporting data between a student information system and other district database systems
- Effective communicator both verbally and in writing
- Ability to work well within a diverse workforce
- Working knowledge of relational databases and web-based applications
Responsibilities:
The Assistant Database Administrator is responsible for assisting the Database Administrator to ensure that all student information systems contain accurate and up-to-date information, creation of user accounts, submitting state and federal reports, year-end rollover of various databases, and training administrative and support staff in using Aspen. Working in collaboration with the Database Administrator, this would include the following primary responsibilities:
- Ensuring that the Student Information System (Aspen) is operating correctly and that end users have appropriate access
- Assembling, generating and submitting all required state and federal reports by reporting deadlines. (SIMS, SCS, EPIMS, SSDR, and CRDC). This includes increased data cleansing for reporting via SIF
- Training and providing on-going support to Administrative Assistants, Administrators, and office support staff on functions associated with their roles in Aspen. This includes one-on-one or small group sessions
- Processing customized report requests from end users and resolving data experience issues. This may include changing rubrics for ELL Report Cards, creating discipline and attendance reports for Chapter 222 compliance, specific label requests, etc
- Assist in the creation of accounts for the DESE Security Portal
- Import MCAS Scores, DRA scores, bus route and financial aid information into Aspen
- Support the Central Registration Office with issues arising with the Registration Gateway software. Troubleshoot and help resolve issues with the data flow from Registration Gateway into Aspen
- Assist in training new Administrators on using the emergency notification system
- Provide support for families and students through the family and student portals, with issues concerning their Aspen user accounts
- Create user accounts for new staff as needed in Atlas Rubicon, AIMSWEB, and AMC Anywhere
- Prepare analytical reports from AIMSWEB on student progress
- Assist with adding new staff to IO Education, assigning plans, evaluators and contributing evaluators
- Coordinating the annual student information update (rollover) process
- Create all elementary school schedules in the Aspen database. This includes configuring all homerooms, teachers and elementary courses for student enrollment and preparation for grading for Standards Based Report Cards
- Conducts other administrative and staff duties as directed by the Database Administrator or as needed by the District
Evaluation
The Assistant Database Administrator will be supervised and evaluated by the Database Administrator
PHYSICAL DEMANDS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is frequently required to sit and talk or hear. The employee is occasionally required to walk; use hands to finger, handle, or feel objects, tools, or controls; and reach with hands or arms.
The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.
Experience and commitment to working in a racially and culturally diverse teaching and learning community.
Applicants for employment are considered without regard to age, disability, race, religion, sexual orientation, gender identity, marital status, national origin, or military status.
Salary : $64,630 - $85,581