PROFESSIONAL SUMMARY

Long time IT professional with a multi-disciplinary history of success; education, training, and broad Information Technology experience necessary to excel in new challenges and responsibilities.

experience and successes are in Database Development, Administration, and Data Transfer/ETL

achievements in networking hardware (Lockheed Martin Nuclear Submarine Lab), Cloud/AWS (Pentagon “Mil-Cloud”) web development (CBP NOC Dashboard), programming team lead (CBP Python Data Visualization Prototype)

management experience including US Federal management and regulatory documentation. (CBP/DHS and Technology Management Company)

SECURITY CLEARANCES: DoD Secret (Active and current) July 2016

CBP Full BI -2015

TECHNICAL SKILLS

MS SQL Server 2000/2005/2008r2/2012/2014

ETL/SSIS

Oracle R12 Discoverer

SAP Business Objects XI

Programming languages: C, C++, Java, SQL, Python, Javascript

Proficient at an advanced level in MS Office, (Word, Excel, PowerPoint, Access, Outlook).

Oracle Internet Application Developer: Certificate

PC Technician: Certificate

Web Author/Design using HTML, Macromedia Dreamweaver

CERTIFICATIONS

Security Plus CE

Network Plus

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator:

Insight Global, (Prime is HP Enterprise) United States Marine Corp (USMC) Cyber Command. JUL 2017 – MAR 2018

SQL Database Administrator in an SQL Server clustered Enterprise Data Center

Monitor and support a federal data center comprised of 3 enclaves, multiple SQL Server clusters in an always on environment

Perform routine backup and restore functions and ad-hoc backup and restores to support the enterprise environment customers.

Plan and implement SQL Server version upgrades, 2008 to 2014

Plan and implement SQL Server migrations

ProSoDel, (Contingency contract) APR-JUN 2017

Microsoft SQL Server 2012/2014 exam 70-461 boot-camp

Microsoft SQL Server 2012/2014 exam 70-462 boot-camp

Hickory Ground Solutions, LLC. (HGS), Office of the Under Secretary of Defense, Acquisition, Technology & Logistics, Acquisition Resources and Analyses Directorate (OUSD/ AT&L/ ARA). SEP 2016 to APR 2017

Primary Data Transfer/ETL, maintenance, operations, and optimization of:

oSQL Server 2014 DB

oMongoDB database

oPostgreSQL database

Linux Administrator for secure virtual environment (MilCloud)

o9 Linux servers

oAWS structure for migration of existing financial applications

oApache

oTomcat on DoD

oMongoDB database

Windows System Administrator for multiple Windows servers both in production and test environments

Repeat Consultants LLC (Temp-to-Perm with Concept Plus LLC) Washington Headquarters Service, a DOD entity. AUG 2016 to SEPT 2016

SQL Server Database Developer: responsible for routine backup and restore functions to support the enterprise environment customers

Tableau Administrator, Tableau database reporting application, Administer user list, logins, roles and access

Software Tech Enterprises, US Customs and Border Protection (CBP/DHS). JUN 2015 to AUG 2016. DBA and Application Developer (TITLE: Sr. System Architect-Business Process Re-engineer)

Project lead on 4 multi-year CBP projects: 2 software projects and 2 hardware projects

oData Transfer/ETL, Database Developer/DBA on data mining and data warehouse design project for a 100 TB dataset of sensor data

oLead on a $500 Million dollar, multi-year Java development project leading a team comprised of a Professor at Carnegie Mellon University and his research team to automate and maintain the Nuclear Radiation Sensor network nationwide

oLead on a Remote Satellite-Modem project to support the Nuclear Radiation Sensors. Researched, designed, obtained proprietary access to US Military satellite networks and commercial grade DOD/DISA certified satellite modems and successfully transmitted proprietary formatted sensor data via satellite to military ground station for secure transmittal via secure government network to analysis office

oLead - Application Designer on a Python big-data visualization development project in support of the Nuclear Radiation Sensor project.

oInstrumental on re-writing critical SQL queries to optimize run-time and lessen impact on database services and other user organizations

Database designer using Enterprise Architect, Tableau, and other tools to design, diagram, and document progress of front-end applications and configure the database backend

Database analyst and report writer for proprietary Customs and Border Protection (CBP) very large database

Analyze and suggest updates/ modifications to enhance and optimize the db and/or result sets

Research and prepare documentation and staffing recommendations for staffing-up Data Analysis Center for Threat Evaluation and Reduction (DAC-TER) (CBP) utilizing Department of Homeland Security guidelines and procedures

Prepare presentation and training for new data warehouse functions and data marts additions to CBP database

BAM Technologies, LLC. DEC 09 to JUN 15.

Primary ETL/SSIS Data Transfer Twice weekly full database refresh from 2 VLD US Gov’t Oracle 12c systems (military personnel database (MILPDS), and federal civilian personnel database (DCPDS)

Primary ETL/DBA/Helpdesk Analyst for Air Force Senior Leader Career Management System (SLCMS)

Daily reporting operations using Oracle R12, Oracle Discoverer, and SAP Business Objects to access military personnel database (MILPDS), and federal civilian personnel database (DCPDS)

Working closely with Air Force personnel gathering requirements for complex ad hoc SQL queries to produce reports to specifications on request.

Test, monitor and optimize database queries and tables

Produce technical design documentation from requirements: Working closely with Air Force personnel gathering requirements for ongoing improvements to proprietary client-server application

Liaison with Air Force Board Secretariat and Senior Leader Personnel Operations Administration

Documented and Certified the Promotion Board results for all SR personnel listed above for Congressional review

Web Content Developer:

OpsSoft, Inc. (subcontrator for QinetiQ-North America) CBP/DHS. FEB – NOV 09.

Develop, upgrade and maintain secure web portal and supporting database for a U.S. Customs and Border Patrol, using AJAX, Java, JavaScript, SQL, MySQL, and SQL Server

Maintain and update existing Secure Web Portal/Network Operations Center dashboard using Java, JavaScript and SQL

Produce technical design documentation from requirements: Working from user requirements, upgrade and develop content for web portal

Perform maintenance, updates, and user logins and roles on sql server databases that support web portal functions

SQL Server DBA: Administer user list, logins, roles and access to secure web portal

Project Management Information Systems Manager:

PMIS, Technology Management Company, Chantilly, VA. (Project management firm with over 400 employees and $20 million annual revenues). NOV 07 to JUN 08.

Responsible for the update and maintenance of the Project Management Information System (PMIS)

Perform Daily ETL procedures from multiple sources for PMIS

Design SQL queries and reports to support the project control office

Designed and implemented MS Access databases

Evaluate and recommend IT services and equipment

Information Systems Analyst

TSI Onsite, Lockheed Martin Manassas, VA site. DEC 05 to NOV 07.

ETL Operations: Developed comprehensive parts database by ETL from 5 major Oracle based databases

Administrative and database support to IDP Lab, Production and Test unit

Assist in inventories, audits, data input

Database administrator: operation and maintenance of 5 SQL based proprietary databases

Design and implementation of MS Access databases in support of Sonar Lab operations

Rack Server Technician: service and upgrade of rack servers for deployment to U.S. Nuclear Sub Fleet

EDUCATION/TRAINING

MS, Computer Science & Engineering – Database Concentration, Colorado Technical University, MAY 2012, GPA 3.85

Extensive coursework in database, data warehouse design and implementation

Coursework in requirements gathering and the requirements to design process

Bachelor of Science, Information Systems - Programming, Strayer University, DEC 2008

Object oriented program design in C, C++, and Java

Certificate, Db-Training, A division of Information Systems Consortium, Inc. DEC 2001

Oracle Internet Application Developer Program

Bootcamp: Administering Microsoft SQL Server Databases 20112/2014, Global Knowledge Training LLC, MAY 2017

Plan, install and Configure SQL Server databases

Backup and restore databases

Import and export data

Authenticate and authorize users

Configure and assign permissions and database roles

Use encryption and auditing

Manage SQL Server Agent and jobs

Configure SQL Profiler and SQL Trace and use the Database Engine Tuning Advisor

Monitor data by using Dynamic Management Views

Bootcamp: Querying Microsoft SQL Server 2012/2014, CED Solutions Computer Training Center, MAY 2017

Program with T-SQL

Query multiple tables

Stored procedures and functions

Implement error handling

Implement transactions

SOFT SKILLS

Extensive public contact experience including senior level corporate and congressional liaison

Experienced at conducting informational interviews for requirements gathering for projects or projects

Extensive public contact experience as an investigator

Extensive public contact experience as Helpdesk support

MILITARY EXPERIENCE

U.S. Army, NOV 86 - APR 91

Counterintelligence Special Agent, 501 MI BDE

Demolitions SGT, U.S. Army Corps of Engineers, Combat Corp. 14th ENG BTN

Contact this candidate