Kevin Schoonmaker Email & Phone Number

Experienced IT professional with experience in database administration, application development, integration, and reporting.• Analytical thinker with strong problem-solving skills.• Strong communication skills. Able to work with clients to identify needs and develop solutions.• Experience with remote database and system administration as well as remote collaboration and tech support.SQL Server DBA Skills: • Capacity planning• Install, configure, and optimize SQL Server database engine.• Install and configure SSIS, SSRS, SSAS. Modify and deploy SSIS packages.• Physical and virtual servers (VMware)• Backup and restore• Automate maintenance with:o Maintenance planso SQL Server Agent jobs,o Scheduled tasks with sqlcmd• Manage users and permissions (including with Active Directory integration)• Transact-SQL scripts and stored procedures• Performance Tuning:o Execution Plans, DMVs, Query Storeo Query Optimizationo Indexes• SQL Server Audit and IBM QRadar (SIEM)• Solar Winds Database Performance Analyzer (DPA)• Quest LightSpeed• SQL Server version upgrades• Experience with SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016MS Access Skills:• Data modeling• Application development• VBA• ODBC with SQL Server, mysql, and Oracle databases.• Database/system integration• Automation• ReportingOther Skills:• MySQL• Oracle• Windows Server administration• Excel• PHP application development• Ellucian Banner• Ellucian Recruit CRM/Microsoft Dynamics• Blackboard Learning Management System• LISTSERV email list software administration and integration• PaperCut print tracking software

Listed skills include Microsoft Sql Server, Mysql, Databases, Database Administration, and 10 others.