SUMMARY

• I have been involved with database administration, application development, cloud migrations, BI analytics and a vast array of technologies over the past 24 years.
• I am also an expert with ITIL, agile and DevOps methodologies using Bamboo and Redgate CLI for database level CI continuous integration and CD continuous delivery.
• The bulk of my experience has been via contract engagements, which has exposed me to a wide variety of existing infrastructure and allowed me to add value to any environment.

TECHNICAL SKILLS

• Principal Engineer
• Cloud Data Engineer
• MongoDB System Administrator
• Microsoft Azure Cloud Developer
• Microsoft SQL Server Database Administrator

PROFESSIONAL EXPERIENCE

Principal Engineer

Confidential, Edmond, OK

Responsibilities:

• Returned to the FAA for a brief project via Karsun Solutions, to support the transition of ATOW with migration from Oracle RAC to MariaDB in AWS.
• Managed existing FAA Oracle RAC 12g including PL/SQL reviews and implementation as well as general database administration.
• Worked with OCHIN to provide a DevOps solution for their Microsoft SQL Server environments using Bamboo and Redgate CLI.
• Responsible for all existing OCHIN Microsoft SQL Server database administration and performance tuning.
• Developed custom application enhancements for ElmTree Systems using PowerBuilder as well as providing support and training for their customer sites across the USA.

Cloud Data Engineer

Confidential, Oklahoma City, OK

Responsibilities:

• Architected production enterprise migration from VMWare SQL Server to AWS based MongoDB.
• Worked with developers and vendors of existing applications to ensure a smooth transition with a through QA testing period.
• Managed integration of IBM Netezza BI appliance using IBM DataStage.
• Trained users on Tableau and Power BI to leverage their IBM Netezza.

MongoDB System Administrator

Confidential, Tulsa, OK

Responsibilities:

• Architected cloud solutions for all sizes of business and technology customers.
• Developed custom CentOS bash scripts to migrate MySQL databases to MongoDB.
• Implemented custom DevOps using Jenkins, Chef, Puppet and Ansible.
• Implemented custom cPanel, CentOS, Ubuntu, Red Hat Linux & Windows server solutions for on - premise, shared and private cloud infrastructures.
• Managed Big Data solutions using NoSQL in MongoDB, and Apache Cassandra environments.
• Daily production relational database administration using Microsoft SQL Server, MySQL, and PostgreSQL.

Microsoft Azure Cloud Developer

Confidential, Tulsa, OK

Responsibilities:

• Migrated existing custom College Student Management system from a client-server Visual Basic 6 application to a PHP/Zend enabled Microsoft Azure hosted Cloud based solution.
• This did include engineering the new Azure Cloud Infrastructure.
• Also responsible for managing the existing Microsoft SQL Server 2012 database environments and the development and test environments on the Microsoft Azure SQL Server platform.
• Also migrated MySQL database environments to Microsoft SQL Server 2012.

Microsoft SQL Server Database Administrator

Confidential, Tulsa, OK

Responsibilities:

• Directed the existing Microsoft SQL Server and Oracle environments, implementing changes and following up with business customers to ensure the infrastructure team maintained all SLAs with change management review process prior to implementation.
• Migrated existing VMWare and physical servers from their current environments into Microsoft Azure.
• Designed and implemented the ONEOK custom Microsoft SQL Server BI solution utilizing SSAS, SSRS & SSIS.
• Engineered additional BI environments using Cognos and Oracle for Confidential .
• Developed custom ETL packages using SSIS, PowerShell and Python depending on the database source and destination technologies.
• Architected solutions to automate backups, restores, and storage expansions utilizing the ITIL framework and developing custom workflow integrations utilizing ServiceNow with Microsoft PowerShell.
• Worked with Tivoli to ensure all database backups older than 90 days were still available via external tape request.
• Also trained offshore resources for after-hours first call database support.

Microsoft SQL Server Database Administrator

Confidential, Oklahoma City, OK

Responsibilities:

• Developed custom Microsoft PowerShell scripts to monitor and administrate separate Microsoft SQL Server instances at each of the 500+ Confidential retail locations.
• Managed all corporate ETL through SSIS Packages, to transfer data between SAP, Sybase Anywhere and Microsoft SQL Server both virtual and physical in clustered and non-clustered environments.
• Provided Microsoft SQL Server performance monitoring to establish baselines and adjust resources and/or database settings to achieve higher performance.
• Led weekly code reviews with development teams, provided training on the correct corporate standards and syntax of each database with all T-SQL and C# code.
• Also responsible for migrating Enterprise MySQL environments to Microsoft Azure SQL Server 2012.

Database Infrastructure Team Lead

Confidential, Oklahoma City, OK

Responsibilities:

• Led a team of DBAs (Oracle, SQL Server, Sybase Anywhere) to provide all of the database administration, business intelligence support, documentation, and server maintenance as required.
• Developed custom ETL packages using Informatica to manage transparent data warehouse replication from both Oracle and Microsoft SQL Server databases of record.
• Provided custom Business Intelligence reports utilizing Cognos reporting tools.
• Fine-tuned existing Microsoft SQL Server Analysis Services OLAP cubes to increase business intelligence processing times by over 400%.