Senior Database Administrator, Alumni and Development

Otterbein University is in search of a Senior Database Administrator, responsible for maintaining and enhancing data and technology for all Institutional Advancement departments (Development, Engagement, and Advancement Services). The goal being to help the division increase donor acquisition and fundraising dollars and increase efficiency while decreasing departmental costs such as postage/printing, labor, and licensing fees. Serves as the chief administrator for the alumni/development database system; contributes to the reliable and secure operation of the Momentive Millennium software and/or its successor, SQL Server Management Studio, and related software components underlying the Momentive Millennium application and interfaces; Helps provide visualization and understanding of complex datasets through the use of tools like Power BI; works closely with the University's Information and Technology Services Department (Ellucian) by performing the duties below:

To help attract a talented team, Otterbein offers a comprehensive benefits package to full-time faculty and staff.

Benefits at Otterbein include:

• Tuition benefit for employee and their dependents
• Accrue 4 weeks paid vacation and 10 days paid sick time per year
• 12 paid holidays
• Medical, dental, vision, life insurance for employee, dependents, or domestic partner
• Disability
• Defined contribution retirement plan
• and much more

ABOUT OTTERBEIN UNIVERSITY: https://www.otterbein.edu/about/ ABOUT OTTERBEIN CAREERS and BENEFITS: https://www.otterbein.edu/about/careers/

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

50% Serves as Chief Administrator for the alumni/development database system; , ensures that the interface between hardware and software are compatible and allows for efficient user experience; installs, implements, and supports Momentive Millennium application software, MS SQL Databases, and related third party software which currently includes GiveCampus their volunteer management package (VMS), and OneCause (events management); transfers data between institutional databases (Ellucian Banner to Momentive Millennium); creates and maintains data migration to third party vendors (ie: GiveCampus); responsible for appending new data elements and maintaining data accuracy and comprehensiveness; installs, implements, and supports any additional software particularly as it relates to fundraising purposes within the Institutional Advancement division. Currently this includes software to support the Office of Planned Giving; works with institutional vendors to leverage advancements in technology;

20% Acts as a primary technical resource for Institutional Advancement’s administrative computing applications; provides ongoing support, including installation of software upgrades and fixes, and maintaining the database and other Advancement software for 7x24 availability; leads PCI discussions and develop a comprehensive plan for departmental compliance; investigate and implement new hardware and software technologies for commonly used business and mobile devices (e.g. smartphone, tablets, laptops, and desktops) to improve ease of use for both constituents and employees; keeps abreast of the latest trends in technology used by business and peer institutions; contributes to policies and procedures designed to ensure consistent data architecture to promote high quality, maintainable application components; contributes to the design and implementation of a security plan for Advancement systems;

20% Implements internal and external technologies for monitoring, tracking and reporting the progress toward meeting the Division of Institutional Advancement’s goals and the University’s return on investment in the Division which includes maintaining and enhancing the division’s Power BI dashboards; creates business reports using Crystal reports and Power BI; processes data requests for Advancement and various departments across campus including report development and generation; understand IA employee roles and make suggestions for process improvements and efficiencies.

10% Adheres to all University and departmental policies and procedures, maintains the highest level of confidentiality; Serves as a member of the Otterbein University AI task force Serves on institutional committees as assigned; other duties as assigned.

SUPERVISORY RESPONSIBILITIES: N/ATo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE: Required: Bachelor’s degree in Computer Science or a related technical field with at least 5 years of related experience; experience with advanced technologies, application design, and analysis; experience with, SQL Server 15 and Crystal Reports 10+.

MISSION CRITICAL COMPETENCIES: Accountability and Professionalism: Collaboration and Teamwork: Diversity and Inclusion: Integrity and Trust:Job Knowledge: Works with diligence and identifies opportunities to streamline or improve processes.

LANGUAGE SKILLS: Must possess strong presentation, interpersonal, and communication skills including excellent verbal and written English skills including grammar.

MATHEMATICAL SKILLS: Must be competent in general math and have the ability to use excel.

TECHNICAL SKILLS: Required: Expertise in Windows 10, Office 2010 products, client/server networks on a Windows operating system, web browsers (PC, Apple and mobile), RDBMS, mobile technologies, social media, SSL websites, SSIS, SSMS, and cloud computing. Prior work experience in a fund-raising and/or non-profit organization preferred. Knowledge of general office procedures. Must take pride in and be thorough in quality of work produced; must be able to use general office equipment including office PC, copier, telephone, etc.

REASONING ABILITY: Demonstrated ability to meet deadlines and work independently; must be able to interact positively with a variety of constituencies; demonstrated ability to work well in team environments; must possess excellent attention to details; must possess excellent customer service skills; must exercise initiative and independent judgment in unusual or new situations.

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 talk or hear, sit, reach and use repetitive motions of hands and wrists. The employee is occasionally required to stand, walk, stoop or bend. The employee must occasionally lift and/or carry up to 20 pounds and occasionally push and/or pull up to 20 pounds. This position requires close vision. Must be able to meet regular and predictable attendance standards. Must be able to meet regular and predictable attendance standards; must be able to work evenings and some Saturdays.This description is intended to indicate the kinds of tasks and levels of work difficulty that will be required of positions that will be given this title and shall not be construed as declaring what the specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of any supervisor to assign, direct, and control the work of employees under supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of a similar level of difficulty.Otterbein University is an Equal Opportunity Educator and Employer.