SUMMARY:

To utilize my technical and management skills for achieving the target and developing the best results achievable as quickly as possible. I would like to implement my innovative ideas, skills, and creativity for completing projects and helping guide stakeholders in future endeavors.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Working in the Oracle RAC environment to ensure consistent performance and uptime in the production, test and development environments.
• I manage the Oracle database backup and restore operations using RMAN. I also work to ensure a seamless integration of the Oracle RAC environment with the enterprise mainframe COBOL environment.
• I also ensure the IBM Netezza BI appliance is optimized and running with the IBM DataStage software which is utilized for BI analysis and reporting from both Oracle and the mainframe.
• In addition, I manage the existing printing process for paper invoices using Python scripting and SAP Crystal reports 2016 in our enterprise environments.
• Utilized Agile workflow process tools such as JIRA, Bitbucket, and SLACK to manage development and plan releases.

Cloud Infrastructure Engineer

Confidential, Tulsa, Oklahoma

Responsibilities:

• Developed private cloud solutions for all sizes of business and technology customers.
• Engineered shared hosting, VPS, and dedicated server solutions for everything from budget web hosting to enterprise data centers.
• Produced solutions using the latest virtualization technologies from SolusVM, OpenVZ, KVM and Dell dedicated server equipment.
• Implemented custom cPanel, CentOS, Ubuntu, Red Hat Linux & Windows server solutions for on - premise, shared and private cloud infrastructures. Established Big Data solutions using NoSQL in MongoDB, DocumentDB (Azure) and Apache Cassandra environments.
• Provided relational database administration for Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.

Cloud DevOps Engineer

Confidential, Tulsa, Oklahoma

Responsibilities:

• Migrated existing custom Confidential Student Management system from a client-server Visual Basic 6 application to a PHP/Zend enabled Microsoft Azure hosted Cloud solution.
• 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 responsible for development and implementation of big data solution utilizing Apache Cassandra.

Database Administrator

Confidential, Tulsa, Oklahoma

Responsibilities:

• Managed Oracle database environments, implementing PL\SQL changes and following up with business customers to ensure the infrastructure team as a whole maintained all SLAs with change management review process prior to implementation.
• Migrated existing VMWare and physical servers from their current environments into Microsoft Azure.
• Implemented the OneOK Oracle BI solution utilizing Attunity.
• Engineered additional BI environments using IBM Cognos analytics and Oracle for OneGas.
• Developed custom ETL packages using Informatica 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 database support.

Database Administrator

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Developed custom Python scripts to monitor and administrate separate Oracle instances at each of the 500+ Hobby Lobby retail locations.
• Managed all corporate ETL through Informatica, to transfer data between SAP, Sybase Anywhere and Oracle both virtual and physical in clustered and non-clustered environments.
• Provided Oracle 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 PL\SQL and Python code.
• Also responsible for migrating Enterprise MySQL environments to Microsoft Azure SQL Server 2012.

Database Manager

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Led a team of DBAs (Oracle, SQL Server, PostgreSQL, and 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 Oracle databases of record.
• Provided custom Business Intelligence reports utilizing IBM Cognos analytics.
• Fine-tuned existing Microsoft SQL Server Analysis Services OLAP cubes to increase business intelligence processing times by over 400%.

MSPRC Release Manager

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Planned and implemented the MSPRC data center in Oklahoma City with the help of the IT Director, Network Engineer, Incident Manager and System Engineers.
• Developed highly encrypted Python scripts customized for use as ETL and EDI x12 solutions to automate collections for three call centers operating under the guidance and support of the Chickasaw Nation and the Federal Government.
• Worked directly with CMS (Medicare) to develop new EDI standards for Medicare collections and custom CPT (Care Patient Terms) for specific Medicare billing resolutions.
• Administrated all Oracle database server environments, including migration from physical servers to VMWare virtual machines, with the planning and scalability of VMWare high availability using dual NetApp storage area networks with Cisco routing equipment.
• I also served as the Release Manager and gained COTS customization certification in HP Service Manager, HP Connect-It, and HP Orchestrator.
• Also responsible for the daily production MySQL database administration.

Database Administrator

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Single point of contact for all of the Microsoft SQL Server database administration, application development and Compco MySoft.net Telecommunications Workflow software.
• Saved Washington D.C. (ATOW) over 4 million in annual revenue by designing custom a custom Microsoft Visual Basic 6/Microsoft SQL Server client application with Microsoft SQL Server Analysis Services (SSAS) dashboards and Microsoft SQL Server Reporting Services (SSRS) integrated reporting.
• Re-Engineered Compco MySoft.net tool to allow custom billing using Oracle Financials (Delphi).
• Administrated all Microsoft SQL Server database servers including upgrades and backups.

Business Intelligence Analyst

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Developed and implemented custom business intelligence and reporting solutions for local companies using Oracle, MySQL & SQL Server databases along with Business Objects, IBM Cognos analytics and SAP Crystal reports. Consolidated CRM & BI solutions for all Williams-Sonoma call center locations.
• Saved the company an estimated 2.8 million in annual IT support costs. Developed 345 highly customized SAP Crystal reports for Abbott Labs medical diagnostic equipment infrastructure in Chicago, Illinois.
• Engineered custom LAMP (Linux, Apache, MySQL & PHP) web application for use by Mary Kay cosmetics consultants (known as pinkoffice.com).

Database Administrator

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Engineered an Informix Online v7.3 RDBMS running with AIX OS on an IBM RS/6000 server mainframe platform.
• Developed a fuel network tracking system using Microsoft Visual Basic 6, involving the persistent parsing and loading of data (ETL) from fuel terminals throughout the USA into the corporate Informix database management system.
• Implemented hundreds of real-time fuel network reports utilizing SAP Crystal Reports Enterprise server.