IT Systems Analyst

University Development Office - 250100

Information Technology

08/05/2025

Temporary Staff (EHRA NF)

IT Systems Analyst

20071682

N000795

1

40

North Carolina, US

$84,000 - $87,360

11 months

University Development’s purpose is to support the mission of the university by raising private resources to enhance financial support for students, faculty, programs, and facilities. University Development provides leadership and centralized services to all development offices throughout the University, serving as a focal point for annual giving, application development and IT support; campaign management; constituent programs; corporate and foundation relations; donor relations; gift planning; gift services; industry relations; marketing/communications; parents giving; principal gifts; prospect management, research and analytics; regional programs; scholarships and student aid; talent management; university events; and volunteer engagement.

Carolina Development is proud of its donor-centered philosophy, pursuing activities that always respect the interests and intentions of the donor as well as the University. The organization’s collaborative nature is a critical component to fulfilling our mission of raising private funds to benefit the university.

Location, Location, Location

• Want to live in Chapel Hill? If so, we have tons of perks to offer you. Discounts and access to many UNC-CH athletics, Performing Arts, Gym memberships and many more on campus and local community opportunities along with a perks program that provides employees with over 800 local deals.
• Want to live outside of Chapel Hill but still in the area? You have a choice of smaller communities, cities, or even suburbs in areas like Raleigh and Durham. Both living experiences offer a multitude of advantages designed to fit your needs and still enjoy the perks offered by UNC-CH.

Tuition & Fee Waiver Program: Check out our Tuition & Fee Waivers Programs – https://hr.unc.edu/benefits/educational-assistance/tuition-waivers/

Benefits: Explore the benefits of working at UNC-CH – https://hr.unc.edu/benefits/

We welcome applicants from all backgrounds and transferable skills!

The IT Systems Analyst will assist the IT Systems Specialist in providing server systems administration for approximately 87 physical and virtual Microsoft Windows servers and SAN storage devices for UDO (University Development Office) located at ITS Franklin and ITS Manning enterprise data centers. In this role there is researching, planning, purchasing, installation, integration, and maintenance of server systems as well as SANs (storage area networks). All of the infrastructure related to our Enterprise level self-hosted Blackbaud CRM (DAVIE) development database, departmental file storage, PowerShell scripting(programming), SolarWinds logging System, DPM backup system, Spotlight SQL DB monitoring system, and various web application hosts will be maintained by this position. This work and any associated scheduled or unscheduled downtime impacts the work of DAVIE CRM users campus wide as well as our Central UDO Organization (over 687 users). Also, this position will provide Active Directory Administration, IT Systems security administration, Qualys vulnerability scanning & remediation, Group Policy administration, firewall maintenance, systems documentation, SQL Database monitoring, troubleshooting & performance tuning for over 70 MS SQL databases, DB Index maintenance, DB security, DB server upgrading, waterfalling of DAVIE CRM dev/staging/production databases, MS SQL Database backups & disaster recovery, SQL scripting as well as designing of database structures and objects necessary to support the functional and technical objectives of the division. The position administers Microsoft SQL databases that are in virtualized and clustered environments which requires working closely with the IT Systems Programmer Specialist which oversees all Development Office server infrastructure as well as consulting with the UDO Applications Development Team. The IT Systems Specialist Sr. infrastructure position and this IT Systems Analyst Jr. infrastructure position report to the UDO Director of IT Infrastructure & Technical Support.

Master’s and 1-2 years’ experience; or Bachelors and 2-4 years’ experience; or will accept a combination of related education and experience in substitution.

Previous experience with MS Hyper-V Virtual and Clustered Server technologies. MS Active Directory Administration, MS Group Policy Administration, MS Windows Server 2019, 2022 Datacenter, 2025 Datacenter & Core. MS SQL Server 2019, 2022, MS SQL Clustering, MS IIS Web Server, MS SQL Database Performance tuning, troubleshooting, and maintenance are required. SQL Server Management Studio (SSMS) and MS SCCM experience. Previous experience with various SAN and NAS data storage systems. Strong analytical and systems troubleshooting skills in order to update and maintain this variety of systems. Issues can arise in any number of places, and it is not always clear if it is software, hardware, wiring, network hardware, vendor or customer based. This requires being able to work quickly under pressure and implement the best fix while at the same time exhibiting strong interpersonal skills with other analysts and customers. A superior customer service ethic is required as well as strong communication skills to effectively collaborate with team members and stakeholders.

MS SQL Server Reporting Services (SSRS), Dell Server Hardware, Dell SAN Technology, NetApp SAN Technology, PowerShell scripting, Log Event Management Tool experience (Splunk, Solarwinds), Some Windows Desktop Support, Blackbaud CRM Sever Support, Qualys Vulnerability Scanning/remediation, Microsoft System Center Data Protection Manager, MS WSUS server, DNS, Virtual Lan environments and general firewall knowledge as it relates to supporting datacenter infrastructure. Quest Spotlight or comparable SQL DB monitoring system. Certification in Microsoft Windows Server Administration and SQL Server administration desirable. Experience with cloud services (Azure) related to database management and deployment a plus. DB Index maintenance, DB security, experience with waterfalling of database environments, MS SQL Database backup technologies, Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server. SQL scripting and troubleshooting of long/non-running queries.

Not Applicable.