Summary





Database Administrator with 15+ years experience with SQL Server, Oracle and DB2. DBA certified on SQL Server, Oracle and DB2. Responsible for installation, administration, monitoring, performance tuning and development support. Experienced implementing and maintaining SQL Server databases on clustered servers and with VMWare on a SAN platform. Has set up disaster recovery and backup/restore processes and migrated SQL Server from 7 to 2000 to 2005 to 2008. Installed, administered and supported Oracle and other Unix-based DBMSs. Excellent customer service and written/verbal communication skills.


Employment

2002 -  August, 2008

Lead SQL Server DBA

Joined as a Lead SQL Server or Oracle DBA. Was promoted to IT Manager and continued in DBA role.
Managed a small but productive team of IT professionals Systems Administration, Network Administration, Data Base Administration, Desktop Support, HelpDesk Support.
As an IT Manager was responsible for oversight of all IT functions for a 2500 user campus.
migrated the campus from Novell to a fully Microsoft environment, Windows Server 2003/2008, SQL Server 2000/2005, Exchange, Outlook, Active Directory, SMS.
Migrated all databases from SQL Server 2000 on Windows Server 2000 to SQL Server 2005 on Windows Server 2003.
Installed, administered and supported Oracle 11g for purchased application.
Implemented a purchased administrative system which used Microsoft clients, web-based applications and Microsoft SQL Server.

As Lead DBA performed installations/upgrades for SQL Server and vendor application software and maintenance.
Supported SQL Server 2005 instances in a VMWare ESX 3.5 environment residing on a LeftHand SAN platform. These were used by the campus 24x7 distance learning management system web-based applications. Planning and budgeting in progress for a move to a clustered server environment.

Used Profiler, Index Tuning Advisor, DTA Database Engine Tuning Advisor, Performance Monitor, graphical execution plan option in SQL Server Management Studio and other tools for performance monitoring and support.
Mentored Junior DBA, Setup and supported many SQL Server Agent database maintenance jobs.
Provided development and production support.
Mentored SQL tuning and SQL Server best practices with application developers.
Performed logical and physical database design.
created and monitored server and database alerts/notifications.
Gathered and managed capacity planning and budget-related information.
Managed scripting and automation.
Wrote triggers, functions, stored procedures, used extended stored procedures.
Designed and planned disaster recovery procedures and performed testing. Set up back up procedures using Veritas BackupExec.
Developed and supported many DTS Data Transformation Services ETL Extract Transformation and Load processes for departments loading/exporting data to/from various internal and external data sources eg Excel, Access, flat files, XML.
Migrated DTS packages to SSIS SQL Server Integrated Services.
Rewrote existing DTS packages as SSIS projects/packages as changes were required.
Created many SSIS projects/packages to meet daily data support needs using BIDS Business Intelligence Development Studio.
Supported applications which created, transmitted to and received XML data from vendor partners for web-based finance applications.
managed and monitored SQL Server s attack surface and security.
Maintained service pack and patch releases and standard maintenance processes, indexing, statistics and reclamation of disk space.

Gary F. Garten

American Century Investments, Kansas City, MO.

Senior Data Base Administrator

Supported multiple node SQL Server clusters used by financial fund management enterprise systems and provided support for transactional replication.
Provided DBA development and production support to application developers with applications that accessed SQL Server, Oracle and DB2 on multiple platforms.
Co-led Disaster Recovery semi-annual exercise. Traveled to out-of-town site for multi-day recovery exercises.
Performed both duties logical and physical design of a Data Analyst and DBA, prior to the creation of the DA role. Erwin was the data modeling tool and repository.
Designed and implemented physical design for a new application which received, transformed and stored ETL short term cyclical storage on for data received from an outside company. Awarded a special bonus for completing project on time and under budget.

Sprint Corporation, Overland Park, KS.

Education

Training

MCITP : Data Base Administrator SQL Server 2005 formerly MCDBA
Microsoft Certified Information Technology Professional
MCTS : Microsoft Certified Technology Specialist : SQL Server 2005
MCP : Microsoft Certified Professional

70 - 453 SQL Server 2008 certification target : summer 2009
Microsoft SharePoint WSS 3.0 certification completed
Additional SharePoint certification target : summer 2009
Oracle :
OCP : Oracle 10g DBA certification
IBM :
Certified DB2 DBA on multiple platforms :
IBM DB2 Database Administration certifications for z/OS Mainframe , UNIX , Linux , Windows platforms
Languages :
T-SQL , XML , VBScript , Shell scripting , Windows Powershell
Software :
Sql Server 7/2000/2005 , DTS , SSIS , SSRS , Profiler , Query Analyzer , DTA , Index Tuning Adviser , Veritas Netbackup , Veritas BackupExec , ERWin , VMWare ESX 3.5 , LeftHand SAN , ASP , ASP . NET , Visual Studio 2008 , Windows 2003 , Active Directory , SMS , MS Management Server 2003 , Exchange 2003 , WMI Scripting , Redgate software .
Continuing education and certification training
Pursuing certification training through Technology Skills , Inc Also doing independent training through AppDev , Inc AppDev s process uses thorough and detailed instructor-led video training delivered via the web to my home . My home-based virtual server environment allows for plenty of working experience for the practical hands-on-lab work with SQL Server , SharePoint , SSIS , SSRS , SSAS , . NET technology and more !
Combined , Technology Skills and AppDev , a number of in-demand technical skills have been added and sharpened .
Gary F. Garten
Data Base Administrator
As part of midrange UNIX Systems Programming group installed and supported Oracle and Informix software and supported AIX , HPUX , DGUX UNIX midrange and client/server corporate applications , working closely with product vendors and developers and DBAs .
Completed UNIX system administrator , shell scripting , performance monitoring and tuning and other related courses .
Performed DB2 DBA and Informix UNIX DBA development and support for Data Warehouse and Operational Data Stores .
Daily ETL Extract Translate and Load processing pulled data from Informix databases on UNIX and stored on DB2 on the mainframe for a Data Warehouse project .
Worked closely with Data Administration staff using ERwin on logical design to physical design project work .
Was sole company DBA on business critical invoice phone bill processing system working with 80% consultant and 20% Sprint employees . Project resolved critical billing issues resulting in significant revenue recovery .