Senior Specialist Resume

SUMMARY

An experienced database administrator (DBA) with demonstrated success designing and implementing innovative database solutions that improve business functionality. Proven ability to implement technologies that decrease cost, increase performance and positively affect the bottom line. Diverse technical background with good communication skills and ability to effectively communicate across both business and technical groups.

PROFESSIONAL EXPERIENCE

Confidential

Senior Specialist

Responsibilities:

Responsible for performance, maintenance and tuning of 3 primary data marts and several secondary ones
Designed backup and layout that saved space while working in a shared environment
Performed hardware maintenance and monitoring over and beyond that done by vendor
Proficient in SQL, query optimization, UNIX shell scripting, and load, transform, extract (ETL)
Wrote UNIX shell scripts that monitor documented and undocumented features of Netezza
Worked with vendors and tuned Netezza to improve performance by 60%
Adept at analyzing problems and effectively troubleshooting solutions
Proficient at data modeling and design optimization to maximize Netezza’s innate features
Performed future capacity planning of Netezza storage and memory needs
Utilization of Netezza best practices and guidelines
Uncovered and engineered solutions to Netezza bugs

Lead Informix DBA

Confidential

Responsibilities:

Responsible for performance, maintenance and tuning of 141 Informix instances containing 397 databases totaling 6 Terabytes
Designed layouts for 137 instances to improve performance, save space and increase reliability
Designed, tuned and migrated, multi - node Informix EDWs
Designed and wrote numerous UNIX shell scripts to perform migrations, logging and monitoring of all instances
Reduced Informix licensing costs by 80% on 134 servers by migrating to Express Edition without any loss of features or performance
Improved backup and recovery times by 4x with compression
Assisted all applications groups with new and existing projects that use Informix

Confidential

Sr. Netezza and Informix DBA

Responsibilities:

Worked with application groups and Netezza support to setup and optimize data marts
Performed database architecture, SQL tuning and appliance configuration
Tuned documented and undocumented configuration variables with running queues and priority queues that were tailor-made for users
Wrote monitoring scripts and a fast unload backup script that created compressed files for each table that was 3 times faster and used 1/3 storage
Worked on Netezza as far back as version 2.2. Helped and advised Netezza on improvements.

Lead Informix DBA

Confidential

Responsibilities:

Maintained and enhanced both OLTP (customer facing) and OLAP (data warehouse and data mart) instances
Performed database migrations and upgrades
Improved speed and reliability of the Informix and SQLs
Reduced data warehouse migration/upgrade from 1 week down to 1 day by doing direct database-to-database transfers in multiple streams
Researched, tested and documented Informix Light Scans and Light Appends (due to insufficient documentation from IBM)
Requested enhancements to and offered work-arounds to IBM Informix design team
Performed, tuned and documented On-Bar, Ontape and cold backups
Designed, tuned and migrated, multi-node Informix EDWs
Designed a cold backup that compressed all dbspaces in parallel that ran in 1/3 the time and used 1/10 the storage
Sped up update statistics by writing a script that ran them in parallel, queued in part by PDQ and by using Light Scans