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.

• 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.
• 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.

• 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)

• 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.