Manager Sql Server

Mark Pearson

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

Campbell, CA. 95008

Cell: 408-***-****

mailto:abg70x@r.postjobfree.com

SUMMARY

. 10 years Windows 2003/2008 Professional/Server, both 32 bit

and 64 bit, XP Pro

. 10 years Active Directory (~4 years vbscript programming

against AD)

. 10 years Microsoft TCP/IP, DHCP Server, DNS Configuration and

management

. 8 years Internet Information Services (IIS) 5.1, 6.0, 7.0

. 5 years automation scripting (Vbscript)

. 4 years IBM and HP blade servers (HS20, LS20, HS21, HS22,

bl460g1, g5 and g6 blades)

. 2 years Vmware VirtualCenter management (Versions 3.0, 3.5

and vsphere 4.0)

. 2 years Symantec Antivirus 8.x, 9.x, 10.x server and client

. 1 year HP Sitescope Monitoring

. 1 year Altiris Deployment Server 6.9

. 1 year Netscalar load balancers

. 1 year Windows Cluster Services

. 1 year Microsoft Exchange 2007/2010

. 1 year HP server management infrastructure (Insight Manager,

HP Smart Update Manager, Version Control Repository)

. 1 year SQL server 2005 & 2008

. 1 year Powershell scripting

. 6 mo. Office Communications Server

. 6 mo. Mcafee Anti-virus EPO server 4.5.0 and client

EDUCATION & CERTIFICATION

. Bachelor of Arts in Psychology, UC Irvine, completed: June 1992

. A+ certification, Sylvan Prometric, completed: August 1999

. Cisco ICND training, completed: April 2001

. Microsoft Certified Professional (MCP), Windows 2000 Server,

completed: April 2002

. Associates of Sciences in Computer Information Systems, Shasta

College, completed: July 2003

. Microsoft Certified Professional (MCP), Windows 2003 Server,

completed: May 2006

. Microsoft Certified Systems Administrator (MCSA, 2003),

completed: August 2009

WORK HISTORY

Windows Engineer, Mphasis - Cupertino, CA. 5/2011 -

. Managing array of HP blade infrastructure including c3000 &

c7000 chassis' with bl460c G1 - G7 servers hosting both Vmware

and Microsoft Hyper-V clusters.

. deploying mainly windows 2008 R2 64 bit OS machines on both

virtual infrastructures using an HP Altiris RDP deployment

server.

. Managing the deployment of HP blade and chassis firmware and

software updates using both remote management tools and manual

methods.

. Setting up test platforms for QA/testing of HP Insight Recovery

tool, including deploying and testing new software builds of

HP's flagship Systems Insight Manager server/storage/switch

management product with the Insight Recovery component.

Windows Systems Administrator, Travelzoo - Mountain View, CA. 9/2010 -

5/2011

. Built out and setup HP Insight Manager server, configured SNMP

and email alerts for HP blade and proliant rackmount hardware

health monitoring.

. Setup HP version control repository and smart update manager for

managing driver and firmware updates on BL460c G1, G5 & G6

blades, and proliant rackmount servers.

. Setup web application performance testing environment and

analyzed performance data from IIS 6.0 application farms, load

balancers, SQL server 2005 databases to improve overall site

performance.

. Built out SQL server 2005 & 2008 new installs.

. Performed queries against SQL server 2005 using SQL server

management studio, and also added/removed users, roles &

permissions on master and child databases.

. Built out newly deployed web application farms utilizing IIS 6.0

and both Windows 2003 and 2008 server.

. Deployed automated windows server patch environment using

vbscript.

. Managed Windows based virtual machines using Virtual Center with

ESX server 3.5 and 4.0.

. Performed light management of 3par based SAN using Inform

Management console, including exporting LUN's to two or more ESX

servers for enabling migration of VM's between ESX servers, and

creating new storage volumes to add additional space for

existing guests.

. Managed MS Exchange clusters, including failing over cluster

nodes for maintenance, and overall user account, public folder,

email routing/flow troubleshooting and management. Managed

permissions and access to public folders, user and group

mailboxes. Used powershell to perform mass mailbox migrations to

SAAS storage.

. Created and tweaked Active Directory GPO's including Adobe

Acrobat software deployments, firewall and auditing policies.

. Manage OCS (Office Communications Server) environment including

updating Active Directory to configure new and existing users

for remote instant messaging, SIP changes, and troubleshooting

user communication issues.

Windows Systems Administrator, Xilinx Corporation - San Jose, CA.

6/2010 - 9/2010

. Managing application infrastructure as part of contract to

provide Microsoft windows support to Corporate IT services.

. Remediate and manage Windows Software Update services patching

environment.

. Install and configure IIS 7 on servers to redirect from HTTP to

HTTPS driven web application, and host ASP.NET pages.

. Participating in migrating windows anti-virus from current

Symantec platform to new Mcafee anti-virus solution, including

installing client software on servers, ensuring current agent

versions, DAT file versions, and overall health of migration

process, and monitoring servers in console for proper

functionality of anti-virus.

. Using windows command line utilities (secedit) to create and

deploy security templates for windows OS hardening.

. Built out new Avocent switch infrastructure and migrated from

Dsview 2.1 server software to newer 3.7 platforms. Deployed

servers with Dsview software to all major sites. Integrated

Dsview software into active directory to provide windows domain

login capabilities.

. Build Windows based virtual machines using Vmware Virtual

Center, migrate guest machines to new datastores, and provide

general monitoring and maintenance of the Vmware Vsphere 4.0

environment.

. redeploy windows OS server templates using sysprep and

unattended install technologies after installing upgraded

software components.

. Built out two node exchange 2003 cluster for testing of public

folders migration to new backend storage. Included installing

and configuring HBA cards to connect to SAN/NAS storage,

snapdrive software to import LUN's as NTFS volumes/drives, and

exchange software to service requests from client access

frontend exchange nodes for user inbox/calendar access on

backend server.

Windows Systems Administrator, Mimeo.com - Hayward, CA. 3/2010 -

5/2010

. As part of short-term contract with Mimeo.com, managed and

executed windows domain and site migration from Emeryville, CA.

location to new Hayward, CA. office.

. Created and ran script to reset all local passwords on computers

across old domain to facilitate moving them to new domain.

. Reconfigured print server with new locations of migrated

printers, repointed TCP ports/internet addresses on both print

server and print devices.

. Created service accounts in new domain to replace old service

accounts, and applied them to scheduled tasks replacing those in

old domain.

. Migrated user profiles on local desktops and servers where

required from old domain to new domain.

. Setup/configured/authorized in active directory new Microsoft

dhcp server to replace old server, along with configuring new

scopes, reservations, and exclusions for new subnet.

. Worked with software vendors to move their applications to new

domain and resolved any DNS/WINs name resolution issues

resulting from moves.

. Built out local exchange 2010 server in new location, including

configuring basic distribution groups and recipients inbox's for

local users and performed handoff of server to enterprise

sysadmin to integrate into corporate wide email infrastructure.

. Re-setup static DNS A, CNAME, and NS records on Microsoft DNS

server with IP's of new subnet while old domain was still online

to allow old domain to effectively resolve host names in new

domain.

Windows Systems Administrator, IAP World Services - Livermore, CA.

9/2009 - 1/2010

. As part of contract with National Ignition facility at Lawrence

Livermore Laboratory performed Windows server and infrastructure

maintenance, troubleshooting and architecture buildouts.

. As part of architecture projects built, tested and deployed a

sharepoint team services server for use by NIF IT project

managers, team leads and contributors.

. Also assisted in building and deploying a replacement Windows

2003 Cluster Service server with a file server backend.

. Built and deployed virtual machines using Vmware virtualcenter

vsphere 4.0.

. Wrote a NIF specific Active Directory cleanup script using

ADO/LDAP search queries to locate and quarantine for later

deletion stale computer accounts.

. Wrote script to change a locally configured server admin

username's password across all servers in Active Directory.

. As part of maintenance duties built out windows based servers

for various projects. Server versions utilized included both x64

and x32 versions of Windows Server 2003 and 2008.

. Configured and setup printer drivers and permissions for client

hosts in a centralized printer server environment.

. Built out and configured IIS 6 websites, also renewed

certificates using institutional IT subordinate CA server to

obtain raw certificate files to install on servers/web sites

needing renewals.

Windows Systems Administrator, Ebay - San Jose, CA. 6/2007 -

9/2009

. Acting as windows server and infrastructure administrator for

175+ server environment for Ebay development/testing labs, and

also 1000+ server environment for QA.

. Used Vmware VirtualCenter versions 3.0, 3.5 and vsphere 4.0 to

build and deploy virtual machines.

. Used HP sitescope monitoring tools to monitor IIS, apache

webservers, and Vmware virtual machines.

. Manage Shavlik Netchk Pro patch deployment environment end to

end on one server instance for Lab environment. Wrote VB scripts

to automate patch deployments.

. Manage Norton Antivirus Software server clients in both lab and

QA environments, including remotely deploying GRC.dat files to

host machines to change scan schedules and other local client

configuration, and remediating server hosts that were reported

as not functioning by the server.

. Use gpedit, group policy management tool, gpresult and resultant

set of policy tools to create, deploy and troubleshoot

deployment and effect of GPO's on Labs OU's.

. Manage file share permissions, create custom NTFS and share

level ACL's and deploy batch files for mapping filer shares on

client computers.

. Configure and troubleshoot IIS 5.0 & 6.0 when in use on servers.

Process certificate requests to third party vendors (verisign),

download and install certificates on IIS servers, and assign to

websites. Manage and troubleshoot logs and log settings.

Troubleshoot web site performance and issues.

. Installed, configured and managed DHCP server on build network

in Lab.

. Managed and configured Netscalar load balancer pair in labs and

QA environments.

. Configured and managed Altiris Deployment Server 6.9, including

task management and deployment, script creation and management

with DS framework, usage of Microsoft WAIK to create winpe 2.0

boot images for client servers to boot to and receive Windows OS

images.

. Build and manage IBM and HP blade servers (HS20, LS20, HS21,

HS22, 460g6 and g5 blades) end to end with W2k, W2k3 32 & 64bit,

2008 server products.

. Build both IBM/SUN x335, x336, x4100 servers with all

aforementioned OS' and manage these servers remotely using ASM,

RSA, ILO and serial interfaces. Configured serial interfaces for

basic network connectivity remotely using cyclades remote KVM.

. Configure both dlink/alteon layer 2/3 and copper pass-through

switches on bladecenter chassis'. Used vlan capabilities of

layer 2/3 switches to segment blade network interfaces into vlan

memberships for separate build and public networks.

Windows Server Administrator, ITC Infotech - Mountain View, CA.

8/2006 - 6/2007

Provide Tier 2 technical support remotely maintaining,

monitoring and repairing 4,000+ IIS 6.0 server cluster

environment for Microsoft Hotmail datacenter.

. Troubleshoot connectivity to servers, including web based

internet client access, local intranet access, SMB windows share

access, and low level network access between switches, VLANS and

routers separating server clusters. Use various tools such as

ping, netstat, pingpath, nslookup and tracert to trace and

resolve network connectivity issues.

. Monitor and troubleshoot server performance using windows

performance monitoring counters/trace tools, web based client

provided (Microsoft) cluster monitoring tools; detect and

resolve server application issues using IIS 6 httperr and

application logs, httpwatch, task manager, tasklist, system

monitor, request monitor and perfmon tools.

. Deploy standard server builds (Windows 2003 server) using ADS

(Automated Deployment Services). Troubleshoot and resolve

various ADS issues including problems with DNS name

registration, DHCP services, MAC address discovery and

resolution, and ADS XML template/script deficiencies. Also

resolve ADS connectivity issues using aforementioned network

troubleshooting.

Windows Desktop Administrator, Business Control Systems - Sunnyvale,

CA. 3/2005 - 8/2006

Manage local Organizational Unit infrastructure as part of 2003

Microsoft Enterprise Active Directory Infrastructure for Texas

Instruments.

. Plan and implement Group Policies in conjunction with Corporate

IT services at the local OU level. Troubleshoot Group policy

using command line tools such as gpedit and gpresult to isolate

and correct problems applying Group Policies.

. Resolve network connectivity issues such as DHCP lease problems,

DNS name resolution problems, TCP/IP conflicts and

misconfigurations.

. Manage, troubleshoot and replace/install server hardware (Dell

poweredge 1500 and 1700 series, HP Proliant DL360 rackmount

servers).

. Manage local Norton Antivirus Software PC clients, including

remotely deploying GRC.dat files to host machines to change scan

schedules and other local client configuration.

IT Support Technician, Computer Logistics Corp.- Redding, CA.

9/2003 - 01/2005

. Completed full migration to Windows 2000 server active directory

domain.

. Support and management of Windows NT 4.0 workstations within NT

Server domain environment for Tehama County Social Services

department.

. Support and Management of routed and secure network in a

northern California based county elections office.

. Setup and configured login batch files in government offices.

. Performed help desk troubleshooting functions for various

business and home customers.

IT Consultant/Full-time Student 12/2001 -

9/2003

. Full-time student at Shasta College earning my A.S. degree in

Computer Information Systems.

. As a part-time consultant for A1 Web Server of Redding, CA.,

designed and implemented a secure web server to serve as a

remote site backup for the Creighton School of Medicine's

student medical records.

Network Technician, I3 Mobile- Hurst, TX. 08/1999

- 08/2001

. RAS, DNS, WINS, DHCP server configuration. Complete TCP/IP

protocol configuration and management for a 35-45 user LAN

Environment, RAS, DNS, WINS, DHCP server configuration.

. Configured and setup a Datacenter for the research &

development office consisting of 30-35 Rackmount Compaq DL380

servers.

. Managed MS Exchange Server 5.5 server, MS SQL Server

Database, Sourcesafe 5.0/6.0.

. Provided support for all software and hardware

upgrades/patches/service packs and performed all new

equipment purchases and setups.

. Maintained and documented tape backup of Novell 5.1

development file server using Seagate Backup Exec.

*All professional/personal references and proof of certifications available

on request

Contact this candidate