SUMMARY:

• Database designer, developer, DBA, UNIX administrator in consulting, technology startups, healthcare, R&D, QA/Test, manufacturing, government, and HW/SW OEM industries. Lead developer for projects in Property Tax Assessment, Billing Systems, Content Management Systems, Financials, BI and Confidential, HRMS, and Enterprise Reporting. Enterprise project experience in test automation, POC, data storage product benchmarks, data warehousing and business intelligence (BI). Deep hardware experience with capacity planning, storage and RAID strategy, ILM policy, tape archival, storage pools, and hardware specification. Experience with designing enterprise solutions of database DR, site fail - over, HA, RAC and node clustering. Experienced in data architecture, normalization, query optimization, index design, clustering, multi-threaded programming, and data model validation. Non-technical experience in presentations, proposals, technical writing, and public speaking. Product rollout experience with product launch, administration, maintenance and legacy data merge, platform migration, upgrade, and change management.
• System architect experience in quantifying risk, prioritizing design objectives, designing data interfaces for enterprise data warehouses, designing information solutions for external and internal customers. Deep experience selecting hardware, operating system installs, file system configuration, logical volumes and physical storage design (OCFS, Bigfile, DBFS, +ASM), storage and server virtualization (VMware RDM, VMDK), and best practices for RDBMS tablespaces, data files, and parameters. Experienced with several Enterprise Application Service platforms for SOA (WSDL) J2EE Application Servers. Skilled in reverse engineering data systems for analysis and reporting (EDW, BI), troubleshooting variety of enterprise DB Applications (Oracle Apps, MS Financials, Content Management, ALM). Platform experience on Solaris, OVM, VMware, Linux, Mac, Windows, and AIX. UNIX or Windows capable with networking, services, security, file systems, host bus. Design with RUP and UML, programming 4GL imperative, procedural, logic programming, and scripting.
• Mechanical and Controls Engineer in Manufacturing, R&D, Product Test. Turnkey designer for OEM-SI (system integrator) facilities and R&D test equipment. Experienced through all phases of machine design and controls programming through UAT and commissioning. Created AutoCAD mechanical, electrical design and schematic drawings, and programmed complete control system including PLC, real-time control, DAS, SCADA, and HMI. Supported and trained customer operators, and created OEM maintenance and documentation manuals.
• Project Manager and Team Lead with experience defining technical and business requirements, scheduling and tracking projects, estimating budgets and developing revenue. Commissioned equipment and created product proposals, technical documentation, and customer training.

PROFESSIONAL EXPERIENCE:

Database Solutions Architect

Confidential, Denver, CO

Responsibilities:

• Converted to FTE after 2 months consulting engagement at Confidential.
• Designed pilot program test harness in Python for certification with HDS storage.
• Performed competitive analysis for HDS Unified Converged Platform vs. Oracle Exadata.
• Analyzed Confidential replication (HUR) with Oracle RAC Extended Distance configuration.
• Performed C# 4.0 and 5.0 code reviews in Visual Studio 2010 and 2012.
• Designed code enhancements for C# 5.0 .NET 4.5 with Team Foundation Server (TFS 2010).
• Generated storage analysis for Fortune 500 customers using internal tools.
• Created enterprise SAN FC storage analysis and database analysis from Oracle AWR reports.
• Performed Oracle benchmarking on modular and enterprise HDS storage arrays.
• Analyzed IOPS, bandwidth, and latency with least squares regression of benchmark output.

Environment: Visual Studio 2010 and 2012, Team Foundation Server 2010, C# 5.0 with .NET 4.5, Python 2.7, Oracle Linux 5 and 6 (OEL), RedHat Enterprise Linux 5.5 and 6.2, Oracle 11gR2 EE, Oracle 12c EE, Windows Server 2008 R2, MSSQL Server 2008R2, MSSQL Management Studio, Oracle SQLDeveloper, OEM Grid Control 10gR5, OEM Cloud Control 12cR3, Oracle RAC, HUS-VM and HUS-150 Enterprise storage array, Confidential Compute Blade 2000, Compute Blade 500, Confidential Blade Management Server, VMware ESX, VMware Fusion (Mac), VirtualBox 4.2, Swingbench 2.4, ORION (Oracle IONumbers benchmark), Oracle CALIBRATE IO package, Oracle RMAN, Confidential Command Suite, Confidential Tuning Manager, Confidential Tuning Manager Agent for Oracle, Confidential Storage Navigator.

Sr. Data Warehouse Consultant

Confidential, Denver, CO

Responsibilities:

• Confidential consultant to City and County of Denver Technical Services.
• Designed and coded Operational Data Store and Data Mart of property tax assessment data.
• Designed solution to hold incremental, multi-edition, Property Tax data served to the public.
• Developed on OEL+11gR2 Oracle VM, environment deployed on VMware RHEL5 vSphere.
• Developed using Data Modeler + SQL Developer and ODI 11.1 topology, ETL, scheduler, agent.
• Coded ODI interfaces, scenarios, packages, with calls to Python, PL/SQL, SQL, Bash scripts.
• Transformed 0NF mainframe extracts to 1NF in Staging ETL and again to 2NF/3NF in ODS ETL.
• Designed and forward engineered Logical (LDM) to Physical (PDM) for Staging and ODS.
• Designed metadata to transition from mainframe tax system to new MSSQL + ADO.NET system.
• Coded incoming data quality cardinality validation in staging and metadata capture in ODS.
• Created complete Python + PL/SQL metadata pre- and post-processing using ODI.
• Data subscribers include SOA web services, internal Assessment, website, other agencies.

Environment: SQL, Oracle PL/SQL, BASH script, Python 2.7, Jython 2.5, Oracle 11gR2, Oracle SQL Developer 3.1, Oracle Warehouse Builder, Oracle DataModeler 3.1, Oracle JDeveloper, SQL*Plus, MS-SQL Server 2008 R2, SQL Server Management Suite, Visio 2010 Pro, Oracle Data Integrator (ODIEE) 11gR1, ODI Change Data Capture, MS SQL Change Tracking, ODI Data Quality, ODI RCU, Red Hat Linux (RHEL5 U5) system administration, VMware ESX 4.1, VMware Fusion (Mac OS X), VirtualBox OVM, Solaris 10, vSphere, vMotion, EMC CLARiiON and Symmetrix, RDM, VMFS, Manatron GRM and CustomCAMA, Mainframe MVS.

Sr. Exadata Technical

Confidential, Denver, CO

Responsibilities:

• Oracle corporate employee assigned to assess Fortune 500 companies for pre-sales Exadata readiness, execute Proof-Of-Concept, demonstrate Exadata performance and compatibility.
• Performed Exadata RAC and storage node configurations, supported customers and provided remote and on-site troubleshooting of new Oracle Exadata product in a customer-facing role.
• Executed complete POC within the sales cycle of VLDB (terabyte scale) customer data sets.
• Tuned SQL execution times in competitive analysis of Oracle RAC (SMP, inter-node shared everything over InfiniBand) load profiles vs. TeraData (MPP, node distributed index cluster keys).
• Delivered vendor and reseller presentations in customer-facing speaking engagements, Exadata workshop instructor, and Exadata conference guest speaker.
• Executed TB data set platform migrations from Solaris SPARC to Oracle Linux.
• Tuned, optimized SQL for Oracle 11gR2 RAC, Exadata compression, flash cache parameters.

Environment: Oracle Exadata Database Machine V2 and X2, Oracle 11gR2, Oracle +ASM, Oracle RAC (clustering, clusterware), Oracle RMAN, Exadata Storage Software 11.2, Oracle Grid Control, Oracle DBControl, Oracle Linux, Oracle Solaris, VirtualBox (OVM), VMWare Fusion (Mac OS X).

Principal Staff Engineer

Confidential, Broomfield, CO

Responsibilities:

• Development and Ops DBA supporting 16 databases including HP Quality Center 9.x ALM deployment of 250+ users including directors, managers, engineers and testers across Sun.
• Designed and administered automated product testing databases for Sun Storage division.
• Designed and coded Operational Data Store ETL to de-normalize Quality Center data.
• Performed database platform and storage migrations, including cross endian (x86 to SPARC).
• Administered Linux, Solaris 10 (x86,SPARC), OpenSolaris, Windows XP Server.
• Configured and customized application servers JBoss 4, Oracle AS, MX7, and OMS Grid Control.
• Coded Python and VBScript application customizations in QC, BOE, and CF apps.
• Acquired deep DBA experience across Oracle 10.x, 9.2, 8.2, MySQL 5.x, MSSQL 2005.
• Created and used disaster recovery (DR) plan with Oracle 10g RAC, Data Guard and RMAN.
• Designed and deployed db and API integration of Telelogic DOORS and Quality Center.
• Designed database storage policy management of 35+ TB with 50 TB tape scratch pool.

Environment: HP TestDirector for Quality Center 9.x, HP Dashboard for Quality Center (QCD 9.x), Quality Center Open Test Architecture (OTA 9.0), JBoss 4, Apache Tomcat, Oracle 10gR2 RAC (10.2.x), Oracle Data Guard, Oracle Automated Storage Manager (+ASM), Oracle SQL*Loader, Oracle DataPump, Oracle 10gR1 (10.1.x), Oracle 9i (9.2.x), Oracle 8i (8.x), MSSQL 2k, MySQL 4.x, MySQL 5.x, Solaris 8 (SPARC), Solaris 9 (SPARC), Solaris 10 (x86), Solaris 10 (SPARC), Solaris Nevada (11-x86), Solaris 10 global and non-global zones, RedHat Linux AS 3 (RHEL/AS 3), RedHat Linux ES 4 (RHEL/ES 4), RedHat package manager (rpm), Win2k and 2k3 Server, Veritas Cluster Server and Volume Manager, Sun Common Array Manager (CAM), Veritas NetBackup for Oracle, Oracle RMAN 10.2, VTL 1.0, Trinity Archive System 1.x, Oracle OEM (9.x, 10.x), Oracle SQL*Plus, Oracle PL/SQL, Oracle SQL, Oracle opatch, Oracle Recovery Manager (RMAN), SQL, UNIX script (ksh/bsh/bash/csh), VBScript, VisualBasic, Python 2.5, IronPython for .NET, DCOM, COM+, MS CLR, file systems (Oracle ASM, ZFS, UFS, EXT2, EXT3), QLogic SANSurfer and SANTricity, BOE XI R3 (Solaris).

Sr. Database Consultant

Confidential, Louisville, CO

Responsibilities:

• Analysts International Corporation consultant on Continuous Data Protection storage product.
• Designed and executed RDBMS interoperability testing and customer emulation for Confidential .
• Deployed tests on Oracle with Veritas Cluster Server (VCS) and cluster FS (VxFS) on SANSurfer.
• Developed, coded, created Solaris shell scripts for backup automation, system performance data.
• Created database replication, export, import. Performed, recommended index analysis, database tuning, statement tuning, application DB performance analysis and documentation.
• Developed, wrote, executed test plans for 25 Oracle backup and restore test cases, TPC-C benchmarks, simulated cluster failure and failover, wrote defect tracking reports.
• Estimated performance loads, server and storage requirements, and tuned database servers.

Environment: Solaris zsh/bsh/bash/csh script, Linux bash script, Perl 5 script, Rational Clear Quest, QLogic SANSurfer and SANTricity, MyTop, MySQL InnoDB, Toad for Oracle and MySQL, MySQL Super Smack, Oracle TPC-C benchmark, Oracle Certification Environment (OCE), Mobius document server, file systems (UFS, EXT2, EXT3, NTFS, VxFS), SunBlade 150 desktop, SunFire, x4200, Sun and STK disk arrays, STK tape library, Brocade zoning, LSI FC-HBA, Solaris MPXIO failover driver.

Sr. Automation Engineer Consultant

Confidential, Jacksonville, FL

Responsibilities:

• Automation Engineer for Production and Confidential & Confidential Acuvue contact lens manufacturing.
• Converted, debugged, reduced cycle time, improved machine automation control and HMI software for Acuvue production line conversion to new extended-wear product.
• Highly visible, multi-national project of new product marketed by Confidential & Confidential Acuvue, Oasys Lenses.

IT Support Consultant

Confidential, Dillon, CO

Responsibilities:

• Tier III technical support. Administered, maintained, and supported 200+ systems with 250+ users at 23 golf resort locations across multiple time zones.
• Supported, managed, and performed troubleshooting for MS Active Directory, MS Exchange, desktop email clients, Jonas Course Management Software, network hardware infrastructure.

Environment: W2K server, W2K workstation, W2K Terminal Server, WinXP, Veritas Backup Exec, IBM LanDesk, ADSI, MMC, Computer Manager, Task Manager, Exchange Administrator, Outlook 2000, Outlook Express, Outlook Web Access, Event Viewer, Performance Monitor, Command Shell, Jonas CMS, EZ Links, ICVerify, Credit Line, MS Office

Director of Databases

Confidential, Atlanta, GA

Responsibilities:

• Director, lead DBA, database architect and developer for human resources information portal.
• Designed, created, administered snowflake schema MSSQL data warehouse and data mart.
• Designed, created, administered BI solution of HOLAP cubes, snowflake Confidential, and DTS ETL.
• Designed BI cubes for customer, marketing, sales using pre-cursor to SSAS, SSIS.
• Designed Kimball- Confidential snowflake schema by integrating WebTrends Confidential with internal Confidential .
• Created CWS data mart delivery platform that generated $1.2MM in revenue.
• Hired, supervised, developed, trained staff of 10 engineers.
• Customized, administered Kana (MS) CRM, MS Great Plains Dynamics ERP applications.
• Developed POC database platform to MySQL 3.23 on Win2K.
• Refactored website database design using UML, OOP, ORDB (object-relational DB).
• Created complete technical documentation including requirements, software specifications, test cases, programming reference, DB design, data interfaces and procedures.

Environment: Oracle 9i, Oracle HRMS 11i, Oracle Enterprise Manager, Oracle Migration Assistant, Oracle Universal Installer, Mercury LoadRunner / WinRunner, MSSQL 7, MSSQL 2K, MySQL 3.23, MSAccess 2K, SSAS (MS Analysis Server), MS OLAP, WebTrends Intelligence Suite, WebTrends OLAP Manager, Crystal Web Server, Crystal Reports, MS Great Plains Financials, Kana CRM, Rational Rose, DBArtisan, ERStudio, BPWin, Lumigent Log Explorer, MS Data Analyzer, Hyperion and MS cube viewers, Excel Pivot Table, UML, SQL, T-SQL, XML, HTML, VB script, ADO, ODBC, Windows Scripting Host, NT shell script, IIS 4.0, Site Server LDAP, ETL, DTS scripting, MS Visio, MS Project, MS Office, Visual Sourcesafe, NT 4.0 Server, W2K Server

Oracle Applications Team Leader

Confidential, Atlanta, GA

Responsibilities:

• Project Manager, Lead DBA, Financials Administrator, Technical Project Leader for healthcare information portal for physicians and patients.
• Created project schedules, led technical team, managed consultants, wrote documentation.
• Managed, trained staff of three application developers, reports writers.
• Administered Oracle ERP applications (AR, AP, PO, GL, HR, FA, invoicing, lockbox) for 60+ financials users, 30+ data entry, 18 developers across multiple time zones.
• Created databases, designed backup and recovery strategy, applied financials patches, rebuilt indexes, administered security, tuned distributed queries for 6 enterprise database servers.

Environment: Oracle 7.3, Oracle 8i, Oracle Metalink, Oracle Financials 10.7 NCA, Oracle Financials 11i, Oracle HR 11i, Oracle Universal Installer, Oracle Workflow, OEM (Enterprise Manager), SQL-Plus, PL/SQL, Oracle Developer 2K, Oracle Forms 4.5, Oracle Reports 2.5, Oracle WAS, ODBC, JDBC, Oracle Names Server, UNIX shell scripting, UML, Veritas Cluster, Legato Backup Exec, SQLNet, Net8, IBM DB2, MS Visio, MS Project, MS Office, Solaris 7, Solaris 8, NT 4.0