What are the responsibilities and job description for the Database Administrator position at Lexington Public Schools?
Position Title: Database Administrator
FLSA: Exempt
Reports to: Director of Data & Strategy
July 1, 2026 start date.
TERMS OF EMPLOYMENT:
Work Year: 12 months
Work Hours: 8:00-4:30 (40 hours/wk, 1/2 hour unpaid lunch)
Vacation: 1-3 years - 15 days; 4-10 years - 20 days; 11-15 years - 25 days; 16 years - 30 days
Sick: 15 days, carried over without limit
Personal: 3 days annually, no carryover
Bereavement: 5 days in case of the death of an employee’s family or household member.
Holidays: Based on Central Administration observed holidays
QUALIFICATIONS:
- Experience in School and Municipal Data Management (e.g. ASPEN, Munis, ReadySub, Clever, SIF)
- Knowledge of Massachusetts DESE reporting systems (e.g., SIMS, EPIMS, SCS, SSDR).
- Robust knowledge of databases, cloud technologies, and software applications.
- Experience managing and providing user support for Front-End database applications
- Knowledge and experience of implementing databases and data processing best practices
- Proficiency in using data languages such as SQL and Oracle to manage and export data
- Must be able to self-initiate and follow through on tasks while managing multiple priorities
- Strong communication and writing skills (in-person, phone, written, email, chat, etc.)
- Ability to work effectively with a team and within a diverse workforce.
- Proficiency in Microsoft Applications (Excel, Word etc.) and Google Suite tools
- Must possess a minimum of a Bachelor’s degree
RESPONSIBILITIES:
- Provide Front-End data application support, and database administration, troubleshooting, providing support to end-users and ongoing maintenance for school software, including the district’s student information system.
- Analyze and administer system upgrades, software patches, and security.
- Continuously monitor and analyze databases systems and while making recommendations and implementing process improvements, including customizing (including simple programming tasks) the student information system to meet the district’s needs..
- Coordinate and provide training for staff on district’s Student Information System, related processes, state data collections, and select applications along with developing FAQs and documentation to minimize and resolve requests
- Process customized reports and data requests from end-users
- Liaison with vendors for integration of data systems; Resolve technical issues and bugs, while creating information pathways between systems to improve use of data (e.g. Parent Square, Transfinder, TeacherEase districtwide assessment systems etc.)
- Works with the Department of Education and other agencies to ensure the accurate exchange of student, staff, and program data and meet expected timelines (SIMS, EPIMS, SCS, SSDR etc.)
- Coordinate with school and district leaders, assisting with school year startup/closeout and maintenance processes (Student registration, Scheduling, Report cards, annual systems rollover).
- Export and Import data using various report writing and query languages
- Monitor and advise on Data Privacy and other regulatory requirements
- Monitor data infrastructure and respond to unplanned incidents
- Supervise and evaluate the Assistant Database Manager
- Conducting other administrative and staff duties as directed by the Director of Data & Strategy or as needed by the District.
EVALUATION:
The Database Administrator will be supervised and evaluated by the Director of Data & Strategy.
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, physical, mental or psychiatric disability, genetics, race, religion, sex, sexual orientation, gender identity, marital status, national origin, or military status.