DEBI KASTNER

26400 La Muera Farmington Hills, MI 48334 (313) 496-2962 (work) (248) 426-9339 (home) email
* My thanks to www.worldprints.com

	*Objective: To obtain a position either as a :*
	*database administrator and or,*
	*shell programmer and or,*
	*something equally geeky and fun*
	*for a progressive company that takes as much pride in their work as I do.*

(Good surf is always a plus ...)

Summary

COMPUTER TECHNOLOGY professional with twenty years experience ranging from system design, new development and implementation to database administration ...

The first five years of my career, I worked in as a systems engineer, designing, modifying, and writing new software. I began by intergrating, converting, implementing, and maintaining the AT&T Wisconsin Bell phone system. I then worked on the GM Warehouse Consolidation Project, designing, writing, and implementing new consolidated systems.

The next 5 years I was trained and worked as a IMS/VS database administrator at Detroit Diesel.

The last many years I have worked as both the Informix dba, a shell programmer, the Edenoa administrator (our vendors version of Peoplesoft), and the Linux sysadmin for our distance learning servers. Have been forced by necessity to act as the Unix sysadmin on occasion (daily maintenance, crashed server, strange tty problems occurring while moving one production system over another via NFS mounts, misinformed consultants chunking system memory out from under Informix). I am NOT a sysadmin. I'm from the old school ... dba's and sysadmins should be extensively trained by senior dba's and sysadmins. Not by the seat of their pants.

Strengths include trouble shooting and problem resolution, writing Korn/Bourne / awk / perl / sed system shells for server and database maintenance & diagnostics, and automating processes for both our IT department and our end-users that previously had to be run manually.

Education
Experience
Software
Hardware
References

Top of Page

Education

Post Bach : Novell Networking, 6/95 - 6/97, OCC Farmington Hills, MI
GPA : 4.0

B.S. Computer Science & Technology, June 1985, Chaminade University, Honolulu, HI
GPA : 3.6 "With Distinction"

Post Bach : Calculus, 1/83 - 1/84, University of Hawaii, Honolulu, HI
GPA : 4.0

B. A. Biology (Pre-med), June 1977, Wayne State University, Detroit, MI
GPA : 3.3 "With Distinction"

High School, December 1972, Rochester Adams High, Rochester, MI
GPA : 3.9

SCHOLARSHIPS :

4 Year Academic Scholarship (WSU)

EDUCATIONAL ACCOMPLISHMENTS :

WSU Honor Society
Honor program independent research biology projects at WSU
Neurological research at WSU Medical School
Honor program independent research in biology at Rochester Adams
Graduated third in class from Rochester Adams
Poetry published 1972

Back -> Summmary

Top of Page

Experience

Employment History & Highlights :
_________________________________

10/95 - current

Dba / Sr. Applications
Programmer

WCCC
Detroit, MI

Helped migrate database from Informix -- > Oracle for new Banner front end migration. Wrote and ran automated shells to unload Informix database tables.

Writing tons of sql (Toad) & Crystal Reports for missing customized user reports.

Wrote Oracle views to replace common huge sql streams needed by our programmers (accounts receivable charges, payments, and balance routines, last general person student record submitted, ...)

Created senior waiver loads on new system (multiple sql & plsql combos)

Informix DBA for student financial, financial aid, account receivables, and student registration systems. Weekly functions include database space analysis, db table resizing and redistribution, reorgs, Informix system monitoring, ...

Moved our Informix databases to larger Unix box (twice), because either we were out of space and / or as a exercise in Y2K parallel processing.
Fixed Informix system tables (vendor patch had created 2 dead dangling tables) before exporting production system.
Resized all Informix system raw partitons.
Resized all Informix dbspaces / chunks and recreated. Also re-sized most of our critical system partitions.
Wrote a automated utility to resize all database tables to their correct extent size. Resizing ALL tables and creating the new import sql from the export took less than 20 minutes.
Installed both prod and test.

Split the 2 systems running at WCCC apart and moved the one onto its own dedicated RS6000 Unix server.
Fixed all corrupted table index's and data areas before exporting from original system.
Resized all Informix dbspaces / chunks and recreated Informix on the new box.
Resized all database tables from the export before importing to the new system.
Installed both prod and test.

Write Unix & Linux system utilities.
(Cron utilities include scanning for downed servers (NT, Unix, Linux), killing idle users, enabling downed printers, backing up & cleaning out Apache logs, ... )

Wrote online interactive database manager. This system consists of multiple sub-systems running combinations of shell commands, Informix commands, awk's, sed's, back door Informix utilities, and other goodies which enable the dba & system managers to :

monitor Informix db's, tables, & users

resolve deadlock situations

run ANY Informix tbstat, tbcheck, or tblog command interactively

create ANY dba job to unload, automatically resize, rename, or reload any table in the system

automatically bounce both the SIS user system and Informix, with options to bring both either up or down as desired

automate moving databases between unix machines. This includes re-sizing all database tables with their correct dbspace parameters by manipulating system table dumps and the dbexport sql.

Wrote internal website for WCCC admissions.

Wrote shell sub-systems to automate :

tar back-ups and restores

financial aid document tracking

gpa recalculations

ledger balance interface processing

financial reporting

room scheduling

refund processing

course cancellations

student service requests

registration reporting

Run vendor modset gens, vendor system updates, and vendor patches.

Occasionally perform sysadmin functions.
Set system & profile globals, new product installation, DNS updates, NFS mounts, set up user id's, group id's, change passwords, SMIT around. Monitor system during high load periods, resolve sluggish serve problems.
Create new user id's, remove obsolete ones.
Create new and manage existing physical & virtual print queues.
Managed system security (yuck, hate secuity).
Periodically remotely move production systems between servers.
Changed 2 of our 3 servers back to base ksh (made sure nothing crashed, prefer Korn/Bourne over C shells.)

Do alot of trouble-shooting.
Fix Informix database problems (most of the time out of space, need more raw chunks), crap data on Informix tables, crapped out Informix tables (vendor modset gens don't always work like they should), system shells, local shells, vendor programs, and vendor system shell logic.

02/95 - 10/95

Dba / System Consultant

Custom System Consultants
Farmington Hills, MI

Designed & implemented a new accounting : invoicing system using Oracle Workgroups 2000 for a small business. Also designed and submitted written proposal to set up a new WinNT network.

11/89 - 02/95

Dba - Se
System Infrastructure

Eds, Detroit Diesel Account
Detroit, MI

Formal DBA training under Account Senior DBA (who is currently a certified Oracle Database Certified Master, and whom is still teaching me).

Designed, wrote, & implemented IBM <--> UNIX middleware platform to keep IMS : Oracle db's on multiple hardware platform's in sync.
3 sec. tolerance allowed.

Helped implement the new JIT WAREHOUSING system On Unix Oracle platform. Wrote db download utilities for conversion from one platform to the other.

IMS & CICS dba support of current DDC systems. Daily (and nightly) support of over 600 production db's. New db development projects included a on-line order tracking system through logically related Canton warehouse db's, implementation of over 70 new relational incase db tables, as well as 2ndary index and logical db design & implementation on a multitude of various sub-systems (warranty, ddec, ebom...).

Various database and vendor installations & upgrades. Ran monthly sysgens to update IMS.

09/87 - 11/89

Systems Engineer
Consolidation Project

Eds, GM Account
Flint, MI

Designed the new consolidated GM Warehouse Physical Inventory System and databases. Coded and supervised on-site and off-site coding. Highly successful implementation brought in 4 years early due to customer enthusiasm.

Helped design, code, & implement new consolidated GM warehouse invoice processing, warranty and Canadian pricing systems.

06/85 - 09/87

Systems Engineer
Communications Div

Eds, Eds Towers
Southfield, MI

Implementation, enhancement, and production maintenance of Wisconsin Bell AT&T phone system.

Wrote track switching system for above phone system. DB2 to Focus conversion.

06/84 - 04/85

Computer Lab Monitor
& Tutor

Chaminade University
Computer Science Dept.
Honolulu, HI

Back -> Summmary

Top of Page

Software

*Databases*	*DB2*	*CICS*	*FOCUS*
*Databases*	*INFORMIX*	*IMS/VS*	*ORACLE*
*nnnnnnnblank line*
*Languages*	*Assembler*	*Awk*	*Basic*
	*Cobol, Cobol II, MICROFOCUS Cobol*	*Dos*	*Fortran*
	*HTML*	*IBM JCL*	*Perl, Perl-Cgi*
	*Pro C*	*Sed*	*Shell Script (ksh/bsh)*
*nnnnnnnnblank line*
*Operating Systems*	*CPM*	*DOS-VS*	*MVS/XA & MVS/ESA*
	*DEC*	*MS-DOS*	*UNIX & UNIX AIX*
	*Linux*
*nnnnnnnnblank line*
*Networks*	*Novell 3.x, 4.0*	*TCP / IP*	*WIN NT*
*nnnnnnnnblank line*
*System Utilities*	*FTP*	*IBM IEB Utilities*	*IBM DB Utilities*
	*Informix Tbmonitor*	*Informix ISQL*	*Oracle Sql-Dba*
	*Recon / Dbrc*	*SMU Pointer Chkr*	*Unix Root /etc*
	*Unix SMIT*	*Unix System Cmds*
*nnnnnnnblank line*
*Tp Monitors*	*CICS*	*IMS MFS*	*TSO*
*Tp Monitors*	Vi

Back -> Summmary

Top of Page

Hardware

*Main*	*IBM 3390*	*IBM 3090*	*IBM 3080*
*Mid*	*IBM RISC 6000*	*PYRAMID*	*DEC PDP 11*
*Micro*	*Most pc's & pc clones*

Back -> Summmary

Top of Page

References

Refences available upon request.

Back -> Summmary

Top of Page

Hosted by www.Geocities.ws