Experience

• 

  NOL

  • Manager, Database

    • Jul 2009 - Present

• 

  APL Limited

  • Senior Lead, Database Administrator

    • Jan 1999 - Dec 2008

    Managed and maintained LAN and mainframe-attached corporate-wide Teradata system environments with 24/7 responsibility for performance, tuning, recovery and planning.• Collaborated with development teams on database design and ETL processes. Developed backup and recovery strategies, enhanced system and application performance. • Developed and implemented enterprise standards and strategies on database design, backup, recovery, security and production support.• Conducted technical and cost evaluation of various database products. Provided management with selection recommendation for corporate data warehouse to minimize overall cost of ownership.• Assisted in the capacity planning and hardware/software acquisition of the next generation data warehouse platform. Managed and coordinated hardware installations and software upgrades.Managed a worldwide network of 100+ Oracle instances for OLTP and data warehousing systems. Led team of five DBAs for project planning, and consulted on technical and database management issues.• Managed the upgrade of mission-critical production Oracle databases from 8i or 9i to 10g. Developed, managed and oversaw test and implementation plans on schedule and under budget.• Developed and maintained database system performance monitoring and tuning methodologies, reviewed and resolved design issues, assisted developers to improve SQL query performance.• Provided 24/7 production support, directed database problem resolution, developed preventive maintenance processes to reduce production outages.

• 

  PROVIDIAN FINANCIAL

  • Senior Teradata Database Administrator

    • Jan 1998 - Dec 1998

    Designed, developed and maintained a Teradata data warehouse in a UNIX environment for credit risk scoring and credit card marketing programs.• Developed and managed ETL, backup and recovery strategies, evaluated application performance and capacity requirements. Advised developers on database issues interfacing with SAS and Microstrategy, enabled clients to accurately identify potential targets for new account solicitation

• 

  APL Limited

  • Consulting Database Administrator

    • 1989 - 1997

    • Managed the corporate-wide Teradata data warehouse. Provided clients accurate and timely information to track sales and equipment. The resulting analysis contributed to increased market share, operating margin, and increased profits. • Managed a network of RS6000 servers hosting Oracle databases, and supported time-critical OLTP applications for Pricing, Finance, Leasing, Human Resource and Customer Profile.• To serve the future DSS needs, researched and recommended alternative hardware and software platforms (NCR 5100, IBM SP2, etc.) supporting parallel database in a client/server environment. • Developed and enhanced standards and tools to ensure the availability, integrity, and recoverability of application data across multiple database platforms.

• 

  American Airlines

  • Senior Programmer Analyst

    • 1986 - 1989

    • Researched and developed software/tools for a new corporate business intelligence environment with an integrated data repository to facilitate data analysis, data mining and corporate decision making. • Designed and developed Teradata databases and business views for the integrated dictionary. • Directed the design and development of a database performance evaluation tool to assess accurately the performance of SQL-based relational products (DB2, SQL/DS, and Teradata).

• 

  Bank of America

  • Advisory Systems Engineer

    • 1981 - 1986

    • Designed, developed and implemented IMS/Fast Path-based databases for retail banking applications.• Designed and developed software methodology/tool to assess relational database performance.• Recommended database product selection to management based on assessment results. • Developed and documented logical database design methodology and logical data modeling techniques for application development