• Server maintenance for both development & production environments including managed upgrades, connectivity support (especially ODBC updates & support), Gallery software configuration & management
• License management using google sheets – Server & Artisan
• Database admin support for end users on SQL Server / MySQL / Snowflake / MongoDB
• User support – including access levels, workflow guidance, network share & SQL Server database administration etc
• Data management – SQL server data warehouse ETL process along with SSAS / report building SSRS
• Project management of Alteryx related activities
o US environment– Development to Production migration
o UK Server migration to US AWS cloud based environment
o Manage small scale projects including UAT
• Service account access and permissions
• Alteryx gallery support
• Alteryx Connect – Configuration and support
o Establishment of processes for Meta data and compliance reporting
• Investigation of new product functionality and capabilities including recommendations for training of Artisans.
• SQL Server database upgrades, backup and recovery, maintenance
• Working within the Alteryx community for troubleshooting and problem resolution.
• Any other related task deemed reasonable by Caterpillar management

• Provide 2nd and 3rd line support to student and business applications with SQL server 2008 / 2012 back-end databases, resolving incidents and service requests, Incident Management working to ITIL framework
• Helping end users better understand and build their reports working on either Crystal reports / SQL server reporting services
• General maintenance of Unix / Linux servers (checking logs, Scheduling cron jobs basic Create, Delete and modify user and groups)
• Creating roles in SAP clients also making changing in development and transporting them through to production
• Configuration and administration of IIS web servers
• Take ownership of service desk management software (Sostenuto) implementing new changes / upgrades / fixes by use of XML / HTML5
• Creating T-SQL / PLSQL scripts to implement fixes also creating/amending of views / procedures
• Work closely with Application owners and key stakeholders in the University to ensure maintenance and support aligns to end-user needs and priorities
• Ensure compliance with corporate standards for information systems, security and technology are in line with relevant legislation and audit requirements
• Contribute to the applications strategy and delivery, development and review of the university’s overall ICT strategy and annual implementation plan.
• Powershell remoting
• Hands-on experience of implementing and supporting large multi-user applications including the implementation of minor enhancements, application configurations, bug fixes and data extracts and reports.
• Working on end to end of new application projects / working with infrastructure team to get correct VM set up to supplier recommendation
• Documentation: Raising RFC for changes and taking them to CAB, Solution guides for known issues, Training user manuals