Database Administrator
Woodland Hills, California, Us
Provided 24x7 production DB2 support. Created and maintained development, test, and production DB2 environments, and enforced site standards. Developed and implemented physical database designs, using design elements including tables, columns, column data types and cardinality, referential integrity, data constraint rules, index design, and access strategies. Monitored database utilization on corporate platforms to ensure adequate resource allocations; analyzed and tuned performance of applications transactions. Supported several databases, including Peoplesoft, FARE (FHS Automated Rating & Enrollment), various information warehouses. Developed data warehouse logical data models based on corporate and legacy systems business rules, and designed practical physical data modes. Automated routine maintenance cycle (image copies, quiesces, reorgs, runstats, rebinds of application programs) for all major application databases; implemented cycles for new databases. Founded and chaired internal DB2 Users Group (FDUG).