University of Central Florida: Database Administrator II

Mari Rains

Unleash YOUR Potential With UCF

As a next-generation public research institute, we are an inclusive community of thinkers, doers, creators, innovators, healers, and leaders striving to shape the future and solve the world’s most challenging problems. No matter what your role is, when you join Knight Nation, you’ll play an integral role in pushing us forward to become among the most impactful universities in the country. You’ll be met with opportunities to connect and collaborate with uniquely talented faculty, staff, and students across 13 colleges and multiple campuses and regional locations. That means greater challenges to tackle, more meaningful opportunities to grow, and rewarding experiences that go beyond a paycheck. We’re seeking qualified, motivated individuals who will help UCF fulfill its mission in unleashing the potential of every individual, enriching the human experience through inclusion, discovery, and innovation; and propelling broad-based prosperity for the many communities we serve.

Advancement

OUR VALUE PROPOSITION:

UCF Advancement powers partnerships and transforms lives through philanthropy. Your efforts on our team will transform the lives of many students, enable innovative faculty research projects, equip centers and institutes of service to diverse populations, and forge strategic partnerships. Our most valuable asset is our people. UCF has never been restrained by our past because our faculty, staff, students, alumni, and friends have always been optimistic dreamers focused on the future possibilities. UCF’s rapid achievements are the result of the efforts of our people, and they will be our greatest asset as we focus on excellence. UCF’s Advancement division comprises the Office of Alumni Engagement and Annual Giving and the UCF Foundation, Inc., a 501(c)(3) nonprofit organization created to assist donors wishing to offer private support to deliver resources beyond traditional funding sources, such as tuition, state support, and government research grants. We are a powerful team of 130+ professionals who support the university by soliciting, accepting, and managing gifts as well as engaging alumni. Together, we work with alumni, friends, corporations, parents, and others who seek to make gifts in support of priorities and initiatives in alignment with the university’s strategic plan.

YOUR TOTAL HEALTH:

UCF offers a comprehensive benefits package with you and your total health in mind. Our benefits focus on your physical, mental, financial, social, and occupational well-being. Key benefits include:

Tuition Waivers for you, your spouse, or eligible dependent child

Very Generous Paid Time Off/Vacation Time & Sick Leave

Paid Holidays

Affordable Healthcare – including Medical, Dental, Vision, & Supplemental Plans (Accident/Cancer/Disability/Hospitalization)

Multiple Retirement Plans

Health Savings Accounts, Health & Wellness Programs, Flexible Spending Accounts,

Life and Disability Insurance

Parental Leave

Free Fitness Center

Professional Development & LinkedIn Learning

Public Service Loan Forgiveness Program

Discounted tickets to local theme parks, attractions, movie theaters, and transportation providers

Discounted tickets to UCF School of Performing Arts

UCF Technology Product Center Discounts on personal hardware and software

On-campus childcare

The Opportunity:

The Database Administrator II (Database Developer) will act as the primary owner and subject matter expert for the department's enterprise data mart, advising on optimal table structures, maintaining data integrity, and extending the data mart and data warehouse. Responsibilities include writing optimized queries and stored procedures in support of enterprise platforms such as SSRS and Tableau. Utilizes the Blackbaud CRM SQL-based software development kit to support customizations that maximize CRM usability. Participates in code reviews for others on the team, as well as requirements gathering and technical or training documentation in support of new initiatives.

This position offers a hybrid remote work option with supervisory approval.

Responsibilities:

Oversees the design, development, and maintenance of the Advancement enterprise data mart and the BBCRM data warehouse in support of Advancement's long-term business intelligence strategy. Ensures optimal structure, integrity, and usability of these resources.

Writes optimized SQL queries and stored procedures in support of enterprise reporting platforms. Supports the design, coding, testing, and debugging of SQL views, procedures, and other database objects including providing SQL code reviews for other members of the team.

Primary contributor to the design, configuration, and usability of Blackbaud CRM by utilizing Blackbaud's SQL-based software development kit to support data access and reporting data layer. Assists in strengthening the CRM user experience related to data access and efficient user navigation. Stays abreast of BBCRM updates and new functionality.

Supports data integration interfaces between various campus applications and the primary CRM utilizing software and custom-developed software, including SSIS packages and the CRM's SDK.

Ensures accurate and thorough technical documentation of business standards and business processes. Contributes to the development of technical specifications for projects.

Interfaces with Business Analysts and other members of the team to support opportunities for system improvement. Assists in identifying solutions to business process needs, either internally or via external resources. May participate in meetings and campus committees related to job functions as required.

Minimum Qualifications:

Bachelor's or Master's degree and 2+ years of relevant experience.

Preferred Qualifications:

Extensive experience as a SQL developer and expertise in designing and maintaining data warehouses and enterprise data marts.

Familiarity with Tableau or other business intelligence platforms.

Knowledge of Constituent Relationship Management software/applications and their structure, with the ability to navigate and retrieve accurate data from a CRM system.

Skill in understanding and translating business needs and requirements into technical implementations.

Ability to effectively communicate, handle multiple priorities, and the pressure of deadlines.

Experience in Advancement or a related field such as higher education, non-profits, marketing, or sales.

Additional Application Materials Required:

Please include a cover letter and resume with your application.

Are Benefits Important to You?

Working at UCF has its perks! In addition to helping drive change and having a positive impact by supporting our students, staff, and faculty, UCF offers:

Benefit packages, including Medical, Dental, Vision, Life Insurance, Flexible Spending, and Employee Assistance Program

Paid time off, including annual and sick leave and paid holidays

Retirement savings options

Employee discounts, including tickets to many Orlando attractions

Education assistance

Flexible work environment

And more…For more benefits information, go to UCF Employee Benefits Guide (12-14-21)

Who Are We?

Founded in 1963 to fuel the region’s talent pipeline and support the growing U.S. space program, UCF is built to make a better future for our students and society. It’s one of the reasons U.S. News & World Report ranks UCF among the nation’s top 20 most innovative colleges, while Forbes, Kiplinger, and The Princeton Review rank us a best-value university. UCF is one of 14 universities nationwide designated as both a Hispanic-Serving Institution and a Research 1 university. With 13 colleges, including a fully accredited College of Medicine, UCF offers more than 220-degree programs between its main campus, downtown campus, hospitality campus, academic health sciences campus, and 11 UCF Connect centers located throughout the region. In addition, UCF extends its reach to communities in and beyond Central Florida by offering complete, online programs leading to bachelor's degrees, master's degrees, Ph.D.'s., certificates, and more.

Unless explicitly stated on the job posting, it is UCF’s expectation that an employee of UCF will reside in Florida as of the date the employment begins.

Department

UCF Foundation - Accounting

Work Schedule

Hybrid remote option; Monday-Friday; 8am-5pm

Type of Appointment

Regular

Expected Salary

Negotiable

Equal Employment Opportunity Statement:

As an equal opportunity/affirmative action employer, UCF encourages all qualified applicants to apply, including women, veterans, individuals with disabilities, and members of traditionally underrepresented populations. UCF's Equal Opportunity Statement can be viewed at http//www.oie.ucf.edu/documents/PresidentsStatement.pdf.

As a Florida public university, UCF makes all application materials and selection procedures available to the public upon request.

The University of Central Florida is proud to be a smoke-free campus and an E-Verify employer.