Andy L. Email & Phone Number

Canandaigua, Ny, Us

Canandaigua, Ny, Us

Oak Brook, Illinois, Us

Oak Brook, Illinois, Us

Continued position from Benefit Resource after acquisition.* Planned & executed multiple SQL Server migrations* Created scripts and processes in both SQL Server and PowerShell to facilitate system management* Performed ongoing query & database optimization* Identified and implemented optimizations of critical processes to reduce overall runtime and runtime variability* Modernized scheduled processes for performance, maintainability and reliability using custom T-SQL and PowerShell (dbatools module)* Authored documentation for supporting the database environment and related processes

https://dbatools.io/Contributing code & documentation to the development of the best open-source PowerShell toolkit for SQL Server database administrators

Rochester, Ny, Us

* Executed multiple SQL Server consolidation, migration & upgrade projects* Performed ongoing query & database optimization* Implemented optimizations of critical processes to reduce overall runtime and runtime variability from 1-6 hours to 20-30 minutes* Standardized database backup management across all SQL Server instances * Improved and standardized index maintenance processes to reduce maintenance windows while improving overall system performance* Implemented masking for data used in development and QA processes using Redgate SQL Data Masker* Implemented SQL Server monitoring and alerting for critical processes using SolarWinds SQL Sentry and custom scripts* Modernized scheduled processes for performance, maintainability and reliability using custom T-SQL and PowerShell (dbatools module)* Authored documentation for administrative tasks and troubleshooting and supporting scheduled processes

Rochester, Ny, Us

• Responsible for ongoing maintenance, support and improvement of a SQL Server instance supporting thousands of websites • Stabilized performance of test/QA database environment • Implemented SentryOne monitoring suite • Upgraded all SQL Server environments to SQL Server 2016 • Consulted with developers on database design & implementation • Worked with key stakeholders across the company to identify implement enhancements to availability and performance of the environment as well as project deliverables • Shared 24x7 on-call support

Rochester, Ny, Us

* Performed database monitoring, query tuning & optimization* Developed both ad-hoc and SQL Server Reporting Services (SSRS) reports based on department and business needs* Integrated table-based security from a 3rd party application into the parameter selections for SSRS reports* Advised system administrators regarding SQL Server requirements, installation & configuration practices* Performed application & system troubleshooting* Performed regular reviews of diagnostic, error-correction and application queries for performance and correctness* Monitored SQL Server performance during critical processing periods and assisted users in avoiding processing slowdowns and timeouts* Heavily customized MRI web screens & reports to tailor the product to Home Properties' specific operational needs* Revised MRI (residential property management system) data archive tool to make it suitable for use in the Home Properties​ environment* Built ad-hoc ETL processes for insertion and analysis of data* Scheduled process automation via Windows PowerShell, Windows Script Host and SQL Server Agent* Implemented SQL Agent jobs for data correction and synchronization* Responsible for documentation throughout software development & implementation, including developing business and testing requirements with personnel at several organizational levels and complex implementation plans with developers and system administrators

Us

* Built templates and custom applications for websites maintained by the Marketing group at The Advest Group (a subsidiary) for public and internal websites.* Maintained several utilities and one website written with .NET technologies.* Updated processes and tools to remove or reduce developer support requirements.* Shared 24x7 on-call application and server support.

* Worked as part of an interdisciplinary team responsible for the development, maintenance and management of web servers, sites and applications serving audiences both internal and external to the company.* Designed and built a custom, dynamic web interface for a vendor system to streamline the underwriting and issuance of policies.* Organized the integration of Visual SourceSafe and related procedures into the web development environment.* Shared 24x7 on-call application and server support.