Scott Basch Email & Phone Number

New York, Ny, Us

As a Senior Database Administrator:Microsoft Certified Azure Database Administrator AssociateAssist developers and infrastructure staff with all aspects of SQL ServerDetermine, diagnose, and resolve issues with system slowness and application timeoutsImplement custom and third-party monitoring solutions to help troubleshoot incidents and outagesOptimize poor performing SQL queries through execution plan evaluation, query restructuring, and index tuningSupport on-prem MSSQL as well as cloud-based Azure SQL DBs and Managed InstancesProduction SQL Server administration (Security, Replication, Back-up/Restores, High Availability, etc.)Build ETL packages using SSIS for data archival or to automate common tasksImplement and support Oracle GoldenGate for data replication solutionsReview and approve continuous integration deployments in Azure DevOpsExperience with Transparent Data EncryptionEvaluate and optimize Azure Synapse queries executed on dedicated SQL poolsTroubleshoot ETL failures in SSIS Catalogs and Azure Data Factory pipelinesAs a Software Developer Team Lead:Led a group of developers concentrated specifically on ETL and data migration (mostly SSIS and TSQL)Migrated outdated high cost insurance infrastructure to a new platformAutomated manual processesCoordinate transfers of policy bookrolls purchased from other companiesTroubleshoot data issues on the front and back-endDevelop commissions processesBuild complicated financial reportsCreate complex ETL batch processesCoordinate data migration from large corporate acquisitions

Akron, Ohio, Us

Work in the Business Intelligence Group.Develop and support systems for marketing strategists.Support and develop the data warehouse.Architect corporate reports.Develop and support client systems.Automate the creation and delivery of client files.Troubleshoot back-end issues.Support client web-portal.