Database Analyst - SQL, Python, AWS, MFA, SSO Expert

Gordon Relph

Full Stack Developer

VANCOUVER, BC

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

778-***-****

LinkedIn GitHub

ABOUT ME

Growing up as a twin on a farm taught me three things: the importance of teamwork, the value of hard work, and the power of automation to increase efficiency. I have a passion for problem-solving and streamlining processes. My enthusiasm has driven me to build networks, websites, games, scripts, and databases, combining creativity with technical expertise to deliver effective solutions.

EDUCATION

Bachelor of Technology: Technology Management (Distinction) Sep 2015 Jan 2020

Thompson Rivers University, Kamloops, BC

Computer Science / Project Management Degree

Programming (C++, Python, JavaScript, PowerShell), relational database technologies (MySQL)

Project Management: Agile, productivity focus, full Gantt charts and reports

Network Security, Firewalls, Kubernetes, System Administration, and virtual server management

Network & Telecommunications Engineering Technology Diploma

Okanagan College, Kelowna, BC

Network Administration (Cisco), VOIP / Telephony, installation of structured cable management

System Administration (Windows Server, Linux), focused on remote security, routing protocols

Active Directory, IIS, and Firewalls, GPO, VMWare Virtualization, High Availability systems

Creating reporting documents and project management charts, and Visio diagrams

Programming in Java, Python and PowerShell. Databased in MySQL on VMWare virtualization

I also worked at the college (while attending) in their computer labs helping others

Junior Data Analyst Program May Sep 2022

NPower Canada, Vancouver, B.C

Accountability leader for the NPower program & Participant Peer Leader (Agile)

Utilize Pandas, Numpy, and Excel spreadsheets to data wrangling and data mining

Composed queries to access data in cloud databases using SQL and Python from Jupyter notebooks, VS Code, and PyCharm

Cloud computing, core Azure architecture components and Azure AI services

Visualized data using Python libraries including Matplotlib, Seaborn, Plotly and Dash

CERTIFICATIONS

ComIT MERN Full Stack Certificate Dec 2025

IBM Data Analyst Professional Certificate May Sep 2022 Microsoft Azure Fundamentals Professional Certificate Jul 2022

EXPERIENCE

Database Administrator / System Analyst Jul 2022 Jul 2024

Exact Pay, Vancouver, British Columbia

Monitored/repaired transaction errors on SQL databases, ensuring an 99.9% uptime

Developed and maintained time-sensitive automation scripts for transaction processes, reducing manual intervention by 40% and improving processing time by 30%

Analyzed system inefficiencies and scripted automated solutions using PowerShell, Python, and JavaScript, Node.JS, React.

Managed multi-platform environments (Mac, Linux, Windows Server) via VPN remote login, ensuring seamless operations for 100+ users across multiple time zones

Designed and optimized SQL and T-SQL database views, improving query performance by 25% and enabling faster data retrieval for 5+ departments.

Provided 24/7 on-call support and optimized team schedules, increasing operational efficiency and reducing downtime by 15%.

Automated critical tasks using Crontab, Task Scheduler, and Python/PowerShell scripts, decreasing manual workload by 50% and preventing operational delays

Private leased lines for security. Task Scheduler for scripts execution

EXPERIENCE (CONT.)

Online Analyst Nov 2021 Jul 2022 Telus International, Vancouver, British Columbia

Verified/processed data requests for 3 major search engines, ensuring data accuracy and improving search results relevance by 15%

Mapped and processed 6 client requests into machine learning databases, improving data quality for training models, which increased system accuracy by 10%

Automated data input processes from external sources using Python scripts, reducing manual entry errors by 25% and increasing processing speed by 40%

Networking & Cloud Management Analyst Feb 2018 Jan 2019 Okara: Compliance Solutions, Vancouver, British Columbia

Troubleshot MATLAB and Python scripts for micro-particle inspection

Researching technology for new aerial products involving obtaining and transmitting information from remote probes and cameras to be used for real time diagnostics

Managed SQL databases to store positive matches, increasing system reliability by 10%

Oversaw facility security and assisted contractors in setting up IT environments, ensuring compliance with safety protocols and operational efficiency

Designing the air gapped network, and designing a 20-user office, subnets, VLAN, and Radius

Setting up and administrating Windows Server Active Directory, Office 365, and IIS for logins

Configuring and deploying repeaters, and implementing EIGRP and spanning tree protocols

Programming

JavaScript

TypeScript

HTML

CSS

Node.JS

React

Vite

Express

Python

C#

PowerShell

Database Types

SQL

- MongoDB

- MySQL

- NoSQL

- RDBMS

- SQLite

IBM Cognos

Juniper

Power BI

Data Types

XML

JSON

Applications:

Office 365

Excel

VBA

PowerPoint

Visio

Operating Systems

Windows Server 2022

Windows Server 2016

Windows 11

Windows 10

Windows 7

Red Hat Linux

Ubuntu Linux

Office 365

AWS

Azure Certified

Contact this candidate