Responsible for the integrity, maintenance, security, performance and tuning for all test and production databases. Utilize DB2, IDMS, IBM, Platinum and PeopleSoft 5.12 utility software products and tools. Perform PeopleSoft migration and upgrade support. Provide database backup and recovery, data reorganization, restructure, data rebuilds, and security administration. Perform database capacity planning, tuning, indexing and database implementation.
Define database objects, synonyms, views, and referential integrity.
Lead several database projects advising and making technical decisions involving prioritizing tasks, best use of resources, and effective use of database features. Participated in the successful implementation of two critical systems, PeopleSoft payroll and Advantage financials from DB2 to Oracle in a Database Administrator, Lead role. Resolved HRMS performance problem as a result of extensive analysis, improved testing time drastically. Upgraded NAU s IDMS database from version 10.2 to 12.01 Supported several successful student registrations events. Developed a database utilization analysis process involving interpretation of host data, file transfer to the LAN, and data manipulation using mainframe utilities and PC software.