Paul LaGrone
TEMPLE, TEXAS **501
EMAIL: abk8pf@r.postjobfree.com
SUMMARY
SQL Database Administrator for Charles Schwab, Inc. as a contractor through
Teksystems. My primary work experience has been in both the IT
Hardware/Networking fields since Novel 2.0a++ in 1989 and with Databases
since 1994. Effective communicator, able to explain complex concepts and
ideas to non-technical individuals.
Professional Experience
Teksystems, inc 2009-Present
SQL Server Database Consultant
Support SQL Server databases and maintain SSIS/DTS packages for system
processes.
> Use SQL Diagnostic Manager along with SQL Profiler and Performance
Monitor to determine and resolve SQL Server bottleneck issues
> Coordinate a new implementation of 2008 SQL Server Reporting Services
into Dev, QA, and production environments.
> Develop and implement a process for converting 104 Crystal Report
objects into SQL Server Reporting Services.
> Develop and implement a process for converting 100+ SQL DTS packages
to SQL server Integrated Services.
> Diagnose and resolve issues with the Archiving process to move
financial data from Production to Near-Line to Off-Line storage.
> Work closely with Austin Database Team to implement changes using the
Schwab E-Change system.
City of Fort worth, Texas 2003-2009
Senior Database Administrator
Support and develop the ESRI ArcGIS environment for 300+ users:
> Administered a 4 node SQL Server 2005 Cluster, including all day to
day backups, troubleshooting locks, implementing new databases, and
service pack implementation.
> Administered 30 SQL Server 2000/2005 standalone databases with 40+
instances and 500+ databases including all day to day backups,
troubleshooting locks, implementing new databases, and service pack
implementation.
> Lead support on Computer Aided Dispatch (911) SQL Servers 24/7
including SQL Replication and Log Shipping for Disaster Recovery, and
day to day troubleshooting. Developed and implemented 2005 Reporting
Services environment for ad-hoc reporting.
Work with a development team to help create and tune SQL queries and
stored procedures for effective use of database resources as
applications are designed and implemented.
> Upgrade ArcGIS environment through two version releases and from SQL
Server 2000 to 2005, including updating ArcObject executables in VB6
and VB .Net 2005
> Maintained 125 servers running Windows 2000/2003, including backup
operations, patch management, and security review.
Healthaxis, Inc. 1990-2002
Formally the Data Processing division of UICI, Aegon, and Life Investors
from 1990 to 1999
Manager - Local Area Network Support
Manage all areas of the Windows 2000 Local Area Network.
> Documented overall network availability of 99.8% from 1997 to 2002 while
running Microsoft Windows Operating Systems, both Windows NT and Windows
2000.
> Designed and implemented SQL Server 7.0 databases for backend process
information such as backup information and automated TCP/IP assignment
program.
> Implemented and supported a new Windows 2000 Active Directory domain.
> Migrated 1,000+ workstations, and their business processes, from
DOS/Novell O/S to Windows NT O/S
> Developed and executed an offsite Disaster Recovery plan for the Windows
2000 Active Directory domain.
> Managed a technical group of six individuals supporting 100 Windows
NT/2000 servers spanning from Philadelphia to Utah to Jamaica, with the
bulk of the equipment in the D/FW area.
> Created, justified, and ran a hands-on lab allowing for change management
within the Local Area Network.
CCH Computax, Inc. 1981-1990
An Income Tax Processing division of CCH, Inc.
Director of Customer Support
Managed a team of 24 technical personnel supporting the nationwide
clientele using the Computax Income Tax Processing Software.
> Frequently resolved Income Tax Processing issues, both software and tax
regulation issues, for Senior Tax Officers at National and Regional
Accounting offices. Some problems would require on-site visit to
customer's offices for resolution
> Developed and taught internal training programs for new accounting based
software. These training programs required travel to the Regional
Support Offices throughout the U.S.
> Repeatedly recognized by customers for customer service above and beyond
their expectations.
Education
BBA, University of Texas at Arlington, Arlington, TX
Microsoft Classes Taught
Microsoft 2779: Implementing a Microsoft SQL Server 2005 Database
Microsoft 2071: Querying Microsoft SQL Server 2000 using Transact-SQL
Microsoft 2073: Programming a Microsoft SQL Server 2000 Database
Microsoft 2151: Microsoft Windows 20000 Network and Operating System
Essentials
Certifications
Microsoft Certified Support Engineer (MSCE) for Windows NT 4.0 and Windows
2000
Microsoft Certified Database Administrator (MCDBA) for SQL Server 2000
Microsoft Certified Technical Specialist for SQL Server 2005
Microsoft Certified Trainer (MCT)
Hands on Experience
Server Hardware - Compaq Proliant, Dell PowerEdge, IBM
Remote Access Systems - Microsoft RAS, Shiva, Cisco VPN
Network Topologies - Arcnet, Token Ring, Ethernet (including Gigabit
Ethernet)
Network Operating Systems - Windows 4.0/2000/2003 including Active
Directory, Novell 4.0 NDS, Linux (Slackware 7.0, 8.1)
Database Systems - Microsoft SQL Server (7.0, 2000, 2005, 2008), Access (97
through 2007)
Network Monitoring Tools - Compaq Insight Manager, C/A UniCenter, Net IQ
Web Servers - Microsoft IIS (3.0 through 7.0), Apache for Intel