Jonathan Marshall
Washington,District Of Columbia
Overview
24
24
years of professional experience
Work History
Cloud Architect
CoquinaSystems, (Self-Employed)
10.2023 - Current
- Setup HA VPN Tunnels between AWS and GCP
- GAMADV-XTD setup and configuration for Google Workspace Administration
- Provided best practices and configurations for Google Workspace core applications
- Capture various processes and create BPMN models using Visio and SmartDraw
- Configured Google Workspace for Google Workspace Migration for Microsoft Exchange GWMME
- Provided support and guidance for Microsoft 365 to Google Workspace migration in hybrid environment.
Enterprise Architect
TechnaLink, (Self-Employed)
07.2023 - Current
- Captured and categorized Federal Railroad logical, physical, and technology FISMA compliant system components using TOGAF best practices
- Created SharePoint lists to represent data, application, and technology components for FISMA complaint systems for the FRA
- Architected BPMN diagrams for system process flows using Visio and SmartDraw
- Collaborated with Chief Data Officer (CDO) to establish and implement data management policies and procedures for the Federal Railroad Administration (FRA)
- Initiated creation of FRA Data Management Sharepoint site for collaboration and retention
- Contributed to creation of Azure AD identity management for the Business Intelligence Service (PAAS)
- Designed SharePoint lookups for RNS Railroad Security, ATIP, MERMEC, ENSCO, FRA HOSTS, and FRA DYNAMICS.
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
09.2022 - Current
- Configure key based authentication for SSH
- Set enforcing and permissive modes for SELinux
- List and identify SELinux file and process context
- Restore default file contexts
- Use boolean settings to modify system SELinux settings
- Diagnose and address routine SELinux policy violations
- Diagnose and manage Linux processes
- Analyze and troubleshoot using linux system log files
- List, create, delete, and modify physical storage partitions
- Manage and configure LVM storage
- Create and configure encrypted storage
- Configure systems to mount file systems at or during boot / on demand
- Configure and manage swap space
- Create and manage RAID devices
- Create, manage, and diagnose advanced file system permissions
- Set up user and group disk quotas for filesystems
- Create and configure file systems
- Configure networking and hostname resolution statically or dynamically
- Configure network services to start automatically at boot
- Implement packet filtering
- Manage user privileges, configure PAM
- Deploy, manage, and develop containers using Podman.
Kubernetes Platform Engineer
Delta Dental, (Self-Employed) Remote
04.2022 - 09.2022
- Supported day-to-day KTLO on-prem Kubernetes clusters
- Upgrade of Kubernetes cluster version using helm charts and bash scripts
- Upgrade of ArgoCD cluster using helm charts
- Created proof of concept for the usage of OpaGateKeeper for policy governance
- Usage of DynaTrace and ElasticSearch in the monitoring of Kubernetes Clusters observability
- The capture of current baseline architecture and proposal of best practice future state architecture.
Google Cloud Architect
Lumen Technologies, (Self-Employed) Remote
01.2022 - 07.2022
- Delivered GKE Cluster Usage Metering resource consumption using BigQuery and Data Studio
- Generated reporting dashboard in Data Studio for data visualization into multi-tenant cluster costs (FinOps)
- Built architectural diagrams using Lucidchart to reflect created or proposed processes
- Implemented data-driven Terraform integration to provision GCP project creation by integrating with ServiceNow extract csv report.
Google Cloud Architect
Vitu, (Self-Employed) Remote
11.2022 - 03.2022
- Setup POC for Google Cloud Platform centralized logging within the test environment along with architectural diagrams using Jira / Confluence / LucidChart / Gliffy
- Spearheaded GCP Anthos Istio Service mesh rollout platform
- Setup POC for Google Cloud Platform (FinOps) automated billing for projects, GKE (Kubernetes), and DataStudio visualization with technical documentation using Jira / Confluence
- Monitored Observability by the usage of kube-state-metrics capture and native GCP tools
- Architected centralized Single Pane of Glass GCP cloud logging POC and implementation
- Created Terraform scripts for the orchestration of infrastructure within the GCP platform.
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
02.2021 - 01.2022
- Building and modifying container images
- Creation and usage of Jobs and CronJobs
- Multi-container Pod design patterns (e.g
- Sidecar, init, etc)
- Deployments strategies
- Helm package manager deploy strategies
- Configure systems to mount file systems at or during boot / on demand
- Configure and manage swap space
- Create and manage RAID devices
- Create, manage, and diagnose advanced file system permissions
- Set up user and group disk quotas for filesystems
- Create and configure file systems
- Configure networking and hostname resolution statically or dynamically
- Configure network services to start automatically at boot
- Implement packet filtering
- Manage user privileges
- Configure PAM
- Application observability and maintenance
- Services and Networking
- Provisioned EC2 instances using Terraform CLI | Terraform Cloud
- Used modules from the Terraform Public Registry to define an Amazon VPC containing two EC2 instances
- Imported non-managed infrastructure into Terraform state and configurations to manage Terraform infrastructure in the AWS environment
- Obtained overall knowledge of Terraform workflow regarding workspaces, input/out, variables, state, local/remote backends, and cloud methodologies
- Deployed Kubernetes Cluster using kubeadm
- Understanding and hands-on experience with K8s configuring, troubleshooting, scheduling, upgrading, scaling, storage, services, networking, installation, pod design, services, configuration, and architecture
- Management of K8s RBAC and highly available K8 cluster
- Practiced Kubernetes hardening security best practices based on NSA guidelines
- Installed and configured Prometheus server and Grafana for metrics and visualization
- Implemented life-cycle management for google cloud storage classes
- Implemented Encryption Keys using Google Cloud KMS
- Created Load-Balanced Managed Instance Group on the Google Cloud Platform
- Constructed streaming data pipeline on GCP using Pub/Sub, DataFlow, and BigQuery
- Setup billing account and billing export using BigQuery on GCP
- Created and established ACL permissions on GCP buckets using GCS CLI gsutil commands
- Created custom images on Google Cloud Compute Engine GCE
- Created permissions and granted IAM roles to service accounts for provisioned instances using best practices
- Configured firewall rules on Google Cloud VPC Network
- Obtained CKA | CKAD | CKS.
Talend Big Data Developer
Travelers, Remote
08.2020 - 02.2021
- Created automated processing end to end API calls Post/Get using Talend 7.3 components in AWS environment
- Formulated DDLs for Athena table creation
- Merge and cleanse data to and from S3 buckets to create output delimited files for Athena tables
- Coordinated with offshore resources
- Defined and tracked work using Rally in an Agile environment.
Talend Big Data Consultant
Deloitte, Remote
11.2020 - 01.2021
- Assessed and advised C-level executives of possible roadblocks and risks
- Triage data discrepancies within Azure/Hadoop pipelines using HUE, Azure Data Factory, Talend 7.3, SQL
- Administered Talend Data Fabric using TAC on Linux
- Architect roadmap in the refactoring of Talend code using best practices in Visio
- Operationalize and automate the capture of metrics using Talend, SQL
- Created technical documentation using SnagIt and Office 365
- Orchestrated and collaborated with offshore resources to meet deliverables.
Talend Consultant
Otis Elevator, (Self-Employed) Remote
07.2020 - 10.2020
- Migrated ERP systems data from Informatica JDE, BAAN into the Talend data platform
- Architected, automated, and aggregated data pipelines for subledger reporting
- Performed reconciliation and data quality tasks using Talend Data, SQL Server 2017
- Triaged failures and performance issues using best Talend and SQL Server best practices.
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
01.2020 - 07.2020
- Designed and planned cloud solution architecture (cost optimization, application design, integration of external systems)
- Creation of migration plan (software licensing mapping, architectural diagrams
- Infrastructure orchestration, resource configuration, and patch management
- Plan and design (e.g
- Cloud key management, remote access, auditing, vpc service controls)
- Obtained Google Cloud Architect Certification (6/2020).
Talend Consultant
KPMG, Remote
07.2019 - 01.2020
- Erected, developed, and implemented end-to-end solutions to pull down Excel data files from Outlook 360 mailbox using Talend components
- Developed Talend jobs to parse multiple sheets of Excel data files into flat files, and subsequently publish data to Azure Blob Storage to be rendered by Databricks notebook
- Create DDLs (schema definitions) in Azure Databricks notebooks to enable data and business analysts to query data in an enterprise environment
- Processed 60+ raw Excel sheets with embedded tabs into the enterprise data lake environment 2 sprints (2 months) earlier than planned.
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
04.2019 - 06.2019
- Applied GCP organization policies to the resource hierarchy
- Managed access and security with the usage of IAM
- Enabled relevant API within GCP projects
- Provisioning and set up of GCP Billing
- Planned and configured GCP resources (compute, storage, network, BigQuery, Cloud SQL)
- Cloud DNS configuration
- Deployed containerized GKE applications
- Configured GKE monitoring and logging
- Management of GKE resources (e.g
- Pods, node pools, services, horizontal and vertical auto scaling configurations
- Obtained Google Cloud Certified Associate (6/2019).
Google Cloud Engineer Manager
Maven Wave, Remote
10.2018 - 04.2019
- Designed an end-to-end solution leveraging SSIS, .NET, and Powershell to integrate and load Adobe Analytics API endpoints to capture impressions and conversion data into data warehouses using OAuth 2.0 integrating with Google App Engine
- Migrated and converted JSON data into CSV to load into SQL Server 2016 data warehouse
- Delivered digital demo and technical documentation using Camtasia screencasting software
- Translated and migrated SQL Netezza queries into Google BigQuery syntax for cloud data warehouse ingestion from Teradata
- Using BigQuery BQ CLI commands to create, load, and extract data into and from cloud storage | on-prem
- Created cloud storage buckets and assigned IAM privileges permissions based on GCP security best practices
- Utilized GSUTIL to move files data to and from Google Cloud Storage buckets
- Converted Bash scripts into Python for Apache Airflow ingestion
- Utilized Google Cloud Composer and Apache Airflow for Python job execution
- Constructed DAGs for Airflow job orchestration
- Deployed and monitored, managed, scalable VM and Kubernetes clusters.
Data Engineer
QAT Global / Mediware, Remote
10.2018 - 10.2018
- Supported day-to-day data warehouse operations using SSIS, SQL Server, and PowerShell
- Improved SQL Query performance by optimizing and refactoring queries and stored procedures
- Triage bugs in code and other systemic workflow errors
- Created technical documentation of the agile workflow of platforms and tools in Confluence
- Collaborated with other Data Engineers and Tableau Developers by leveraging agile methodology using SSIS, SQL Server, Git, Bash, JIRA, and Confluence in the workflow.
IT Specialist (SAS | TALEND | ETL)
Office of Financial Research, Washington, DC
06.2013 - 04.2018
- Installed and configured Talend Studio for Big Data Enterprise for accreditation in Linux and Windows environments
- Integrated Talend Studio for Big Data Enterprise with Hadoop Cloudera distribution
- Created and configured Talend job execution servers in Linux and Windows environments and configured them within the TAC
- Configured and developed job design patterns using Talend Data Quality while adhering to Talend and environmental best practices
- Migrated and translated SSIS jobs into SAS jobs using SAS Data Integration Studio
- Administered SAS Platform by creating and automating feeds using shell scripting
- Leveraged base SAS to formulate ad hoc reporting using SAS ODS
- Created ETL automation processes for large datasets using SAS Data Integration Studio, Base SAS, Bash Scripts, and SQL Server 2012
- Utilized data profiling components within SSIS 2012 to capture KPIs and other business metrics
- Architected a data-driven solution for SAS DI Studio and Talend by utilizing and standardizing metadata
- Led the implementation of the custom metadata audit database for SAS data feeds and reporting
- Developed and deployed a mobile reporting solution to organize the iPhone using Base SAS and HTML 5
- Researched and implemented Kerberos ticketing authentication and automation framework for Talend Data Integration execution servers in a Windows and Linux hybrid environment
- Integrated Talend with Splunk to capture events for IT security auditing
- Memorialized organizational training material by using SnagIt 12 screencasting features, DFD (data flow diagrams) using Visio, and ERWIN for entity relationships
- Set up Talend’s (AMC) activity monitoring console to monitor the health of the integration ecosystem and data flow metrics into Postgres' database
- Configured, tested, and implemented the Data Quality Portal and Data Stewardship console
- Architected dynamic data-driven data loads by using implicit context variables as integration points between various enterprise applications using Talend Studio for Big Data (XML, CSV, RDBMS sources into Hive databases)
- Used XMIND mind mapping software to present and brainstorm ideas with executive-level stakeholders.
Lead Data Engineer
Booz Allen Hamilton, Washington, DC
06.2012 - 06.2013
- Led ETL development supporting phase 1 stand-up at the Office of Financial Research data services using SSIS and SQL Server
- Analyzed, inspected, loaded, and restructured data sets from XML and CSV sources
- Audited load processes performed for ETL projects like DTCC, FINRA, OptionMetrics, Lipper, LEI, and Markit into a database
- Assisted in setting up the SAS Data Integration Studio for ingesting into SQL Server 2008 R2 database
- Planned, presented, and delivered decks using PowerPoint to publish to Confluence, Sharepoint, and Visio.
SQL Server DBA
BAE, Washington, DC
06.2011 - 06.2012
- Implemented high availability solutions using Database mirroring in SQL Server 2008R2
- Maintained, optimized, and tuned with 1+ terabytes of databases
- Architected database backups and restores using Microsoft's best practices
- Centralized ETL processes from Ad Hoc distributed processes using SSIS
- Created a metadata framework to capture data quality metrics.
Data Operations Engineer
Mirixa Corporation, Reston, VA
10.2008 - 06.2011
- Responsible for data conversion and migration routines using SQL Server utilities in various environments, including installation, and configuration
- Migrated and upgraded DTS packages from SQL Server 2000 to SSIS 2005 packages
- Automated data distribution in all production and non-production environments
- Performed backups of 300+ GB databases using SQL Red Gate
- Implemented security audit logging using SSIS and SSMS.
SQL Server Database Administrator
Navy Federal Credit Union, Vienna, VA
12.2007 - 10.2008
- Responsible for data conversion and migration routines using SQL Server utilities in various environments, including installation, configuration, and migration of data from legacy systems into SQL Server 2005
- Migrated data and set up disaster recovery using replication
- Implemented disaster recovery solutions for SQL Server 2000 and SQL Server 2005 transactional replication, log shipping, and third-party tools like Double Take.
Programmer Analyst
General Dynamics, Washington, DC
01.2000 - 01.2007
- Installed scheduling software on the client user base and created technical documentation manuals for proper usage
- Performed testing, debugging, and daily backup procedures for scheduling software databases in SQL Server 2000
- Delivered training to the (USCP) United States Capitol Police on software usage and best practices
- Implemented backup and system maintenance for SQL Server 2000 applications running on Windows NT/2000 platforms
- Created PowerPoint decks for the rollout of ad hoc scheduling software
- Orchestrated and scheduled self-correction SQL Server agent tasks
- Supported, scripted, and debugged the MH-53 flight simulator using C and FORTRAN in the UNIX environment
- Created UI pre-populated dropdowns to retrieve data from Access databases using ASP
- Revamped intranet applications for the Naval Air Warfare Center using ASP, IIS 5.0, and Access 2000 for the back end from Cold Fusion
- Created UI Dashboard using .NET 1.1 to mine Naval Air Warfare inventory data for end-users
- Designed and deployed data-driven web pages for the Department of Public Health and the Health Alert Network using CSS, ASP, HTML, and JavaScript
- Assisted in the development of local and state systems for rapid receipt and broadcast of urgent health alerts by proposing and implementing a user-friendly web UI
- Created templates and graphics using Paint Shop Pro v.6 for mouseovers and website navigation.
Education
Bachelor of Science - Management Information Systems
Western Connecticut State University
Danbury, CT01.2000
Timeline
Cloud Architect
CoquinaSystems, (Self-Employed)
10.2023 - Current
Enterprise Architect
TechnaLink, (Self-Employed)
07.2023 - Current
Google Cloud Architect
Vitu, (Self-Employed) Remote
11.2022 - 03.2022
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
09.2022 - Current
Kubernetes Platform Engineer
Delta Dental, (Self-Employed) Remote
04.2022 - 09.2022
Google Cloud Architect
Lumen Technologies, (Self-Employed) Remote
01.2022 - 07.2022
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
02.2021 - 01.2022
Talend Big Data Consultant
Deloitte, Remote
11.2020 - 01.2021
Talend Big Data Developer
Travelers, Remote
08.2020 - 02.2021
Talend Consultant
Otis Elevator, (Self-Employed) Remote
07.2020 - 10.2020
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
01.2020 - 07.2020
Talend Consultant
KPMG, Remote
07.2019 - 01.2020
IT Consulting Services
MarshallsMind Int’l LLC, (Self-Employed)
04.2019 - 06.2019
Google Cloud Engineer Manager
Maven Wave, Remote
10.2018 - 04.2019
Data Engineer
QAT Global / Mediware, Remote
10.2018 - 10.2018
IT Specialist (SAS | TALEND | ETL)
Office of Financial Research, Washington, DC
06.2013 - 04.2018
Lead Data Engineer
Booz Allen Hamilton, Washington, DC
06.2012 - 06.2013
SQL Server DBA
BAE, Washington, DC
06.2011 - 06.2012
Data Operations Engineer
Mirixa Corporation, Reston, VA
10.2008 - 06.2011
SQL Server Database Administrator
Navy Federal Credit Union, Vienna, VA
12.2007 - 10.2008
Programmer Analyst
General Dynamics, Washington, DC
01.2000 - 01.2007
Bachelor of Science - Management Information Systems
Western Connecticut State University