We provide IT Staff Augmentation Services!

Lead Sql Database Administrator Resume

PROFESSIONAL EXPERIENCE

Confidential
Lead SQL Database Administrator (Infrastructure Consultant)

Single point of contact for all of the SQL database administration, business intelligence support, and infrastructure planning for the revised ONEOK/ONEGAS corporate split, including:

  • Redefined multiple server hardware requirements based on the need to maximize performance of the SQL component(s) being utilized (i.e. Setup VMWare SQL 2012 BI DEV servers with less virtual resources than either TEST or PROD.
  • Architected solutions to automate backups, restores, and storage expansions utilizing the ITL v3 framework and developing custom workflow integrations with the ServiceNow product, custom .NET SharePoint portal and reported and remediated all SQL incidents and problem tickets.
  • Managed the existing MySQL, PostgreSQL and Oracle environments, remediating incidents and following up with business customers to ensure the database team as a whole maintained all agreed upon SLAs, and ensured my manager approved ALL changes prior to implementation.
  • Custom ETL packages using Informatica, SSIS, PowerShell and/or Python depending on the source and destination data sources.

Confidential
Senior SQL Database Administrator

Worked under the direction of the IT Manager, Jeaux Smith, to engage directly with the retail business (end-to-end) providing database services to all lines of business which included:

  • Developed PowerShell scripts to monitor and administrate separate SQL instances at each of the 500+ Confidential Lobby retail locations.
  • Managed all corporate ETL through SSIS Packages, to transfer data between Oracle (SAP), Sybase (for iOS applications), and SQL Servers both virtual and physical in clustered and non-clustered environments.
  • Provided performance monitoring using PerfMon & ClearTrace to establish baselines and adjust resources and/or database settings to achieve better SQL Server performance.
  • Attended weekly code reviews with development teams, providing training on the correct corporate standards and syntax of each database and all T-SQL.

Confidential ,(contract through Partners Consulting, LLC.)
Lead SQL Database Administrator (DBA Consultant)

Lead a team of DBAs (SQL, Oracle, Sybase) to provide all of the database administration, business intelligence support, and server maintenance including:

  • Architected solutions to automate backups, restores, and storage expansions utilizing the ITL v3 framework and developing custom workflow integrations with the ServiceNow product, custom .NET SharePoint portal and reported and remediated all SQL incidents and problem tickets.
  • Developed custom ETL packages using Informatica, SSIS, PowerShell and/or Python depending on the source and destination data sources.

Confidential, (Federal Government Contract)
MSPRC SQL Database Administrator (ITIL Release Manager)

Single point of contact for all of the SQL database administration, business intelligence support, and software release management including:

  • Planned and implemented the MSPRC data center in Oklahoma City with the help of the IT Director, Network Engineer, Help Desk Manager and VMWare System Engineer.
  • Developed highly encrypted custom Python scripts for use as ETL and EDI solutions to automate collections for three call centers operating under the guidance and support of the Chickasaw Nation and the Federal Government.
  • Administrated all SQL Server 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 Nexus routing equipment.
  • ITIL v3 trained and certified I also operated as the Software Release Manager as well as being trained and certified in HP Service Manager, HP Connect-It and HP Orchestrator.

Confidential (Federal Government Contract)
SQL Database Administrator (Principal Engineer AMI-400)

Single point of contact for all of the SQL database administration, application development and Compco MySoft.net Telecommunications software as follows:

  • Saved Washington D.C. (ATOW) over 4 million in annual revenue by designing custom SQL Server SSAS dashboards & SSRS business intelligence data warehouse solution.
  • Re-Engineered Compco MySoft.net tool to allow custom billing using Oracle Financials (Delphi).
  • Administrated all SQL Server database server environments including upgrades, backups, maintenance and custom data export service requests.

Confidential, LLC
Database Administrator (SQL & MySQL)

  • Developed and implemented custom business intelligence and reporting solutions for local companies using SQL Server, MySQL & Oracle databases along with SSRS, Business Objects, Cognos & Crystal Reports.
  • Consolidated CRM & BI solutions for the entire Williams-Sonoma corporate and all call center locations.
  • Saved the company an estimated 2.8 million in annual IT support costs.
  • Developed 345 highly customized 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 (now known as pinkoffice.com).

Confidential,
Database Administrator (SQL & Informix)

  • 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, 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 Crystal Reports Enterprise server.

Confidential, Inc.
Business Intelligence Consultant

  • Designed and implemented all clinical reporting utilizing Crystal Reports and Cognos with NexGen EMRS.
  • Engineered and maintained Microsoft SQL Server 6.5 production RDBMS environment.
  • Supported existing InterSystems Cache (including custom JavaScript development) & MUMPS EMRS production environments.

Confidential, Inc.
Associate Technical Representative

  • Developed all custom Cognos & Crystal Reports as well as administration and development of modules for the Intellisystems voice response system.
  • Directed the interview and hiring process of new employees.

Hire Now