Software Engineer

• May 2022 - Present

Project Consultant

• Jun 2021 - Sep 2021

IT Contractor, for Meteorcomm’s System Resilience Project. Created a disaster recovery playbook, triage flow and sequence diagrams, risk matrix, crisis communications plan, and IT best practices and critical business classifications documents. This was a ten-week contract. IT Contractor, for Meteorcomm’s System Resilience Project. Created a disaster recovery playbook, triage flow and sequence diagrams, risk matrix, crisis communications plan, and IT best practices and critical business classifications documents. This was a ten-week contract.

IT Security Contractor

• Feb 2019 - Nov 2020

Works with IT Teams, Cybersecurity, Problem Solving, Analysis, Design, Development, Modeling, and Tuning, Linux, UNIX, Oracle, System and Database Administration. Lifelong learner, independent worker, team player and leader. Has CISSP, ITIL, OCP, and MTA certifications; once held TS Clearance (expired). Works with IT Teams, Cybersecurity, Problem Solving, Analysis, Design, Development, Modeling, and Tuning, Linux, UNIX, Oracle, System and Database Administration. Lifelong learner, independent worker, team player and leader. Has CISSP, ITIL, OCP, and MTA certifications; once held TS Clearance (expired).

Professional System Engineer

• Jul 2014 - Dec 2017

Worked with a production support team for internally developed systems, primarily Common Services Back Office Business Process Management (BOBPM) and Common Services Business Rules Management System (BRMS), also secondarily Request Fulfillment System (RFS) and Common Service Fallout Manager (FOM). Apart from Oracle backends, BOBPM & BRMS rely on an open source stack using Linux, Java, Cassandra, and Apache ZooKeeper. Internally developed tools on the server include application software written in Java, the GRID API and Caches framework, and the Local Resource Manager (LRM) command line interface. Remote deployment and configuration of code of rules and code is handled by IBM Decision Server and Decision Engine, Subversion, CFEngine, AFT Software Manager (SVM), and Global Resource Manager (GRM). Monitoring tools include Splunk, Nagios, and internally developed reports. Developed menu-driven script in Perl that used the LRM for starting, stopping, and bouncing of individual components, resource groups, and all managed resources of the BOBPM application. Developed web-forms written in PHP and Perl and automated reports written in Bash and Perl that queried the Oracle database repository for the most recent three months. Approver in the Midrange User Access Manager (MUAM) for the systems that run BOBPM, RFS, and FOM, approver for BOBPM change requests, sponsored 45 Mechanized IDs for the applications and related databases, and administrator for the configuration code repository for BOBPM. Debugging problems entailed reviewing Splunk and application logs and Oracle DB data, and participating in chat rooms and online conferencing with other team members, developers, and other production teams. Helped assure that new servers were properly configured for applications. Show less

Lead Contractor

• Sep 2012 - Jun 2014

Supervised a technical team of contractors monitoring network operational readiness at the Regional Network Operations and Security Center Pacific (RNOSC PAC), MARFORPAC Headquarters, Camp H.M. Smith, HI (Sep 2012 – Jun 2014). Interfaced with the Cyber Defense branch and RNOSC PAC leadership, interacted with managers of subcontractors, attended weekly teleconference calls, and provided RNOSC PAC Monthly Status Reports for the USMC IT Regionalization Support Services (ITRSS) contract. Scheduled leave by maintaining watch bill, reviewed and signed employee time cards, escalated contract performance issues to supervisors as needed, mentored staff for career advancement, and ensured staff completes required annual certifications. Interviewed contractor candidates and guides new contracting staff through the on-boarding process. Resolved problems with subcontractors ranging from gentle discussion to termination. Performed initial out-processing of exiting employees. Provided technical assistance for MS Project. Created cyber event reports documenting instances of intrusion, malware, phishing emails, or other Computer Network Exploitation (CNE) attempts. The RNOSC PAC used SolarWinds and Netcool for network monitoring. Received “Far Exceeds” Overall Performance Rating for 2013 Appraisal. Show less

Part-time Reference Librarian

• Oct 2006 - May 2014

Atherton Library, Hawaii Loa Campus, HPU Atherton Library, Hawaii Loa Campus, HPU

Unix System Administrator

• May 2009 - Sep 2012

Member of the Defense Information System Agency-Pacific (DISA-PAC) Tier II System Admin team supporting DISA’s Operations Support System (OSS) & DISN (Defense Information Systems Network) ATM (Asynchronous Transfer Mode) Services (DATMS). Administered & patched Solaris 10, 9 & 8 running on SUN T5120 & M4000, SUN Fire & SUN Ultra servers. Administered IBM Tivoli Netcool (Omnibus, Network Manager IP Edition [Precision], & Webtop / Web GUI). Netcool monitored many network devices, such as routers & switches like Cisco, Juniper, & Broadmore, firewalls, network encryption equipment, session border controllers, VoIP services, DATMS & other transport devices .Installed, patched, configured, & maintained HP OpenView as an alternate means of COOP capability for monitoring DATMS devices. Monitored Oracle 10 databases, RMAN jobs, & Web services with Oracle Enterprise Manager Grid Control 12. Monitored Sun servers & Netcool services using Netcool & Grid Control. Used Data ONTAP v7 operating system to monitor NetApp systems & increase the size of Logical Unit Numbers (LUN or logical disk). Updated the Domain Name System (DNS) database. Updated application licenses & keys. Updated asset & finding records in the Vulnerability Management System (VMS). Wrote shell scripts for restarting applications & Perl scripts for backing up network device configurations for ASX ATM switches & Symmetricom/TruTime timing & synchronization devices. H&led ad-hoc requests & issue resolution. Opened, maintained, & closed tickets in DISA’s Remedy-based Ticket Management System (TMS). As needed, escalated problems to Tier III support & assisted them with problem investigation & resolution, & installations. Supported SafeNet’s Security Management Center (SMC), Wide Area Network Design Laboratory (WANDL) IP/MPLSView, DISA-developed applications, & backups with EMC Legato NetWorker & Spectra Logic tape library. Used traceroute to identify routing problems, particularly for X-Windows traffic. Show less

Application and Systems Administrator

• May 2007 - Jun 2009

GIGCOP Application and UNIX System Administrator at Defense Information Systems Pacific (DISA-PAC). Administered and monitored GIGCOP (Global Information Grid Customizable Operational Picture) application and the SUN Fire servers running Solaris 9 and Trusted Solaris 8 on which GIGCOP ran as well as the Oracle 9 database and ArcGIS services that it utilized. Resources Integrated Management System (RIMS) was one of the data sources for GIGCOP.

Database Administrator

• 2006 - 2007

Part of a remote DBA team providing 24x7 support for AON account. Created, altered, and dropped tables, tablespaces, data files, and users. Created, replaced, and dropped views, indexes, database links, and synonyms. Assigned privileges and roles. Dropped obsolete databases. Modified Oracle network configuration files. Renamed and reconfigured migrated databases. Ran Oracle export/import and data pump jobs. Recompiled invalid objects after imports. Ran pre-migration and post-migration verification scripts. Created databases using scripts. Cloned databases using cold backups and RMAN hot backup files. Specified UNIX requirements for Oracle databases such as SAN space to clustered servers, fail-over configuration, and implementation of virtual DNS / IP configurations for service groups. Prepared configuration of database files and file structures to support cluster fail-over between nodes. Debugged developer database problems, produced SQL trace files, and ran scripts to modify data. For SOX compliance, sanitized production data for development and testing environments and furnished information to auditors. Worked with SQL*Net to create and alter Oracle network configuration files and with tnsping to test and debug Oracle database network connectivity. Show less

Developer / Analyst,

• Jan 2006 - Apr 2006

Temporary assignment on Raytheon account for adapting and augmenting Perl scripts for the Cross Functional On-Line System, an automated tool that analyzed and collected data about Service Level Agreement (SLA) Metrics. Telecommuted from Kailua, HI.

Developer/Analyst, Data Analyst, System Architect, and Consultant

• May 2000 - Dec 2005

Senior member of a small team that maintained and documented a scripting, ordering, and account management application for AT&T’s residential products and services (see earlier AT&T position) using OO CASE tools, Oracle, C++, Tuxedo, and UNIX.. Used Microsoft Project for task management. Created architecture topology drawings. Telecommuted from Kailua.

Instructor

• Sep 2002 - Jun 2003

Part-time Instructor for four IT classes in Database Concepts and Database Management Systems Part-time Instructor for four IT classes in Database Concepts and Database Management Systems

Senior Technical Member

• Jan 1998 - Apr 2000

Member of team that developed a script engine to replace non-Y2K compliant software by using object-oriented methods, a CASE tool, and a code generator. Implemented an abstract design to represent algorithmic conditions as data. Designed system interfaces to Zenith, a system supporting telemarketing, real-time and batch ordering, account retrieval and maintenance for AT&T’s residential products and services. Created complex SQL views and base tables, and optimized SQL for the Oracle database. Wrote systems requirement documents for GUI and Table loads. As a Subject Matter Expert for Promotion and Marketing data, Dial 1 Provisioning records and processing of automated Calling Card Orders, advised on data warehouse design for an ordering application meant to integrate AT&T various residential product lines. Also worked with Perl, HTML, CGI.pm, JavaScript and Apache Web Server to help create web forms used to input data for the Zenith Script. Show less

Technical Member II: Object-Oriented Analyst (OOA) and Project Leader

• Feb 1994 - Dec 1997

Helped to design, develop, & maintain Zenith. Project Leader for: enhancing system to process calling card orders received from an Integrated Voice Response (IVR) system; implementing changes required for Third-Party Verification of long-distance service selection; rapid integration of new marketing programs into the application. Mentored new team members. Guided team migration to Sun’s Solaris 2.4, CDE & Oracle 7.3.2. Applied object-oriented methodology to develop data dictionaries, information models, object communication models, & state transition models, & programed state actions using pseudo-code in a CASE tool. Wrote UNIX shell, SQL*Plus, Perl, & SQL Loader scripts to automate OOA tasks. Created complex SQL views & base tables, & optimized database queries by finding slow accesses in application logs & by using Oracle’s EXPLAIN PLAN utility, then tuning queries or creating indexes. Employed code generator to extract CASE tool data & to generate over a million lines of code that included Oracle DDL & DML, Pro*C, C, C++, & Tuxedo. Executed unit & system level tests. Supported the quality assurance, performance testing, & production teams. Inspected & debugged code, investigated problems, identified root causes, & repaired defects. Designed subsystems to store marketing promotion data & to transmit records for provisioning & fulfillment of long distance service, incentives, & consumer data. Created the architecture topology drawings & system design for processing calling card orders received from an external Conversant system. Wrote system & design requirements. Served as the team's initial function point representative. Helped develop then documented OOA st&ards on internal web site. Implemented enhancements that improved performance metrics, reducing processing of provision & marketing records & script initialization by nearly a third. Learned to work with AT&T’s Software Development Life Cycle (SDLC) methodology. Show less

Technical Member I, Technical Associate: worked as a Database Design, Developer, & Systems Analyst

• Sep 1990 - Jan 1994

Designed a data warehouse database and application for 400 users that supported payphone long-distance marketing and sales. At 22-gigabytes in April 1991, MDSS was briefly the largest Oracle implementation in UNIX. Also part of the systems architecture group. Designed and created tables, indexes, views, private and public synonyms, and database triggers. Analyzed and developed data warehousing design, physical database design, capacity planning, and disaster recovery strategy with team. Worked with clients to know their data needs, business processes, and requirements. Worked with management to design a data architecture strategy. Created and maintained data dictionaries, data validation scripts, and entity/relationship (ER), data flow, and architecture topology diagrams. Utilized Oracle’s CASE tool. Wrote requirements to Extract, Transform, and Load (ETL) data. Used Oracle import and export utilities, maintained Oracle Forms code (PL/SQL), and coded SQR reports. Optimized database performance with query tuning, indexes, and aggregation of data in summary tables (now known as materialized views). See link for mention of MDSS in 1991 Oracle annual report. Show less