Resume
Experience
SQL SERVER DATABASE ADMINISTRATOR II
ACCRUENT, FORTIVE
DENTON, TX/REMOTE | 2019
Switched teams from Oracle and learned SQL Server to meet the company’s evolving and expanding needs.
Learned the Agile paradigm at the company’s direction and co-led a project to reorganize 30 individual contributors into several pods. Served for two years as Scrum Master, working closely with Product Manager to identify priorities and eliminate blockers for the team, before training others on the role and turning it into a duty rotation for pod members.
Planned, executed, and communicated to internal stakeholders a project to convert 1,100 single-byte schemas to double-byte via PowerShell and T-SQL scripts over several maintenance windows.
Overcame dynamic GraphQL performance tuning challenges by collaborating with Software Engineers about designing a covering index to eliminate plan choices in the optimizer.
Performance Tuning, Encryption at Rest, T-SQL, CMD, PowerShell, Python
​
​
​
SENIOR ORACLE DATABASE ADMINISTRATOR
ACCRUENT, FORTIVE
AUSTIN, TX | 2018
Promoted to Oracle DBA in 2016. Ensured the recoverability and standardization of important scripts and artifacts by creating a centralized Git repository for DBA teams.
Wrote a suite of scripts to standardize and automate a datacenter migration of 50+ VLDB’s and Oracle version upgrade of 25+ servers using Bash, expdp, impdp, and PL/SQL. Reduced the amount of required downtime from hours to seconds and eliminated operational risk by use of GoldenGate replication.
Eliminated human error by designing and programming a Text User Interface to automate database refreshes of lower environments. Eliminated human error and enhanced disaster recoverability by designing Bash scripts to automatically backup/restore the crontab.
OEL, AWS, Oracle 12c, OGG, Oracle Cloud Control, DR Testing
​
​
JUNIOR ORACLE DATABASE ADMINISTRATOR
ACCRUENT, VISTA EQUITY PARTNERS
AUSTIN, TX | 2013
Relieved pressure from Systems Administration team by learning to stop/start IIS, deploy web app code via Jenkins, and cut/restore NetApp snapshots. Restored lower environments from Production backups upon request. Reduced the number of false alarms by adding secondary logical checks to existing alerts prior to reporting to on-call. Created a robust new database monitor around a vital business process by writing PL/SQL, Bash, and collaborating with SysAdmin resources to automatically induce the appropriate server to stop/start the queueing service via JavaScript when detecting the targeted problem scenario.
Excelled in a fast-paced setting, effectively adapting to new technologies and environments. Successfully acquired proficiency in Oracle 11g on RHEL via self-directed learning and on-the-job experience.
RHEL, Oracle 11g, RMAN, CDC, PL/SQL, Streams, Bash, DataGuard
Skills and Disciplines
Scripting
Bash, PL/SQL, T-SQL, PowerShell, Python, JavaScript, Vim
Backups and Restores
RMAN, Disk Snapshot, expdp
Disaster Recovery
Strategy, Implementation, Testing, RPO, RTO, Desired-State Config
High-Availability
Oracle RAC, SQL Server HA Groups, VM clusters, Load-balancing
Replication
GoldenGate (OGG), DataGuard, Change Data Capture, Streams
Migrations
impdp, SQL*Loader, DB directories, csv, temp tables, cursors, cleanup
Data Warehousing
ETL, MicroStrategy Reporting
Code Deploys
Octopus, Jenkins, Deploy pools, Continuous Integration/Delivery, Regression testing, Feature toggles, Rolling deploys, Schema deploys
Methodologies
Agile Scrum, RACI, 5S, VOC, RPN, PSP, Secure Product Development, API
Security
Binary patching, SOC Audits, IAM, User/Profile/Group management, Key-based authentication, TLS, SSL, SSH, SFTP, HTTPS, Encryption at rest
Code Branching
SourceTree, BitBucket, Git
Administration
PDB, CDB, TNSnames, Listener, Binary Patching, Tomcat, IIS
Monitoring
Oracle Enterprise Manager (OEM), LogicMonitor, PagerDuty, Heartbeat
Scheduling
Cloud/Grid Control, crontab, Windows Task Scheduler
Operating Systems
Virtualization, Desired-State Config, Oracle Enterprise Linux (OEL), RedHat Enterprise Linux (RHEL), Ubuntu, CentOS, Windows Server
Cloud Computing
Amazon Web Services (AWS), Microsoft Azure, Oracle Cloud (OCI)
App Logging
Logz.io, Splunk, ElasticSearch
Troubleshooting
extended and sunset support, international character sets
Third-Party Tools
SolarWinds, SSMS, SSRS, Toad, SQL Developer, NotePad++, VS Code, Jira, Confluence, Salesforce
Third-Party Packages
Brent Ozar’s “First Responder Kit”
Ola Hallengran’s “Maintenance Solution” Erik Darling’s sp_HumanEvents and
sp_PressureDetector
Professional Development
IN PROCESS
1Z0-071 Oracle Database SQL Certified Associate
1Z0-083 Oracle Database Administration II
1Z0-149 Oracle Advanced PL/SQL Developer
DP-300 Administering Microsoft Azure SQL Instances
Education
KNOX COLLEGE 2004
B.A. Spanish
Galesburg, IL