Thomas J. Gallagher

P.O. Box ***

Lisbon, Maine

207-***-****

ac6sn4@r.postjobfree.com

www.linkedin.com/pub/thomas-gallagher/74/b71/322

Professional Experience

Over 30 years database administration and design experience in various Database Management Systems (DBMS), both relational and hierarchical in the Unix/Linux and Mainframe environments.

Expert experience working with Management and other Users to develop appropriate strategic solutions.

Extensive experience working on teams and independently creating and implementing physical and logical designs in multiple Database Management Systems.

Extensive database design, performance tuning, Quality Assurance, and administration experience across multiple environments.

Experience presenting data and findings to varied audiences.

Experience with ETL between new and existing databases.

Experience with developing data strategies, standards, and backup and recovery procedures (both daily and Disaster Recovery) for enterprises large and small.

Extensive experience working with Users to solve data conflicts, uses, and other problems/issues.

Extensive experience deconstructing legacy systems to evaluate tuning and efficiency opportunities.

Willingness to learn new skills and adapt to fluid situations.

Skilled at working multiple projects/problems concurrently.

Ability to evaluate the usefulness of third party products for various DBMS.

Strong analysis skills and ability to anticipate user needs/requirements.

Extensive skills using Microsoft Office software (Word, Excel, Access, Outlook, etc.)

Skills

Unix/Linux

oMS/Access

oOracle database management system

oMySQL database management system

oPython scripting language

oDjango Web Framework

oHTML coding

Mainframe

oIMS database management system

oDB2 database management system

oCA/Datacom database management system

oJob Control Language (JCL)

oISPF/TSO interface

WORK EXPERIENCE

Database Consultant

January 2017 – May 2017 (full time, part time July 2017 to present)

National Alliance on Mental Illness(NAMI) – Maine Augusta, Maine

Responsible for evaluating, tuning and coding solutions for existing Microsoft Access databases. Tuning has included evaluating existing Microsoft Access queries for inefficiencies and “dead code” that slow response times. Currently coding and creating new Microsoft Access Reports and processes that better satisfy required reporting for State of Maine programs. Currently providing part time, ad-hoc consulting services.

Programmer 3

September 2015 – December 2016

V-Tech Solutions Augusta, Maine

Responsible for supporting and creating Microsoft Access programming for contract with Maine State Department of Health and Human Services’ Office of Child and Family Services and creating some queries using PL/SQL. Duties involved creating and maintaining Microsoft Access Queries, Reports and Forms for various databases. I have also been instrumental in designing and supporting databases for local users and assisting with various issues that came up with those users.

Database Analyst/Web Programmer

February 2014 – March 2015

Dr. Newton’s Naturals South Portland, Maine

Responsible for designing, writing, documenting and supporting the in-house Media Buying system. Responsible for coding, testing and supporting the system using Python programming language, Django Web Framework and MariaDB/MySQL relational database. Part of the design process also included examining the existing data for unnecessary/unused data and not carrying it over into the new system. Responsible for supporting legacy Microsoft Access reporting system. Includes coding queries and macros, backup and recovery and general database maintenance.

Thomas J. Gallagher

P.O. Box 164

Lisbon, Maine

207-***-****

ac6sn4@r.postjobfree.com

www.linkedin.com/pub/thomas-gallagher/74/b71/322

Database Analyst

November 1996 - June 2013

Computer Sciences Corp. Bath, Maine

Design, maintain and provide programmer support for Oracle, IMS, DB2 and CA/DATACOM databases for multiple clients. Also responsible for programmer support recommending code changes, developing backup, recovery, disaster recovery standards and recommending 3rd party utility products for the above database systems. My last assignment had been supporting Oracle database administration in Oracle versions 10g and 11g using PL/SQL, performing user I.D. creation, stored procedure compiles and data restores.

Database Analyst

October 1994 - November 1996

Bath Iron Works Bath, Maine

Design, maintain and provide programmer support for IMS, DB2 and CA/DATACOM databases for client. Also responsible for programmer support recommending code changes, developing backup, recovery, disaster recovery standards and recommending 3rd party utility products for the above database systems.

EDUCATION

Bachelors of Science in Computer Information Systems. DeVry Institute of Technology Columbus, Ohio

Contact this candidate