Andreas Zimmermann

Working as an independent senior consultant in a group of DBAs in a large 24/7/365 VLDB environment, re-designing general architecture utilizing up to date native technologies (e.g. AlwaysOn Availability Groups) in order to support business growth as well as core company values with regard to customer service. Furthermore serving as a vital liason between the German & US technical teams as well as the international business teams & internal clients.

Build up a talented DBA group & lead Coyote efforts for a redesign of the core SQL Server environment utilizing up to date native technologies (e.g. AlwaysOn Availability Groups, In-Memory OLTP) as well as modernizing 'external' technologies (e.g. all flash SAN, server internal enterprise flash, caching solutions) in order to support business growth as well as core company values with regard to customer service. For more details please see www.linkedin.com/in/azimmermann/

Lead ITW SQL Server consolidation & virtualization efforts in preparation for campus wide move while implementing corporate-wide SQL Server setup & backup standards as well as improving performance where possible.

Lead the GRI efforts to transform local into cloud based services while expanding & strengthening the internal DB & DW team of 5 DBAs. - Responsible for 25+ SQL Server instances (virtualized locally/Amazon AWS) - Resp. f. research, architecture & implementation regarding cloud transformation - Lead efforts to implement audit compliant security, standardized setup / backup proc. & proactive monitoring - Lead efforts for SQL Server consolidation - Gateway regarding architecture between business & SD

Research, build & document a sustainable & efficient SQL Server DB infrastructure for the new SaaS team, migrating 20+ TB of data from the existing environments (mixed Oracle 10g and SQL Server 2000 through 2008) into the new structure, meanwhile provide expertise to improve the existing database environment and implement standards / best practices as well as prepare all environments for upcoming audits. For more details please see www.linkedin.com/in/azimmermann/

Solely responsible DBA for 20+ MSSQL 2008 and Oracle 10g databases with sizes up to 500 GB & large tables up to 100 million rows feeding web applications with over 30+ million unique visitors per month. Planned & implemented new hardware structure, migrated SQL Server environment from 2005 to 2008, re-designed main content SQL Server DB (including partitioning), designed databases for new web-products, [...]. For more details please see www.linkedin.com/in/azimmermann/

MS SQL Server 2000 performance tuning, Application Development (frontend - ASP / backend - SQL Server), conceptual design (logical / physical DB design, indexing, stored procedures, exception handling, data encryption etc.) of a SQL Server 2005 database for upcoming business (expected marketing volume about 3.5 million customers / year) Skills: MS SQL Server 2000 / 2005, Crystal Reports (migration from CR to dynamic Report creation through ASP), TOAD for SQL Server, TSQL, ASP, Windows NT, 2000 & XP

Freelance database & web development as well as network support / administration

Project management including acceptance, planning, coordination, execution & supervision of customer specific development requests as well as customer support, database upgrades and preparation of browser based data output Software Developer

Transfer of commercial data from third party systems into proprietary runtime software book, customizing of the internal accounting system (including part-developing), customer liveware training & support Technical Support Specialist

Statistics, analysis & reporting, presentation preparation (controlling provision / payoffs), data backup, setup & configuration of internal bank Software & remote data transmission, telephonic support, hardware check & OS / Software installing as well as configuration