Post Job Free

Resume

Sign in

Manager Sql Server

Location:
Minneapolis, MN
Posted:
July 06, 2014

Contact this candidate

Resume:

Dale W. Holtberg

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

Minneapolis, MN 55414

office phone 612-***-****

cell phone 612-***-****

aceu9p@r.postjobfree.com

Experience: Over twenty plus years experience in the Information Technology and the

Consulting industry. Positions held; Large Server System and Database (SQL)

Administrator (MS server farm of 35 servers), Information Systems Manager,

Server and PC Administrator, Account Manager, Consultant, Main Frame Systems

Programmer, Technical Application Developer, Programmer Analyst (Batch and

Online applications). Strengths include: a well-developed set of diagnostic skills,

strong problem resolution skills, a self-starter and a fast-learner, a natural

curiosity, proven ability to put people at ease when working with the different

communities to resolve issues.

1997 to Present FBN, Inc., Minneapolis, MN

Owner/Consultant

Assist individuals, small, and mid-size companies on a part or full-time basis.

• MS SQL DBA

• MS SQL installation and set up

• MS Server installation and setup

• MS Workstation installation and setup

• Server setup in Real, Clustered, and Virtual environments

• Server, desktop, and application maintenance

• Problem determination and resolution

• Server and desktop backup and recovery

• Disaster recovery planning

• Network (wired and wireless) installation/troubleshooting

• E-Mail (MS Exchange and others)

• Internet and service provider setup

• Well versed in the Microsoft Server, Workstation and Office Suite

• Perform database tracing, network tracing, and wireless channel interference, wireless

spectrum analysis, and data loss diagnostics

• FBN, Inc. owns and maintains an MSDN subscription and a test lab that supports some

older and current software and operating systems levels. This is used for product

evaluation, training, and situational testing scenarios

Have been performing contract work on a continuous basis performing tasks as described above.

The variety of the work is what I enjoy.

January 2002 to September 2013

System Administrator – McKesson Horizon Patient Folder (HPF) HealthEast Care System –

13th largest hospital in Minnesota, 5,000+ users, 4 facilities, and a lot of clinics

• Responsible for the all aspects of the HPF (Electronic Medical Record) system

• Designed the server- farm architecture

• Install and maintain W2K8 operating systems

• Install and maintain the HPF application on servers and workstations

• Design and deploy upgrades

• Assess, diagnose, and resolve Operating Systems and applications issues

• Work with user community to understand needs and resolve issues

• Work with the infrastructure teams to address system needs

• Monitor systems; make necessary adjustments to maintain system performance

Microsoft SQL DBA:

• Provide database administration, system administration and end user support

• General security and database/server maintenance

• Installation of SQL Server 2008 and older

• Upgrade SQL 2008 and older on cluster, stand-alone, and virtual server

• Manage SQL Server 2008 and older jobs, monitor processes, tune databases

• Set up, maintain, and test offsite Disaster Recovery servers

• Tuning and troubleshooting through the use of SQL Profiler and various scripts to

identify blocking, long running spids and CPU usage

• Provide 24 X 7 support for high-availability business critical databases

• Regularly scheduled major code releases for all QA, Test and Production environments

including reviewing all scripts before deployment to confirm proper use of best practices

by development

• Acting lead DBA for primary application

• Manage large databases ranging from 200 gigabytes to 8 terabytes

• Set up, maintain, and test Backup and Recovery process

• Database development using T-SQL, SQL Stored Procedures, Triggers, Views, functions

for SQL Server 2008 and older

• Evaluate and test various SQL Server monitoring tools

• Perform database backups and restores

• Troubleshoot and resolve hardware/software issues

Microsoft Server and Client Systems Administrator:

• Provide server system administration and end user support

• General security and server maintenance

• Installation MS Server 2008 and older

• Installation MS Workstation 2008 and older

• Upgrade MS Server (enterprise and standard) 2008 and older on cluster, stand-alone, and

virtual server

• Set up, maintain, and test offsite Disaster Recovery servers

• Tuning and troubleshooting through the use of MS Performance Monitor, NetMon,

WireShark, SolarWinds and various other monitoring tools

• Provide 24 X 7 support for high-availability business critical applications

• Regularly scheduled maintenance server and application

• Evaluate and test various MS Server monitoring tools

• Perform backups and restores as necessary

• Troubleshoot and resolve hardware/software issues

• EMC Centera & Diskextender

Major accomplishment: Improved HPF system performance from unplanned system cycles

several times a month, and handled numerous support calls during off-call hours using deliberate

observations, measurements and planned improvements. The end result being a system that only

has planned maintenance down time and perhaps one or two support calls per month.

Diagnosed multiple infrastructure problems that have impacted my areas of accountability.

Assisted other areas to diagnose and identify the root problems. The appropriate infrastructure

groups were able to apply the necessary hardware, software, and microcode modifications to

resolve the problems. This in turn not only resolved issues with my accountabilities but other

business systems as well.

Awards: HealthEast’s “One of Our Best” awards for going above and beyond and

positively demonstrating HealthEast’s Core Behaviors. This simply means that I

would not give up on a problem until it was fully resolved and the user

community could depend on the results.

1982 to 1997 Davis, Thomas and Associates, Inc., St. Louis Park, MN

Information Systems Manager

Held various advancing positions. As the Information Systems Manager; responsibilities

included maintaining and improving current systems and applications, developing and

implementing the corporate infrastructure vision, planning, implementing and maintaining new

systems and applications. Supported the Software Development branch office in Bangalore India

and managed the import/export issues involved with shipping hardware and software to another

country. Administered and managed a joint venture with Data Matics, Ltd. of Mumbai, India

that included travel to India.

Account Manager

As the corporation’s first Pilot Account Manager, Worked with the sales staff to develop current

client relationships and gain new client contacts. Was involved in defining the project and its

scope, as well as selecting the consultants for the project. Was responsible for monitoring,

evaluating, and reviewing the consultant's projects, work product, and client expectations, as well

as consultant development. This position allowed me to work extensively with middle and upper

management and to experience the process companies use to manage projects and develop

infrastructures.

Consultant

As the corporation’s first Pilot Systems Programming Consultant, Planned, installed, and

maintained IBM mainframe operating system and application support systems. This included

VM, VSE, VTAM, NCP, CICS, ICCF, VSAM as well as other vendor support packages. Along

with the installation of these systems I was responsible for training users and operations staff.

Assisted the Products Division in development of several commercial products for general sale

to the public. Also wrote user exits in Assembler language for MVS and JES.



Contact this candidate