Karin E. Zirk

4629 Cass Street, #188                                                                                       858 / 405-7503

San Diego, CA 92109                                                                                    kzirk@earthlink.net

Objective

Database Administrator position for a company that values 99.9% uptime and zero loss of data.

Summary Of Experience

• SQL Server Database Administration

• Data Integration and Analysis

• Data Warehouse Manager

• Technical and User Documentation

• Accounting Systems Setup and Support

• Compliance with Security Regulations

• Project Management

Professional Experience

SQL Server Database Administrator 2000 to present	CSA Travel Protection, San Diego, California Manage company data and data systems for a managing general insurance agency. • Design, administer and troubleshoot a multi-server Microsoft SQL Server 2000/2005 environment with disaster recovery redundancy implemented via transaction log backups with servers located internally and at co-location facilities. Perform upgrades. • Create and maintain stored procedures using T-SQL. • Assist business users with T-SQL query optimization and data analysis. • Troubleshoot and provide technical solutions to SQL Server database issues encountered by new and existing development. • Manage and enhance a data warehouse including needs analysis with business users. • Implement and update ETL processes using T-SQL stored procedures. • Manage capacity and budget for system upgrades. • Insure compliance with PCI audit requirements. • Manage security and grant access to data systems per company policies as requested. • Data modeling for new development. • Design and administer SQL Server Great Plains Dynamics accounting system including upstream and downstream data integration. Work closely with Accounting Manager and CFO to develop needed data sets from SQL Server databases for reconciliation and audit purposes. • Write database documentation for both technical and business users. • Provide backup support to Help Desk as needed.
Partner 1996 – 2001	Small Business Automation Solutions, San Diego, California Performed all functions for client companies including process engineering, solutions research and development, project management, systems analysis, database development, company operations, bookkeeping, strategic planning, programming, documentation, curriculum development, training, and website design and development. Sample Projects: • Microsoft Access to FrameMaker database published directory for Croner Publications. • Contractor sales tracking system in Microsoft Access for Mitchell’s Floor Coverings • Microsoft Access database add-on project for Small Business Development Center • Accounting software instructor for Imperial Valley Community College • Computerized bookkeeping and operations training for various clients
Technical Writer 1995 – 1997	SAIC, San Diego, California Prepared software documentation and proposals for a variety of contracts utilizing desktop publishing software and CASE tools on UNIX, Macintosh and PC platforms. Produced documents for company Intranet. Projects included Marine Tactical Warfare Simulation system (MTWS), Large Area Tracking Range (LATR) and Comprehensive Health Care System (CHCS).
Directory Manager 1994 – 1995	Wells Publishing, San Diego, California Managed and produced a 500 page industry-specific directory using database-publishing technology. Tested and implemented database, collected and integrated data from a wide variety of sources for inclusion in directory, designed and implemented QA/QC procedures, coordinated display advertising with sales manager and graphic designer, supervised other directory staff.

Education and Training

Bachelor of Arts in Literature/Writing, University of California, San Diego
Cum Laude, Department Honors with Distinction

Administrating SQL Server 2000 and Introduction to Data Warehousing
 Computer Science and Engineering Department, via UCSD Extension

Yukon and You (SQL 2005 and .Net), UCSD Extension

SQL Server 2005 Administration and Development
Hands on Technology Training, San Diego

Summary of Technical Skills

PC:	Windows 95/98/NT/2000/XP/2003, MS SQL Server 7.0/2000/2005, Enterprise Manager 2000, MSSQL Management Studio 2005, Dynamics 6.0/7.5/8.0, FRx 6.5/6/7, Microsoft Office 95/97/2000/2003, ACT! /2000/6, XML Spy 5.0, Net Objects Fusion 2.0/5.0, Toad Data Modeler V 2.0, FrameMaker 5.0/6.0/7.0, XML Spy, WinFax Pro, FileMaker Pro 3.0/4.0, QuickBooks Pro 5.0/6.0/99/2000, WordPerfect 5.2/8.0, MS Project 3.0, Lotus Notes 4, QuarkExpress, PageMaker, Lotus 1-2-3, Visual Basic 2.0, ftp, Visio, Telnet, Putty, Adobe PhotoShop, dBase IV, Adobe Acrobat, Eudora, Outlook/Outlook Express, WinZip, Peachtree, Quicken, Wincats, TurboTax, Goldmine, M.Y.O.B.
UNIX:	FrameMaker 5.0, HP-UX, X Windows, vi editor with troff/nroff utilizing tbl and eqn, LaTeX and TeX, cgi, Perl, CADRE Teamwork 4.1, xv utility, Lotus 1-2-3, Rapport, Telnet, and ftp.
Macintosh:	System 7.5/8, Word 6.0, PowerPoint 4.0, MacDraw Pro 1.5, Excel 5.0, ClarisWorks, PageMaker 4.2, FileMaker Pro 2.0, FoxPro, MacProject, ClarisImpact, WordPerfect 5.1, QuickMail 2.6, Fetch, telnet, GIF Converter, Netscape 3.0, ClarisDraw 1.0, Acrobat Exchange 2.0.1, Acrobat Distiller 2.0, Print Shop Deluxe.

References Available Upon Request