Alan J. Gano

425-***-****

ac0az4@r.postjobfree.com

Summary

Productive professional with deep experience in the database administration role. I excel in the back-end or front-end. I am goal oriented, self directed, motivated, and a proven analytical problem solver. I have worked in a variety of roles, from sole DBA to member of large international teams to Team Lead, in companies ranging in size from fresh-startup to large enterprises. I bring a wide base of auxiliary experience in the fields of Unix System Administration and development.

Key Skills: Oracle, RAC, SQL, PL/SQL, performance tuning, data design, RMAN, DataGuard, Streams, PostgreSQL, MySQL, Ruby, Perl, BASH, KSH, Java, Linux System Administration

Recent

SmartFocus (May, 2015 to Present) – DBA Team Lead

DBA TEAM LEAD

Took over as Team Lead of a world-wide DBA team.

Unify environment codebases with git and BitBucket

Implement use of JIRA for DBA ticketing

Standardized PostgreSQL environments

Implement hot standbys in PostgreSQL production environments

Implement standardized backups for PostgreSQL and EnterpriseDB databases

Replaced a home-growth on-call paging mechanism with PagerDuty

PagerDuty integration with Zabbix

Ruby program to interface with PagerDuty and JIRA for automated ticket creation

MIGRATE ETL PROCESS

Transparently migrated an extensive ETL process from one product to another.

Data Design

Java

BASH

CLIENT ACCOUNT MIGRATION

Balance client activity across Oracle databases by way of migrating client data between databases.

Oracle

Data Design

PL/SQL

ESP IT (Feb, 2014 to Jan, 2015) – Senior Consultant – UHG (United Health Group)

MAHIX DB SUPPORT

UHG inherited a set of databases from an IT management company. I joined a tiger-team of DBAs in support of the Massachusetts Health Exchange website.

Verification and modeling of environment and databases

Implement basic monitoring

Assisted in application rollouts

Assisted in live recovery scenarios

UPGRADES

UHG has a large database environment. I was tasked with the main push to upgrade them.

Refined upgrade and failure-recovery procedures for standalone and RAC databases

Documented problem cases for DBA team

Developed methodology to manage concurrent upgrades

Scheduled with project teams and performed most lower-environment upgrades (>400 databases)

Scheduling and upgrading of production databases

“SMART TABLESPACE GROWTH”

The goal was to lighten the paging load by developing a system to collect tablespace growth information (Ruby) from all Oracle databases in the company, and predictively beat Grid OEM alarms by automatically adding space, handling both FileSystem and ASM storage and standby space, and handle special-case tablespaces (i.e,. UNDO and TEMP).

Ruby

Data design

Distributed systems

Cequint.com (Feb, 2013 to Feb, 2014) – Senior DBA

Support of database operations, including installations, upgrades, and backups

Development and emplacement of environmental standards

Database migration to Linux platform

Used Ruby to write database maintenance and monitoring utilities

Triad Group (Dec, 2011 to Jan, 2013) – Consultant – Cequint

Support of critical databases implementing and supporting these technologies: Standby, DataGuard Broker, Fast Start Failover (FSFO), Enterprise Manager 12c, Multi-master Streams replication.

Used Ruby to write database maintenance and monitoring utilities

APEX (Dec, 2010 to Dec 2011) – Consultant -- AT&T Mobility

PHYSICAL DBA

Working with a large group of DBAs to support thousands of databases. Directly supported three assigned projects.

Oracle 9i to 11g

DataGuard

Backups

National Park Service (Aug, 2009 to May, 2010)

INDEPENDENT CONSULTANT

Based on the NPS permits system, I developed an intranet reporting website.

MySQL

PostgreSQL

Ruby (and Rails)

Tek Systems (Aug, 2007 to Jun, 2010) – Senior Consultant -- AT&T Mobility

PERFORMANCE ISSUES

I resolved a number of issues for various high priority projects, often being called in on consultation basis. For the project I was directly connected to, I analyzed/resolved database issues relating to SAN hardware, SQL performance, and application behavior.

DATA ARCHIVAL AND PURGE

A busy customer facing website only needs 3 months of online data. 2 years existed, and growth rate was increasing. The previous archive/purge solution was failing to keep up. I was assigned the task of re-engineering a better performing solution.

Oracle

Ruby

Provided a rolling window of archived data for reporting teams

Online table builds to shrink database

MYSQL TEAM TRANSFER

I was assigned the task of supporting the MySQL environments and preparing them for transfer to another team of new MySQL DBAs.

MySQL

Standardized existing environments to prepare for handoff

Completed handoff to new MySQL DBA team

CONFIGURATION MANAGEMENT

I developed a system to collect and track information from all Oracle databases in the company, on subjects such as init.ora parameters, redo configuration, RMAN backup activity.

Oracle

Perl

Intranet web application

APPLICATION DBA

I supported a large project at the application-level. Extensive work with developers, database performance tuning, SQL performance tuning, data migrations, and process implementation.

System/Database/SQL Tuning

Data Conversions/Migrations

Implemented a project-level Bugzilla website for tracking SQL tuning issues

Implemented DB Change Management using a ticketing system and supporting scripts

Physical and Logical Standbys

PHYSICAL DBA

Supported the Global Physical DBA team on an consulting basis

Implemented and supported a team Wiki site

Oracle / MySQL

Classmates (Jan, 2004 to Jul, 2007) – Principal DBA

SYSTEMS METADATA MONITORING

Developed and implemented a system which collects host and database information. From this discovery information, a Metadata subsystem is automatically updated, serving as our overview of the entire environment. A Monitoring subsystem uses the historical discovery information to alert the DBAs to problems. I wrote a DBA intranet site to interface with the system.

Oracle

Ruby (and Rails)

MYSQL ROLLOUT

Merged MySQL into our enterprise database environment

Developed metadata repostory tracking the MySQL environment

Ruby monitoring scripts

Data replication between Oracle and MySQL in Ruby

DASHBOARD

Designed, developed, and implemented a corporate “dashboard” intranet site, to show the health of the company on a near-real-time basis. The system follows a classic Data Warehouse architecture wherein disparate information sources are queried and loaded into an Operational Data Store at a high granularity, and Data Warehouse-style tables in an Analytical layer, at the levels of detail and formats required to meet information demands. This web site is widely viewed by NSI and DBA teams, as well as upper management.

Oracle

Datawarehousing

Apache / mod_perl

PL/SQL

Perl

DATABASE ADMINISTRATOR

Worked with an elite team in the management of a large installation consisting of 7 Oracle and 34 MySQL databases in production, and 60+ Oracle and 150+ MySQL databases at the development, QA, Stage, and Perf release levels.

Past Employment

Banfield Pet Hospital – Oracle, database digration

PROdx / Banfield Pet Hospital – Oracle, database migration, Perl

PROdx / Premier Lease and Loan Services – Oracle, platform migration, Oracle Names, performance tuning

PROdx / AT&T Fixed Wireless – Oracle, data migrations, Perl

PROdx / Velodia – Oracle, Java, web development

PROdx / Oregon State Department of Corrections – Oracle, backups, Perl, upgrades, tuning

PROdx / Breakwater Security Associates – Perl

PROdx / Fluke Corporation – Oracle, upgrades, Y2K preparation, DSS

Datex-Ohmeda – Oracle, Progres4GL, shell, backups

McHugh Software International – Oracle, backups, Perl, web development

SoloCup Company – Oracle, data warehousing, backups

Jockey International – Oracle, Essbase, data warehousing

Graebel Companies – Oracle, Oracle Forms/Reports, SQL, C

Contact this candidate