The Lexington School welcomes resumes from individuals interested in working as part of our Information Technology team. The Database Administrator position will provide system and data integration between multiple systems, applications, and create reporting applications in order to meet the instructional and operational needs of The Lexington School.
The responsibilities of this position are varied and complex and require a high degree of initiative, independence, critical thinking, and technical skills. The Database Administrator will be responsible for maintaining and integrating the School’s data systems and in supporting the operation of administrative and academic information systems. This position will also work closely with the Business Office, Enrollment, and Development to understand their data needs, reporting requirements, and system integrations.
This position will work with confidential and proprietary information that requires a signed IT Confidentiality, Conflict of Interests Agreement, and background check prior to hire.

Position Overview:
The Database Administrator will be responsible for managing and maintaining the school's database systems, ensuring data accuracy, security, and availability. The position will work closely with various stakeholders to support the school's administrative and academic functions.
This position requires a strong understanding of database management principles and logic, excellent problem-solving skills, and the ability to work in a fast-paced educational environment.

Essential Functions:
1. Data Management:

1. Design, develop, and maintain the school's database systems, ensuring optimal performance and data integrity.
2. Implement and enforce data security measures, including user access controls, backups, and disaster recovery plans.
3. Monitor database performance, identify, and resolve issues, and optimize system resources.
4. Regularly update and maintain database documentation, including data dictionaries, schemas, and procedures.

2. Data Analysis and Reporting:

1. Collaborate with various departments to understand their data needs and develop custom reports and queries.
2. Extract, transform, and load data from various sources into the school's database systems.
3. Perform data analysis to identify trends, patterns, and insights to support decision-making processes.
4. Generate accurate and timely reports for administrators, faculty, and staff as required.

3.System Integration and Support:

1. Collaborate with key stakeholders to integrate the school's database systems with other software applications and platforms.
2. Provide technical support and troubleshooting assistance to end-users, resolving database-related issues promptly.
3. Conduct regular system audits to identify and resolve data inconsistencies or errors.
4. Stay updated with the latest database technologies and trends, recommending improvements to enhance system efficiency.

4.Website Administration

1. Collaborate with the Director of Marketing and Communications to maintain and administer the school’s website, intranet, and parent portal.
   1. The Marketing team is responsible for content creation
2. Distribution list management
   
   1. Imports and exports from various sources, such as Blackbaud, iModules, and safety and security programs.
3. Support for all aspects of the website and platform, including but not limited to content issues, links, process and data flow, and log in access with escalation to the vendor for additional support if required.

5.Training and Documentation:

1. Develop and deliver training sessions to educate staff on database usage, best practices, and data entry standards.
2. Create and maintain comprehensive documentation for database systems, including user manuals and troubleshooting guides.
3. Assist in the development and implementation of data governance policies and procedures.

Please note, this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, Responsibilities, and activities may change at any time, with or without notice, to meet the needs of the school.