SUMMARY:

• Multi - system DBA and Database Systems Engineer with 18 years experience. Extensive project management experience, including two $500,000 datacenter builds and 4 data warehouse builds, extensive troubleshooting skills with VMWare mounted database servers, excellent skills in t-SQL, SSIS, BI Stack, Oracle, Teradata and Business Objects. Previous experience working with international business markets and extensive M.B.A. coursework in Finance, Leadership, and International Business.
• Specification, design and install of multiple Windows server OS systems from NT 4.0 through Server 2016. Specification, design and implementation of multiple MS SQL systems, from SQL 7 through SQL 2017 Specification, design and implementation of multiple Oracle systems, from Oracle 8i through Oracle 12c, both Windows and UNIX foundations. Complete hardware build for multiple Database systems, from server specification, SAN or NAS, Brocade switching, Array and LUN assignments, and Cisco core and edge switching requirements. Experience with HA and clustered solutions for MS SQL, including multimode clusters in Microsoft, MS SQL 2014 HA clusters, and Oracle RAC. Extensive work with ESX and VMWare optimizations for SQL systems. Strong experience in ETL operations, SSIS packages for ETL, and various data migration tools including TPT, Golden Gate, and SSIS. Extensive work with Backup, DR and recovery SLA’s for mission critical databases, including yearly testing and compliance. Strong t-SQL and pl/SQL as well as work and familiarity with pSQL
• Sybase SQL, and Gupta. Strong experience writing SSIS packages, stored procedures, functions, and triggers. Excellent data mining skills. Solid experience in SQL optimization, query optimization, and daily system monitoring for dead-locks, blocking and handling data isolation levels within FERPA and HIPA guidelines while maintaining usability. Solid troubleshooter for SQL systems and underlying hardware, bringing a unique ability to look Confidential just simple database or hardware solutions. Experience with multiple database and server monitoring tools, including Idera, Apex SQL, and Solarwind’s Orion.

PROFESSIONAL EXPERIENCE:

SQL OLTP DBA

Confidential, Keiler, WI

Responsibilities:

• Met with stakeholders and data users to determine database parameters, including stored procedures and database embedded functions to be included with the Unknown Chemical Analytics database. Provided feasibility and process studies to determine build requirements and scope. Provided updated ER-model database design with Erwin Data Architect tool. Provided technical expertise on SQL version update from SQL 2014 to SQL 2017. Stood up dedicated MS SQL 2017 database servers, including OS build and SQL Instance launch. Designed and implemented OLTP Datamart Design and Build in MS SQL 2017. Rebuilt
• ETL process to ingest HPLC, LCMS, and GCMS data outputs in SQL 2017. Worked with Chemists and Chemical Engineers to vet data inputs, determine required computations, and identify critical data processes. Wrote required stored procedures for data handling. Provided back-end for MS SQL concepts, such as stored procedures, DW design, and data normalization and integrity.

Skills Utilized: MS SQL 2012, MS SQL 2016, ETL, Application development, SDLC (ITIL), Application Data Migration, SQL Server build, Backups and Restores, MS SQL Patching, tSQL, Stored Procedures.

Consultant-Teradata DW Admin

Confidential, Detroit, MI

Responsibilities:

• Designed and built enterprise level data warehouse and corresponding data mart to provide extra-departmental data-users timely access to critical UIA data, replacing an obsolete flat-file report generation. Provided technical assistance, analysis, and recommendations for MS SQL server, including cluster failure diagnosis, troubleshooting a data migration issue due to ODBC connection problems caused by memory buffer crashes and helping to establish procedures for handling the VLDB instance housed in an aging MS SQL 2008 R2 instance. Provided ongoing query writing support to data-users needing ad-hoc report generation, assisting in ongoing efforts to optimize existing queries by identifying and addressing poorly written queries.

Skills Utilized: MS SQL 2008, MS SQL Reporting server, ETL, Teradata, TPT, SSIS, Application Integration, Application Data Migration, MS SQL Server Replication, Backups and Restores, Data Analysis, SAP, Oracle, t-SQL, pl/SQL, MS SQL Optimization and query analysis, Data Mining, Capacity Planning, Database Security (Teradata, MS SQL, Oracle 11g), Database Disaster Recovery, Database testing, Government Policy and Procedures, written documentation, project planning, ERWIN, Database design.

SQL OLTP DBA

Confidential, St Louis, MO

Responsibilities:

• Designed, built, and launched a successful database backing a VB written application that can process and identify unknown chemical samples based on comparing chemical instrument analysis to known sample responses stored in the database. Analyzed data structure requirements and processes, provided recommendations for development and changes to current front end process to better handle data manipulation and calls.

Skills Utilized: MS SQL 2012, MS SQL 2014, SSIS, REST API, ETL, Data Integration, MS SQL patching, Server build, MS SQL build, Backups and Restores, MS SQL Optimization, SDLC (ITIL), Performance tuning, t-SQL, Stored Procedures, triggers, MS SQL Automation and Jobs, database design, ERWIN, Project Management.

Consultant-SQL Systems Engineer, Process Engineer

Confidential, Iowa City IA

Responsibilities:

• Through troubleshooting and configuration changes established a x6 increase of throughput for VMWare housed SQL servers and a significant reduction in latency. Provided a PCI compliant process for a retail outfit that had failed its initial PCI compliance audit, including data scrub of card-holder information. Built new ETL processes used to maintain central to local data pushes at new store locations, built key data mart for Point of Sale operations. Provided process analysis of new store operations and new store opening procedures.

Skills Utilized: MS SQL 2012, Point of Sale (Micros, NCR), application integration, ETL, secure data, VPN, security mitigation, PCI Compliance, Security Compliance.

Consultant-SQL Systems Engineer

Confidential San Diego, CA

Responsibilities:

• Through troubleshooting and configuration changes recovered an ~40% increase of throughput for VMWare housed SQL servers and a significant reduction in latency.

Skills Utilized: MS SQL 2008, MS SQL 2012, MS SQL 2014, Backups, Restores, Replication, log shipping, MS SQL server optimization, tSQL queries, stored procedures, server builds, MS SQL server builds, troubleshooting.

Consultant-SQL Systems Engineer

Confidential, Minneapolis, MN

Responsibilities:

• Designed and implemented key data warehouse and data-mart ETL process to facilitate business merger processes using SSIS and INTAP Provided Project Feasibility Study for systems rebuild of ACH and Billing application. Designed and implemented data warehouse and ETL process to pull data from an outdated GUPTA database to MS SQL 2012. Designed and implemented an OLTP database in support of an active al process, including grading, support, and financial modules.

Sr. Systems Administrator/ Interim Assistant Director

Confidential, Iowa City, IA

Responsibilities:

• Project lead for Blackboard Transact 3.6 install, including data import from 2.9 Oracle 10g database to the 3.6 Oracle 11g database. Technical lead on Blackboard PCI compliance verification, including resolution recommendations and re-evaluation of Blackboard resolution attempts. Project lead for StarRez housing system implementation Project lead for the Housing data warehouse design and implementation, supporting data imports from Admission’s DB2 data warehouse, Registrar’s Sybase data warehouse, Directory Service’s using MS SQL CDC, and MAUI (PeopleSoft HRMS) Oracle 10g database as well as exports to StarRez MS SQL OLTP and Blackboard Oracle 11g production databases using Erwin backbone for architecture Project initiator for Disaster Recovery evaluation.

Sr. LAN Tech/Sr. SQL Systems Engineer

Confidential, Milwaukee, WI

Responsibilities:

• Project initiator to re-engineer the collections department workflows and processes, including document revision control, document security, multi-departmental document routing, and long-term image archival with OnBase. Led initiative to optimize the SQL environment, achieve test environment; hardened the production SQL servers and wrote policy and procedures for promoting SSIS and DTS packages
• SQL server builds, and SQL reporting. Established guidelines and minimum requirements for consistent SQL server builds. Led $400,000 capital budget project to revitalize and harden the data center, including upgraded MSA1500 SAN infrastructure, new Cisco layer three 4500 series core switch, dual NIC and HBA pathing, main-line UPS, and Liebert cooling system. Assisted with implementation of GSX and ESX VM environments. Served as Project Lead on Transcentive Stock Option approval application rollout, Veritas Backup Exec 10d upgrade, SQL2005 Enterprise Reporting Services rollout, and HP EVA 4400 series SAN infrastructure upgrade.

Oracle Systems DBA

Confidential, Kenosha, WI

Responsibilities:

• Implemented an Oracle 10g upgrade on an AIX 5.x platform. Designed and modeled (ER modeling) db system. Created tablespace, tables and views within Oracle 10g. Documented and catalogued system for reporting group functionality. Designed and implemented a student record archival system migrating and integrating data from the current PeopleSoft ERP, legacy SAS, and db2 data systems.

Network Administrator

Confidential, Pleasant Prairie, WI

Responsibilities:

• Planned and implemented installation and integration of more than 8 core infrastructure systems across 5 sites including:
• Active Directory 2003 and Exchange 2003 domain upgrade
• Project Police squad computer system
• VoIP with legacy PBX system
• 911 telecom system upgrade (including contractor oversight)
• Iceplex expansion and Recplex system datacenter upgrade

IT Analyst and Direct Import Coordinator

Confidential, Lake Forest, IL

Responsibilities:

• Managed and implemented IT and EDI changes. Coordinated direct import process from Asia, China FTE's and South Korea manufacturers to the United States. Managed 5 servers and 23 office machines, TCP/IP LAN network, telephony, and production and warehouse IT support.

Network Security Administrator

Confidential, Rolling Meadows, IL

Responsibilities:

• Provided security administration acrosmultiple environments, including HP-UX 10.2 and 11.0; Windows server 2000 and NT 4.0; VSE mainframe with CICS; Peoplesoft 7.5; and 8.0 running against Oracle 8i. Created profiles, maintained DNS, and administered Checkpoint-1 firewall.