PORTFOLIO

Work History

IT Consulting

WordPress, MySQL, Apache, PHP, Amazon Web Services            April 2020 – September 2021

·    Implemented AWS VPN (Virtual Private Network)
to host servers

·    Migrated WordPress installs into an AWS
environment

·    Setup Amazon MySQL/MariaDB/Aurora DB

·    Setup Amazon EC2 instances to host WordPress

·    Setup Amazon EFS for shared filesystem

·    Setup Amazon Elasticache for memcached
implementation

·    Implemented automatic server scaling based on
demand

·    Implemented Amazon SES to send customer
confirmation emails

·    Implemented Amazon S3 to host logs and files
for CDN use

·    Implemented Amazon CloudFront

·    Other Amazon (AWS) features

Sentek Consulting

Senior Oracle DBA / Database Analyst II, San Diego, CA             January 2014 – Feb. 2014

·    Delivered day-to-day DBA operations such as
creating tablespaces, adding datafiles, and ensuring efficient database
operation

·    Verified and corrected as necessary database
backup scripts

·    Verified proper standby database
configuration and recoverability

·    Created scripts ancillary to main
applications

·    Recovered and continued database upgrade from
10g to 11g

·    On call 24/7 for database emergency
situations

Nielsen / Claritas

Senior Oracle DBA, San Diego, CA                                             April 2007 – December 2009

    · Migrated online several local databases from

onsite to remote data center ranging from 300 gb to 6 TB of data

· Optimized PL/SQL and SQL of PrimeLocation to
run 3-8 times faster than original code

· Installed and configured OEM to monitor all
of Claritas’ databases

· Migrated the PrimeLocation database from
Windows only to Redhat Linux

· Created the Prime Location bash script for
database installation and configuration

· Assisted customers with onsite custom
installations

· Developed automatic backup and recovery
testing RMAN and bash scripts

iiON Corporation

Team Lead / Sr. DBA, San Diego, CA                                          April 2000 – April 2007

·  Recreated the database on RedHat Linux from Solaris

·  Created 60% of the ColdFusion and PL*SQL code
for the company’s primary software

·  Created and optimized 90% of the SQL

·  Created code to dynamically insert data into
the OLTP database and a DW database simultaneously with nearly zero performance
decrease for the OLTP database
The OLTP database was used to run the online application.  The DW database was for back-end analysis.

·  Created 95% of the code used to generate
analytics for the DW database
Original code ran very slowly and returned results after running for a
day.  My optimizations radically revamped
the analysis process and returned results in a matter of seconds; worst case
was a matter of minutes

·  Created code to import / export data from the
primary application to xml and other formats to be used in offline analytic
software including SAS, Excel, and StatPack (Not Oracle’s StatsPack)

System Engineering Solutions Inc., San Diego, CA                                February 1998 – April 2000
Technical Writer / Programmer / DBA

· Created code to dynamically retrieve data from
a database and generate FrameMaker+SGML pages within FrameMaker
I had a timeframe of three weeks to do this. 
I had to read over 3000 pages of FrameMaker SDK and implement the code
in the same time constraint.  I spent the
first week digesting and absorbing the FrameMaker SDK.  I spent the next four days creating a
framework for dealing with the database as objects within FrameMaker.  The rest of the time I spent implementing the
code in C++ and testing.
I was an undergrad when I accomplished this feat, still 3 years away from
getting my bachelor’s degree.  Other
programmers with bachelor and master’s degrees looked at the requirement and
said it could not be done.  I was the only
one that said it could, and actually did it.

· Assisted with future versions of the Company’s primary software, PowerPubs in PowerBuilder and to conform with ATA
Spec 2100.

United States Navy, San Diego, CA                                                            July 1992 – April 1996

Aviation
Structural and Hydraulic Mechanic

· Trained
personnel in proper software usage

· Installed
and maintained military software

· Provided
maintenance on military aircraft, engines, and equipment