Cloud Data Architect & Engineering

VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 1 of 9

PROFESSIONAL SUMMARY

Cloud Architect Cloud Engineer and Data Architect experienced in legacy database modernization, relational database design, performance engineering, and cloud data-platform transformation across on-premises and cloud environments. Build T-SQL procedures, performance-tuned queries, and automated ETL/ELT pipelines that ingest Excel and structured files from Azure and AWS storage into enterprise SQL platforms. Modernizes and migrates legacy databases to Azure SQL Database and AWS RDS through schema assessment, SQL refactoring, data migration, validation, and cutover planning while improving reliability, scalability, and operational efficiency. Integrate cloud-storage events, ETL orchestration, Python transformations, data-quality controls, and secure SQL data models supporting analytics, reporting, and mission-critical workloads. PROFESSIONAL HIGHLIGHTS

• Engineered secure, scalable cloud solutions across AWS and Azure, supporting enterprise databases, applications, and hybrid environments.

• Automated cloud infrastructure and data workflows with Python, PowerShell, AWS Lambda, Azure Data Factory, and CI/CD pipelines.

• Modernized legacy systems through cloud migration, architecture redesign, SQL refactoring, validation, and phased cutover planning.

• Built and operated cloud database platforms using Amazon RDS, Azure SQL, PostgreSQL, and SQL Server with a focus on availability, performance, and security.

• Implemented event-driven ingestion and ETL/ELT pipelines connecting Amazon S3, Azure Blob Storage, and enterprise relational databases.

• Improved cloud reliability and operational efficiency through monitoring, logging, performance tuning, data-quality controls, and repeatable deployments. CORE COMPETENCIES

• AWS and Azure cloud engineering.

• Cloud infrastructure, architecture and operations.

• Amazon RDS, Azure SQL, PostgreSQL, and SQL Server.

• Cloud migrations and hybrid modernization.

• Amazon S3 and Azure Blob Storage integration.

• Cloud ETL/ELT pipeline engineering.

• Python, PowerShell, Lambda, and ADF automation.

• Infrastructure as code and event-driven services.

• Cloud security, governance, and data protection.

• CI/CD, Git, monitoring, logging, and incident troubleshooting.

• Cross-functional cloud engineering collaboration. VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 2 of 9

TECHNICAL SKILLS

Databases & Data Platforms

• Engineered secure, scalable database platforms on Amazon RDS and Azure SQL, including compute, storage, connectivity, backup, and high-availability configurations.

• Provisioned and operated PostgreSQL and SQL Server cloud environments with performance monitoring, access controls, patching, and capacity management.

• Modernized legacy databases through cloud-readiness assessments, schema refactoring, migration planning, validation, and controlled cutovers.

• Built event-driven cloud data pipelines using Amazon S3, Azure Blob Storage, AWS Lambda, Azure Data Factory, Python, and SQL.

• Improved cloud platform reliability through centralized monitoring, logging, encryption, least-privilege access, auditing, backup, and recovery controls.

Programming & Scripting

• Developed cloud automation with Terraform, Python, PowerShell, and SQL for infrastructure provisioning, configuration, and operational workflows.

• Built reusable Terraform modules and deployment scripts for AWS and Azure compute, storage, networking, security, and database resources.

• Orchestrated event-driven cloud pipelines with AWS Lambda, Azure Data Factory, Amazon S3, Azure Blob Storage, Python, and SQL.

• Refactored legacy deployment scripts into version controlled Terraform and GITHUB CI/CD workflows for consistent, repeatable cloud releases.

• Automated cloud migrations, infrastructure validation, policy checks, database testing, and post- deployment verification across AWS and Azure.

Cloud Engineering Cloud DevOps

• Engineered scalable AWS and Azure infrastructure, improving reliability and resource efficiency.

• Standardized Terraform provisioning, accelerating consistent multi-environment deployments.

• Automated GitHub and Azure DevOps pipelines, reducing release effort and deployment risk.

• Embedded security and governance controls, strengthening compliance and cloud oversight.

• Enhanced observability, backup, and recovery, improving availability and incident response. VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 3 of 9

Cloud ETL/ELT Pipelines Data Integration and Movement

• Engineered cloud pipelines for reliable ingestion, transformation, and movement of structured data across AWS, Azure, and enterprise SQL platforms.

• Orchestrated batch and event-driven workflows using Amazon S3, Azure Blob Storage, AWS Lambda, Azure Data Factory, Python, and SQL.

• Automated pipeline deployments with Azure DevOps CI/CD, improving consistency across development, test, and production environments.

• Embedded schema validation, data-quality checks, audit logging, and error handling to protect data integrity throughout pipeline execution.

• Implemented monitoring, retries, and recovery controls to improve pipeline resilience, troubleshooting, and dependable downstream delivery. Tools & Frameworks

• Orchestrated cloud data workflows with Azure Data Factory, AWS Lambda, Step Functions, Airflow, SSIS, and JupyterLab.

• Managed source control and release workflows with Git, GitHub, Bitbucket, Azure DevOps, Jenkins, and GitHub Actions.

• Standardized repeatable deployments with Terraform, Docker, Ansible, CI/CD pipelines, automated testing, and rollback controls.

• Automated cloud validation, migration, and maintenance with Python, PowerShell, Bash, SQL, CloudWatch, and Azure Monitor.

• Enabled event-driven ingestion with Amazon S3, Azure Blob Storage, Lambda, ADF, Excel, CSV, JSON, and secure API integrations.

• Modernized relational platforms with SQL Server Management Studio, pgAdmin, SQL Developer, ER/Studio, Erwin, schema comparison, and reverse engineering. Operating Systems

• Supported AWS database development and SQL operations across Windows Server, Linux, and macOS.

• Automated database ingestion, validation, and migration on Windows and Linux with Python, PowerShell, and SQL.

• Operated AWS Lambda, SSIS, and ADF pipelines for reliable file-to-database loading.

• Maintained secure operating-system configurations supporting dependable AWS and on-premises database services.

• Monitored logs and resolved SQL pipeline, Amazon S3 trigger, and database performance issues on Windows and Linux.

VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 4 of 9

Azure AWS Database Operations

• Monitoring — Used Amazon CloudWatch, RDS Performance Insights, Azure Monitor, Log Analytics, and SQL diagnostics to track availability, resource utilization, failed jobs, connection errors, and database events.

• Performance — Tuned SQL queries, indexes, execution plans, CPU, memory, storage, I/O, connection pools, and database configurations across Amazon RDS, Azure SQL, SQL Server, and PostgreSQL.

• Troubleshooting and Recovery — Resolved connectivity, authentication, locking, blocking, deadlocks, ETL failures, and capacity issues while supporting backups, point-in-time recovery, failover, patching, and incident response.

PROFESSIONAL EXPERIENCE

McLane Advanced Technologies, LLC

Data Systems Architect /Database Developer/ Software Engineer Aug 2022 – Jun 2025

Modernized legacy SQL workloads on Amazon RDS.

• Accelerated ingestion with S3-to-RDS pipelines.

• Using Data Mesh architecture (Databricks- Data Mesh)

• Simplified systems through modular data architectures.

• Improved data integrity and auditability.

• Scaled services with reusable data components.

• Architecture experience in Data Mesh is utilizing decentralized data architecture (where each business domain owns its data and publishes it as a product.)

• Streamlined releases through automated CI/CD.

• Increased reliability through resilient system design.

• Standardized APIs, migrations, and operations.

• Reduced query latency through SQL tuning.

• Automated schema and data validation.

• Improved uptime with proactive monitoring.

COMNAVSURFPAC / SERCO-NA / Smart-Synergies

Solution Architect / Database Architect/developer Jul 2021 – Jul 2022

• Modernized mission-critical SQL databases for AWS-ready deployment.

• Reverse-engineered schemas and ETL workflows to define scalable data architectures.

• Engineered automated S3-to-RDS ingestion pipelines with Python and SQL.

• Strengthened data integrity through validation, auditing, and secure AWS controls.

• Architected phased migrations from legacy SQL systems to Amazon RDS.

• Partnered with engineering teams to deliver reliable database services and maintainable software.

• Integrated AWS services and applications, accelerating deployments.

• Architected resilient databases, improving up time and recovery. VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 5 of 9

• Warehouse managed by my central team, using Data Mesh distributes responsibility to domain teams

(Naval Logistics, ships expenses, etc.). Using self-serve data platform (storage, pipelines Governance, Etc.)

• Standardized architecture, improving consistency across environments. Perspecta / Catapult, Inc.

Solution Architect / Database Developer/ Software Engineer Dec 2019 – Mar 2020

• Engineered automated data capture and validation workflows for AWS-hosted SQL platforms.

• Modernized legacy SQL systems into scalable Amazon RDS architectures.

• Architected cloud-ready data models and phased AWS migration strategies.

• Built S3-to-RDS ingestion pipelines with Lambda, Python, and SQL.

• Strengthened data integrity through validation, auditing, and secure AWS controls.

• Delivered maintainable software and resilient database services for mission-critical workloads. KBRWyle / Strategic Data Systems

Sr. Software Data Architect /Database Developer Jan 2017 – Jun 2018

• Engineered SQL databases for mission-critical systems and AWS-ready deployment.

• Modernized legacy schemas into scalable, reliable relational architectures.

• Built secure SQL workflows, stored procedures, ETL pipelines, and validation controls.

• Partnered with engineering teams to deliver dependable database services.

• Architected data models and analytics solutions for MOCC and MCMS.

• Delivered SSRS automation and cloud-ready reporting architectures.

• Optimized SQL Server ETL, performance, and BI integration.

• Standardized database delivery through Git, CI/CD, and DevOps automation. Physical Rehabilitation Center (PRC)

Database Developer/ Architect / Software Architect & Network Consultant Apr 2014 – Dec 2015

• Architected AWS-ready SQL data models and secure ASP.NET MVC applications.

• Engineered reliable database services, data integrations, and secure application infrastructure.

• Optimized SQL queries and reporting workflows, improving data accuracy and decision support. Camber Corporation — Joint Support Division

Software Architect / Data Developer Jan 2014 – Mar 2014 VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 6 of 9

• Engineered Azure SQL databases for mission-critical defense systems.

• Architected secure Azure data workflows and resilient software components.

• Built stored procedures, ETL pipelines, and performance-tuned Azure SQL.

• Modernized legacy schemas into scalable Azure data models.

• partnered with engineers to deliver secure, reliable database services.

• Modeled SSDS MK2 data flows and Azure-ready integration architectures.

• Automated secure data integration with SSIS, Azure Data Factory, and SQL Server.

• Delivered MVC, Web API, and Azure database services for simulation accuracy. Hewlett Packard Enterprise (NAS Coronado)

Software Architect / Database Developer/ Engineer & SQL Developer Jul 2011 – Jan 2013

• Engineered AWS-ready SQL Server databases and secure ASP.NET services. Architected ETL, SSIS, SSRS, and BI pipelines for scalable data delivery.

• Modernized legacy applications into cloud-ready MVC architecture.

• Standardized software and database delivery through Git, CI/CD, and DevOps. Global System Technology (NAS Coronado)

Software Engineer / database Architect Jan 2011 – Jul 2011

• Engineered Oracle and PL/SQL replication workflows for AWS-ready data integration.

• Modernized VB6 applications into maintainable VB.NET and database services.

• Supported reliable database workloads across VMware, Hyper-V, and multi-OS environments.

• Designed scalable software architectures integrating applications, APIs, and AWS data services.

• Architected secure relational schemas, replication strategies, and cloud migration patterns. Northrop Grumman / Oaktree Software

Data Architect Database Developer Nov 2009 – May 2010

• Architected AWS-ready data platforms using TOGAF-aligned enterprise practices.

• Defined scalable relational models, integration patterns, and data governance standards.

• Engineered MILSTRIP/MILSTRAP pipelines and C4ISR data integrations.

• Developed SQL schemas, stored procedures, and high-integrity data workflows.

• Built ETL components for AWS-ready logistics and readiness data processing.

• Partnered with engineering teams to deliver secure, compliant database operations.

• Optimized SQL queries, indexes, and execution plans for reliable performance.

• Automated schema deployments and database validation through CI/CD.

• Implemented auditing, error handling, and data-quality controls.

• Supported AWS database migrations, monitoring, and production troubleshooting. L-3 Communications / D.P. Associates

Software Architecture Engineer /Database Developer Sep 2008 – Sep 2009

• Led a cross-functional team delivering data-transfer engines for MH-60 mission platforms. VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 7 of 9

• Built AES-256 data protection, securing mission-critical transfer workflows.

• Delivered SCORM training engines supporting enterprise courses and users.

• Implemented SharePoint systems, improving secure data access and collaboration.

• Architected high-integrity software, strengthening mission readiness and reliability. Cytori Therapeutics

Software Architect / Engineer/ Database developer Jun 2007 – Nov 2007

• Architected AWS-ready SQL data models for regulated stem-cell banking platforms.

• Engineered SQL Server schemas and SSIS/SSRS pipelines for biomedical data workflows.

• Built secure data-processing services integrating clinical, imaging, and laboratory systems.

• Designed validated reporting and data-transfer architectures aligned with FDA and HIPAA controls.

• Partnered with scientists and engineers to deliver reliable, compliant database operations. Additional Roles (2006–2007)

• Architected AWS (the year AWS started) - ready relational models and service-based data platforms for enterprise systems.

• Engineered secure database applications supporting distributed hospital networks.

• Developed SQL Server schemas and SSIS/SSRS pipelines for regulated data workflows.

• Built secure data-engineering services integrating clinical, imaging, and laboratory systems.

• Designed validated reporting, data-transfer, and audit architectures for compliant operations.

• Partnered with scientists and engineers to deliver reliable database platforms and data quality.

Orchestrated ETL pipelines for reliable batch and service-driven data exchange.

Developed WCF services for secure APIs, messaging, and distributed data integration.

Integrated service layers with ETL workflows to trigger and govern database processing. Early Career (2003–2006)

Database Developer and Software Engineer roles designing relational schemas, stored procedures, ETL pipelines, data integrations, query optimizations, validation controls, and CI/CD workflows for Navy, EMS/SEPO, and MILSTRIP systems.

Academic Roles (2001–2003)

Adjunct Instructor — Taught database development, relational data modeling, data architecture, ETL fundamentals, SQL/ADO data access, UML, and software engineering using ASP.NET, C#, VB, JavaScript, XML/XSLT, Perl, and VB6.

LANGUAGES

C, C#, Python, ASP.NET, VB.NET, HTML5, XML/XSLT, JavaScript, jQuery, PowerShell, Scala, VB6, VBA, and Perl. VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 8 of 9

TECHNICAL SKILLS — REGULATED ENVIRONMENTS (FDA, HIPAA, DoD) Database Development:

• Designed relational schemas, stored procedures, functions, and reliable SQL workflows.

• Built secure ETL pipelines with SSIS, WCF, and SQL.

• Improved performance through indexing, partitioning, and query-plan tuning.

• Added data validation, auditing, and error handling for critical systems. Data Platform Engineering: SQL Server, Oracle, T-SQL, PL/SQL, SSIS, SSRS, SSAS, data warehousing, Data Lake, Formal (storing massive volumes of raw data cheaply) Lakehouse platforms, ER/Studio, and Erwin.

• Designed data platforms for analytics, reporting, and operations.

• Integrated reporting, training, SharePoint, WCF, and MVC systems.

• Developed secure data-transfer and encryption solutions for regulated environments.

• Supported data integration across defense, biomedical, and aviation systems. Programming & Scripting Reports Coding

• Python (Jupyter and JupyterLab), C#, ASP.NET, VB.NET, HTML5, XML/XSLT, JavaScript, jQuery, PowerShell, VB6, VBA, Perl, and Scala. JSON CSV)

• Coding Language: DDL (Data Definition Language); DML (Data Manipulation Language); DCL (Data Control Language); TCL (Transaction Control Language) Includes Stored Procedures, Functions and Triggers.

Cloud DevOps / DevSecOps

• Cloud database tools: AWS RDS, Elastic Beanstalk, Azure DevOps, Docker, Jenkins, Ansible, GitHub, Bitbucket, Hyper-V, and VMware.

• Automated database deployments with Git, Jenkins, Azure DevOps, and infrastructure as code.

• Added security scans and approval gates to database CI/CD pipelines.

• Secured cloud databases with least privilege, secrets management, and compliance controls.

• Improved database releases with automated testing, monitoring, logging, and rollback.

• Migrated Microsoft Access backends to cloud databases.

• Migrated SQL Server workloads to Amazon RDS, RDS Custom, EC2, and Aurora. Tools & Frameworks

• Architected AWS database solutions with TOGAF, Jira, Rational Rose, UiPath, IIS, and SharePoint, improving integration and delivery consistency.

VINCENT R. CABRERA

San Diego, CA • 619-***-****

*************@*****.*** • LinkedIn: VRC

Page 9 of 9

• AWS Database Development: Amazon RDS, Aurora, SQL Server Management Studio, pgAdmin, SQL Developer, ER/Studio, and Erwin.

• AWS Data Engineering: S3-to-RDS ETL, Lambda, Step Functions, SSIS, Airflow, and JupyterLab.

• AWS Database DevOps: RDS, S3, Lambda, Step Functions, CI/CD, Docker, Jenkins, Ansible, GitHub, and Bitbucket.

• AWS Application & Data Access: ASP.NET MVC, Web API, WCF, Entity Framework, and secure RDS integration.

• Operating Systems

• Windows client and Windows Server, PowerShell, Solaris, PowerShell (Ubuntu), Apache HTTP Server, PuTTY, and PuTTYgen.

• Administered Windows Server and PowerShell environments supporting SQL Server, PostgreSQL, and cloud database workloads.

• Automated system and database tasks with PowerShell, Bash, and Python.

• Configured services, permissions, networking, and secure remote access across Windows, Linux, and UNIX platforms.

• Monitored logs, performance, patching, and availability for reliable database and application operations.

Contact this candidate