Post Job Free
Sign in

Sql Server Manager

Location:
Temple, TX, 76501
Posted:
September 12, 2010

Contact this candidate

Resume:

Paul LaGrone

**** *. *** ******

TEMPLE, TEXAS **501

254-***-****

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



Contact this candidate