Kevin Heraghty Email & Phone Number

Stamford, Ct, Us

Stamford, Ct, Us

Boston, Massachusetts, Us

Baltimore, Maryland, Us

North Hills, New York, Us

• Support multiple transactional database environments on a DB2 PureData System for transactions.• Utilize v10.5 Blu capabilities by building columnar-organized tables within a pre-defined analytics warehouse database.• Maintained “Hub-to-Spoke” replication between Oracle & DB2 databases using Infosphere Change Data Capture technology.• Partner with application developers in order to improve and secure the software development life cycle in a fast paced release environment.

New York, Ny, Us

• Build and manage multi-TB DB2 LUW data warehouses from development to production for multiple lines of business• Primary DBA for a Mongo database which combines 45 million customer agreements from 70 legacy systems, resulting in improved interactions between call center agents and customers• Design strategies and implement database backup scripts for a multi-TB sharded Mongo database across 37 servers and 2 data centers• Provide business continuity, disaster recovery and high availability through existing technologies and recommend new alternatives when gaps are identified• Coordinate with application development teams to implement enhanced privacy using data masking techniques• Led the successful confidential transfer of 600 million customer accounts amounting in $6.4billion in deposits from MetLife Bank to GE Capital while using encrypted devices across various database platforms• Maintain seamless working relationships with offshore DBA teams to ensure 24/7 coverage• Utilize table level compression on largest database tables, which result in 60-70% storage savings• Obtained ADP/IT II security clearance to support confidential U.S. Government TRICARE databases• Implement SRDF and BCV copying techniques for improved customer reporting availability• Create Multi-Dimensional Clustering on several key warehouse tables in order to improve performance on low cardinality field searches and sorting• Estimate future database utilization and equipment (hardware/software) requirements

• Loaded and maintained the database for the world’s largest Net.Commerce deployment• Frequently monitored and tuned databases to maximize performance and business transactions• Managed user security throughout development and production databases• Setup and configured data models using ERWIN for all database environments• Developed Data Warehouse used to create financial status reports for our electronic marketplace• Handled schema engineering, database design and documented appropriate data-dictionaries• Maintained contact with applications and technical support personnel from vendor companies

Bethesda, Md, Us

• Installed and provided reliable support of 3rd party products running over database platforms.• Developed automated backup scripts necessary for recovery procedures.• Improved interface between customers and software vendors.• Reverse and forward engineered databases using database-modeling tools. • Assisted web application developers with DBA support.• Performed necessary upgrades to databases and applications at unsupported levels.