Data Engineer Azure Sql
Resume:
Manassas
******@*****.***
PATRICK QUINN
P R O F E S S IO N A L S U M M A RY
Senior database engineer/analyst with over 20 years of expertise in data engineering, system design, and technical requirements gathering. Demonstrates a proven ability to enhance business processes and data integrity through scalable data architecture and enterprise analytics. Adept in utilizing advanced tools like PowerBI, Tableau, and SQL to deliver innovative data solutions and system enhancements.
E M P LOY M E N T H IS TO RY
MAY 2020 - PRESENT
Database Engineer, TEKSYSTEMS, Remote
Lead DB Engineer for MTMS, ensuring efficient munitions tracking for the US Army.
Collaborate with Visual Studio Team to design and develop source control for Oracle and Azure SQL DB. Reduced open Remedy tickets from 250+ to 12, enhancing system reliability.
Productionisation of AWS Aurora PostgreSQL as an alternative to SQL Server
Develop and deploy data ingestion pipelines using continuous integration/continuous development principles, git, and Agile practices.
Experienced on Azure SQL Server, Azure SQL Database, Azure SQL Data warehouse, Azure Logic Apps, Azure Storage, Azure Data Lake Storage, Azure Synapse Analytics, Event Grid, Event Hubs and Azure Stream Analytics, Az copy and Others.
Gained proficiency in Python, C#, and C++, overseeing MTMS development. Implemented detailed troubleshooting, reducing monthly Remedy tickets from 265 to 5.
MAY 2019 - NOV 2019
Database Reports Developer, MKS2, INC. - DEPARTMENT OF VETERANS AFFAIRS, Washington, DC Standardized ICAMP database reports with SQL SSRS, ensuring VA compliance and reporting accuracy. Managed VA ICAMP reports in Azure Cloud via TFS, reviewed stored procedures, and deployed new architecture. Developed and enforced database administration standards, enhancing security and efficiency.
Designed, developed, and maintained PostgreSQL database architecture. And Prepared and updated scripts for various administrative tasks.
Created comprehensive software inventory reports, identifying compliance gaps across all VA locations.
AUG 2018 - JAN 2019
Database Analyst Lead Database Developer Data Architect, NA-ALII CONSULTING, INC., Crystal City, VA
Managed development of a Data mart for Pentagon forensic scientists, ensuring accurate identification of WWII, Korean War, and Vietnam War human remains.
Investigated and mapped data from external sources to feed the Interim Data mart, including mission, incident, and bio profiles.
Worked on Migrating products from Physical Data Centers to AWS with zero down time.
Maintenance of PostgreSQL database binary replication on more than 20 server environments, each with specific needs
Integrated SharePoint applications with other systems, optimizing business processes and enhancing collaboration. Designed and optimized data and ETL pipelines, supporting big data ingestion and transformation ahead of schedule. Wrote SQL Tuning ingestion code, achieving 99.2% OLTP and OLAP efficiency through database modernization techniques.
AUG 2012 - JAN 2018
Systems Engineer QA Analyst, TURNING POINT GLOBAL SOLUTIONS, Rockville, MD
Provided high-level operations support for APS application, resolving complex issues and data challenges. Ensured consistent website functionality across browsers and OS, developing and modifying test cases. Identified and troubleshot issues using manual QA, writing test cases for features across multiple environments. Executed database queries and data analysis, gaining in-depth knowledge of APS database architecture.
Managed MySQL and Oracle databases on UNIX/LINUX, overseeing configurations and implementations.
NOV 2004 - JAN 2012
Database Admin DB Architect Security Manager, CARLSON WAGONLIT TRAVEL (CWT) TQ3 NAVIGANT SATO TRAVEL, Herndon VA
Managed MS SQL Server database administration, supporting 3 applications for customer satisfaction. Led Sybase to SQL Server conversion 5 weeks early, generating $480K in additional income.
Oversaw database login security and served as Patch Manager for HARP production rollout. Coordinated database optimizations for monthly releases, creating new stored procedures and APIs. Ensured 99.5% High Availability for TQ3Navigant's databases, improving from 85.3%.
E D U C AT IO N
Bachelor of Science (BS) in Computer Engineering / Computer Science, Valparaiso University, Valparaiso, IN
S K IL L S
Data Analytics Data Visualization
Statistical Analysis Big Data
ETL Processes Agile DevOps
L IN KS
A D D IT IO N A L IN F O R M AT IO N
CAREER HIGHLIGHTS
Reduced unaddressed enhancements and bug fixes over 2 years at TEKsystems by leveraging Visual Studio, NetBeans, and Quest Software.
Led MTMS database conversion from Oracle DB to Azure SQL Cloud for the US Army, saving 160 labor hours and $76K+ in 6 weeks at TEKsystems.
Created a SQL report identifying expiring IT hardware for 278+ USA VA locations, saving $7.5M at MKS2. Developed a Datamart with SQL Server 2012 for the DoD POW/MIA National Accounting Office, feeding data to "Documentum" under Na-Alii's contract.
Fixed 100+ bugs and conducted compliance testing, reducing project costs by 5% at Turning Point. Migrated APS databases to Medicare/Medicaid, securing a $5.5M contract for Turning Point.
Developed 500+ stored procedures and advanced SQL queries, supporting 35+ database rollouts/migrations for large-scale data warehouses (100 GB+).
Contact this candidate