Skip to content

Crafted Systems

Portfolio of projects – please get in touch if you have a requirement

  • Availability
  • Download CV
  • Skills
    • .NET
    • 6502 Assembly
    • Active Directory
    • Adobe ColdFusion
    • Agile
    • AI
    • Android
    • Angular
    • Apache
    • Apache Cordova
    • AWS Cloudwatch
    • AWS Lambda
    • Banking
    • BASIC
    • Bootstrap
    • C
    • C#
    • C++
    • COBOL
    • DCL
    • Excel
    • GIT
    • GitHub Actions
    • iPhone
    • JavaScript
    • JSON
    • Large Language Models
    • Linux
    • MS SQL
    • Mumps
    • MySQL
    • Next.js
    • OpenVMS
    • Oracle
    • Pascal
    • PhoneGap
    • PHP
    • PostgreSQL
    • Project
    • Python
    • Terraform
    • Terraform Cloud (TFC)
    • tfsec
    • Trivy
    • Uncategorized
    • VBA
    • Visual Basic
    • WooCommerce
    • WordPress
    • XML

Category: Terraform Cloud (TFC)

Terraform Security Scanner for MyTutor

I took over a project from a previous DevOps engineer who had recently left MyTutor. The project involves scanning Terraform files for vulnerabilities using the tfsec utility. Initially, the scan results were uploaded as an HTML file to Slack, which required downloading to identify vulnerabilities.

GitHub Actions, Python, Slack API, Terraform, Terraform Cloud (TFC), tfsec

MySQL Slow Query monitor at MyTutor

Some of the SQL queries in the MyTutor application were taking a very long time to run. We already had the MySQL slow query log logging them to AWS CloudWatch, but we found they were left unnoticed there.

AWS CloudWatch, GitHub Actions, Python, Terraform, Terraform Cloud (TFC)

The Lesson Space monitoring at MyTutor

MyTutor relies extensively on an external SaaS service to deliver their online lessons. This project aimed to implement robust monitoring to quickly detect any service downtime or performance degradation.

AWS CloudWatch, AWS Lambda, AWS S3, GitHub Actions, Python, Terraform, Terraform Cloud (TFC)

Tags

WSDLStored ProceduresAWS RDSLlama3ExcelAdobe ColdFusionSlack APIFacebook APIHTMLIBMActive DirectoryC#.NetKubernetesAngularJSBBC MicroJSONTradingClusteringDCLGIT FlowAWS S36502 AssemblyManufacturingOOPUnixcron jobsCDelphiDECNetCakePHPGNUPhoneGapOracleApachefreetdsVisual Basic for ApplicationsLinuxE-CommerceGitHub ActionsJiraPostgreSQLShadowsetsObject PascalX (Twitter) APIWeb ServicesJavaScriptTCP/IPLarge Language Models (LLM)RESTful APIBankingAndroidBACSVBATrivyCOBOLNext.jsVirtualBoxAWS CloudWatchNetfinityiPhoneWooCommerceFilesystemsTCP/IP TracingCSSbashGraphicsAgiletfsecReportingSaleforcePHPExcelGamesGITSQLxamppAWS LambdawamppWindows SDKMS SQLAnsibleSOAPApache CordovaVMSRaspberry PiDSMAWSOpenVMSJenkinsEcommerceOllamaTerraform Cloud (TFC)CommodoreSMS GatewayRAIDXMLPythonMySQLBootstrapApp DevelopmentTransact SQLMumpsPluginsPHPMyAdminLAMPWordPress PluginsMessagingWordPressPHPTerraformExpert SystemDelphi PascalOpen SourceBASICC++