SQL Server database administrator managing performance tuning, upgrades, installs, SSIS, SSRS on 50+ SQL Servers.Manage 50+ SQL Servers - Version 2014 through currentProactively monitor the SQL Server environment for potential issues.Perform upgrades of existing SQL ServersTroubleshoot incorrect reportsTune poor performing stored procedures and queries.Deploy database changes during go-lives.Modify indexes and queries for better performanceInstall and configure new SQL Servers.Perform server-side traces to capture load test data.Troubleshoot deadlocking issues.Maintain patches and updates on the SQL servers.

SQL Server Database Administrator managing disaster recovery, high availability, maintenance plans, performance tuning, index maintenance, SSIS, Power BI Report Servers.- Created a system using C#.net, PowerShell and SQL to extract, decrypt and decompress developer code inside production Navision databases.- Created a system using Active Directory integration inside PowerShell that polls every SQL Server for all security priviliges, including nested memberships for tracking and alerting on security changes.- Installed and configured Power BI Reporting Services.- Created a dll using C#.net with a method that mimics the behavior of the STRING_AGG function that can be used in older versions of SQL Server that do not have this built-in function.- Created a system using SQL Server audits and PowerShell to track DDL changes in all databases in the environment.- Created a system using PowerShell that generates scripts of all SQL Server Agent jobs, linked servers, logins and permissions that can be used as part of a DR solution.- Created a system using PowerShell and SQL that checks and sets standardized security on the SQL Servers across the environment.- Created standard Active Directory security groups and applied proper permissions on the SQL Servers to the Active Directory security groups.- Created a dashboard using PBIRS, SQL, stored procedures that displays live performance data on any given SQL Server in the environment.- Created standards for ad-hoc changes to production databases including standardized approaches to backing up data before updates, inserts, deletes occur.- Created SQL Server installation and configuration standards that include drive configuration, service account naming standards, standard Active Directory groups, service account permissions, collation, maxdop, standard trace flags, cost threshold for parallelism, etc.- MUCH more!

Lead Conversion Engineer leading a group of 15 engineers in the process of converting legacy systems to OnBase.Key Responsibilities- Technical lead and key technical resource to a group of 15 conversion engineersKey Accomplishments- Converted more than one billion documents into OnBase from other legacy systems- Completed over 20 full system conversions into OnBase from disparate legacy systems- Technical resource on over 100 conversion projects- Wrote programs that merge multiple files and file types (PDF, Word, Images, etc.) into a single document. Output may be a PDF, Word document or multi-page TIFF file.- Wrote programs that generate documents in PDF or Word format from discrete data found in the a database, flat files, etc.- Wrote programs that add attachments to PDF files- Wrote programs that extract attachments and embedded files from PDFs, emails, Word documents, Excel Spreadsheets, etc.- Wrote programs to identify file types of files that do not have file extensions and subsequently rename the files with the appropriate file extension- Wrote programs that extract blobs from different databases and convert them to OnBase documents- Wrote programs that convert files from J2K to a standard image format (TIF, JPG, etc.)- Wrote programs that convert RTF files to PDF- Much more

Database administrator managing maintenance plans, performance tuning, index maintenance, SSIS, SSRS on 80 SQL Servers which host over user 1000 databases. SQL Servers range from version 2000 through current.Key Responsibilities:- Manage 80 SQL Servers with over 1000 user databases- Create and modify new and existing SSRS reports.- Re-write poor performing stored procedures to increase performance.- Create and modify new and existing SSIS packages.- Troubleshoot performance issues.- Make recommendations on index modifications.- Perform SQL server upgrades.- Install and configure new SQL Servers.- Upgrade and migrate SSRS servers.- Perform server side traces to capture troubleshooting data.- Troubleshoot deadlocking issues.- Maintain patches and updates on the SQL servers.- Troubleshoot performance issues.

Database administrator managing maintenance plans, performance tuning, index maintenance, SSIS, SSRS, clustering and Hyper-v. Extensive knowledge of MSSQL server versions 7 through current.Responsibilities:- Manage SQL server databases ranging up to 1 TB- Create and modify new and existing SSRS reports.- Re-write poor performing stored procedures to increase performance.- Create and modify new and existing SSIS packages.- Make recommendations on index modifications.- Perform SQL server upgrades.- Install and configure new SQL clusters- Manage SSRS server.- Perform server side traces to capture troubleshooting data.- Troubleshoot deadlocking issues.- Maintain patches and updates on the SQL servers.- Troubleshoot performance issues.

SQL Server Database AdministratorResponsibilities:- Write extract procedures for PeopleSoft to SAP migration.Key Projects:- Wrote all extract procedures using stored procedures and SSIS for a PeopleSoft to SAP migration. Procedures extracted data into a specific SAP format for importing into the SAP system. Extracts pulled data from PeopleSoft Accounts Receivable, Accounts Payable, Billing, Inventory and Purchasing.

Database administrator managing maintenance plans, log shipping, index maintenance, performance tuning, SSIS, SSRS, clustering and replication for over 140 SQL servers with over 1000 total databases ranging up to 4.5TB. Extensive knowledge of MSSQL server versions 7 through current.Responsibilities:- Manage over 140 clustered, stand alone and virtual SQL server instances some of which regularly reach over 16,000 batch requests per second.- Manage SQL server databases ranging up to 4.5TB- Manage indexes on tables ranging up to 3 billion rows and over 1.5TB in size- Create and modify new and existing SSRS reports.- Re-write poor performing stored procedures to increase performance.- Create and modify new and existing SSIS packages.- Make recommendations on index modifications.- Write archiving procedures. - Perform SQL server upgrades, both in-place upgrades and side by side migrations.- Install and configure new SQL clusters- Manage 4 SSRS servers.- Perform server side traces to capture troubleshooting data.- Meet with department heads to discuss specific requirements for new projects and determine the most efficient and cost effective way to accomplish the task.- Troubleshoot deadlocking issues.- Maintain patches and updates on the SQL servers.- Lead contact with Microsoft for support cases involving SQL servers.- Troubleshoot performance issues.

Database administrator, database developer and overall technical lead at Parts Associates, Inc, a national distributor of maintenance, repair and operations (MRO) equipment with roughly 300 employees spanning 44 states. Managing 8 different production and development SQL servers with over 160 databases ranging up to 500GB. Manage PeopleSoft Enterprise Resource Planning (ERP) system with approximately one-hundred twenty thousand SKUs and processing orders for roughly ten-thousand distinct customers per year. This is a rapidly changing business environment in which I was not only regularly delivering new processes and applications that allow the business to run more efficiently but was also mentoring others as they learn the development process. This exposure has given me the ability to adapt quickly to a wide range of issues across all segments of the business environment not only as a technical resource but also as a leader in my department.Responsibilities:- Database administrator managing backups, restores, maintenance plans and performance tuning for 8 different production and development MSSQL servers with over 160 databases ranging up to 500GB. Extensive knowledge of MSSQL server versions 7, 2000, 2005 and 2008.- Database developer creating and modifying tables, views, indexes, stored procedures, SSIS packages and archiving procedures for production and development SQL servers. - Upgraded several instances from 2000 to 2005.- Create SSIS packages for interfacing new business needs.- Create and modify database maintenance plans for over 160 databases.- Create and administer data warehouse for reporting system- Create and modify new and existing reports in Business Objects reporting system.- Website developer for creating and maintaining e-commerce website developed in asp.net/vb.net.

Managed the internet servers, network and helpdesk among other misc. tasks.