PROFESSIONAL EXPERIENCE
01/2008 - Present
Fred Hutchinson Cancer Research Center– Statistical Center for HIV/AIDS Research and Prevention (SCHARP), Seattle, WA – Principal Database AdministratorInterface with all departments and create new tools & databases to reduce work time and reduce human errors.
- Specializing in query optimization, taking long running query and getting them to run in seconds.
- Created interactive phone list that can generate pdf employee lists and pdf maps showing employees room locations.
- Created Closeout Checklist so that the paperwork does not need to be passed person to person.
- Created Software Inventory to make sure that licenses are renewed on time plus to be able to reclaim unused licenses, thereby saving money.
- Created MPMYBT v2 & v3 to help finance create Multi-Project Multi-Year Budgets in Excel 2007/2010 while storing versioned data in Postgres.
- Created PHP Library for doing Postgres, with error wrappers, and LDAP functions, designed for our ldap structure.
- Created Outage Database that email groups of people with calendar events for system outages.
- Created CTS2 DOG’s Control Database. This allows easy manipulation of files that would get corrupted by people editing them manually.
- Worked on several Atlas Modules: Tracking, DMQ, Spec Mgmt
- Consolidated finance data from many schemas to just three schemas. Allowing finance to easily find and use their data.
- Upgrade Postgres 9.0.12 to 9.2.4 to 9.4.6 to 9.4.9 with LDAP to 9.6 with LDAP and 10.6 with LDAP
- Convert ASCII databases to UTF8
- Discovered, reported, and had fixed Postgres bugs #7553, 8173, 8257.
- Run the Seattle Postgres Users Group, giving many presentations and hosted at FHCRC.
- Find and review everything that connects to PDB, SODA, & SMORES to show how everything interconnects and where data is input vers used.
- Create monitoring solution for the PostgreSQL Servers using collectd, graphite, grafana, and raspberry pi's.
07/2005 - 01/2008
Skycorp Executive Charters, Inc, Everett, WA – Accountant / Systems Administrator / Network Administrator / Systems Analyst / Programmer / Technical PublicationsInterface with all departments and create new tools & databases to reduce work time and reduce human errors.
- Created a new chart of accounts for accounting to match the Aircraft Management Reports created by the reporting department.
- Created an electronic flight board to replace white board in both the Flight Department and the Maintenance Department PHP & PostgreSQL driven.
- Created an Excel sheet to track Crew Currency, later converted to being PHP & PostgreSQL database driven.
- Created a Passenger Verification Database which interfaces Access to CharterSuite’s Access database & TSA’s CSV Lists.
- Created and designed the Operational Control System where you submit CharterSuite flight to and it then reads the flight and crew information from CharterSuite Access Database it then verifies crew status in the PostgreSQL Database, Aircraft Status in the PostgreSQL Database and may auto-reject the flight. If approved it will email a list of authorizers the crew itinerary for which they will respond with an authorization or rejection. The system will then automatically generate a pdf file and print at the satellite office the approval or rejection form along with printing it at the Principal Base of Operations. If approved it also removes any previous version of the flight from the electronic flight board and puts up the new version. If rejected it also removes any previous version of the flight from the electronic flight board. Then an email is sent to all the authorizers letting them know the flight was authorized and also notifies the crew flying the flight along with the appropriate maintenance & scheduling personnel.
- Created the VPN Network between the satellite offices and the Principal Base of Operations with fail-over dual WAN and 4-way fail-over VPN networking.
- Created City Pair price books from a list of Airports and their coordinates, had to figure out if the airport was within non-stop flight range and calculate the distance and flight times to be able to figure out the flight cost along with fuel surcharges, overnight fees, standby fees, landing fees, etc. Also made sure that the flight would comply with the Federal Maximum Duty Day of 14 hours with a minimum of a 10 hour rest period before the next leg of the flight.
- Created a website for the customers to quote their own trip and to check the aircraft status and then submit the flight. It then emails Scheduling and posts it as a pending flight on the electronic flight board.
- Systems Administrator for the Windows 2003 File Server and Windows 2003 Small Business Server (Exchange Server).
- Network Administrator for the entire multi-site/state offices.
7/2003 – 4/2008
Global Wizards Communications – Accountant / Systems Administrator / Systems Analyst / ProgrammerFull-service website hosting company, develop & maintain customer websites on our own servers.
- Create and maintain database driven ecommerce websites for clients, including Shoreline Chamber of Commerce, K&D Enterprises, Global Wizards Communications
- Maintain Redhat Linux & Fedora Servers, Windows 2000 & 2003 Servers and Qmail Email Server.
- Specialized in creating websites using PostgreSQL back-ends with PHP, consumer, & Microsoft Access, business, front-ends.
- Built new Crystal Report to hook into Brunswick bowling system to run a specialized daily till report for Leilani Lanes and is now used by Sunset Bowl.
5/1989 – 7/2003
Aturna Communications – Accountant / Systems Administrator / ProgrammerFull-service website hosting company, develop & maintain customer website’s on our own servers.
- Create and maintain database driven ecommerce websites for clients, including Marlow’s Fine Jewelry & Pressline Printing Equipment.
- Maintain Redhat Linux Servers, Windows NT 4 Servers and Mercur Email Server.