Mike Long

Background

About Mike Long

Database Consultant with over twenty five years of combined experience in software design solutions, data migration and consolidation, data warehouse design, performance optimization, support and team leadership.Performance - Design and tune database code to maximize data delivery throughput from database to application-> Analyzing database normalization-> Evaluating the implementation of stored procedures, views, partitions and file groups-> Index Tuning-> Analyze Query PlansCloud Computing - Migrate on-prem Sql Server Farms to the cloud (AWS and Azure)-> Manage failover clusters-> Create and maintain replication between geographic regionsSecurity - Protect Personal Health Information (PHI) and Payment Card Data (PCI DSS) information-> Database encryption-> Customized server and database login roles-> User access logging to meet auditing requirementsDatabase Code - Manage database code as it moves from the Development, QA, UAT and Production environments. Automation - Create scripts to automate testing and deployemnt of Database code-> QA scripts to test changes to the database API-> Tooling to automate the setup and management of database servers and objectsMigration - Migrate data from Oracle, MySQl, Spreadsheets and flat files-> SSIS packages-> Powershell scripts-> Batch files and BCP-> Scrub and transform data from source format to target format