Susan Kratzer Email & Phone Number

San Jose, Ca

San Jose

• Perform all primary DBA activities for the InsuranceNOW hosted production systems including installation, configuration, patching and tuning of Microsoft SQL Server 2008 R2 databases.• Performed migrations of the Microsoft SQL Server 2008 R2 databases from physical hardware in the San Jose data center to Virtual servers in the Santa Clara data center. • Handled all the back-end storage on NetApp prior to having a storage admin on the team at ISCS.• Developed and implemented the automation of SQL Server 2008 R2 SP3 installations including the database maintenance jobs and DBA alert notifications.• Performed migrations of the Microsoft SQL Server 2008 R2 databases from San Jose and Santa Clara data centers to Aurora in AWS utilizing the DMS tasks. • Documented all systems’ design, installation, configuration and daily task to be performed by the Database Administrators.• Trained and mentored the newly hired database administrators.• Proactively monitored all databases servers for potential performance issues.• Resolved performance issue by making suggestions to R&D for code or index changes in the primary database or creating non-clustered indexes in the data warehouse or reporting databases.

Database Administrator Duties• Perform all primary DBA activities for the Financial Supply Chain, Business Intelligent, Warehouse Management and other business systems including installation, configuration, tuning and patching of MicroSoft SQL Server 2005/2008 databases.• Performed upgrades of multiple SQL Server 2000 databases to SQL Server 2008 databases. • Developed and deployed SSIS packages for Financial application running SQL Server 2008 R2• Developed and implemented interfaces between SQL Servers utilizing linked servers, stored procedures and sql scripts.PeopleSoft Administrator Duties• Responsible for all aspects of PeopleSoft Administration including installing and configuring Database, Web, App, File and Process Scheduler servers.• Performed PeopleTools 8.47 upgrade of PeopleSoft FSCM 8.8 to PeopleTools 8.50.14 • Apply quarterly PeopleTools critical security patches for PCI compliance• Perform all migrations from development environments to test and production environments.• Document all systems’ design, installation, configuration and daily task to be performed by DBA and PeopleSoft Administrator.

Database Administrator Duties• Performed all primary DBA activities for the back office Financial, Tax and Purchasing systems and secondary DBA activities for the HR and Travel systems.• Performed upgrades of SQL Server 2000 databases to SQL Server 2005 64-Bit databases.• Performed complete installation and configuration of HPUX 11.0 64 bit operating system, Oracle 8.0.5.0.1 and 8.0.6 64 bit databases.• Created and scheduled UNIX shell scripts to automate database backups, starting and stopping Peoplesoft processes, archiving interface data files, removing old log files, and analyzing the database tables.• Documented all systems’ design and configurations, scheduled processes, modifications to applications and daily task to be performed.Non-DBA Duties (PeopleSoft Projects)• Performed complete installation and configuration on HPUX 11 of PeopleTools 7.58 and PeopleSoft 7.53 application including PeopleSoft application server and process schedulers.• During the PeopleSoft 7.5 implementation, my duties included UNIX system administration, Oracle database administration, PeopleSoft application administration and PeopleSoft Application Server network administration. • Performed migration of PeopleSoft FSCM 7.5 Oracle data into PeopleSoft FSCM 8.4 SQL Server 2000 database • Applied PeopleTools patches and PeopleSoft application SP1 and SP2 patch bundles to the PeopleSoft FSCM 8.4 environment.• Performed major application upgrade of Peoplesoft FSCM 8.4 to Peoplesoft FSCM 8.9 • Applied patch bundles and tax updates to PeopleSoft HRMS 8.9 using PeopleSoft Change Assistant.

• Developed custom interface programs using ‘C’ with embedded SQL, Unix scripts and Oracle PL/SQL for formula processing manufacturers’ to accurately track ingredient usage and production inventory.• Created custom interface programming to provide seamless integration of purchased applications.• Performed system analysis, design documentation and assignment of tasks for custom in-house applications.• Performed system implementation including documentation, user training and support issues.

• Developed custom bar-coding programs using ‘C’ with embedded SQL, Basic and IDOL-IV programming for process manufacturers’ to accurately track purchased and production inventory.• Created custom and maintenance programming in GEMMS using JAM/JPL from JYACC, ‘C’ with embedded SQL and Oracle PL/SQL triggers for a large variety of applications.• Performed system implementation including user training and support issues.

• Created custom and maintenance programming in Microsoft ‘C’ and scripts for a loan application and credit card processing software package (COIN).• Developed custom programming modifications for the Mercedes Benz Credit Corporation.

• Created custom and maintenance programming in Basic and IDOL-IV for scheduling and production of custom plastic film products.• Performed installation and maintenance of Novell LAN, Novell Netware Connect, E-mail systems and a variety of workstations and software.• Performed system implementation including user training and support issues.

• Created custom and maintenance programming in Basic and IDOL-IV for a point of sale system (CRIS) for the music and video industry.• Performed system implementation including user training and support issues.