Software/Database Architect, Senior Software Engineer* Lead for software defect analysis and elimination, client facing role, on-call for client escalation, and participated on client conferences and visits to propose corrections.* PowerShell scripting to handle client customization requirements without changing production code.* Built performance monitoring tools and maintenance jobs to detect index fragmentation and statistics that rebuilt only those in need using best practices. Plan was modeled using Ola Hallengren’s solution.* Updated database code (procedures, triggers, etc.) to SQL Server 2012/2014 standards from SQL Server 2000.* Replaced SQL CLR code used for time zones with lightweight scalar functions and GUI frontend capable of importing updated time zone configurations including DST updates directly from Microsoft Windows.* Analyzed memory, disk subsystem, network traffic, CPU utilization, component profiling, and more to determine root cause in performance bottlenecks.* Assigned to data analytics projects that included ETL designs to move transactional database (OLTP) normalized structure to data warehouse (OLAP) star schema of dimension and fact tables for near real-time reporting without compromising production processing.* Key participator of change control board with all client facing teams to ensure client requirements were addressed and communicated back to the clients and prioritized to fit SDLC (Software Development Lifecycle) process ensuring faster delivery to meet demand.

Senior Software Engineer, Software Engineer, Technical Service Representative II* Served as database administrator for the engineering team and reviewed all database code before it could be committed to source control. * Created interface engine for foreign system imports able to handle custom rules, multiple input formats, and in-line data transformations. Inputs processed as a whole within a batch to avoid single-record looping algorithms.* Participated in multiple client visits to review outstanding items, investigate install environment, and present recommendations.* Database merge utility capable of combining SQL Server database with respect to all existing constraints (DDL) and programmatically determined proper parent/child data load order with extensive logging.* Database sizing tools to predict future growth based on historic data sampling.* Used Kimble methodology for data warehouse design.

Database Administrator, Network Administrator, PC Tech, Computer Operator* Designed and maintained the data model within ErWin 4.0, provided business rules, and documented procedures.

Computer Operator/Communications Specialist, Top Secret/SCI Clearance, Honor Guard, Veteran