The Hammer | The Hammer



Derik Hammer203.623.0492derik@ Myers-Briggs Type Indicator: INTJProfessional SkillsExperience working in database operations, application development, and data warehousing teamsExpert level experience with SQL Server AdministrationExperience with large scale data warehouse design and implementationHigh performing problem-solving skillsStrategic minded thought leader capable of building finding elegant solutions to long term challengesExcellent communication and teaching skillsTechnologies & Technical SkillsMicrosoft SQL Server 2000-2017T-SQL / SQL Server Performance TuningSSIS/SSAS/SSRS AdministrationSQL Server High-Availability & Disaster RecoveryAutomationPowerShell & PythonContinuous Delivery/IntegrationData Warehouse DesignData ModelingErwin (Data Modeler, Mart Server, & Web Portal)Amazon Redshift & EC2 (AWS)SSIS ETL DevelopmentMatillion for RedshiftAmazon S3 (AWS)Azure SQL Data WarehouseAzure SQL Database & Amazon RDS PostgreSQLJenkins & Octopus DeployPythonC# / .NETRESTTest Driven Development (TDD) w/ automated testing and golden data strategiesPosition Overview2017-2020 Derik Hammer Data Solutions | Consultant2017-2020 Subway | Sr. Data Manager – Data Warehousing & Architecture2016-2017 Subway | Technical Lead – Database Operations2015-2016 Ascension Information Services | Senior Database Administrator2014-2015 Liberty Tax Service | Data Architect / T-SQL & .NET Developer2012-2014 Liberty Tax Service | Technical Lead – Database Operations2011-2012 Liberty Tax Service | Database Administrator2005-2011 United States Navy | Fire-Control Technician | Highest Rank: E-6Community Involvement (events)Public speaker (24+ conferences)Blogger (personal,syndicated,paid)Product group memberships/affiliations (3 groups)Education / Certification / HonorsMicrosoft Data Platform MVP (2-time award winner, first award 2017)Querying Data with Transact-SQL (SQL Server 2016) – Exam 70-761 (2017)Querying Microsoft SQL Server 2012 Databases – Exam 70-461 (2015)Administering Microsoft SQL Server 2012 Databases – Exam 70-462 (2014)Bachelor of Science in Computer Information Systems with a focus in Database Management – Summa cum laude with a 3.97 GPA (2014)CompTIA Security+ Certification (2011)ExperienceConsultant – Derik Hammer Data Solutions (Client: Danbury Kanreikai Karate)Developer and Architect (Present)Product - Event Hammer ()Karate tournament management software.Server based system with direct integration between itself and client’s MySQL Wordpress database.Desktop client tool for user access.Provides competitor and match management, administrative and match score reporting, printable signage and registration forms.Tools usedC# Windows forms application, SSIS, Microsoft SQL Server, MySQL, Wordpress, and Visual Studio.Worked with the customer to determine business requirements for year one minimum viable product along with a feature backlog.Architected the solution and designed the software structure.Developed, tested, and bug fixed all aspects of the product.Orchestrated programmatic unit testing along with manual functional testing and user acceptance testing, using a test driven development (TDD) methodology.SubwaySenior Data Manager – Data Warehousing & Architecture (Present)Data WarehousingDesigned a data mart layer into our business intelligence stack resulting in a much more consistent model which improved business and data analysts’ ability to easily comprehend the model and use it more effectively.Coordinated design sessions and acted as direct contributor and final review / approval for all work as it relates to our on-premises Teradata warehouse and our Amazon Redshift warehouse.Solution architect with overall responsibility for the quality of design and successful implementation for a 29-month project to migrate our Teradata warehouse into Amazon Redshift.Conducted a two-month proof of concept and deep technical comparison of Amazon Redshift and Microsoft Azure SQL Data Warehouse.Data IntegrationsOverall authority on the ground up redesign and methodology of performing ETL/ELT integrations for data warehouse.Spearheaded a proof of concept and eventual decision to embrace Matillion for Redshift as a replacement for a heavily convoluted set of custom processes which included Active Batch, SQL Server Integration Services (SSIS), Teradata Parallel Transporter (TPT), and multiple layers of custom batch and SQL scripts.Lead a team to implement a data quality and testing framework for our data integrations, for the first time in the company’s data team history.Defined and implemented python into our ETL processes resulting in me training our department on Python and REST request and response patterns.Resolved major back-end implementation challenges with our new Matillion platform, including working directly with Matillion engineers to debug cluster node interactions and memory management problems within their commercial off the shelf solftware (COTS).Business IntelligenceArchitectural design of our future state intermediate business intelligence layer which includes SQL Server Analysis Services (SSAS Tabular) cube and Amazon RDS PostgreSQL. The BI layer is built from Amazon Redshift.DevOps & QualityDesigned the continuous delivery automated deployment workflow for promoting changings in our MPP data warehouse, OLTP metadata database, and integration processes.Authored functional testing standards and implemented automated integration testing for our platform using test driven development (TDD) methodologies and a golden data (known good) result comparison strategy. LeadershipCoached my team of four data architects and one ETL architect to base all of their work on a central set of principles and design standards resulting in independent work between team members fitting together seamlessly. Also, resulting in collaborative work being conducted without conflict and with a unified set of concepts which everyone is following.This role as Sr. Data Manager has been a highly technical role with requirements for technical deep dives with the team on a nearly daily basis.Established and enforced high integration design and development standards resulting in 75% fewer ETL job failures.Implemented integration development templates and reusable common components resulting in 30% faster development of ETL jobs.Contributed key technical insight in direct program manager interactions with both Microsoft and Amazon for feature feedback / technical analysis.Technical Lead – Database Operations (1 year)CloudDesigned and implemented an Azure SQL Database (PaaS) with hooks into SharePoint Online Business Connectivity Services for a contract management system.Designed and implemented an Always On Availability Group high availability / disaster recovery architecture for the mission critical Subway remote ordering platform. This system resided in two regions of Microsoft Azure (IaaS) with multiple data integration points between third party vendors and our on-premises systems.Data Architecture / Database DesignDesigned a metadata driven controller database which was responsible for performing automated database restores and scrubbing all sensitive information, such as PII, out of the databases and then backing up the sanitized copies to a developer accessible file share.Participated in peer review and reactive schema design analysis of multiple OLTP and enterprise data warehouse systems including a global scale remote order platform.PerformancePerformed proactive performance monitoring at the database instance and query level using home-grown and third-party tools including Idera SQL Diagnostic Monitor and SentryOne SQL/BI/DB Sentry.Advanced skills in query tuning and execution plan analysis from both a resource usage-based approach and execution plan optimization.DevOps / DLM / Continuous IntegrationWorked intimately with the DevOps team to design and implement a database lifecycle management system which mandated all changes be implemented automatically.Wrote the standards for and educated development and DevOps teams on the use of SQL Server Data Tools (SSDT) database projects, a desired state deployment tool.Automated database deployments utilizing PowerShell.Software / Configuration Implemented and tuned In-Memory OLTP tables for ETL processes, write heavy workload lock reduction, and optimizing tempdb file contention.Performed SQL Server side-by-side upgrades on versions from 2008 R2 to 2016.Implemented automated SQL Server patching system using System Center (SCCM). This system accounted for lower environment testing before propagation through the upper environments and separation of duties between the DevOps and Database Operations.Maintained database servers in multiple domains with a variety of one-way and two-way trusts. Maintained database servers in isolated environments with cloned domain controllers.High-Availability / Disaster RecoveryImplemented and maintained multi-node Windows Server Fail-over Clusters on Windows Server 2008 R2 and 2012 R2.Implemented and maintained Always-On Availability Groups to include stand-alone SQL Server instance configurations and hybrid configurations incorporating SQL Server Fail-over Cluster Instances. Architected cross-subnet Windows Server Clusters for fail-over to remote data centers. Data Distribution / MigrationMaintained a SQL Server replication architecture utilizing transactional and snapshot replication. Ascension Information ServicesSenior Database Administrator (1 year)Data Architecture / DevelopmentDesigned and developed a financial data warehouse for a large hospital.Performed requirement gathering and business stakeholder interviews to understand reporting needs.Optimized data warehouse performance using columnstore indexes.Performed data analysis and data modeling for major schema refactors.Principal report writer using SQL Server Reporting Services for Population Health and Meaningful Use metrics (healthcare, external data submissions).Developed and optimized extract, transformation, and loading (ETL) packages using SQL Server Integration Services (SSIS), PowerShell, and the bcp utility.Software / Configuration Performed 150+ SQL Server side-by-side upgrades on all versions between 2005 and 2012.Installed and configured SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Database Engine, and SQL Server Data Tools. Liberty Tax ServiceData Architect / T-SQL & .NET Developer (2 years)OLTP Data Architecture and DesignParticipated in the design of eight databases comprising a tax preparation platform servicing both self-preparers and tax professionals in three countries and five time zones.Designed and developed a database and ETL process for receiving customer tax data from nine acquired organizations with flexibility to snap in data as more organizations are acquired without knowing the completeness and cleanness of their data in advance.Responsible for near lockless processing of data with transactions per second in the 10s of thousands.Optimized performance using Read Committed Snapshot Isolation and Snapshot Isolation, where appropriate.Data Warehousing / Business IntelligencePerformed code reviews and performance tuning / analysis of 8 database projects with over 2,000 user objects.Developed Extraction, Transformation, and Loading (ETL) SSIS processes in Business Intelligence Studio (2008) and SQL Server Data Tools for Business Intelligence (Visual Studio 2012 and 2013).Developed PowerShell driven processes for automating SSDT database project deployments and custom pre/post deployment tasks..NET DeveloperDeveloped WCF services acting as the business layer beneath the presentation and application layers. Also, developed within a centralized data access layer where I contributed to development standards for efficient access of the databases.Developed with C# (.NET 4.0, 4.5, 4.5.1) in Visual Studio 2012 and 2013. Technical Lead – Database Operations (3 years)Software / Configuration Developed a PowerShell based automated provisioning system capable of building over 32 SQL Servers overnight without human intervention.Standardized SQL Server Integration Services deployment, management, and processing with a central dedicated package store and assigned processing servers.Established an enterprise wide method of auditing Data Definition Language changes to database schemas and ETL’ed the data to a central auditing server to be viewed via SSRS reports.High-AvailabilityImplemented and maintained multi-node Windows Server Fail-over Clusters on Windows Server 2008 R2, 2012, and 2012 R2.Implemented and maintained Always-On Availability Groups to include stand-alone SQL Server instance configurations and hybrid configurations incorporating SQL Server Fail-over Cluster Instances. For standard edition SQL Server instances, implemented and maintained database mirroring.Architected cross-subnet Windows Server Clusters for fail-over to remote data centers. Disaster RecoveryDesigned and implemented an automated database backup solution, with a tiered priority structure, for production databases ranging from very small to a sharded system of databases exceeding 2 TBs per shard.Implemented and maintained log shipping for warm sight, tier 2, databases.Automated database backup file testing on secondary servers by retrieving a random sampling of backup files each day via Central Management Server and log restore tests. Utilizing both DBCC repair and page level restore methods, recovered from 10+ database corruption incidents to include corruption to mission critical systems such as Team Foundation Server (TFS) source control. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download