About

Hello, I am independent consultant specializing in designing database infrastructure in the cloud. I aim to build fault tolerate resilient systems that maintain data consistency. Adhering to best practices and finding solutions that keep costs down and allow for flexibility. I have 17 years of experience in the field and hold many certifications.

Services

Project Planning & Strategy

Coordinate teams, schedule and develop project plans. Advise on best practices. Build and test disaster recovery procedures. Strong problem solving and communication skills. Work to schedule

Solution Sustainment

Maintain and improve current operations. Monitor and improve performance, aid application teams, build proactive processes to keep systems optimized and business moving.

Process Development

Designing and build robust ETL, monitioring and automation processes that keep your business applications moving and teams well informed. I am to use cloud platform services and tools to create highly integrated solutions.

Premium Customer Support

I deliver off-hour and on-call support during projects, go-live and sustainment contracts. My premium support will assure project success and go-live date.

Skills

DB2 LUW 10.5
100% Complete
DB2 DPF
100% Complete
DB2 HADR
100% Complete
db2hpu tool
100% Complete
Amazon Web Services
100% Complete
Google Cloud Platform
100% Complete
Perl
100% Complete
Ksh
100% Complete
Python
100% Complete
LDAP Security
100% Complete
Label Based Access Control(LBAC)
100% Complete
Query Optimization
100% Complete
Project Design
100% Complete
SAP HANA
90% Complete
SAP Replication Server
90% Complete
Apache Hadoop
90% Complete
MongoDB
90% Complete
Agile Methodologies
100% Complete
Data Warehouse Design
100% Complete
Cloud Infastructure
100% Complete
ETL processes
100% Complete
Communication
100% Complete
Database Migration
100% Complete
Database Performance Tuning
100% Complete
Business Process Design
100% Complete
Backup and Recovery Design
100% Complete
UNIX/AIX
100% Complete
Problem Resolution
100% Complete
Teamwork
100% Complete
Spatial UDF creation
100% Complete
CLOBS/BLOBS/XML
100% Complete
Proactive Monitoring
100% Complete
Develop New Stratagies
100% Complete
Best Practices
100% Complete

Experience

Jan 2018
  • Amazon Web Services Solution Architect Certified
  • Passed AWS Solution Architect Certification
  • 01-2018

Sep 2016
  • DB2 DPF Project Lead
  • 2 year project designing DB2 Data Warehouse for a large Midwest Insurance Company
  • 09-2016 - 08-2018

Sept 2014
  • Guest Speaker at IBM Insight2014: Conference for Big Data and Analytics
  • Session on how to use db2hpu to extract, transform and load large amounts of data. Real life client experiences
  • 09-2014

  • DB2 Advanced Technical Expert V10.5
  • Passed IBM DB2 Certifications as DB2 Advanced Technical Expert. Version 10.5
  • 03-2014

Jan 2013
  • DB2 Project Lead at Canada Pacific Railway
  • Lead on Migration on DB2 Databases from z/OS to Linux
  • 08-2013 - 12-2014

  • SAP Certified Technology Associate SAP HANA 1.0
  • Completed Training and Certification as a Technology Associate for SAP HANA 1.0 (Exam:C_HANATEC_1)
  • 01-2013

Nov 2012
  • SAP Certified Application Associate SAP HANA 1.0
  • Completed Training and Certification as an Application Associate for SAP HANA 1.0 (Exam:C_HANAIMP_1)
  • 11-2012

  • DB2 DPF Project lead on PureData for Analytics System
  • 2 Year Project Migrating Old System to New PureData for Analytics system by IBM
  • 09-2010

Sep 2010
  • DB2 Advanced Technical Expert V9
  • Passed 3 IBM DB2 Certifications. Last exam was expert level.Version 9
  • 06-2010

  • DB2 DPF Administrator for a Large Midwest Insurance Company
  • Designed and played key role in Data Warehouse Project
  • 09-2006

Jun 2002
  • DB2 Advanced Technical Expert V7
  • Passed 3 IBM DB2 Certifications. Last exam was expert level. Version 7
  • 06-2002

  • Hired with IBM
  • DB2 DPF Administrator for a Large Midwest Insurance Company
  • 06-2002

  • B.Sc. Computer Science
  • Completed a Bachelor of Science in Computer Science at the University of Calgary
  • 12-2002

Latest News From My Vlog

Check out adatacloudguru Youtube Channel to find cloud data tutorials

Create a DB2 HADR Cluster on AWS: Part 1

Sandy 6:49 AM Technology

Learn how to create a DB2 HADR database on AWS. It's really easy... all you need to use is a Cloud Formation template

View More

Create a DB2 HADR Cluster on AWS: Part 2

Sandy 4:34 PM Technology

A guided walkthrough of the DB2 HADR Cluster created on AWS and first steps

View More

Creating a DB2 ROS Cluster on AWS: Part 1

Sandy 9:00 PM Technology

Tutorial on creating a DB2 ROS Cluster on AWS the easy way... with a modifed cloud formation template

View More

Contact Us

For consulting requests and questions to blog posts please use the contact form below. We will get back to you within 48 hrs

    Thanks! We'll contact you soon.

    Sending...

    Call Us

    1-403-519-5757

    Email Address

    contact@adatacloud.guru

    Office Location

    Calgary, Alberta

    Working Hours

    Monday-Friday MST 8:00-16:00