Manager Sql Server
Resume:
Dale W. Holtberg
Minneapolis, MN 55414
office phone 612-***-****
cell phone 612-***-****
*********@***.***
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