SUMMARY:

Solution Developer Data Architect Advanced Computing DPF Range Partitioning HACMP AIX Replication HADR PureData for Analytics for DB2 Cloud Computing Architecture - DB2 DB2 Cloud Platform

TECHNICAL SKILLS:

Advanced Computer & Software Engineering Skills: Software Configuration Management Script programs RDMS - Database Migration Strategic Planning and System Migration HACMP Project Management HADR / DR recovery solution AIX Replication IBM BLU Acceleration IBM DB2 DPF TSM TSA

Software Databases: IBM DB2 v8.2/v9.5/v9.7/v10.1, Oracle 10/11g, SQL Server 2005/2008/2012 , Sybase 12, MySQL 5.

Performance Testing Tools: Visual Studio Ultimate, Embarcadero Performance Center - DBArtisan, Oracle Enterprise, Confidential Surveillance, BMC Patrol, IBM DB2 Performance products

Languages: Java, Korn/Bourne Shell, WebSphere Suite, ASP, JDBC, JSP, C#/C++/C/, Visual Basic.net, SQL, HTML, Visual Studio.NET

Operating Systems: AIX r6/r7, LINUX (REDHAT/CentOS), Windows, VMWare

Management Skills: Effective Communications ISD Writing Class Effective Life and Time Management Managing Multiple Projects Leadership at Work Communicating with Better Result Managing Corporate Data Anti-Terrorism / Workforce Protection

ROFESSIONAL EXPERIENCE:

LEAD DATABASE ENGINEER

Confidential, Omaha, NE

Responsibilities:

• Recruited to Lead a word-class managed services DBA team and spearhead the transition from outdated organization-wide and departmental techniques to highly functional, streamlined, and business solutions which have dramatically improved efficiency, decreased after hour calls, and optimized data integrity and safety.
• Scope of position is expansive and includes departmental direction for supported databases and full design, installation, engineering, implementation, support, training, administration, and management authority.
• As a member of the managed services database team, I simultaneously supported 8 fortune 500 customers on physical and virtual servers, with an astonishing total of:
• 125 DB2 LUW v9.5,9.7and10.1 Database Servers total of 8.2 terabyte of data
• 72 SQL Server 2005/2008/2012 Instances total of 10.2 terabyte of data
• 5 MySQL Database Servers total of 500 GB of data
• 6 Sybase Instances total of 300 GB of data
• Developed solutions to reverse engineer newly acquired supported databases to migrate off physical hardware into a virtualize infrastructure. Architected the database and reduced the nightly batch processing from 6 hours to 1.5 hours.
• Increased database stability 86%, resolving extended wait times with Direct Access virtualization solutions - while reducing after hour support calls nearly 67%
• Designed a new approach for database standards with operational health check reviews to optimize database performance
• Led the complete reorganization of database roles and responsibility including after hour call outs, ticket assignments, SLA requirements and root cause analysis
• Instituted the first highly reliable corporate, centralized backup system
• Lead DBA team in the migration of 12 DB2 version 9.5 to 9.7 on Linux/Windows
• Supported and development standards for Federated DB2 Databases
• Implement DB2 performance solutions and improved customers nightly process from 2 hours to32 minutes
• Developed backup TSM process for Disaster Recovery for all supported databases
• Implemented HADR for supported customer and enhanced AIX replication for faster DR test and recovery
• Developed advance DPF partition and table cluster and reduced customers SQL query from 16 minutes to 2 minutes
• Provided leadership and cross-training to other DBA members

DATABASE CONSULTANT

Confidential, Austin, TX

Responsibilities:

• Manage and set the direction of 16 DB2 LUW/AIX v9.5 and v9.7 databases total of 3.4 terabyte of data, utilizing the Loan IQ Application
• Implemented 5 DB2 LUW for the migration of DB2 version 9.5 to 9.7 on Linux and Windows
• Developed and implemented HADR for disaster recovery
• Reverse engineer database structure to in corporate best practice
• Implemented enhance features of DB2 LUW version 9.7 including table partition and table compression
• Lead DB2 LUW DBA for the Scalability and Showcase Validation of Loan IQ
• Provided expert senior level advice for the performance and benchmark of Loan IQ on DB2 LUW - 6 Million-dollar yearly project

DATABASE CONSULTANT

Confidential, Austin, TX

Responsibilities:

• Managed and directed 37 BAC DB2 UDB databases on Linux, AIX, and Windows
• Created multiple databases to test database encryption algorithm
• Setup and implemented HADR for disaster recovery
• Responsible for SQL performance tuning and enhancements

DATABASE CONSULTANT

Confidential, Parsippany, NJ

Responsibilities:

• Designed the DB2 database for Confidential call center
• Implemented communication protocol for Mainframe to DB2 UDB v8 table transfer
• Maintained High Availability Multi-Cluster for 6 Production OLTP Servers
• Managed the consolidation and migration of DB2 UDB Production Servers from Dallas, Texas to Louisville, Kentucky

DATABASE ENGINEER

Confidential, New Orleans, LA

Responsibilities:

• Implemented and Maintained High Availability Multi-Cluster OLTP Partition Production Servers
• Established korn shell scripts for Production Database Failovers for a single and multiple node environment
• Implemented Departments protocol to transfer Classified Data across multiple node environments
• Maintained Classified Databases and Data for facilitating the location of all personnel (government, military, or contractor) working for SPAWAR

SENIOR DATABASE ADMINISTRATOR

Confidential, Austin, TX

Responsibilities:

• Database Lead for the implementation of Confidential - monitoring software for DB2, Oracle, MSSQL, and Sybase
• Database Lead to upgrade the production HACMP DB2 UDB 8.2 database to a supported maintenance level
• Designed the Point of Sale Motor Vehicle Registration and Title database system (RTS) for the State of TX 256 Counties
• Developed policies and procedures on best practices in the DBA Team
• Responsible for daily maintenance, installations, job and alert monitoring, and nightly backups of 10 Production database Servers running on Windows Server 2003 and UNIX (AIX 5)
• Implemented the Confidential job and alert monitoring for 20 Production and Test Servers running MSSQL Server 2000 on Windows Server 2003, 8 Production and Test Servers running Oracle on AIX, and 4 Production and Test Servers running Sybase on AIX
• Designed and developed the DB2 database administration section’s website