Kanetra S. Tillotson

· Provide technical/administrative support for the Ellucian Banner ERP & Self Service Applications, Ethos Integration, Degree Works, Experience, Smartplan, BDM AppXtender, EMBURSE, Evisions Suite/MAPs & other 3rd party integration applications

· Automate critical jobs for IT using JAMS Job Scheduler – Command Line, SFTP, SQL Scripting, PowerShell, Linux CRON

· Perform clone/refresh of Banner Test databases from Production environment

· Manage Banner Application User Access & Security through Banner Access Management Classes & Object access

· Troubleshoot/Resolve Faculty, Staff & Student body issues with Banner ERP applications & 3rd party integration apps.

· Upgrade/Patch Banner ERP, Self Service, Ethos APIs, Degree Works, Evisions Product Suites, ESM, Oracle DBMS, Tomcat Server, RabbitMQ Client & Server, Erlang, Java & other required system dependencies for application version.

· Test/Troubleshoot existing departmental processes through use of Evisions Formfusion document design & creation-management tool

· Analyzed and assessed existing business systems and procedures to identify areas for improvement and optimize performance.

· Fulfill requirements of internal and external application users

· Manage/Create/Update AWS Load Balancer & WAF rules using Ansible/Sceptre and native AdministratorAccess dashboard.

· Manage/Create application AWS security groups inbound rules depending on application/tomcat version requirements.

• Provide users technical & administrative support for the Banner ERP System
• Provide administrative support for BDM AppXtender, Chrome River Travel & Expense, Degree Works, Evisions Suite/MAPs
• Schedule/Automate critical jobs for IT using JAMS Job Scheduler – Command Line, SFTP, SQL Scripting, PowerShell
• Setup JAMS jobs delimited Flat File integration for Student & balance information for Cashnet Payment Gateway System through use of SQL Scripts
• Setup JAMS jobs for Chrome River T&E tool integration loading cash advance, expense and encumbrance data through use of Banner API’s
• Created JAMS job to help load student photo data from Banner into Health services system Pyramed
• Troubleshot and resolved e-Transcript issues using Formfusion/NSC, ensuring smooth operation of document processing
• Assisted with upgrade of Banner Document Management System (BDMS AppXtender)
• Program & Debug SQL code according to specifications through use of SQL Developer for Oracle 12C databases
• Resolved student duplicate records within the Banner system
• Resolved Issues related to Degree Works Faculty, Staff & Student body through access to the application and database server
• Test/Troubleshoot existing departmental processes through use of Evisions Formfusion document design & creation-management tool
• Utilize PuTTY to access various files for our Banner Processes on our Linux servers
• Utilize SQL Plus and SQL Developer to access, view, update & remove data in our database system environments
• Analyzed and assessed existing business systems and procedures to identify areas for improvement and enhancement
• Fulfill requirements of internal and external program users
• Assist in resolving problems with software products/systems
• Managed Evisions MAPs administration to support user requirements.
• Executed software product installations to improve system performance.

• Supported users of Banner ERP System by addressing inquiries and resolving issues
• Program & Debug SQL code according to specifications through use of SQL Developer for Oracle databases
• Schedule/Automate critical jobs using JAMS Job Scheduler
• Tested and troubleshot departmental processes using Evisions Formfusion, ensuring optimal document design and management
• Perform upgrades for Evisions Intellecheck
• Analyze and assess existing business systems and procedures
• Resolved software product/system issues, enhancing user experience and operational effectiveness
• Assist in resolving problems with software products/systems
• Write reports for management and/or team members through use of Evisions Argos Reporting tool
• Managed MAPs system administration tasks
• Performed installation of software products
• Supported operations at Information Technology Center

• Maintained and provided 24/7 SQL Server Database System backend support for internal and third-party party vendor applications. Ranging from multiple languages - ASP.NET, ColdFusion, VB, C# & HTML
• Implemented Maintenance & Performance tuning strategies to improve database & application performance + functionality
• Automated SQL Server performance and database maintenance using T-SQL scripts and SQL Server Agent Jobs, enhancing overall system reliability.
• Automated Database & Server Based Alerts/Monitoring through use of T-SQL Scripts & SQL Server Agent Jobs
• Created/Implemented Stored Procedures & Triggers to aid in troubleshooting application and database performance issues
• Primary Point of Contact for 85+ Application Databases supported in multiple environments - Development, Test, E2E, Production, QA, Staging, Sandbox, and Disaster Recovery
• Migrated/Upgraded multiple application databases from EOSL versions of software to current & in support versions of the software across various server platforms – Clustered, Standalone & VMWare Virtual Cloud Servers, SAN, NAS, & RDM storage. System Upgrade/Migration experience includes – SQL Server 2000 to 2005, 2005 to 2008R2, 2005 to 2012, 2005 to 2014, 2008R2 to 2012, 2008 to 2014
• Coordinated with application developers to rigorously test upgraded database systems, ensuring application stability and functionality post-upgrade.
• Decommissioned older/obsolete versions of database software after migrating EOSL databases over to current in support versions with thorough testing from my end & from the application team. Allowed appropriate soak periods for Development and Test database migrations ensuring user & regression testing had been properly performed & to ensure enough time to discover and troubleshoot any unexpected issue
• Delivered comprehensive scripts for database/server logins, users, roles, jobs, and linked servers along with detailed upgrade documentation to facilitate seamless migrations to new SQL Server versions.
• Troubleshot & provided immediate support for degraded database performance related to server resource issues such as High CPU, Memory, Waiting Tasks, I/O Latency, Long Running Queries, Long Running Jobs, Blocking, Deadlocking, Disk Usage etc. through use of querying, Perfmon, pssdiag, SQL Server Spotlight and Activity Monitor
• Collaborated/Coordinated with Application Developers on deploying SSIS packages & DTS package conversion to SSIS for use within SQL Server Agent Job Automation
• Maintained Production Support for a High Transactional Alwayson High Availability Database that was used for replicating a larger scale of data in terabytes across multiple servers within a singular Availability Group
• Implemented/Automated Database Backup & Recovery Jobs and Transaction Log Backups through Maintenance Plan creations & TDP (Tivoli Data Protection) to help ensure consistent database performance & prepare for disaster recovery using SQL Server Failover from one node to the other in a clustered environment
• Delivered 24/7 on-call support for production outages and issues through a weekly rotation with a team of SQL Server DBAs.
• Provided Production Database System Support for multiple application deploying code change releases
• Performed Oracle database upgrades from Oracle 9 to Oracle 10G from 10G to 12C
• Maintain/Monitor Oracle database systems. Applying patches, DB upgrades & monitoring through OEM.
• Provided Full Documentation & Support to Oracle Production DBA with detailed steps of database tasks performed in Dev/Test environments
• Applied Quarterly Oracle PSU Patches to multiple 10/11G databases.

• Used Oracle Database Software using PL/SQL and Putty
• Maintained STA environment within Ensemble database, ensuring it was consistently updated with latest patches.
• Utilized Linux/Unix commands to modify database schemas and tables, enhancing data management efficiency.
• Monitored and maintained Oracle database systems, applying patches and conducting upgrades through OEM.
• Completed Various Oracle DBA Administrator training courses – Beginner & Administrative. Most recent Oracle 12 C: New Features
• Supported IT operations to ensure system functionality.