Andy L.

Andy L. Email and Phone Number

Contributor @ dbatools.io
Canandaigua, NY, US
Andy L.'s Location
Canandaigua, New York, United States, United States
Andy L.'s Contact Details
About Andy L.

Specialties: Database administration, SQL query tuning, PowerShell scripting, systems integration, analysis & documentation, process improvement

Andy L.'s Current Company Details
dbatools.io

Dbatools.Io

View
Contributor
Canandaigua, NY, US
Website:
dbatools.io
Employees:
22
Andy L. Work Experience Details
  • Dbatools.Io
    Contributor
    Dbatools.Io
    Canandaigua, Ny, Us
    View
  • Inspira Financial
    Lead Database Administrator
    Inspira Financial Sep 2024 - Present
    Oak Brook, Illinois, Us
    View
  • Inspira Financial
    Database Administrator
    Inspira Financial Jan 2024 - Sep 2024
    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
    View
  • Dbatools.Io
    Contributor
    Dbatools.Io Jul 2017 - Present
    https://dbatools.io/Contributing code & documentation to the development of the best open-source PowerShell toolkit for SQL Server database administrators
    View
  • Benefit Resource, Inc.
    Database Administrator (Bri Is Now Inspira Financial)
    Benefit Resource, Inc. Oct 2019 - Dec 2023
    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
    View
  • Catertrax
    Ms Sql Database Administrator
    Catertrax Mar 2017 - Oct 2019
    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
    View
  • Home Properties, Inc.
    Technical Project Lead
    Home Properties, Inc. Nov 2005 - Mar 2017
    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
    View
  • Axa Financial
    Web Developer
    Axa Financial Jun 2004 - Oct 2005
    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.
    View
  • The Mony Group
    Web Developer
    The Mony Group Jun 1999 - Oct 2005
    * 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.

Andy L. Skills

Databases Microsoft Sql Server Integration Sql Software Development Software Documentation .net Powershell T Sql Itil Ssrs Windows Server Database Design Software Project Management Systems Analysis Windows Sql Server Mri Windows Scripting Iis Web Applications Java C# Sdlc Visual Studio Xml Html Ssis Active Directory Remitplus Query Optimization Version Control Subversion Kcs

Andy L. Education Details

  • Clarkson University
    Clarkson University
    Computer Science

Frequently Asked Questions about Andy L.

What company does Andy L. work for?

Andy L. works for Dbatools.io

What is Andy L.'s role at the current company?

Andy L.'s current role is Contributor.

What is Andy L.'s email address?

Andy L.'s email address is an****@****rax.com

What is Andy L.'s direct phone number?

Andy L.'s direct phone number is +121563*****

What schools did Andy L. attend?

Andy L. attended Clarkson University.

What skills is Andy L. known for?

Andy L. has skills like Databases, Microsoft Sql Server, Integration, Sql, Software Development, Software Documentation, .net, Powershell, T Sql, Itil, Ssrs, Windows Server.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.