James Hoftiezer

North Charleston,SC

Summary

Data Engineer specializing in Database Administrator & Architecture, building enterprise data sets, performance databases and resilient data architectures that deliver performance and valuable end user ready data to customers. Known for distilling requirements and building concepts into engineered data systems

Overview

years of professional experience

Work History

Senior Database Administrator

Booz Allen Hamilton

01.2019 - Current

Provide Production level support for a shared services model consisting of 200+ applications and 90+ databases.
SME for Oracle, PostgreSQL, SQL Server, MySql, DocumentDB, Elasticache, Redis, Aurora, GoldenGate
Provision AWS instance using AWS Console and Terraform
Resolved multiple production outages including AWS/Oracle bug rendering patched servers in unusable state, Oracle bug dropping dictionaries during restore, Oracle bug stopping GoldenGate replication
Resolved multiple production performance issues; Refactored code reducing load by up to 99%, Indexing to reduce nested loops and eliminate table scans, Implementing table caching improving I/O by 40%, Working with application teams to reduce load by 75%
Reduced program expenses Proof of concept for replacement of MongoDB using DocumentDB, Proof of concept for replacement of Oracle GoldenGate by AWS DMS, Downsizing of production servers to match loads, Addressing top SQL on production servers reducing loads by up to 70% preventing the need for hardware upgrades, Utilize AWS Backup to remove redundancies in backup plans eliminating 43% of storage expenses
A global firm of approximately 29,200 diverse, passionate, and exceptional people driven to excel, do right, and realize positive change in everything we do. We bring bold thinking and a desire to be the best in our work in consulting, analytics, digital solutions, engineering, and cyber, and with industries ranging from defense to health to energy to international development.
Senior Database Administrator, 2024 – Current
Senior Database Administrator, 2022 – 2024
Senior Data Engineer & Architect, 2021 – 2022
Senior Database Administrator, 2019 – 2021

Enterprise Data Architect

Advance America

01.2013 - 01.2019

Responsible for all data architectures across the enterprise including point-of-sale OLTP, data warehouses and BI Analytics. Reporting to VP IT Operations, CIO
Crafted and implemented an Enterprise Master Data Architecture for corporate data delivering data from 17+ point of sale systems, systematically giving lineage and defining quality for decades of corporate data
Starting at ingestion (Data Silos / Data Lake), all raw data is retained providing an enterprise archive that can be reconciled or recompiled on demand
Data is pushed through a single integration point, conforming it to enterprise standard records (customer, product, financial transaction) regardless of source system
Added time dimensions (Hybrid Type 5 SCD) to create consolidated and derived tables for the data warehouse
Designed final presentation to end users through virtual data marts (Informatica Data Services) allowing for simplified access with perpetual data elements and fast prototyping of new data sets
Built system in Oracle 11g, upgraded to 12g and migrated to all oracle($12M/yr) to EnterpriseDB PostgreSQL($2M/yr) in one year.
Presented Enterprise Master Data Architecture for review by PwC and McKinsey who approved the architecture with no significant changes
Conceptualized and provisioned CORE database for the enterprise in 60 days, providing a single point-of-truth for all future point-of-sales and online services
Created a 360 or OMNI view of the Enterprise customer to consolidate customers across dozens of data sources
Oversee the development of enterprise data governance, assigning ownership, documenting lineage and assigning value
Developed and implemented concepts and methods for data valuation, creating % and metals (Silver, Gold) concepts assigning value based on origin(data entry, purchased), certification(Trusted Source), validations(Multi-source) and enhancements (services)
Trusted with architecting the back-office integration of a new point-of-sale with 7000+ objects, providing simplified and consolidated views for reporting
Drove project to reduce or eliminate Oracle software licenses in the enterprise environment, with a potential savings of $10MM per year
Evaluated Big Data and Big Data tools (Mongo and Hadoop) resulting in a hybrid model storing structured and unstructured data in EnterpriseDB PostgreSQL
Managed deliverables using AGILE development methods and participated in scrum teams with EDW/ETL team. Implemented AGILE database model versioning across multiple scrum teams
Market leader in consumer financial services providing personalized financial solutions through ~2,500 locations nationwide and online lending services.
Manager of Data Services, 2006 – 2013
Senior Database Administrator, 2000 – 2006

Senior Database Consultant

Datastream Systems, Inc.

01.1997 - 01.2000

Responsible for project management and implementation, customer consulting, product integration, database programming and the data mapping of custom database conversions
Managed catalog content for multiple proprietary databases servicing an internet portal using SQL Server 7.0 and Oracle 8i backends. Maintained data warehouse representing 1.2MM catalog items with vendors such as Grainger
Served as DBA for up to 30 Microsoft SQL databases, including SQL 7.0 administration and implementation, content management, content loading, database design and creation
Coded programs in Microsoft TransAct SQL and Oracle PL/SQL
Traveled to over 160 customer sites, providing an onsite resource for consulting, education, integration or data conversion and ensuring customer satisfaction through direct engagement
Developed conversion implementation into a profitable format for database analysis; billed $1.2MM in 2.5 years
Provides asset management software, integrated procurement and supporting services to organizations and facilities worldwide, including over 60% of the Fortune 500.
Senior Database Administrator, 2000 – 2006

Education

Bachelor of Science - Electrical Engineering

Clemson University

Clemson, SC

Skills

Proven experience in:
Amazon Web Services (AWS)(Cloud); EC2 & RDS provisioning, AWS Console monitoring and database highlights; AWS Backup; Amazon Data Migration Services (DMS); Snapshots and cloning; AWS CLI, Aurora, DocumentDB, Elasticache, Redis
Oracle 8-12, 19c, 24ai, Oracle Enterprise Management; Oracle Real Applications Cluster; Oracle GoldenGate; RMAN, DataGuard (Physical and Logical standby); Active Data Guard; PLSQL
Microsoft SQL Server 15-16; TSQL
PostgreSQL 13,15,17; EnterpriseDB (PostgreSQL) 9,10
PL/SQL development, query refactoring and performance tuning
Quest software family (Quest Central, Spotlight, TOAD, TOAD Edge, Data Modeler);
Informatica PowerCenter, PowerExchange, Virtual Data Service, Business Glossary, Data Dictionary
Embarcadero software family (DBArtisan, Rapid SQL, E/R Studio); Tableau, Erwin, Pentaho Talon, Bitbucket, GitHub, Terraform, LINUX, BASH, Python, Dynatrace, Mongo

Demonstrated abilities in:
Database administration: design, installation, management, movement, upgrade, security
Architecture: conceptual, logical and physical modeling
Enterprise Data: standard records, data warehouse, big data, governance, master data
Systems administration: multiple servers, multiple sites, replication, disaster recovery
Content management: design, quality, consulting, loading, administrating, multi-buyer and multi-vendor
Managing projects: specifications, design, contracting, purchasing, implementation
Departmental management: budgeting, employee review, hire, fire, retention

Accomplishments

Accomplishments here

Software

Oracle

Timeline