Technical professional with years of experience in database management, design, development and implementation of information systems, as well as budget, resource, staff and project management with particular emphasis in the chemistry, laboratory, petrochemical, information technology and educational industries. Database experience using SQL Server, Postgresql, MySQL and Oracle extends back several years including Master’s degree program. Data Warehouse systems including SQL Analysis Services, Hive, Hadoop, Spark. Reporting systems with Reporting Services (scaled-out) and Tableau Clustered Environment. Proven track record of accurately completing research, reporting, information management, and business-intelligence (BI) development efforts. Excellent telephone and communication skills, with an exemplary record of dependability and reliability. Works well under pressure performing a wide variety of tasks.  

Tripadvisor 
Needham, Massachusetts
August 2013 - Present
Senior Data Warehouse Engineer and Team Lead
  • Everything "Big Data" on Postgresql (HA Distributed) and BI (HA SQL Server, Cube Servers, Reporting Services, Tableau)
 
Massachusetts Department of Early Education and Care
Boston, Massachusetts
June 2011 – May 2013
Lead Database Administrator & Data Architect

  • Implementation of outside consultant recommendations for data operations. This included streamlining/optimizing databases, upgrade modifications and establishing “Best Practices” procedures and extensive documentation to further support operations.
  • Installation, configuration and bulk migration of all legacy instances to an array of 24 SQL Server 2008 R2 and 2012 physical and VMware virtual based servers. This included modification and documentation of security enhancements based on benchmark standards including the Center for Internet Security (CIS) guidelines.
  • Deployment of Utility Control Point and Policy-Based Management for real-time analysis of server array operations.
  • Installed, configured and maintained several Composite Information Servers for Data Virtualization, Data Federation, Cloud and Big Data Integration.
  • Primary technical support for installation, configuration and operation of multiple SharePoint 2010 servers (farms).
  • Developed significant quantities of diverse ETL solutions using SQL Server Integration Services (SSIS), scripting and stored procedures especially pertaining to large data consolidation and transformation for the SQL Server Analysis Services (SSAS) data warehouse operations.
  • Instructed, directed operations and functional tasking for other database administrators. Established protocols for more efficient database administrator to developer interactivity and communication.
  • Developed several C++ based expert system methodologies to perform extensive data repair and cleansing operations for porting pre-existing multiple legacy application data into a newer unified system. This involved consolidating 16 disparate databases into 3 optimized databases while balancing multiple conflicting business requirements.
  • Deployed various networked software systems on Microsoft IIS 7 & 7.5 servers.
  •  Performed installation and integration of complex SOA (Service Oriented Architecture) interoperable services using JBoss, Apache, EngageOne, Dundas, ILog, Composite, SharePoint and SQL Server Reporting Services.
  • Deployed Team Foundation Server 2012 with integrated SharePoint and Reporting Services. Migrated existing Visual Source Safe and TFS 2005 projects into new architecture.
  • Migrated and expanded existing data warehouse onto new SQL Server 2012 platform to utilize several master data features available on the newer platforms.   
  • Deployed and configured servers and instances in multi-DMZ (multi-vLANs) environments.
 

Innovolition
Houston, Texas                                             
April 2010 to May 2011 (self employed)
January 2000 to April 2010
Information Systems and Network Consultant

  • Interesting or noteworthy projects with independent groups, organizations and businesses, often pro-bono. Selected clients include NASA, The Starcher Law Firm, Mirage Enterprises, Holeshot Motocross Park, Trinity Lutheran Church, Texas Environmental Damage Assessment.
  • Continued software development of chemical waste consolidation software package. The software assists with waste combining to achieve the safe combination of disparate chemical mixtures based on their compatibility. The software was written in C++ using linked lists and flat files for information storage and portability. The current rewrite is in Visual C++ with a small profile database backend.  The software is available under GNU licensing.
  • Supported and developed information systems and solutions for multiple businesses.
  • Network installation and maintenance.
  • Point of Sale systems installation and maintenance
  • Developed intranet and internet websites, including wiki group-authoring systems
  • Programmed data acquisition, storage and retrieval using database systems.


NASA - Johnson Spaceflight Center
JIMMS Contract
Tessada and Associates
Houston, Texas
January 2008 to May 2010
Database Administration Architect

  • Administered 14 SQL Server instances hosting nearly 1,000 databases ranging is size from 4 MB to 40+ GB. Primary support DBA on these instances for over 2 years:
    • 1 SQL 2000 instance
    • 6 SQL 2005 Clustered instances
    • 4 SQL 2005 stand-alone instances
    • 2 SQL 2005 Virtual (VMWare) instances
    • 1 SQL 2008 Virtual instance
    • Preparation of the installation of 3 SQL 2008 Clustered instances
  • Maintained SQL instances with absolutely no data loss, database or application downtime except for routine, scheduled maintenance outages.
  • Assumed all tasks of three staff SQL Server DBAs as these employees were lost through reassignment and job attrition and their responsibilities were consolidated into my single position.
  • Position required development and maintenance of DTS (SQL 2000) and BI-SSIS (SQL 2005-8) packages to perform all varieties of data migrations and manipulation.
  • Created over 100 stored procedures to perform a wide variety of tasks.
  • Performed instance/database performance optimization using Dynamic Management Views/Functions, SQL Profiler, Performance Monitor and several other techniques.
  • Provided essential support for legacy applications using MS-DOS batch files, bulk transfers and other pre-SQL 2000 methods of data transfer and manipulation.
  • Regularly consulted with application developers regarding performance modifications to the database structure and objects. Implemented changes or assisted with database modifications.
  • Authored a large quantity of technical writing on best practices, operational planning, projected requirements for future operations, specifications on databases or applications, and yearly, monthly and weekly status reports.
  • Project – JSCMIS (Johnson Spaceflight Center Management Information System)
    • Developed and maintained a complex software and database system to allow Human Resources Department to access sensitive personal information on all JSC employees.
    • Responsible for initial software development in MS Access and regular extraction, transfer, loading and maintaining of the SQL Server database backend.
  • Project – MS SQL Server migrations
    • Performed server migrations of databases, users, packages and functionality from instances of SQL Server 2000 to SQL Server 2005 and later SQL Server 2005 to SQL Server 2008.
    • Upgraded and modified operational packages to support improved functionality and eliminate deprecated or removed functionality and support between the various instances.
    • Adapted instance connectivity to newer security concerns and requirements derived from CIS (Center for Internet Security) benchmark analysis.
  • Project – CSS (Contractor Support System)
    • Developed highly complex ETL (Extract, Transform and Load) packages for the large and critical CSS system to support contracts throughout NASA.
  • Several projects requiring Security Clearance which cannot be specified publicly.


Texas A&M University-Corpus Christi                                         
Corpus Christi, Texas
January 2004 to January 2008
Physical and Environmental Sciences (PENS) Lab Director

  • Created and maintained an online database-driven task system for the PENS department to coordinate support operations. Programmed system in PHP with a user interface allowing the faculty to schedule tasks and review the status of operations and current inventory of research and teaching supplies. The system allowed the coordination of the faculty, staff, graduate assistants and work studies to network and assist each other. The system evolved to include a wiki-based paging system to perform notifications.
  • Managed budget and purchasing requirements for research and teaching labs. Helped researchers extend their limited purchasing power by using an extensive vendor contact network and encouraging them to compete for purchases and services. Arranged for requisition of unused or lightly used equipment to achieve a higher level of efficiency in the departmental operations. Total annual purchases exceeded $5,000,000, and a significant portion was entrusted to my discretion.
  • Designed and implemented an expert system for chemical waste consolidation, cutting costs of waste remediation by over 70%. The system was written in C/C++. It coordinated the combining of hundreds of chemicals and predicted some of the critical physical data about the resulting mixture - such as whether it would become endothermic, exothermic, generate excessive vapor, boil or ignite. Enabling a technician to more accurately predict the outcome of waste consolidation when combining chemical waste in bulk containers, it saved Texas A&M-Corpus Christi $10,000 in its first year alone by avoiding extra packing, transport and disposal costs of multiple intermediate transport containers.
  • Installed and maintained network information systems and high performance computing clusters (OpenMOSIX, Gentoo Linux) with responsibility for construction, programming, optimization, security, maintenance and back-up of file and web-servers and underlying infrastructure. The primary cluster consisted of 12 Dell PowerEdge Servers, totaling 24 Xeon Processors. It was highly specialized and was used for molecular dynamics simulations, checkpointing tools, GIS interpolation, and analysis of gene hybridization. It ran the following software: Open Mosix, Gentoo.org, Intel C/C++ Compiler, Intel FORTRAN Compiler, and several molecular modeling packages.
  • Primary programmer (75% C++, 15% C, 10% FORTRAN) for several professors research projects using the clustered environment. Developed proprietary software packages to assist with many aspects of selected research grants.
  • Molecular Modeling – provided technical support for the Molecular Modeling Initiative at TAMU-CC. Primary focus was investigating selected polymers and interactions with various solvents. Installed and operated an array of software used for molecular modeling by research groups on campus including Spartan, Amber, Codessa, MM3, NAMD, and ArgusLab.
  • Installed and developed a chemistry instrumentation subnet for sophisticated NMR, MSGCs and other analytical chemistry instrumentation. Developed server storage array for the instrumentation output information and methodology for technical analysis using specialized software packages.
  • Robotics: “A Mapping Program for the Pioneer Mobile Robot” – Created a Mapping Project for the Pioneer robots on campus. Authored in C++ with C subroutine modules, it employed an occupancy grid to represent the mapped area and a Bayesian method to update the occupancy probability for the individual cells. One of the more unique aspects of the program was the use of a 2-dimensional dynamic memory module to represent the mapping matrix. This package allowed subsequent students to include this robot mapping functionality in their projects for several research projects
 

Texas A&M University-Corpus Christi                                         
Corpus Christi, Texas
September 1999 to August 2003
Graduate Research Assistant – Graduate Teaching Assistant

  • Created and administered an interactive website for several projects tied to a $2.55 million grant jointly funded by NASA and A&M-Corpus Christi. Attended project meetings, photographed events, prepared images for web use, interfaced with the funded groups, and obtained and posted publications and data.
  • Served as a laboratory instructor for roughly 240 upper-level college students in the fields of advanced physics, organic chemistry, environmental science and general chemistry. Planning and prepared for laboratory experiments, coordinated material orders and inventory, disposed of hazardous chemicals in compliance with federal regulations, and maintained and repaired sophisticated laboratory equipment. Certified first aid and safety training was required.
  • Managed, supervised and trained other teaching assistants and oversaw their activities on behalf of the chemistry faculty.
  • Computer-oriented tasks included administering a Macintosh computer lab for the Science and Technology department, which entailed network administration, software installation, tech support and general maintenance.