Esteban E.

Gonzalez

Database Programmer


Education.

  • Bachelor of Science in TechnologyMay 2003
    University of Houston (Houston TX)

Professional Training Courses.

  • Apache Hadoop 2.0: Data Analysis with Hortonworks Data Platform using Pig and HiveFebruary 2014
    Hortonworks (Phoenix AZ)
  • Teradata Physical Database DesignApril 2012
    Teradata (Phoenix AZ)
  • Implementing and Maintaining Microsoft SQL Server 2008 SSASApril 2012
    Interface Technology (Phoenix AZ)
  • Implementing and Maintaining Microsoft SQL Server 2008 SSIS March 2011
    Interface Technology (Phoenix AZ)
  • Upgrading your SQL Server 2005 to SQL Server 2008April 2010
    Interface Technology (Phoenix AZ)

Awards & Certificates.

  • GoDaddy Wow Award October 2015
  • GoDaddy Wow Award February 2014
  • Certified Six Sigma Green Belt September 2007
  • DuPont President Leadership Award March 2004/2005

Software Experience.

  • T-SQL
  • SQL Server 7/2000/2005/2008/2012
  • SQL SSIS
  • SQL SSAS
  • Microsoft TFS
  • MySQL
  • MySQL Connectors
  • ODBC Utilities
  • Microsoft BIDS
  • GITHUB
  • HIVE
  • PIG
  • HDFS

Professional Experience

Database Administrator/Database Developer

Responsible for developing new and maintaining legacy applications for GoDaddy.com’s Business Intelligence Team.  Architect creative and scalable solutions for all facets of the GoDaddy organization allowing us to measure vital metrics while utilizing the SQL Server platform amongst other tools.

    • Manage 30 + MS SQL Databases that span across 5 SQL Server Enterprise Edition Machines.
    • Develop custom dashboards for executives to monitor key metrics. Example: Superbowl Dashboard / Call Center Dashboard.
    • Create and maintain data marts with ETL processes using SSIS and BCP.
    • Create stored procedures for applications and reporting using SQL best practices.
    • Optimize and tune stored procedures for maximum performance.
    • Create, manage and maintain indexes for optimal performance and run times.
    • Create and manage linked server for gathering data across servers.
    • Deploy objects across all environments (Dev/Test/Prod) while following our change management process.
    • Create monitoring tools and alerts for processes, marts, application and cubes.
    • Monitor and manage Sever Disk IO and CPU by using perfmon and other tool making sure long running process and blocking is not occurring by users.
    • Use OLAP technologies to create cubes and their corresponding parts like dim and fact tables, load processes and excel cube templates.
    • Create and manage sql jobs for automation and scheduled processing.
    • Manage and assign permissions to proper roles and users.
    • Migrate SQL Servers across machines and versions.
    • Work with .Net UI developers for app and reporting development.
    • Assist analyst with data gathering and t-sql scripts.
    • Participate in 24/7 on-call rotation.

Database Administrator

Responsible for maintaining the database integrity of DuPont’s Division of Industrial Coating.  Develop innovative solutions to increase database reliability, ensure successful implementations of Business Operations, identify and apply metrics to cost-effective strategies, and improve productivity of manufacturing supply chain.

    • Manage over 20 SQL and Access databases, production databases and CRM tools.
    • Integrate ERP system with newly developed CRM system.
    • Initiate, integrate and train key personnel on shipping software to replace logistics solution resulting in a cost savings of $360K over a 5 year period.
    • Seamless migration of SQL Server 7 to SQL Server 2000.
    • Collaborate with consultants and internal constituents to develop data models to enhance financial, business and manufacturing operations.
    • Administer, maintain, and implement policies and procedures ensuring the security and integrity of SQL Server databases Create PVC (Price-Value-Capture) data model to identify true cost and true gross margin.
    • Develop forecast data model to enhance business system operations; identified needs and process flow for 10 departments.
    • Assist, analyze and provide recommendations with cross function department teams on six sigma and lean projects.
    • Maintain, update and support data warehouse by creating and managing dts’s and jobs.
    • Responsible for data access and table maintenance codes using stored procedures.
    • Resolves database performance issues, database capacity issues, and other distributed data issues.
    • Create custom reports to support daily business activities and business improvement metrics of entire division.
    • Perform and assist in data analysis and data modeling for Supply Chain Projects for greenbelt and black belt projects.