Sql Server Management

Jeremy Jones, MCSE [pic]

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

Austin, TX 78739

Mobile: 512-***-****

**********@*****.***

QUALIFICATIONS:

. 13 years of extensive, hands-on experience in network and systems

administration, design, troubleshooting, and implementation

. 10 years of management and team lead experience

. Highly responsible and results-oriented

. Talent for strategy brings clarity to complex problems and situations

. Enjoys leading large-scale, complicated projects

. Excellent oral and written communication skills

MANAGEMENT EXPERIENCE

. Regularly prepare status reports (weekly) and presentations (as

needed) for upper management on current projects and issues.

. Responsible for preparing (and not exceeding) yearly budget and

negotiating with vendors on new purchases and maintenance/support

contracts.

. Responsible for performance management, pay planning and career

development of my employees.

. Facilitate the interviewing and hiring process for full-time and

contract employees.

. Plan and facilitate weekly staff meetings to review outstanding

trouble tickets and work requests, current project work, new HR

Policies, etc.

. Regularly schedule and lead meetings via conference call, video

conference, etc.

. Regularly work across business and technical groups at Schwab on

projects that affect my group or on our projects that have an effect

on other groups.

. Work with internal and outside audit teams on process and security

audits and remediation work.

TECHNICAL AND PROJECT MANAGEMENT EXPERIENCE (Charles Schwab & Co., Inc.,

acquired The 401(k) Company in 2007):

. Designed and implemented a redundant core routing/switching

environment using Cisco Catalyst 6509 devices in our Austin and Denver

Datacenters with redundant WAN circuits (2010).

. Served as Technical Lead of a project team that moved equipment for

approximately 400 users out of a downtown facility to a north Austin

location which has saved the company considerably in real estate

costs. Also had to decommission and safely dispose of a datacenter

and all the servers, voice, and network equipment within. This

project involved a lot of engineering in the form of new and re-

groomed circuits, routing changes, new servers, new network equipment,

etc. to maintain 100% availability before, during, and after the move.

Met a hard deadline which avoided expensive fees that a delay would

have incurred (2009).

. Served as Technical Lead of a project team that migrated approximately

400 user mailboxes from The 401(k) Company email servers to Schwab

email, blackberry, and chat servers. Significant mail routing changes

were required since so many applications used our mail services. Also

archived and eliminated pst data files and retired the 401k email

infrastructure (2008).

. Served as Technical Lead in an Active Directory Domain migration

project. Worked through a myriad of issues with Infosys Consultants

to move all user and computer accounts, security groups, etc. from the

401k domain to the Schwab domain (2007).

. Designed and implemented migration to Schwab security standards

involving the installation of Marimba on all workstations for patch

management (BigFix for servers), McAfee antivirus, Credant for laptop

hard drive encryption, and Computrace for theft/loss recovery of

laptops (2007).

. Designed and implemented a more secure and redundant Citrix SSL VPN

and Citrix Presentation Server environment to replace the Microsoft

VPN for remote access (2006).

. Designed and implemented a fault tolerant secure email system to

integrate with Exchange and our Client-facing websites using Talisma,

Doubletake (OneSwitch), and Microsoft SQL Server (2006).

. Implemented mail archival, spam/virus blocking, and the Emergency Mail

System with Smarsh and MessageOne (2006).

. Implemented replication of all Microsoft Exchange and SQL servers

using Doubletake software and the MessageOne OneSwitch add-on service

for seamless failover and failback (2006).

. Implemented replication of all Windows file servers using Doubletake

Software.

. Replaced legacy FTP server with the much more secure Enhanced File

Transfer server by Globalscape which supports SFTP, HTTPS, FTP, and

PGP encryption/decryption along with notification emails and file

copies/moves via automated rules.

. Configured and maintained Microsoft Exchange 2003, 2000 and 5.5

Servers, including migration.

. Creation of redundant SMTP gateway servers in multiple locations using

IIS with Mail Essentials anti-spam and virus protection software.

. Installed and configured Blackberry Enterprise Server for Exchange and

installed/managed handheld units for approximately 80 users.

. Designed and implemented a fault tolerant multi-site network using

Catalyst 6509 Switches with redundant route switch modules at multiple

datacenters housing our mission-critical applications and servers.

. Established site-to-site IPSec VPN's with client and partner companies

using Cisco Pix firewalls and Cisco 3600 and 2600 series routers.

. Installed and configured a Catalyst 6009 switch with redundant route

switch modules. Migrated LAN from one flat private IP address scheme

to a multi-subnetted network using VLAN's across multiple switches via

a common VTP domain.

. Coordinated and implemented installation of DS3 and DS1 internet and

point-to-point circuits with multiple vendors using the following

equipment: Cisco routers and firewalls, Nokia IP650 running Firewall-

1/VPN-1, and Lucent Bricks.

. Worked in a team to establish a change management and helpdesk

solution for the software development side of the company and our own

department using IBM Rational Clearquest and Microsoft SQL Server.

Specifically, my role was to install and maintain the server and

develop the application it hosted using a GUI development environment

and Visual Basic.

. Designed and implemented a MS Systems Management Server site. This

allowed for hardware and software inventory, remote control, and

software distribution on all network clients and servers.

. Disaster recovery of mission critical servers on several occasions.

. Implemented virus protection and automatic virus definition updates on

all servers and workstations using Symantec Antivirus and McAfee

Netshield/Groupshield.

. Configured and maintained Microsoft Remote Access Server for user

access to the internal LAN via VPN or modem dial-up.

. Configured and maintained FTP server using WS_FTP server software.

. Configured and responded to extensive system and service monitoring

system using Sitescope and Siteseer software.

. Responsible for backup and recovery of all Windows servers using

Legato Networker.

. Implemented Sybase, Access, and Microsoft SQL Server for numerous in-

house application servers - responsible for maintenance and backup of

said databases.

. Designed and implemented a variety of automated electronic data

transmissions with client companies and trading partners utilizing one

or more of the following technologies: batch files, PGP encryption,

FTP, site to site VPN, Blat, Procomm Plus, Hyperaccess, Windows

Scheduler (winat), NFS, Samba, rsh, and UNIX cron jobs.

. Worked in a team to design and implement an upgrade to a Windows 2000

Active Directory Domain from Windows NT.

PROFESSIONAL HISTORY:

Senior Manager - Network Systems Administration, Charles Schwab & Co.,

Inc., Austin, TX. 2006 - Present. Managed a team responsible for the

implementation and administration of all network equipment, telephone and

phone switch equipment, Microsoft desktops/laptops/servers, the email

messaging environment, Apple Macintosh machines, and our VMWare

environment. My team was also responsible for the helpdesk phone and

ticketing system, hardware/software budgeting and purchasing, information

security, and file transfers with encryption.

Systems Administrator Team Lead, The 401(k) Company, Austin, TX. 2001 -

2006. Responsible for overseeing the operations of the Systems

Administration staff, IT purchasing, and project management for enterprise-

level technical projects. Managed helpdesk by delegating trouble tickets

and resolving escalated issues. Still maintained Systems Administrator

role responsibilities as well.

Systems Administrator, The 401(k) Company, Austin, TX. 1999 - 2001.

Responsible for implementation and administration of Windows Servers and

all network gear (including switches, routers, firewalls, wireless

equipment, etc.). Interacted extensively with vendors, technical support

centers, and clients. End user support on escalated helpdesk issues.

PC Administrator, The 401(k) Company, Austin, TX. 1998 - 1999. Responsible

for new computer setups, moves, installing, troubleshooting, and repairing

PC systems and related peripherals. Interacted extensively with end users

on NT workstations, Microsoft Office, UNIX connectivity, and Adobe

products. Entry level server installation and maintenance.

EDUCATION/CERTIFICATIONS:

Bachelor of Business Administration in Management Information Systems,

University of Texas at Austin, 1998.

Microsoft Certified Systems Engineer 2000 and 2003

Completed Training Courses

. Implementing and Managing Microsoft Exchange 2000

. Implementing and Managing Microsoft Exchange 2003

. Interconnecting Cisco Network Devices

. Administering Microsoft SQL Server 2005

. Microsoft Windows 2003 Certification Upgrade Boot Camp

. Microsoft Windows 2000 Certification Boot Camp

. Administering SMS 2.0

. Implementing and Supporting NT Server 4.0

TECHNICAL SKILLS:

. Cisco Routers (7200, 3800, 3600, 2600, 1800)

. Cisco Switches (6500, 3600, 3500, 2900)

. Cisco Pix Firewalls (515)

. T-3, T-1, Ethernet (Gigabit Ethernet, Fast Ethernet), Metro Gigabit,

ISDN

. Routing Protocol (EIGRP, BGP), Routed Protocol (TCP/IP)

. File Transfers using FTP, HTTPS, SFTP, PGP, VPN

. Globalscape Enhanced File Transfer Server

. Windows NT, 2000, 2003, XP

. Active Directory, Group Policy, DNS, WINS, DHCP, RAS

. Microsoft Exchange 5.5, 2000, and 2003

. Microsoft SQL Server 2000 and 2005

. Blackberry Enterprise Server

. Citrix Access Gateway (SSL VPN) and Presentation Server

. Norton Ghost

. OmTool Genifax (Fax_Sr)

. Legato Networker

. Remedy Change Management and Helpdesk software

. Proficient with VMWare

. Proficient in Visual Basic, windows scripting, and C++.

. Proficient in AIX, Solaris, and Linux.

Contact this candidate