Database and Web Administrator

POSITION SUMMARY
Administer the deployment, support, and maintenance of schoolwide database and web-based systems. Coordinate the use of database systems across campus. Provide database training and communicate professional development opportunities to administrative staff. Provide direct technical support to faculty, staff, and students, as needed.

ESSENTIAL DUTIES

System Responsibilities
Manage schoolwide database and web-based systems (primarily Blackbaud Education Edge, Financial Edge, and Raiser’s Edge) and Finalsite as well as Follett Destiny, Nutrikids, Zonar, Blackboard Connect, custom coded systems and others)
Code, revise and maintain custom coded programs and applications to meet the specific needs of the school such as bus billing and emergency forms.
Coordinate and execute regular synchronization of information between multiple applications and databases, and the internal and external websites using APIs, scripts, or imports and exports. Integrate different database systems with an eye toward efficiency and practicality
Configure more the more complex custom reports, exports, imports, batch changes and queries to maintain data quality and in response to department requests
Maintain database integrity and security through regular monitoring, error correction and data clean-up
Manage and maintain the MailMan listserv system, particularly synchronization of family contact information from Education Edge
Keep database server and client systems up-to-date with patches and updates as appropriate

Website Administration
Maintain, upgrade and troubleshoot internal and external websites
Maintain and manage online directories using API, constituent manager and manually updating when necessary
Create pages, forms, registrations, blogs and other elements as need and upon request
Create custom coded webpages and forms to meet the wide variety of needs
Provide support and training on using a variety of Finalsite modules such as calendaring, registration manager, banners, page manager

Administration/Management
Work closely with administrative departments including Admissions, Human Resources, Technology, Business, Communications, Alumni and Development, Head’s Office, Parent Faculty Association, and academic divisions to build and manage and maintain online forms and data collection and synchronization for admissions, enrollment, employment, event registration, donations, student and parent information, and medical information
Design, implement, and document data entry standards, policies and procedures for all database users and monitor adherence to them
Develop and maintain the structure of attributes, code tables, and all other setup functions
Write and assemble documentation and training materials for the use of database systems
Evaluate new database technologies for their potential to support Catlin Gabel school operations; Advise senior management regarding the strategic growth and change of database systems at Catlin Gabel
Troubleshoot and solve database-related technical issues that faculty, staff, and students encounter both in person and via electronic communication
Provide support for special events such as the Catlin Gabel Auction. Provide after-hours and helpdesk support back when necessary.

Communication
Communicate effectively and personably with faculty, staff, students, department colleagues, volunteers, and vendors.
Work closely with administrative departments including Admissions, Human Resources, Technology, Business, Communications, Alumni and Development, Head’s Office, Parent Faculty Association, and academic divisions to build, manage and maintain online forms, data collection and synchronization for admissions, enrollment, employment, event registration, donations, student and parent information, and medical information and other needs that arise

Professional Development
Regularly assess staff training needs and provide both training and on-going support, enabling staff to use the software effectively and maintain data accuracy
Stay current with current and emerging technology systems, trends, etc.

EXPERIENCE, SKILLS & ATTRIBUTES

Education and Work Experience
Bachelor of Science in Computer Science from an accredited college or university, or equivalent experience.
Training in computer programming, systems analysis/design and/or management, with a minimum of five years of database management or equivalent experience.
Experience with Blackbaud applications and Finalsite CMS highly desirable.
Experience in a school setting preferred

Technical Experience
Comprehensive understanding of relational database theory and management systems.
Extensive experience administering, reporting, and querying databases such as Blackbaud’s Raiser’s Edge, Financial Edge, and Education Edge; Microsoft SQL, MySQL
SMS SQL Server Certification preferred
Extensive experience web programming with PHP, Perl, or other language
Advanced knowledge of Linux systems, preferably Debian
Knowledge of Finalsite CMS or similar platform
Knowledge of MS SQL Server performance tuning and server monitoring utilities
Application of best practices to database design and maintenance.
Ability to use custom reporting tools such as Crystal Reports
Advanced knowledge of Microsoft Office applications
Advanced knowledge of online forms
Ability to work with scripts, APIs, and data importing/exporting to synchronize information between applications
Understanding of web-based data collection
Strong troubleshooting and debugging skills
LDAP experience

Project and Program Management
Detail-oriented with the ability to manage multiple projects and keep up with day-to-day tasks
Experience developing and providing effective training to colleagues
Capacity to cultivate collaboration and buy-in to schoolwide standards and practices
Ability to articulate technical concepts and solutions to a diverse range of users

Personal Qualities
Strong interpersonal skills and the ability to work effectively with a wide range of constituents
Strong verbal and written communication skills
Demonstrated leadership
Ability to effectively prioritize
Ability to lift 30 lbs., climb stairs, crawl under desks as needed to install/move computers

SUPERVISORY RESPONSIBILITIES
None

WORKING CONDITIONS
Daily interaction with faculty, staff, parents, vendors, trustees, and volunteers. After-hours and special events support occasionally required. Problems that arise that are mission critical must be resolved as quickly as possible and may require work outside of normal business hours. Updates and patches performed during non-business hours.

Primary Location IT
Salary Range $60,000.00 - $67,000.00 / Annual
Shift Type Full Time