Analyzed legacy databases for a new Data warehouse

Consulted at dozens of companies in Data Warehousing (all aspects), Data Science., Big Data, and analysis

Designed and implemented 6 workflows and solved many problems using Alteryx

Fixed data quality problems, designed new DB model and schema, loaded it with data, created and provided complete supporting documentation. Used SQL Server 2014, Toad, Talend, and Excel. Created 3 new Azure VMs.

Designed complex SQL queries for automation and ETL processes. Using SQL Server 2008,2012,2016, Analyzed query operation and output.

Trained in Cloudera, Hive/Impala, and Hadoop. Helped with database design, documentation, and analysis.

Managed and optimized over 25 SQL Server (2008-2012) and 4 Oracle 10g databases, including log shipping, automation, replication, backup/recovery, and performance improvements.

Solved problems and documented databases in SQL Server 2008. Tuned and supported worker’s compensation insurance applications and databases using Toad. Automated processes to enhance data quality. Performed index optimization and worked on MDM project. Performed all DBA functions using Toad and SQLPlus for OLTP and DSS type databases.

Solved many database problems and provided deduping programs (MySQL stored procedures) for overly duplicated tables in MySQL 5.7 databases. Provided methods for preventing further duplications and loaded new datasets and updates, using Toad, SQL Workbench, Slack, Redshift, and Amazon AWS/RDS.

Analyzed test data files for loading into MySQL database Provided guidance for Amazon Cloud service offeringsInstalled and setup MySQL 5.5 database for demonstrationInstalled and setup Talend ETL tool Developed Java job to reformat and load test datafile into MySQL table Created and debugged proof of concept for ETL process

 Performance tuned SQL scripts and Informatica 9.5 mappings and workflows Improved run times for many critical BI processes and ETL workflows Provided guidance for data warehouse design and tuning methods Used partitioning and parallel processing to improve process performance Supported problem solving and ETL processes for Hawq/Hadoop database system Supported DW migration from Greenplum DB to Hawq/Hadoop system Setup and showed that the MS Azure cloud was a viable solution

Installed and created 4 node Percona/Galera MySQL cluster, created tables and tested replication, setup and tested ScanBase for load balancing and parallelization, configured individual database nodes to limit and control replication and failover

 Designed and implemented database schemas in Mysql, Vertica, and Mongo DB Created and administered 12 development databases Created data dictionaries and data models, using Lucidchart and Excel Supported, administered, and tuned MySQL and Vertica databases on AWS Ubuntu  Created databases for CRM and retail transaction support Provided DBA support for development team

 Solved problems in MySql 5.5 Databases, Stored Procedures, Backup, and data migration Instituted Transaction Control into all production Stored Procedures Created data dictionaries and data models, using Toad and MS Visio Supported, Administered, and Tuned MySQL databases on Linux (RHEL) Created databases for Financial Transaction Support Led Team in Agile/SCRUM project management methods

 Executed Proof of Concept for DB2 backup, restore, and suitability for Data Domain file systems usage Performed analysis and verification of best practices in DB2 9.6/7, Oracle 10/11g, and SQL Server 2005/2008 databases Setup and configured Oracle 11g EMCTL, RMAN, and Data Warehouse  Solved many problems in many different database systems Established requirements, use cases, and identified candidate products/vendors for new Enterprise ILM Archiving project Utilized Toad for DB2, Sharepoint, Lynx, and Putty

 Setup RMAN backup system of NASA production and development databases in Oracle 10g and 11g.  Tuned SQL queries and solved problems in MySQL and PL/SQL.  Setup and used Zoho Application Manager for monitoring Linux based computers and Oracle databases.  Utilized Toad for DBA operations, data modeling and ETL processes.  Upgraded databases from 10g to 11g.  Mentored clients in RDBMS, RMAN, SharePoint, Advanced Queuing, and Data Guard concepts and usage.  Installed Oracle 11g on a new Linux machine for production.

 Tuned, solved problems, debugged SQL, Java, and PL/SQL programs in Oracle 10/11g databases for financial applications.  Used Talend for ETL jobs and data migration.  Documented Talend operations and usage.  Administered SQL Server 2005/8 for security and agent job scheduling.  Used Toad for administering Oracle 10/11g databases to support tax applications.  Used and administered Perforce system for document control.  Utilized Mongo DB, PostgreSQL, Hadoop, HIVE, HBASE and NoSQL for ETL testing.

Solved problems in IBM DB2 and tuned SQL Server 2008, provided technical support for database operations

Oracle DBA, Data warehouse design, SQL tuning, shell script writing, technical writing, database migration and conversion, process automation, Discoverant application development and support

Data Warehouse support. ETL process design and BI report development.

Senior Oracle DBA, Data Warehouse Expert, Development, Project Management Consulting at several companies

Solved serious performance/availability issues in a SQL Server (2008) database. Trained in and performed Netezza performance tuning. Administered and supported Oracle 9i databases.

Matlab Programming, PostgreSQL database tuning and support, Image recognition software development, Curl programming. Evaluated the new Windows Azure Cloud system (beta release) from Microsoft.

supported Oracle databases and data warehouses by troubleshooting and performance tuning. Also Administered Hyperion and Informatica. (also worked there from 7/05-11/05)

Led the logical and physical design of the original Zaplet production database in Oracle(8.1 9i, Size: 700G, replicated, partitioned, HA), including design for multimedia digital asset storage. Solved numerous system and database problems while performing all DBA functions and on call in a 7/24/365 system. Setup and administered bug tracking system, PerfectTracker, on MS Access (Windows NT). Setup and used BMC Patrol for DB monitoring. Worked on SQL, PL/SQL, HTML, and Java development. Setup and used Segue SilkPerformer for performance analysis and tuning on Solaris 2.7 in a multi-tiered client/server system. Installed and tested Oracle 9i, for replication, partitioning, and RAC on 800+G test DB. Developed code (Unix shell scripts, PL/SQL, and Perl) to support replication and partitioning. (I was employee #6 in the startup)