About
Projects
Resume

Hi, my name is

Julio Gonzalez Garcia

I build reliable web applications, automation tools, and data-driven systems with a focus on clarity, maintainability, and practical impact.

My background includes full-stack development, SQL Server and Oracle environments, system analysis, and workflow automation across business-critical applications.

About Me

Full-Stack Systems & Data Engineer

Hello! I have 3 dogs, Miklo , Capitan , and Polo . 3 very adorable dogs (I work to feed them) . Hover over their names to get a slide-show of them! After graduating Cal-Poly, I wanted to contribute to my community so I got a job with my old high school district. I enjoy making tools that staff can use.

I build reliable systems, web applications, and automation tools with a focus on maintainability and practical impact.

My background includes full-stack development, system analysis, SQL Server and Oracle environments, backend services, and workflow automation across business-critical applications.

I enjoy working in C#, .NET, Python, SQL, and modern web frameworks like Blazor, React, and Next.js. I like building software that is clean, useful, and easy to evolve over time.

Core Skills

C#, .NET, Blazor, Python, SQL, SQL Server, Oracle, TypeScript, React, Next.js, PowerShell, Bash, Docker, IIS

hey!.shhhhhh-keepthissecret

Core Skills

Tools and technologies I use regularly

C#.NETBlazorPythonSQLPowerShellBashTypeScriptReactNext.jsNode.jsSQL ServerOracleSQLiteDockerIISC#.NETBlazorPythonSQLPowerShellBashTypeScriptReactNext.jsNode.jsSQL ServerOracleSQLiteDockerIIS

Dec 2023 – Present

County of Santa Barbara

EDP Systems and Programming Analyst II. Focused on full-stack application development, database administration, management, engineering, automation, and systems integration.

Sep 2021 – Dec 2023

Santa Maria Joint Union High School

Student Information Systems Analyst. Supported and maintained large-scale SIS environments, worked on data integration, reporting, troubleshooting, and process improvements.

Jun 2021

California Polytechnic State University

Earned a Bachelor of Science in Computer Science with coursework in software engineering, databases, algorithms, and technical writing.

Projects

A few projects that reflect the kind of work I enjoy building.

Workload Equalizer

Next.js / WebSockets / SQL Server

Completed

Designed and developed an internal workload equalizer application that enables staff to assign incoming applications more efficiently by identifying the next worker in rotation, ensuring balanced workload distribution across the team

WebSocketsRealtimeInternal Tool

Real-Time System Status Dashboard

Next.js / SSE / SQL Server

Active

A live monitoring dashboard that pushes status updates to connected clients without refreshes.

RealtimeMonitoringInternal ToolAutomation

Full-Stack ID Card Creation System

Python / CustomTkinter / SQLite / REST API

Completed

A standalone desktop app with drag-and-drop layout tools, barcode generation, and template syncing.

Desktop AppAPISQLitePackaging

Resume

Julio Gonzalez Garcia

Full-Stack Systems Developer & DBA

Specializing in Full-Stack Development, Real-Time Systems, and Scalable Data Architectures

(805) 554-2773

[email protected]

View PDF Download PDF

Key Impact

Optimized SQL performance by 95%; engineered real-time WebSockets/SSE streaming; developed Python/PowerShell-based automation for large-scale system monitoring and deployment.

Professional Experience

EDP Systems and Programming Analyst II

County of Santa Barbara | Santa Barbara, CA

Dec 2023 – Present

Full-Stack Development: Architecting a modern web application using Next.js, implementing scalable frontend components, middleware, and a robust backend connected to SQL Server.
Real-Time Systems: Engineered real-time user interaction features using WebSockets to enable concurrent, live updates across different application pages.
Security & Authentication: Implemented secure session management using iron-session, integrating complex authentication flows between IIS (NTLM) and the web application.
Database Engineering & Optimization: Designed a high-performance SQL backend search for millions of archived documents, reducing query response time to under 2 seconds.
Developed automated SQL scripts for index fragmentation monitoring and automatic rebuilds, reducing weekly performance incidents by approximately 30%.
DevOps & Automation: Built automated batch and PowerShell scripts to push SQL object changes (Stored Procedures, Views, Tables) to GitHub, enabling version control and reducing disaster recovery time from hours to under 10 minutes.

Student Information Systems Analyst

Santa Maria Joint Union High School | Santa Maria, CA

Sep 2021 – Dec 2023

Managed and maintained large-scale Student Information Systems (SIS), ensuring data integrity through regular database maintenance and performance tuning.
Collaborated with administration to plan and implement system upgrades and architecture changes.

Technical Skills

Languages

Python, TypeScript, C#, SQL (T-SQL), PowerShell, Bash

Web & Real-Time

Next.js, React, WebSockets, Server-Sent Events (SSE), Node.js, iron-session, HTML5

Databases & Infrastructure

SQL Server (SSMS, Agent, ETL), Oracle, SQLite, IIS, Docker (Containerization), GitHub, Git, Windows/Linux

Testing & QA

Vitest (Unit Testing), Mocha, Selenium (E2E Testing)

DevOps & Tools

CI/CD (Git-based deployment), System Monitoring, API Integration, PyInstaller, Inno Setup

Education

Bachelor of Science (B.S.) in Computer Science

California Polytechnic State University | San Luis Obispo, CA

Jun 2021

Relevant Coursework: Software Engineering, Design & Analysis of Algorithms, Database Systems, Technical Writing