A role as a DBA, ETL specialist, and software tool developer, with an organization where this skillset is essential to the company's success. Must be a great fit. Distributed workforce and smaller companies especially attractive.

Bachelors degree in Computer Science. Attended school September 1986 – December 1989.

Vertica DBA   •   Indeed, Inc.   •   Austin, TX / Las Vegas, NV   •   November 2022 - present

Sole DBA for production 96-node (2880 CPUs) eon mode Vertica cluster handling analytics queries back-ending Indeed's global hiring platform (www.indeed.com/hire), with a traffic volume of ~3.6M queries/day, peaking at ~100 queries/sec. Led migration of website traffic first from GBQ to Vertica Accelerator, then to a DBA-managed set of EC2 instances in the AWS Cloud. Architect (design, prototyping, optimization) of all ETL interacting with the Vertica database, including calculation of Indeed's "Market Insights" metrics. Author of Indeed's Vertica DR strategy. Did extensive and ongoing performance optimization related to both analytics queries and ETL, including projection and live aggregate projection design, introduction of a query cache layer, tuning of EC2 instance types. Took initiative to architect the solution for a two-year outstanding data problem then described by the product manager as "the most serious issue with analytics at Indeed today". Managed all relationships with AWS and Vertica tech support, identifying numerous issues with both the database product and Vertica management console, working them through to resolution. Developed numerous software tools facilitating traffic routing and cluster management.

Vertica DBA and ETL Lead   •   Diio, LLC, Reston VA / Las Vegas, NV   •   December 2015 - November 2022

Joined Diio ("Data In, Intelligence Out"), a company specializing in business intelligence for the aviation industry.
Diio, LLC merged with FlightGlobal Inc., January 2017. Company rebranded as Cirium Inc., February 2019.

One of two Vertica DBAs responsible for multiple development and production Vertica clusters, as well as ancillary Postgres and MySQL databases. Standardized 30+ business-critical database loading processes, previously requiring multi-step checklists, hand-edits of code, and other human decision-making at multiple interface points, re-implementing as a set of modules, leveraging a new unified, configuration-driven and idempotent framework, improving readability, maintainability, and consistency through automation, while reducing risk, runtime, and need for oversight. Implemented fully productionalized, event-driven system for handling routine loads without any human involvement where appropriate. Prolific developer of custom-built software tools facilitating database administration tasks, cross-database data transfer, database version upgrades, SQL builds, query benchmarking, reference data maintenance and distribution, and other forms of data management and exchange. Author of fully automated back-end processing for partner IATA's Cargo Accounts Settlement System (CASS) and CargoIS Direct Data (CDD) systems, marketed to customers worldwide. Data engineer behind 12-month project extending the ~20Tb database back-end of IATA's Direct Data Solutions (DDS) product. Go-to person for project managers and app developers with database needs (performance optimization, data concerns, bug hunts, new product development). Essential contributor in migration of all company data center computing resources into the AWS cloud (EC2, S3, RDS, RedShift, RedShift Spectrum).

Consultant for American Airlines, Tempe, AZ   •   Perl Developer   •   August 2014 – October 2015

Recruited by US Airways' Revenue Management Group to support two business-critical batch processing systems (Perl, Python, ksh, Oracle) during the US Airways / American Airlines merger, freeing up existing staff to do new development required for the future merged carrier. Made code changes and performance enhancements to these systems as demanded by the merger, such as the alignment of US and AA fare classes. Periodic 24/7 on-call support responsibilities.

Consultant for Grant Street Group, Pittsburgh, PA / Las Vegas, NV   •   Data Migration Specialist   •   April 2011 – August 2014

Returned to the data conversion group to do additional work enabling the conversion of more Florida counties (Indian River, Alachua, Miami Dade, Brevard, Nassau, Santa Rosa) from competing commercial and sophisticated homegrown tax collection and billing systems to TaxSys, Grant Street Group's flagship product. Wrote high-performance custom conversion code (OO-perl, Linux, MySQL) code based on GSG's highly parallel data conversion framework. Example: Miami Dade conversions of ~50Gb raw data routinely converted overnight, consuming a total ~137 days of CPU time, running in 14 actual hours. Maintained and extended the parallel conversion framework code as needed. Refactored pre-framework property tax code to run under the new highly parallel framework. Alternately acted as the primary back-end engineer and supervised protege back-end engineers for Grant Street's tax lien auction business. Example: in 2013, handled all data processing for 31 tax certificate auctions used by county treasurers and tax collectors to collect $725M in delinquent real estate taxes. Initially advertised total value in excess of $1B. Additional duties as directed.

Consultant for Cisco Systems, San Jose, CA   •   Web Developer   •   July 2010 – December 2010

Rewrote Cisco's 10+ year-old frames-based Enterprise Monitor application, used to monitor the availability of IT-supported devices, hosts and applications worldwide, to be an Ajax application based on the Dojo Javascript framework. Extended the software to monitor "composites", so that redundant services with automatic failover would no longer necessarily alarm when some components became unavailable. Completed all coding a month ahead of schedule and singlehandedly for a project where the anticipated need was for two developers. Key technologies: perl, Javascript, Dojo, YUI, Ajax, SQL, memcached.

Consultant for Grant Street Group, Pittsburgh, PA   •   Data Migration Specialist   •   January 2006 – June 2010

Returned to handle data load for all fifteen tax lien auctions conducted by Grant Street Group (GSG) for customers in AZ, FL and MD in 2006; continued in this role until departure. Assigned new responsibilities for reverse- engineering and migrating data from legacy customer systems into TaxSys, GSG's flagship product, an AJAX-based tax collection and billing system for county governments in Florida, introduced in 2006. Developed custom ETL software for roll-out of the cashiering, occupational licensing, tourist development, alarms, bankruptcy and special assessments modules of TaxSys (where applicable) for GSG's first ten TaxSys customers (Broward, Citrus, Highlands, Lake, Okaloosa, Osceola, Monroe, Pinellas, St. Lucie, and Volusia Counties). Coordinated with another data conversion specialist and with business analysts specializing in conversion-related activities on an on-going basis. Developed software implementing the back-end of tax lien auctions for the TaxSys product. Wrote custom patches and other software to resolve database issues in production as necessary. Other duties as directed.

Consultant for FedEx Services, Collierville, TN   •   Sybase DBA   •   October 2005 – January 2006

DBA for Sybase ASE 15 development servers (Linux). Analyzed locking issues intermittently disrupting a cargo flight booking application, showing how to resolve problems without migrating to Oracle. Developed data migration and schema transformation scripts as part of an effort to replace the middleware layer of the application running against this database. Assisted in porting related shell scripts to conform with Fedex production operations standards.

Consultant for Grant Street Group, Pittsburgh, PA   •   Data Migration Specialist   •   January 2004 – October 2004

Designed and implemented software suite (OO-perl, Linux, MySQL) to load delinquent tax and related property data from various Florida counties into Grant Street auction databases, in support of the first-ever offering of tax lien certificates on the Internet, in which $150M worth of instruments were sold. Led team of three engineers loading data into databases used both for Internet auctions and Internet-based bid research by both private and institutional investors. Technical liaison with numerous FL tax collectors and property appraisal offices, gathering data, verifying data integrity, and providing post-auction extracts describing winning bidders, certificate sales, deposit and payment information. Extended Grant Street's proprietary mod_perl-based web application to provide customers access to post-auction deliverables. Rewrote prototype (year 1) code for performance and scalability after client auctions were completed, improving running time by a factor of four.

Managing Partner, Given Solutions LLC

March 2003 – September 2005

Developed innovative web technologies composing Given's proprietary "web engine", a set of mod_perl-compatible object-oriented perl libraries which serve as a basis for rapid development of highly sophisticated database-backed web applications under Apache, MySQL, DBI/DBD. Designed and implemented variously branded production web sites based on this engine which are used to market financial services programs offered by Economic Advantages Corporation (EAC), most notably, "Fair Pay", a strategic alliance between EAC and the National Association of Mortgage Brokerers. Worked daily with other partners to manage Given's business relationships and set the direction of the company.

Consultant for Pitiglio, Rabin, Todd and McGrath (PRTM), Mountain View, CA

Joined several of PRTM's project teams on-site with their clients, providing technical expertise and leadership to PRTM directors and business analysts as well as end-client management and engineering staff members. PRTM has an international presence and specializes in providing management consulting services to technology-driven businesses.

Nortel Networks, Irvine, CA   •   Senior Web Developer   •   August 2000 – October 2000

Represented PRTM at Nortel as a web developer. Advised PRTM analysts documenting and re-engineering Nortel business practices on GUI design principles, web-based interfaces and relational modeling. Collaborated with analysts on design of a highly customized web-based application (~120 screens) providing an interface to a new central repository tracking order management data for Nortel's Verizon account. Implemented this application, using object-oriented perl to dynamically generate HTML with embedded Javascript, interacting with back-end databases (Oracle, Postgres) via DBI/DBD. Systems administrator for development Linux machines (Red Hat 6). Commuted weekly by air to the client's location in Southern CA.

Concentric Network, San Jose, CA   •   Senior Web Developer   •   September 1999 – July 2000

Represented PRTM at Concentric as a web developer. Built a custom web-based application (object-oriented perl, DBI/DBD, dynamically generated HTML, Javascript) accepting DSL orders from corporate customers, interacting with DSL service provider (Covad) prequalification software, queueing qualified orders pending remote approval from designated client representatives, and ultimately uploading approved orders into Concentric's active service request database (Scopus/Oracle 8/Solaris 8).

Hewlett Packard, Cupertino, CA   •   Data Migration Team Lead   •   August 1998 – August 1999

Represented PRTM at Hewlett Packard as the technical lead for a large scale (~150 Gb) ETL/data warehousing project.
Designed, documented and enforced data migration procedures. Implemented software tools (perl, ksh) to facilitate source data quality analysis and cleanup. Trained and supervised 8-10 member technical staff on data migration policies, procedures and tool use. Escalation person for all technical issues.

Maintained and analyzed large (>20k lines) ETL software suite provided by HP which accepted extracts from legacy mainframe systems, reformatted these into a series of XML data bundles according to business rules, and ultimately uploaded them into the data warehouse (Sybase 11.9.2, HP-UX 10.20). This software served double duty as both the ETL team's migration tool and as the daily batch synchronization tool for production data warehouses. Determined early in the project that this software was buggy, inadequate to the task of handling data from disparate world-wide sources, and too slow to process (in a day's time) even the volume of updates that could be expected to arrive on a daily basis in production environments. Reverse-engineered and rewrote the majority of this software in perl, introducing more advanced data structures and data processing concepts (caching, pipelining, collapsing redundant sorts, etc...), thereby improving performance by a factor of eight while simultaneously improving error handling and increasing reliability, readability and maintainability.

Liaison between PRTM's team and HP's Roseville, CA Senior Technology Lab (STL) in daily conference calls related to bug tracking, software builds, benchmarking, status of the data migration team. Lectured at HP on Sybase performance tuning and perl programming. Trained STL staff in use of new ETL and data analysis tools, troubleshooting procedures, data migration policies.

Consultant for Wind River Systems, Alameda, CA

Data Migration Specialist   •   February 2001 – May 2001

Developed perl software tools to migrate data from MS SQL Server 7 databases to Oracle 8i. Ported related Cold Fusion-based HR applications from NT to Solaris 8. Performed a security audit of all applications to ensure sensitive HR data could only be accessed by authorized personnel. Wrote perl scripts to facilitate the replication of Oracle databases.

Senior Sybase DBA   •   April 1997 – May 1998

Senior DBA and systems administrator for all Wind River Sybase servers (Sparc 1000s and E3000s running Solaris 2.5.1). Go-to person for all database-related issues and trouble-tickets. Managed upgrade of Wind River database environment from Sybase 4.9.2 to 11.0.2. Automated database and systems administration tasks by building customized object-oriented perl software tools. Designed and implemented Wind River's disaster recovery strategies. Provided database expertise and Sybase support to a project team deploying a Vantive call-tracking system, including analysis of Vantive performance over Wind River's WAN.

Designed and implemented twelve integrated web-based applications (100+ screens) using Sybase's web.sql product (CGI; object-oriented perl, dynamic HTML, Javascript), enabling the Wind River user community to inspect and modify database content via web browsers. Wrote Java applets to display trouble-ticket status based on database content. Webmaster (Apache, Netscape Enterprise Server) for database-related web servers.

Consultant for Locate, Inc., Half Moon Bay, CA

Software Architect   •   February 1998 – February 2000

Designed and coded all back-end software for Guide, Locate's flagship product, a mobile workforce directory. Designed perl software to download and map raw corporate directory data from flat files, LDAP and/or ODBC-compliant databases to LDIF, and from LDIF to specially compressed and encoded files compatible with the Palm Pilot architecture and usable by the Guide front-end application. Implemented a complex web-based configuration interface to facilitate per-user selection of customized data subsets.

Consultant for PeopleSoft, Inc., Pleasanton, CA

Senior Sybase DBA   •   September 1996 – February 1997

Sybase/UNIX specialist supporting PeopleSoft's Customer Connection project (deployment of a Vantive-based call center under Sybase 11.0.2 and HP-UX 10.10). Originally brought on-board by a former manager to identify database performance issues threatening to impact the project's roll-out schedule (resolved problem in three days). Remained until project completion to provide database and administrative support to the project team as needed, including design and implementation of high-availability/disaster recovery strategies, construction of custom data migration tools, Sybase tuning to optimize Vantive performance. Sole systems administrator for two 24x7 production HP Series 9000/800/T520 machines running Sybase as well as a Sparc 20 supporting a Netscape Enterprise Server. Automated database and systems administration tasks. Built custom perl tools to facilitate management of Vantive user base. Sole contact with Sybase, Sun and HP for support issues.

Consultant for Sybase, Inc., Emeryville, CA

Senior Sybase DBA   •   August 1994 – August 1996

Senior DBA for Sybase Global Support Systems, managing corporate customer call-tracking databases worldwide. Provided UNIX, Sybase, programming and data migration expertise to a team deploying and supporting a customized version of Clarify's ClearSupport application for Sybase Technical Support. Senior systems administrator for ten Sparc-1000s running Solaris 2.4 and Sybase SQL Server 10.0.2 in the US and Europe. Analyzed performance at the network, operating system, SQL Server and application levels. Developed tools used internally by Sybase to automate database and systems administration tasks, and to manage Clarify software. Designed and implemented hot standby and reporting server synchronization, cutover and recovery strategies. Mentored junior DBAs and systems administrators.

Senior Systems Administrator   •   April 1993 – July 1994

Engineer affiliated with the Technical Support group. Developed menu- driven perl software automating installation and configuration of Sybase software to reduce time required to duplicate customer cases. Provided UNIX expertise to Sybase analysts; installed Sybase and third-party software and bug fixes on numerous platforms. Performed systems administration tasks and troubleshooting on Sun Workstations as needed to support the Technical Support group.

Consultant for Silicon Graphics, Mountain View, CA

Senior Systems Administrator   •   February 1991 – November 1993

Engineer affiliated with the I/S Network Services group. Developed numerous perl software tools automating systems administration tasks and the provision of information services. Automated DNS database generation and maintenance. Automated production of the corporate phone book by writing scripts generating MIF (Frame) and SGML files from Informix databases. Maintained and largely redesigned the on-line corporate white-pages and extended the availability of on-line directory services to non-IP connected field offices. Standardized mail configuration for end-user systems. Implemented from scratch a system gatewaying email to ascii-pagers and related administrative maintenance tools. Designed and coded a suite of programs to collect, archive, and postprocess network statistics, producing Wingz graphs representing traffic patterns, link utilizations and latency data. Redesigned timekeeping model for the WAN and corporate networks to increase reliability. Automated the reliable transport of SGI financial data from IP-connected field offices to a secure, central machine. Developed and ported software and otherwise worked to facilitate the SGI/MIPS merger. Ported and/or maintained various large software packages (e.g., mh, rn) for the SGI staff worldwide. Participated in implementation of the SGI Internet gateway and its security systems.

Administrator of last resort for all hosts in all domains on SGI's wide-area network. Senior administrator for hosts on SGI's corporate networks. Frequent technical consultant for SGI Network Operations, the I/S Assistance Center (helpdesk), SGI's North American Field Organization (NAFO), Data Center Operations (DCO), Telecommunications, End User Computing; liaison to the SGI engineering community for various projects.

Consultant for GreyStar Solutions, Las Vegas, NV

Web Developer   •   Oct 2002 – Feb 2003

Developed custom web-based applications (perl, MySQL 3.23, Red Hat 8) for customers and integrated them with GreyStar's existing software suite. Designed and implemented http://www.infinitysaver.com, a customer-facing web site, as well as the web-based administrative interface used by Infinity Access Group (IAG) to manage customers of their site, data transfers to and from their service provider, the collection and management of digital signatures on loan documents and consulting agreements. Additional duties performed as directed.

Consultant for Palm, Inc., Santa Clara, CA

Software Engineer   •   April 2000 – May 2000

Wrote (using mod_perl) a custom Apache module and related support software to allow automatic authorization and authentication of generic HTTP requests on a wireless network. Palm Inc. applied to patent this software in the year 2000 ("Secure Authentication Proxy Architecture for a Web-Based Wireless Intranet Application").

Consultant for Barclay's Global Investors, San Francisco, CA

SQL Programmer   •   March 1997

Wrote SQL triggers and shell scripts to coordinate extraction and postprocessing of data from a human resources database (PDS).

Consultant for Mindcraft Inc., Palo Alto, CA

Q/A Programmer   •   February 1990 – December 1990

Wrote C and Bourne shell code comprising a large conformance test suite, first as a staff consultant for Taos Mountain Software of Mountain View, CA, later as an independent consultant after starting a consulting business. Work involved development and verification of thousands of small subroutines demonstrating that various UNIX utilities and system calls behaved as specified in applicable standards and vendor-specific documentation (Posix, XPG3, AIX).

Robotics Lab, Stanford, CA

Systems Administrator   •   June 1989 – December 1989

Systems administrator for a Vax 11/750 (BSD 4.2), Sun-2 (SunOS) and several DECstation 3100s (Ultrix). Responsible for hardware and software installation, routine administration (adding new users, clients, X-terminals, etc...), porting software from the 11/750 to other architectures, modifying system programs, verifying system security, tailoring systems to meet user's needs.

Electrical Engineering Computer Facility (EECF), Stanford, CA

Systems Programmer   •   June 1987 – February 1990

Wrote software in C to perform network troubleshooting and manage source repositories. Performed administrative tasks, software porting, installation and enhancement, bug verification and correction, system trouble-shooting and maintenance in heterogeneous highly-networked environment. Assisted clients with problems by telephone and in person. Extensively involved in auditing and guaranteeing the security of various systems. Numerous other duties as directed.

Jet Propulsion Laboratory (JPL), Pasadena, CA

Programmer   •   August 1986 – September 1986

Wrote low level assembly language communication code for IBM PC/ATs in conjunction with a hypercube (distributed computing) research project (SURF) sponsored by the California Institute of Technology.