Engineer Sql Server

Title:Analytical Consultant

abpkb0@r.postjobfree.com

Document

Source below

NAME: Sam Barncord

ADDRESS: **** *** ******* ** *** 327

CITY: Irving

STATE/PROVINCE: TX

ZIP/POSTAL CODE: 75063

COUNTRY: USA

EMAIL: abpkb0@r.postjobfree.com

PHONE: 214-***-****

CANDIDATE ID: 114699

CITIZENSHIP: US

Citizen

EDUCATION: Other

EXPERIENCE: 4

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: $90000 $95999

HOMEPAGE:

HOTSKILLS: Database Administration(4), Crystal Reports(0), Visual Basic(0), IIS(3),

Windows NT(6), SQL Server(4), LAN/WAN(5), TCPIP(5)

ESUME

SAMUEL C. BARNCORD

1002 San Jacinto #327

Irving, Texas 75063

Home 214/496-9625

TECHNICAL

SUMMARY: Hardware: 386,486 AND PENTIUMS PC COMPATIBLES, 3COM, COMPAQ servers, and HEWLET

PACKARD servers

Operating

Systems: WINDOWS NT/95/98/2000, MS DOS.

Software: MS SQL 6.5/7.0/2000, MS TRANSACTION SERVER, SEAGATE CRYSTAL REPORTS 7.0/8.5,

CAST WORKBENCH, ERWIN, MS EXCHANGE, MS OUTLOOK, SOLOMON, LOTUS NOTES, MS WORD, MS EXCEL,

MS ACCESS, MS MAIL

Networks: MICROSOFT, NOVELL 3.X-4.X LAN AND WAN, INTERNET, FIREWALLS, ETHERNET, TCP/IP,

RIP, IGRP, OSPF, T-1, T-3, 3COM HUBS AND ROUTERS, CISCO ROUTERS, ASCEND ROUTERS, NETWARE

CONNECT 1.X-2.X

Programming

Languages: T-SQL, VISUAL BASIC 6.0

EXPERIENCE:

Rare Medium, Inc

. Dallas, Texas 12/00-PresentDBA

Perform routine DBA functions for Microsoft SQL Server 7.0 and 2000 databases including

database design, installing and upgrading, backup and recovery, security and performance

tuning. Developed custom in-house database to manage service requests, system outages, and

system change control. Provided custom Crystal Reports for 3rd party systems.

GTE Internetworking, Irving, Texas 12/98-12/00DBA/Senior Advisory Systems Engineer

Perform routine DBA functions for SQL Server 6.5, 7.0, 2000 databases including database

design, installing and upgrading, backup and recovery, security and performance tuning.

Solved database consistency, allocation, query utilization, and process performance

issues. Designed stored procedures as SQL AGENT Task for DTS packages importing/exporting

data from/to other OLE DB data sources. Designed stored procedures to notify individuals

and to cleanup data issues. Support databases for provisioning of dial-up customers

services (i.e. Mail, News, Radius, FTP, ISDN, ADSL, etc.) and DSL order entry system.

Providing redundancy of databases via SQL replication. Developed custom reports for

clients. Responsible for all phases of SQL databases design, ongoing development,

implementation, and optimization. Used CAST WORKBENCH and ERWIN for design and further

development of SQL databases. Developed database and Visual Basic client to help manage

order entry of DSL by controlling agencies and vendors.

GTE Internetworking, Irving, Texas 8/98-12/98NT/SQL Administrator

Responsible for implementation and maintain of 8 Internet Information Servers, and 12 SQL

Servers for provisioning of customers account. Implemented clustered SQL Servers to

provide redundancy.

CapRock Communications, Dallas, Texas 5/97-7/98LAN Admin/System Engineer

(acting MIS Manager)

Support a 100 node Microsoft TCP/IP networks covering three sites over Cisco 2500 series

(2524) routers (using RIP, IGRP, and OSPF), Internet access via Ascend Pipeline 50 router,

implement and maintain Secure Computing - Firewall for window NT. Eight servers covering

PDC, BDC, MS SQL 6.5, MS Exchange 5.5, MS IIS 4.0, Solomon 4.

CompUSA Inc

., Dallas, Texas 3/96-3/97System Administrator/ Systems Engineer

Responsible for supporting and administrating 100 node Novell network consisting of eight

servers, later migrated to Microsoft TCP/IP DHCP network of nine servers with Windows NT

4.0 (with Policies and Profiles), MS SQL 6.5, and Lotus Notes. Provide 2nd and 3rd level

Novell support to retail Tech Departments, Configure Installation Services teams.

Cutler/Williams Inc

., Dallas, Texas 11/94-3/96LAN/WAN Administrator

Supports a 250 node Novell Local Area Network utilizing four Novell Servers and two

Windows NT SQL 4.2 servers in an Ethernet topology. Supports 350 node WAN spanning over

eight remote sites via Frame-Relay using 3COM and Cisco routers. Configure file server

layouts and naming schemes. Duties include adding/deleting users, providing system

security and access, implementing disaster recovery and running system backups. Building

file servers form scratch and troubleshooting over 200 peripheral devices including

file/print servers, PCs and printers

s. Also install upgrades and supports multiple software packages including Microsoft

Office suite, MS Mail, and cc:Mail. Responsible for researching and purchasing

hardware/software according to customer requirements.

TGI Fridays Inc

., Dallas, Texas 10/93-11/94Micro Systems Support Technician

Responsible for evaluation, installation, and supporting PC hardware/software in a

corporate LAN environment with 500 nodes and six file servers. Install and upgraded

multiple software packages including all Microsoft products. Provided 2nd level help desk

support for internal customers.

CompUSA Inc

., Dallas, Texas 8/92-11/93Technical and Customer Services

Provide support services to retail customers regarding hardware/software issues.

United States Air Force

9/89-5/92

304X0 Wideband Communication Technician

Responsibilities for supplying a full range of secure air-born communication (SATCOM,

UHF, VHF, and HF). Provide and maintain fiber optics (T1, T2 and T3 Data Streams), and

microwave communication for the Department of Defense.

EDUCATION: USAF Technical School,

Kessler AFB, Mississippi.

Course of Study: Wideband Communication Equipment Specialist.

Brookhaven Jr. College,

Farmer Branch, Texas.

Course of Study: Electrical Engineering and Computer Science

.

CERTIFICATIONS: Toshiba Technician 1/93

Microsoft Certified Professional (#207864) 7/95

Certified Novell Administrator 4 9/96

Certified Novell Administrator 3 10/96

Contact this candidate