Skip to content
View JohnAskew's full-sized avatar
💭
So far, this week, it's 8 out of 10 stars.
💭
So far, this week, it's 8 out of 10 stars.
4 followers · 7 following

Achievements

Achievement: Arctic Code Vault Contributor

Achievements

Achievement: Arctic Code Vault Contributor

Block or report JohnAskew

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
JohnAskew/README.md

Welcome! 👋

😄 Pronouns: He/Him, but..Hire the best person for the job, and call them by their name.

🔹 README.md

🧩 Overview

This repository showcases work samples with Oracle, DB2 UDB, and Exasol databases.
It demonstrates enterprise-level administration, performance tuning, and automation techniques that improve reliability, scalability, and query efficiency in mission-critical systems.

As a Senior Database Administrator and Python Developer, I built these solutions to support high-availability environments across analytics, finance, and logistics workloads — maintaining uptime above 99.95% and cutting manual intervention time by more than 60% through automation.

⚡ Key Highlights

  • Performance Tuning – SQL and Python utilities to monitor, optimize, and benchmark query execution.
  • Database Automation – Scripts and cron-based processes to streamline backups, user provisioning, and monitoring.
  • Error Recovery Tools – Automated job restart routines and audit logging for high-reliability systems.
  • Integration Scripts – Data loading and ETL automation examples integrating Exasol with Oracle, DB2, and SQL Server.
  • Monitoring Dashboard – Prototype metrics pipeline using Python + Grafana for database health tracking.

🧰 Tech Stack

Category Tools / Technologies
Databases Exasol, Oracle, SQL Server, DB2
Languages Python, SQL, Bash, PL/SQL, JCL, COBOL
Automation Apache NIFI, Cron, Bash scripts, ExaLoader
Monitoring Solution Automation, JSON, Logs, REST APIs
Infrastructure Linux, AIX, OS/390, z\OS, Exasol

📊 Languages & Usage Ratio

Language Usage Ratio
Python 0.45
SQL 0.30
Bash 0.15
PL/SQL 0.10
Total 1.00

🚀 Setup & Usage

Start with Titanic solution for general documentation and coding concepts:

git clone https://github.com/JohnAskew/titanic.git
Here is the Backup and Restore samples repo:
git clone https://github.com/JohnAskew/Samples_Bkup_Restore
Clone example for a particular platorm, such as EXASOL:
git clone https://github.com/JohnAskew/IGAPA3,git
git clone https://github.com/JohnAskew/EXASOL.git
git clone https://github.com/JohnAskew/exasol-udf.git
(IoT / Edge Computing + Innovation Projects):
📌 Overview
These repositories are for code and presentations of working IoT Proof of Concepts:

🚀 Getting Started

Clone the repos:
git clone https://github.com/JohnAskew/Heatmap.git           #IOT coding
git clone https://github.com/JohnAskew/EDGE_compute_POC.git  #PowerPoint of running Hadoop on an ARM computer.

Pinned Loading

  1. EXASOL EXASOL Public

    1

  2. Heatmap Heatmap Public

    Python solution to process IOT sensors and weather data

    HTML

  3. Samples_Bkup_Restore Samples_Bkup_Restore Public

    Showcase samples of DR, Backup and Restore automation

    Shell

  4. DeviantArt-Python DeviantArt-Python Public template

    Code to replicate art posted on DeviantArt

    Python 2

  5. EDGE_compute_POC EDGE_compute_POC Public

    Repository for past R&D POC presentations proving Edge computer can share the heavy lifting

  6. DB2_examples DB2_examples Public

    Samples of DB2/UDB automation code

    Shell