Patrick Boor Email & Phone Number

United States

Minnetonka

Perform 24x7 SQL Server (2012-2016) support across TCF Capital Solutions. Implement best practice maintenance standards across thirty instances. Provide complex technical assistance to SSRS/SSIS applications. Collaborate with Data Privacy team to ensure successful NPI policies and procedures in lower environments. Assess and define inventory of applications and successful steps towards successful Disaster Recovery exercises. Migrate multiple instances of SQL Server forward to meet End of Life cycle requirements. Monitor general health of mission critical SQL Server instances. Create detailed response reports for Risk Management and external Audit. Recommend principal of least authority across SQL Server and related applications. Identify the root cause of timeouts or long running transactions. Perform index tuning and analysis to improve query execution plans. Deliver after hour support and change management activities for successful or rollback implementations. LeaseWave/Great Plains Administration. Design and develop integration strategies between LeaseWave and Great Plains. Close out the month/year end financials and backup Great Plains and LeaseWave database. Develop approval financial web application to interface between LeaseWave and Great Plains using Econnect. Migrate Great Plains, Integration Manager, Mekorma and Management Reporter forward to GP2015. Manage all production and lower environment deployments for patches and new releases. Migration from 2008 SQL Server and Windows OS due to end of life Microsoft support. Created communication and execution plan for a successful migration. Backup Restore and test SQL Server (2008 to 2016) applications moving across domains. Reconfigured file shares and IIS (7 to 10) applications for Windows Servers (2008 to 2016).

Maple Grove Mn