Darren Dugan

***** ***** **** ****** *******, Arizona 85050 480-***-**** abj706@r.postjobfree.com

Summary: Over 14 year of hands-on experience in IT across multiple industries. Demonstrated expertise or

proficiencies in; MS SQL Server (6.5,7,2000,2005,2008/R2, 2012) including SSRS,SSIS/DTS, and

SSAS, Oracle Enterprise (7, 8,9i,10g), PostgreSQL (8,9), MySQL (3,4,5), Server /OS Administration

(Windows/Nix), Project Management, n-tier Application Development, Hardware/Software diagnostics,

troubleshooting, documenting, and end-user training.

Upgraded over 1,000 user databases to MS SQL server 2005 & 2008R2.

Performed data migrations for over 100 MS SQL servers to two different SAN technologies.

Key team member in the virtualization (p2v) many database servers to VM Ware (3.5, 4,4.5).

Designed, built, deployed and supported multiple large-scale clustered MS SQL server farms.

Developed and documented annual disaster recovery strategies and testing processes to ensure

RTO/RPO policy adherence.

Developed and successfully implemented accounting systems for several local construction

companies.

Designed and implemented lending/real estate software systems for more than 60 financial

institutions – finished all projects in a timely manner. Provided client training in network operations

and remote access.

Key team member of the successful expansion of telecom customer base, leading to seven-figure

revenue growth rates that far exceed the pace of larger, more established competitors.

One of two lead Designers/Developers on a real time call traffic analysis and reporting system using

MS SQL Reporting and Analysis Services.

Experience: Ideal Networks – Peoria, AZ

Senior Database Administrator, 4/2013

Contracted to design, build, and implement MS SQL 2008 R2 farms with high availability utilizing

Windows Failover Clustering.

American Traffic Solutions – Tempe, AZ

Senior Database Administrator, 11/2011 – 4/2013

Responsible for day to day support and maintenance of user databases, end user support, backup,

recovery, index monitoring & maintenance, database creations & deletions, user accounts, metrics

monitoring, performance tuning, and establishing and maintaining both SQL Server.

24x7 Support for all SQL Server related incidents and/or initiatives

Installation and configuration of Active/Active and Active/Passive clustered instances

Responsible for providing D/R standards and practices

Implemented non-dependency of host/machine/cluster names for client connection using CNAME

aliases and service principle names

Reviewing and enforcing of change control policies and processes

Migration and consolidation of remote databases and/or servers

Provided baseline, trending, performance, and capacity planning metrics

Normalized all data and log file paths across all installations

Responsible for disaster recovery planning, testing, and implementation for MS SQL Servers.

Implemented database replication for constant data availability

Directly work with developers to tune queries and review database designs.

Responsible for identifying and tuning of long-running SQL queries/procedures/functions to reduce

execution time, ease database load, and improve reliability, portability, scalability, and stability.

Freeport-McMoRan (Accenture Contractor) – Phoenix, AZ

Senior Database Administrator, 10/2007 – 11/2011

Team lead for six DBA’s worldwide servicing both MS SQL and Oracle database servers.

Responsible for day to day support and maintenance of 2500+ databases, end user support, backup,

recovery, index monitoring & maintenance, database creations & deletions, user accounts, metrics

monitoring, performance tuning, and establishing and maintaining both SQL Server and LiteSpeed

nightly backups.

Accountable for compiling and submitting daily shift handover and weekly status reports for the

global DBA teams.

Responsible for disaster recovery planning, testing, and implementation for MS SQL Servers.

Darren Dugan

20914 North 38th Street Phoenix, Arizona 85050 480-***-**** abj706@r.postjobfree.com

Implemented database replication for constant data availability for all global site locations.

Key member in the testing and deploying of EMC SAN replication for near real-time MS SQL Server

data recovery.

Instrumental part in the virtualization (VM Ware) of 50+ large scale MS SQL database servers.

Responsible for identifying and tuning of long-running SQL queries/procedures/functions to reduce

execution time, ease database load, and improve reliability, portability, scalability, and stability.

Responsible for the data migration to latest EMC and Net App/UCS SAN arrays for the company’s

North American and variety of mine sites’ servers

Provide 24x7 on call production support for MS SQL Server and fill-in support for the Oracle DBA’s

in their absence.

ALCO-Computing, Inc.– Phoenix, AZ

Developer/DBA, 8/2005-10/2007

Manage and develop VB.Net windows applications for Phoenix area construction companies.

Responsible for developing various software systems and providing on-site software implementation

and support, using various tools (Visual Studio 2005, Dreamweaver) and languages (C#, VB.Net,

PHP, ASP & HTML).

In charge of logical and physical design with major efforts in performance tuning. Major activities

include advanced performance tuning, database design, capacity planning and establishing standards

for MS SQL and Oracle Servers.

Design, optimize, and support MS SQL Server 7.0-2005 databases for various clients.

Provide back-up and recovery strategies on a project by project basis for both application and

database level tiers.

TRANSCOR GROUP – Phoenix, AZ

Software Developer/DBA, 10/2001-8/2005

Responsible for developing lending software systems and providing on-site software implementation,

support, upgrades, and enhancements using Oracle Forms 5.0 and 6.0

Design and maintain reports which interface with the applications and system databases

Working with the system software on discrepancy reports, fixes, patches, questions, and monitoring

software upgrades

Database Administrator for Oracle8, Oracle8I, Oracle 9i, Oracle 10g, and Microsoft SQL Server 7.0-

2000

Other duties included but not limited to: Installations, patches, optimizing, and upgrading the various

database technologies according to the customers existing or procured architecture.

Education: DEVRY INSTITUE OF TECHNOLOGY – Phoenix, AZ

Bachelor of Science in Computer Information Systems, 9/1997 – 6/2000

Technical Technical proficiencies and expertise include:

Databases MSSQL Oracle Reports Performance Tuning Servers Applications Software

Skills:

Software Implementation Software Systems 24x7 Availability Backup Data Disaster Recovery

Load Metrics Portability Queries Recovery Planning Reduce Reliability Replication

Running Scalability Testing Arrays Data Migration Data Recovery Database Servers

Handover Litespeed Production Support UCS Virtualization VM Architecture

Microsoft SQL Server Oracle Forms System Software Upgrades Capacity Planning ASP C

C# Construction Database Design Dreamweaver HTML Languages PHP Physical Design

Recovery Strategies VB.NET Visual Studio Windows Change Control Cluster Consolidation

Designs Developers File R 4G Access Active Directory Apache ASP.NET Business

Business Savvy Crystal Reports FoxPro IIS Informix International Inter-personal Java

Linux Linux distributions Microsoft Office Microsoft Visual Studio MySQL Operating Systems

Perl PL/SQL Platforms Player SCO Unix Self Self-starter Sendmail Suite Suse Tomcat Transact-Sql

Unix VBA Visual Basic

Contact this candidate