Data Warehouse Sql Server

PROFILE

SKILLS HIGHLIGHTS

KEVIN KEMPTER

PostgreSQL DBA / Architect

PHONE

+1-303-***-****

EMAIL

******@********.***

HIGHLIGHTS

MBA with eBusiness Focus

2005

More than 25 years of

PostgreSQL Experience

Versions 8.3 - Current

DB Platform Conversions

• Oracle to PostgreSQL

• SQL Server to PostgreSQL

• DB2 to PostgreSQL

• On-Prem to Cloud

Co-Author of “INFORMIX

UNLEASHED”

Published in 1997

US Government ‘Public Trust’

Clearance

25 years of Linux / Shell

Programming

Cloud Experience

• AWS (EC2, RDS, Aurora)

• GoogleCloud

• Azure

20 years of Data Warehouse

Architecture Experience

15 years of Professional Training

and Conference Presentations

A senior PostgreSQL Data Systems professional with more than 30 years of combined experience in

Leadership, Team Management, Enterprise Data

Architecture, Data Warehouse Architecture Systems

Design, Open Source Solutions, Database

Administration, Database Development, Linux/UNIX

Development and Professional Training.

• PostgreSQL Versions

8.3 – Current

• EnterpriseDB

• Replication / HA

• Physical & Logical

Replication

• PG Pool & PG

Bouncer

• Foreign Data

Wrappers

• Terraform, Ansible,

GIT

• Jira, Confluence

• Enterprise Data

Architecture

• Backup & Recovery

• PostgreSQL

Monitoring

• PostgreSQL Security

• Zero / Minumal

Downtime Upgrades

• Minimal Downtime

Release

Management and

Rollback Strategies

• Linux / UNIX

• Linux Scripting

• Expert Level Bash

and PERL Scripting

• AWS, Google Cloud

and Azure

• Large Scale Data

Warehouse

Architecture

• PostgreSQL

Development

• Production

Database Support

SELECTED ACCOMPLISHMENTS

• June 2023 Presentation on Massive Scaling with PostgreSQL at the Swiss PG-Day at OST Eastern Switzerland University of Applied Sciences, Campus Rapperswil (Switzerland)

• PostgreSQL Conference Presenter at various conferences since 2009

• Designed, Coded and Deployed a PostgreSQL HA setup that included streaming replication, repmgr and PG Pool. Setup included multiple PG Pool nodes, several read only standby data nodes for load balancing of reads and a full copy of the setup in a DR site along with code to force a failover into the DR site or a failback to the primary site

• Deployed a backup and recovery system where PITR based backup tar archives were staged in S3 and each tar archive was a self contained recoverable data set within specific from and to dates

• Deployed a massively scalable PostgreSQL architecture that utilized PG Pool and Foreign Data Wrappers to create multiple ‘stacks’ where each stack contained a writable ‘Federated’ PostgreSQL node with Foreign server connections to either the outbound writable nodes or the read only nodes depending on the stack role, and PG Pool then managed load balancing across the Federated Nodes

• Primary Data Warehouse architect for multiple PostgreSQL based Data Warehouse efforts, Designed ETL processes, Data Marts and the data structures for the Data Warehouse

• Developed Curriculum and Delivered custom PostgreSQL Training for various end clients including the US Navy, Whole Foods, The Bank of Jamaica, CNN and Sirius XM

• Primary DBA and Architect for several platform conversion efforts – Oracle to PostgreSQL, DB2 to PostgreSQL, SQL Server to PostgreSQL

• US PostgreSQL Association Board Member 2010 - 2014 EDUCATION

EXPERIENCE HIGHLIGHTS

TekSystems / Transamerica – Senior PostgreSQL Architect/DBA Various Clients --- 2007 to Present

Assisted Transamerica in wrapping up a migration from DB2 to Aurora PostgreSQL. Deployed a number of SQL Query tuning and scaling methods and documented scaling options to include :

• PostgreSQL VACUUM strategies

• SQL Tuning

• Rollup Tables for reporting performance

• Partitioning Strategies

• Configuration Strategies for performance

MBA with eBusiness Focus

July 2005

Bachelor of Science

Technical Business Management

1991

Associates Degree

Computer Information Systems

1989

PostgreSQL Certification

2005

New Creation, LLC (dba KarbonDB) – Senior PostgreSQL Architect Various Clients --- 2007 to Present

Various Database Admin and Database Development contracts - Database Architecture (primarily PostgreSQL) and Enterprise Data Architecture to include data modeling, meta data architecture, scaling and disaster architectures, database performance tuning, and Database related strategies such as:

• PostgreSQL VACUUM strategies

• H/A strategies

• Backup/recovery strategies

• Data Warehouse Strategies

• PostgreSQL Admin tasks such as:

Installation & configuration

Performance tuning

Monitoring & troubleshooting

Replication (Sreaming Replication, BDR, repmgr, SLONY, etc) Migration from other DB platforms and Formal PostgreSQL training. Database Development roles to include PL/pgSQL, Use of Foreign Data Wrappers, PL/Perl, Perl, Linux shell, C and Python

Multiple database conversion projects to include:

• Oracle to PostgreSQL

• SQL Server to PostgreSQL

• MySQL to PostgreSQL

• PostgreSQL On prem to AWS

Clients include:

• Wynnbet / Wynresorts

• Care Logistics

• Equian

• Digital Globe

• Various US GOV Agencies

• US Air Force

• Work for the NASA SDO II Project (via the Stanford Astro Physics Lab)

• Time Warner Cable

• Barracuda Networks

• Hewlett Packard

• University of Pennsylvania

• University of Chicago

• Cricket wireless

PROJECT HIGHLIGHTS

Enterprise Data Architecture

Scaling strategies

Meta Data design

Logical & Physical modeling

Data Standards

Data Quality & Stewardship standards

Data Governance / Release Data Management

DSS / Data Warehouse / Big Data architectures

Data Security

Data Integration

PostgreSQL Admin

PostgreSQL installation, configuration and upgrades

Performance tuning and troubleshooting

Backup and recovery, Point in time recovery, etc

DRBD, SLONY, Bucardo, Warm/HOT Standby

Security best practices, Hardened OS & database implementations

Best practices

Knowledge transfer and professional documentation

Client specific customized training

Administration in multiple environments and platforms including many AWS environments

Various Migration Projects

Oracle to PostgreSQL

SQL Server to PostgreSQL

DB2 on the Mainframe to PostgreSQL on Linux

PostgreSQL Related Development

Task automation

H/A process development

Backup and recovery, Point in time recovery based development

Design, Test and Development (Internal Life cycle)

Development / automation of various monitoring & alerting components

Various technologies such as Bash, Perl, Python & C Data Warehouses

Extensive background in Data Warehouse architectures & techniques

Kimball, Innmon and Hackney methodologies

Multiple PostgreSQL Data Warehouse implementations in excess of 15TB

PostgreSQL based ETL processing and data validations

Dimensional modeling experience

High Volume OLTP

Experience with extremely high volume PostgreSQL database systems

Experience managing databases with an average throughput

>2GB/second

Experience managing extremely large data sets (single tables > 2Billion rows)

High Availability and Replication

HOT Standby, BDR, SLONY, Bucardo, PG POOL, PG Bouncer, etc

Failover / Switchover processing

Warm Standby, HOT Standby servers with special needs (reporting, forced time delay, synchronous processing, etc)

Contact this candidate