Brian Engelhardt Email & Phone Number

Erie, Co, Us

Erie, Co, Us

Louisville, Colorado, Us

Senior Oracle DBA Primarily Oracle 12c and 19c, on-prem and Oracle Cloud• Continuously improved the most complex recurring processes w/automation.• Migration into Oracle’s cloud with Data Guard using different AD zones per node• Migrate databases from customer on prem to Oracle Cloud Infrastructure OCI• Managed both the Oracle DBA And MS-SQL DBA teams for 5 years• Ultra-fast backup for Very large DB Incremental-forever RMAN backup/restore • Provide production support for 11g, 12c and 19c Linux and Windows databases• Provide support for over 50 customers and over 200 databases• Installation, upgrades, patches and migrations to new hardware • Quarterly patching of 19c database and JVM remotely under time constraint• Datapump migration with transportable tablespace feature and refreshes• Query tuning using AWR, ADDM, SQLT, TKPROF, PROFILES, SQL plan baselines.• Flashback Database & Flashback Query, Flashback standby to open for mocks• Refresh development and UAT using Data Pump, RMAN or SQL scripts• SQL Server 2012 Always On availability groups, query tuning• PostgreSQL point in time recovery, backup, query tuning, import, export• Automated the capture of blocking trees to a unique filename every minute• Automated complex time-locked full data refreshes with ETL transformations• Developed a variance report tool comparing OCI bucket bytes to RMAN bytes• Developed custom monitoring/alerting tools with heartbeat emails every day• Developed SQL scripts menu’s for efficiency as part of shell scripts w/menu’s • Developed a Datapump optimization to reduce JDE imports time by 50%• Developed Dataguard monitoring plus scripts for quick analysis when responding• Tracing application and database problems w/Oradebug and us of login triggers • Test RMAN backups and code improvements into automation for those backups• 24x7x365 on call support

Primary and only DBA for 2 years. Formerly the team had 3 Full-Time DBAs on staff.Production upgrade of 10.2 10TB DB to 11.2 using Transportable Tablespaces with minimum downtimeTuned SQL shrinking production CPU load 300% opening up processing room to scale with additional customers within the existing hardware/software cluster.Recovered 4 TB of production data in minutes by 'Switch Datafile To Copy' leveraging the already restored and partially recovered Datafile Images in the 'new-school' INCR-MERGE incrementally updating backups located in the FRA.2 years of continuous 24x7 pager support as the only DBA resource resolving all problems including 26 SEV-1's with Oracle Global Support Implemented Fast Refresh to all lower environments without duplicating the 10 TB footprint beginning with a simulation of failed ONLINE Production Diskgroup seeding the refresh from RMAN near-online backups exclusively ( no returning to source DB ).Designed DR Site build-out leveraging DataGuard and implementing & testing the Switchover.Production migration to new hardware RAC servers with 300GB SGA's and Compellent SAN storage.Utilized Flashback Database to rewind the database, open read-only, export tables, apply recovery forward and OPEN the database.Grid Control Performance monitoring pages detailing live queries actual vs estimated rows involved, using Profiles to associate better execution plans with problem SQL. TKPROF, SQL-T.Ensured maximum uptime and performance for our customers accessing sales reports from our production database.Evaluated SQL Plan MGMT for maximum plan stability to prevent sudden performance regressions to critical SQL from optimizer plan switches.

Longmont, Colorado, Us

Built out new DataGuard servers to ensure Business Continuity.

Nashville, Tn, Us

Performed overnight upgrades to hospital Oracle version, McKesson custom software version and new hardware ( RAC Clusters )

Westminster, Colorado, Us

Production DBA staff member performing all manner of DBA tasks from pager support to working tickets, handled all changes to datamodel for custom software release 4.0 and 4.1. Deployments of those releases went smoothly.

Lone DBA conducting installs, tuning and large Data Warehouse loading partitioning and transformations.

2.5 years of PL/SQL development on the inbound receiving side of physical warehouses of office supplies. Shell scripting and JAVA.