SQL Server Datenbankadministrator (DBA) ❖ Senior | Lead | Manager

freiberufler SQL Server Datenbankadministrator (DBA) ❖ Senior | Lead | Manager auf freelance.de
Referenzen
offline
Verfügbarkeit einsehen
Nähe des Wohnortes
de  |  en  |  es
auf Anfrage
30171 Hannover
17.03.2020

Kurzvorstellung

Self-motivated certified Lead DBA / Manager with an established track record, cross-platform experience (MCITP & OCP) as well as proven capability to transform theoretical concepts into efficiently working reality in versatile work environments.

Ich biete

IT, Entwicklung
  • Transact-SQL (T-SQL)
  • Microsoft SQL-Server (MS SQL)
  • Microsoft SQL Server Reporting Services (SSRS)
  • SAN / NAS
  • Software Virtualisierung

Projekt‐ & Berufserfahrung

Sr. SQL Server DBA / Architect
Kundenname anonymisiert, Confidential
1/2017 – offen (3 Jahre, 6 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2017 – offen

Tätigkeitsbeschreibung

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.

This includes but is not limited to:

- Being responsible for roughly 30 instances (mixed MSSQL 2014 & 2016), both physical & virtualized (VMWare).
- Re-design of existing MSSQL environments (e.g. setup, backups, security, high availability etc).
- Design & implementation of new MSSQL environments including HA (WSFC as well as AlwaysON AG).
- VLDB administration (up to 15 TB DB size, 70+ TB overall data volume in production).
- Performance tuning & support for development & business teams with regard to TSQL (e.g. stored procedures, functions, queries).
- Development of a standardized MSSQL server setup as well as backup strategies according to MS best practices
- Being an integral part in SQL Server consolidation & upgrade discussions as well as POCs regarding the implementation of new technologies and / or hardware upgrades.
- Heading initiatives to improve performance & stability of essential core business initiatives (e.g. SQL Server specific monitoring utilizing SentryOne etc.).

Eingesetzte Qualifikationen

Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL), Microsoft SQL-Server (MS SQL), SAN / NAS, Software Virtualisierung


Lead SQL Server DBA / SQL Server DBA Manager (Festanstellung)
Coyote Logistics / UPS, Chicago
12/2014 – 12/2016 (2 Jahre, 1 Monat)
Logistikdienstleister
Tätigkeitszeitraum

12/2014 – 12/2016

Tätigkeitsbeschreibung

Tasks:

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, InMemory 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.

This includes but is not limited to:

•Being responsible for roughly 50 production SQL Server instances (mixed SQL Server 2012 through 2016 mostly virtualized with several physical failover clusters as well as AGs across two data centres) both internally & externally facing
•Supporting a mix of transactional replication, log shipping and daily database refreshes via automated restores with regards to development, QA, reporting & DR.
•Being in charge of documentation, standardization &improvement of the general setup across the complete SQL Server environment.
•Being an integral part in SQL Server consolidation & upgrade discussions as well as POCs regarding the implementation of new technologies and / or hardware upgrades.
•Heading initiatives to improve performance & stability of essential core business initiatives (e.g. EDI, customer facing reporting etc.).
•Moving database related development towards continuous integration & seamless deployments

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL-Server (MS SQL), SAN / NAS, Software Virtualisierung


Lead SQL Server DBA
ITW, Glenview
8/2014 – 12/2014 (5 Monate)
Maschinen-, Geräte- und Komponentenbau
Tätigkeitszeitraum

8/2014 – 12/2014

Tätigkeitsbeschreibung

Tasks:

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

This includes but is not limited to:

•Solely responsible for roughly 60 SQL Server instances (mixed SQL Server 2000 through 2012, mostly virtualized with 6 physical failover clusters) both internally as well as externally facing
•Fixed log shipping setup for global financial application while eliminating need for 3rd party Software (DoubleTake) and speeding up log restores by orders of magnitude (from an average of 13 minutes file to under 1 minute per log file).
•Extensive documentation of SQL Server as well as OS setup for all instances via PowerShell script including general evaluation regarding existing SQL Server issues
•Standardizing backups across all servers defining &documenting a new standard for SQL Server setup across all servers including database mail & operator setup, basic alert setup, min / max memory settings, TempDB adjustments, service account setup & OS permissions
•Take active part in SQL Server consolidation, upgrade & licensing discussions
•Installation of several new servers defining & documenting a new standard for these operations

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL-Server (MS SQL), SAN / NAS, Software Virtualisierung


Vice President Of Database Administration And Infrastructure (Festanstellung)
Guaranteed Rate Inc., Chicago
7/2013 – 8/2014 (1 Jahr, 2 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

7/2013 – 8/2014

Tätigkeitsbeschreibung

Tasks:

Lead the GRI efforts to transform local into cloud based services while expanding & strengthening the internal database administration as well as the data warehouse team of 5 DBAs.

This includes but is not limited to:

•Responsible for 40+ SQL Server instances (mostly virtualized locally but also cloud based on Amazon AWS & physical) both internally as well as externally facing
•Responsible for research, architecture & implementation regarding cloud transformation of vital database services •Implementation of a new SQL Server 2012 Cluster with AlwaysOn to support GRI online operations
•Lead efforts to implement enterprise wide audit compliant security, standardized setup and backup procedures as well as proactive monitoring regarding SQL Server •Lead efforts for enterprise wide SQL Server consolidation
•Take active part in decision finding regarding new local storage solutions to improve performance and availability •Gateway regarding architectural decisions with business as well as software development

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL-Server (MS SQL), SAN / NAS, Cloud Computing, Software Virtualisierung


Sr. Database Administration Engineer (SaaS) (Festanstellung)
ZS Associates, Evanston
3/2011 – 6/2013 (2 Jahre, 4 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

3/2011 – 6/2013

Tätigkeitsbeschreibung

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.

This includes but is not limited to:

•Primary production as well as development support for all hosting related SQL Server / Oracle issues.
•Design & implementation of two new SQL Server 2008 R2 failover clusters (10 / 16+ TB) on Dell / EMC CX4480 SAN. •Migration of 5.400+ production DBs from various servers (SQL Server 2005 / 2008 / Oracle 10g) to the new production clusters (ongoing).
•Implementation of audit compliant security for SSAE16 on new SQL Server production instances as part of the migration process.
•Implementation of standardized backup strategy across production servers (Quest Litespeed). •Implementation of proactive monitoring across production servers (Idera SQL Diagnostic Manager).
•Ongoing enterprise wide SQL Server consolidation to reduce licensing cost and improve performance (e.g. enhanced server setup, implementation of new storage technologies etc.)
•Collaboration with multiple stakeholders on new storage solutions (e.g. Dell Compellent SAN as well as small server solutions like FusionIO ioDrive) for server consolidation.
•Storage footprint reduction project in order to reduce storage needs of the main applications by up to 75% (e.g. implementation of SQL Server database compression, implementation of application controlled de / archiving of DBs not actively used within 90 days, implementation of a tiered storage solution etc.).

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Oracle Database, Microsoft SQL-Server (MS SQL), SAN / NAS, Software Virtualisierung


Database Administrator (Festanstellung)
Highbeam Research / Cengage Learning, Chicago
5/2008 – 3/2011 (2 Jahre, 11 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

5/2008 – 3/2011

Tätigkeitsbeschreibung

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, redesigned main content SQL Server DB (including partitioning), designed databases for new webproducts, implemented best practices to achieve PCI compliance, implemented SQL Server transactional replication / mirroring / log shipping on various DBs, implemented FileStream technology, implemented proactive monitoring utilizing Idera SQLdm, implemented new backup & recovery strategy utilizing RedGate Backup.

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Oracle Database, Microsoft SQL-Server (MS SQL)


Software Engineer (Festanstellung)
Service Payment Plan Inc., Chicago
5/2007 – 4/2008 (1 Jahr)
Dienstleistungsbranche
Tätigkeitszeitraum

5/2007 – 4/2008

Tätigkeitsbeschreibung

Database Administration & Development, Application Development

Eingesetzte Qualifikationen

Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL-Server (MS SQL), HTML, ASP, JavaScript


Freelance DBA / Software Developer
ITS [...], Hannover
11/2003 – 10/2007 (4 Jahre)
Dienstleistungsbranche
Tätigkeitszeitraum

11/2003 – 10/2007

Tätigkeitsbeschreibung

Database Administration / Development, Website Development, Infrastructure (System Administration / Networking)

Eingesetzte Qualifikationen

Oracle Database, Windows Server (allg.), PL/SQL, Visual Basic Script (VBS), HTML, JavaScript, PHP


Software Engineer / Project Manager (Festanstellung)
WKG Software GmbH, Hannover
1/2002 – 8/2002 (8 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2002 – 8/2002

Tätigkeitsbeschreibung

Kundenbetreuung, Softwareentwicklung, Datenmigration

Eingesetzte Qualifikationen

Oracle Database, PL/SQL, Softwareentwicklung (allg.), Kundenberatung


Software Developer (Festanstellung)
runtime Projektsysteme GmbH, Hannover
5/2001 – 12/2001 (8 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

5/2001 – 12/2001

Tätigkeitsbeschreibung

Software-Entwicklung & Datenmigration

Eingesetzte Qualifikationen

Oracle Database, PL/SQL, Softwareentwicklung (allg.)


Zertifikate

Microsoft Certified IT Professional SQL Server 2008 (MCITP)
September 2010

Oracle Certified Expert DBA 9i (OCP)
Juli 2003

Ausbildung

Staatlich geprüfter Informatiker, Fachrichtung Softwaretechnologie
(Ausbildung)
Jahr: 2001
Ort: b.i.b. International College, Hannover, Germany

Qualifikationen

• MCITP DBA 2008
• Oracle OCP DBA 9i
• ITIL v3 Foundation (coursework but no certificate)
• Advanced Querying and Indexing (Brent Ozar Unlimited - training course)
• MongoDB for DBAs (MongoDB University online – some coursework)

Über mich

I am a SQL Server expert with experience from very small startup to huge enterprise environments. I specialize adjusting existing environments to new needs or create new environments for planned business endeavours. This includes system architecture, hardware planning & sizing, licensing as well as all high availability, desaster recovery & business continuity planning.

Furthermore I have a plethora of experience with regard to administration of large SQL Server environments (server as well as data-wise) as well as database development & performance tuning.

Persönliche Daten

Sprache
  • Deutsch (Muttersprache)
  • Englisch (Fließend)
  • Spanisch (Grundkenntnisse)
  • Französisch (Grundkenntnisse)
Reisebereitschaft
Nähe des Wohnortes
Arbeitserlaubnis
  • Europäische Union
  • Vereinigte Staaten von Amerika
Home-Office
bevorzugt
Profilaufrufe
1713
Alter
48
Berufserfahrung
19 Jahre und 1 Monat (seit 05/2001)
Projektleitung
2 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden »