Database Administrator Tech Support
Resume:
Phillip M. Hanson
San Antonio, TX. 78253
***********@*****.***
WORK SUMMARY
20+ Years of experience in troubleshooting in all versions of the Windows Operating system, well versed in MAC OS, Linux, Android, and Windows CE.
20+ years of experience imaging PCs and Laptops using Ghost (Imaging) software on a peer to peer connection as well as mass imaging using switches and networks.
19+ years of aviation maintenance experience working on multiple airframes as an electrician and armament repair specialist.
20+ years of experience maintaining databases and performing troubleshooting in the MS SQL environment from version 2003 to Current.
16+ years of experience instructing classes on ULLS-A(E) which is a maintenance and logistics software used by the US Army for tracking all maintenance and parts requisitions.
20+ Years of experience using T-SQL, MySQL, and very little Oracle.
20+ Evaluating, updating, and testing software used by the US Army and Air Force to track flights, part orders, maintenance steps, etc.
20+ Years of experience troubleshooting both hardware and software issues to include peripherals, networking, and any other issues that arise.
Currently maintaining a Secret level Clearance
EDUCATION
A+ Certified through CompTIA and Pearson Vue 6-1-2015. Expires Jun 2024 Security+ Certified through CompTIA and Pearson Vue November 2018 Expires Nov 2024 – Have all necessary documentation to renew easily. MCSA Certification – Azure Database Administration – This is through Microsoft. Exam is on 09/02/2022
MS-PowerShell – Attended formal training by Microsoft Engineers in February 2020 FCC Certification obtained from North Central Institute in Clarksville, TN. For radar endorsement.
PROFESSIONAL EXPERIENCE
Softworld/DSA, Database Administrator, Data Engineer Oct 2018-Current
Perform queries in SSRS, SSAS, SSIS, and SQL server for information to be used in analyzing information for the US Air Force.
Write, run, and analyze scripts in SQL, Power Shell, and SSMS.
Perform on the spot troubleshooting with servers on the Azure cloud and through remote access and VM.
Leverage Features such as Service Broker and Replication to assist with processes and speed up performance.
Troubleshoot, set up, and repair Replication in SQL and using SSMS
Troubleshoot issues with new software builds
Communicate with and assist the development team with troubleshooting and eliminating errors found during the upgrade and validation process in the Pre- Production environment
Implement changes to production databases
Training/Assisting other users with the functions of the G-TIMS software.
Perform taskings assigned in the JIRA website which can include everything from an insert script to extensive troubleshooting.
Created Automation for backups, transferring to offsite storage in the same automated job, and setting up automation for many mundane tasks that would otherwise take hundreds of manhours to complete
Implement new software and database versions/builds
Perform maintenance and pruning to ensure storage is being efficiently
Migrate data from legacy systems to the cloud environment in Azure.
Install, and configure click once software to provide information and an interface for the Air Force to enter flight information and other data on a thin client.
Troubleshoot network connectivity, security, hardware, and software issues across a cloud and VM platform.
Working with Python and learning from developers.
Attend meetings to strategize release dates and availability
Communicate clearly and concisely with developers, government personnel to include Air Force pilots and GS reps to better assist with improvements to be implemented to the software and databases.
Create documentation and standardize the procedures used to set up, troubleshoot, and create reports to be used by the customer.
All duties performed are on MS SQL 2003-2019, Visual Studio 2017, PowerShell, VM, TSQL, and Azure.
Applied Training Solutions, Modeling and Simulations Engineer Oct 2017-Oct 2018
Build simulations in EDMSIM (Emergency and Disaster Relief Simulator) to be used in FSEs (Full Scale Exercises) that include maps built in Esri tool, RDAC, and ArcGIS, to simulate the emergency, personnel, vehicles, and any other entities needed.
Provide a COP (Command Operating Picture) to the EOC (Emergency Operation Center) utilizing Google Earth or WebEOC in conjunction with the EDMSIM in order to provide situational awareness to the emergency manager and command group.
Create and run simulations, add injects, and assist with guiding the simulation in a direction that supports the Garrison Commander’s guidelines and training objectives being evaluated by an external entity in the MSEL (Master Scenario Events List) tool.
Provide coverage and injects from the White Cell (A room where SMEs make phone calls and enter data in the MSEL tool that help drive the story for the emergency scenario).
Assist the Exercise Design and Control Lead by creating reports (AARs (After Action Reports), Trip Reports, Welcome Packages, and any other documents needed to better assist units with meeting their objectives.
Provide training to SMEs (Subject Matter Experts) in the operations of a White Cell and provide assistance at any time with technical issues.
Ensure there is internet Connectivity by means of MiFi, Wi-Fi, or commercial internet at each unit.
Vencore Services and Solutions, Senior Database Admin III December 2011 – October 2017
Perform troubleshooting on all hardware and software to include the utilized to track all maintenance and supply requisitions for the 1 st
Combat Aviation Brigade
in Fort Riley Kansas.
Perform maintenance procedures such as backups and overall database maintenance in MS SQL 2003-2012. Also perform updates to the database and the ULLS-A(E) software which is used to track all maintenance done on aircraft and to order parts/equipment, maintain inventory, and track order progress.
Provide over the shoulder technical assistance and give impromptu classes to the customer for them to better understand the software being used.
Deploy to any operations the unit is assigned to and provide 24-hour support to the customer whenever and wherever needed with little to no notice.
Software being used as follows. MS SQL 2003-2012, ULLS-A(E) (Unit Level Logistics System Aviation Enhanced) MS Office 2003-2013, GHOST Vencore Services and Solutions, Associate Systems Analyst/Instructor April 1, 2007 – August 12, 2011
Provide professional, formal instruction to customers in the US Army on the proper operation, troubleshooting procedures, and overall maintenance of the ULLS-A(E) software and MS SQL 2003-2012.
Provide troubleshooting and overall assistance in a help desk environment to the customer over the phone.
Perform testing on new versions of the software and provided assistance and input to the programmers to ensure a quality product.
Set up and update databases from older versions to current using MS Access and MS SQL.
Travel from unit to unit for months at a time to provide formal classes, set up database, fabricate CAT-5 cables, establish a network, provide over the shoulder assistance, and answer any questions the customer has.
Create power-point presentations for use with instructing classes to the TRADOC
(US Army Training and Doctrine Command) standard.
DynCorp International, Armament/Electrical/Avionics Technician September 2006-February 2007
Performed both planned and unplanned maintenance on the weapons, electrical, and avionics system on the Alpha and Delta models of the Apache helicopter.
Replaced plugs and wiring harnesses.
Uninstalled and reinstalled components.
Soldered circuit cards.
Managed inventory.
Was assigned the position of database administrator on MS SQL to support the ULLS-A(E) software used to track all maintenance and supply requisitions.
Performed user level troubleshooting on logbooks and other various hardware. United States Army, AH-64A/D Apache Weapons/Electrical/Avionics Technician September 2000-March 2006
Performed both planned and unplanned maintenance on the weapons, electrical, and avionics system on the Alpha and Delta models of the Apache helicopter.
Replaced plugs and wiring harnesses.
Uninstalled and reinstalled components.
Soldered circuit cards.
Managed inventory.
Was assigned the position of database administrator on MS SQL to support the ULLS-A(E) software used to track all maintenance and supply requisitions.
Performed user level troubleshooting on logbooks and other various hardware. Gateway Computers/GE Tech-Team, Tech Support/IT
June 1997-May 1999
Provided customer technical support over the phone.
Provided step by step instructions to the customer to resolve both hardware and software issues.
Assisted both domestic and corporate customers with technical issues.
Ordered replacement parts when needed to be shipped to the customer.
Was assigned a team lead position over 12 personnel.
Performed semi-annual performance reviews for my personnel.
Instructed classes of up to 20 students at a time on general troubleshooting and telephone etiquette.
Provided next tier troubleshooting when an issue was escalated or if the customer requested to speak to a manager.
Contact this candidate