Retail Financial Services
December 2010 – Present
Database Management Lead
Managing a team of on and off shore database administrators supporting the JPMorgan Chase Retail data warehouse environment.
JPMorgan Asset Management
Fixed Income Application Development
November 2005 to November 2010
Senior Database Developer
Responsible for database and application level tuning, data model modifications and additions and implementation of business logic using PL/SQL in the custom built Fixed Income decision support system and LatentZero Capstone databases.Decreased overnight batch processing though the implementation of partitioned tables, tuning of individual SQL statements and tuning of stored packages.Using Informatica to replicate data from Sybase databases into the Oracle DSS database and to generate flat file extracts for consumption by other systems within the Investment Management business.Identified and corrected issues with default database collection of histograms and object statistics.
Scripted, tested, documented and oversaw the implementation of a process to migrate the existing LatentZero Sentinel compliance Oracle8i database to Oracle 10gR2, setting the database level initialization parameters to take advantage of the enhancements found in Oracle10gR2 and the rebuilding of existing tablespaces to be locally managed.Scripted, tested, documented and oversaw the addition of trading and reporting modules to the existing LatentZero Sentinel compliance database.
Retail Operations Center Infrastructure Services
January 2005 – November 2005
Senior Database Administrator
Acted as a point of escalation for the application development teams and user community for Chase Home Finance UAT, production and disaster recovery databases.Implemented start of business health checks to ensure the database environments were ready for business to start.Lead the database administration group during disaster recovery exercises.
IBM Global Services
April 2003 – December 2004
Lead Database Administrator
Responsible for overseeing the day to day activities of a geographically dispersed database administration team that maintained over 60 databases in the UAT, production and disaster recovery space.Ensured appropriate coverage for changes and problem tickets.Acted as a point of escalation for all Oracle database issues pertaining to Chase Home Finance.Met with business and application teams to review project requirements, assign a work effort to the database administration tasks and ensuring timelines were met.Reviewed project requirements against group and corporate standards and verified that all needed processes ( backups, maintenance and monitoring ) were in place to ensure service level agreements would be met.
Chase Home Finance
August 2001 – March 2003
Senior Database Administrator
Designed and implemented a highly available database architecture for a loan origination system using Oracle8i, EMC SRDF and Quest Shareplex.Participated on several disaster recovery exercises.