DARREN SCOTT

**** ** ***** ****

Kenmore, WA ****8

acdfav@r.postjobfree.com

PROFESSIONAL EXPERIENCE

AllRecipes.com, Seattle, WA 2013

Sr. SQL DBA

• Administered and maintained 600+ SQL Server 2008 and 2012 instances in various configurations

including traditional clustered and nonclustered instances, replicated instances, and AlwaysOn

Availability Groups on virtual and traditional hardware with most residing on SAN appliances

Created and implemented plan to move mission critical databases to AlwaysOn Availability

•

Groups for HADR

• Headed project to design and implement DR site and DR plan for databases

• Managed Litespeed for database backups and recovery

• Managed, maintained, and upgraded SQLSentry software to monitor database performance

in all SQL database environments including AlwaysOn Availability Groups

• Implemented and maintained AlwaysOn node in a Cloud environment

• Utilized Powershell scripts and cloud environments to manage backups and repopulation of

stage and development databases

• Reviewed and implemented developer created changes to production

• Deployed biweekly software updates and developed new methods for improvement of deploys

utilizing Redgate suite of SQL tools

• Installed new database environments for development of new software

Serials Solutions, Seattle, WA 2011 - 2012

SQL DBA

• Administered and maintained 120+ SQL Server 2005 and 2008 clustered and nonclustered,

replicated databases on virtual (residing on a SAN) and traditional hardware in SAAS environment

• Developed and implemented refresh techniques for stage and development environments

• Deployed quarterly software updates and developed new methods for improvement of deploys

• Installed new database environments for development of new software

BECU, Tukwila, WA 2010

SQL DBA (contract)

• Administered and maintained 500+ SQL Server 2000, 2005, and 2008 databases on 200+ instances

• Developed and maintained complex ETL packages utilizing SSIS

• Helped support mission critical online banking Oracle Databases

Expedia, Bellevue, WA 2009 – 2010

SQL DBA (contract)

• Created and managed SSRS databases in a SQL 2008 environment to aid reporting for a 4.2 billion

annual revenue dept (SEM)

• Developed ETL processes heavily utilizing SSIS 2008

• Daily administration of several 500 GB + databases

• Put together and taught SQL classes to aid end users in access to data

• Worked alone and with cross-functional team to create a complex reporting system.

• Met with business users to discover reporting needs

• Worked with Data Warehouse and other internal and contracted IT groups to determine existing data,

structure, and meaning

• Assembled reports and interacted with end users to ensure needs were met and data was accurate.

Cole & Weber United, Seattle, WA 2008 – 2009

Sr. SQL DBA

• Maintained and managed mission critical instances of hosted and nonhosted SQL Server 7.0, 2000,

2005 databases

• Utilized SQL Server Reporting Services to support end user information needs

• Created and supported solutions for reporting and failover utilizing Data Mirroring, Log Shipping,

and Replication including geographically redundant locations

• 24/7 production support

• 24/7 on call duties

• Designed and set up emergency failover plan for SQL Server

• Utilization of Quest Litespeed for speed and compression of backups

• Development support and design

• Database refresh, creation, and design for test/dev environments

• Migration of SQL environments 7.0 2000 2005 - 2008

• Creation and support of SSIS packages

• Utilized linked servers for reporting and cross database updating purposes

• Configured and used SQL Mail extensively to alert DBAs/developers about exception conditions (e-

mail and paging)

• Set up SQL Server alerts (defined and created)

• Hardware and software performance tuning & monitoring

• Created scripts and stored procedures (as well as reviewed others’ stored procedures) with advanced

T-SQL for reporting, monitoring, auditing, DML, and DDL activities

• Documented all activities as well as current and future systems

• Relocated databases for hardware optimization

• Configured and supported databases residing on network attached storage (SAN)

• Installed and configured all database platforms listed above

• Created and managed data movement/transformation using DTS packages and T-SQL scripts

• Worked on project to create and maintain Sarbanes-Oxley controls for financially significant

databases

• Software and hardware database clustering implementation and support

• Created and updated .Net projects

Celebrate Express, Kirkland, WA 2006 –2007

Sr. SQL DBA (company was acquired and relocated)

• Maintained and managed mission critical instances of SQL Server 7.0, 2000, 2005 including VLDB

greater than 500 GBs in size

• Designed reports using SQL Server Reporting Services

• Created and supported solutions for reporting and failover utilizing Data Mirroring, Log Shipping,

and Replication

• 24/7 production support

• 24/7 on call duties

• Designed and set up emergency failover plan for SQL Server

• Development support and design

• Database refresh, creation, and design for test environments

• Migration of SQL environments 7.0 – 2000 - 2005

• Creation and support of SSIS packages

• Utilized linked servers for reporting and cross database updating purposes

• Configured and used SQL Mail extensively to alert DBAs about exception conditions (e-mail and

paging)

• Set up SQL Server alerts (defined and created)

• Hardware and software performance tuning & monitoring

• Database modeling for in house projects

• Created scripts and stored procedures (as well as reviewed others stored procedures) with advanced

T-SQL for reporting, monitoring, auditing, DML, and DDL activities

• Documented all activities as well as current and future systems

• Relocated databases for hardware optimization

• Configured and supported databases residing on network attached storage (SAN)

• Installed and configured all database platforms listed above

• Created and managed data movement/transformation using DTS packages and T-SQL scripts

• Worked on project to create and maintain Sarbanes-Oxley controls for financially significant

databases

• Data Warehouse support

• Great Plains database support including migration

• Software and hardware database clustering implementation and support

Caterpillar Inc., Nashville, TN 2005 – 2006

SQL Server DBA/Oracle DBA (contract)

• Maintained and managed 80+ global instances of SQL Server 7.0, 2000, 2005 located throughout the

world

• 24/7 production support

• 24/7 on call duties

• Administered and supported 30+ Oracle instances on Linux and HP

• Designed and set up emergency failover plan for SQL Server

• Trained junior SQL Server DBA

• Copied and moved databases (SQL Server and Oracle)

• Worked with RMAN as well as OS level backups and restores to insure integrity of the database

• Monitored Oracle instances through OEM 10g Grid Control

• Utilized linked servers (SQL Server and Oracle) for reporting and cross database updating purposes

• Configured SQL Mail and used it extensively to alert DBAs about exception conditions (e-mail and

paging)

• Set up SQL Server alerts (defined and created)

• Hardware and software performance tuning & monitoring

• Database modeling for in house projects

• Created scripts and stored procedures (as well as reviewed others stored procedures) with advanced

T-SQL for reporting, monitoring, auditing, DML, and DDL activities

• Documented all activities as well as current and future systems

• Relocated databases for hardware optimization

• Configured and supported databases whose files resided on network attached storage (SAN)

• Installed and configured all database platforms listed above

• Created and managed data movement/transformation using DTS packages, SQL Loader, and T-SQL

scripts

• Set up system for global uptime metrics

• Great Plains database support

• Created and maintained Sarbanes-Oxley controls for financially significant databases

New Breed Corporation, Greensboro, NC 2000 – 2005

Senior SQL Server/Oracle DBA

• Maintained and managed 30+ production SQL Server 6.5, 7.0, and 2000 database servers for both in

house and third party applications (on and off site)

• 24/7 production support

• 24/7 on call duties

• Administered and supported 300+ Oracle instances (both in house and 3 rd party applications)

• Implemented direct replication from SQL Server to other SQL Servers and heterogeneous

subscribers (including Oracle 8i and 9i)

• Copied and moved databases (SQL Server and Oracle)

• Worked with RMAN as well as OS level backups and restores to insure integrity of the database

• Monitored Oracle instances through OEM 10g Grid Control

• Utilized linked servers (SQL Server and Oracle) for reporting and cross database updating purposes

• Configured SQL Mail and used it extensively to alert DBAs about exception conditions (e-mail and

paging)

• Set up SQL Server alerts (defined and created)

• Set and maintained local and second data center failover plans

• Set up and managed NSI Doubletake and Quest Shareplex replication solutions

• Set up and maintained SQL Server Clusters

• Hardware and software performance tuning & monitoring

• Database modeling for in house projects

• Created scripts and stored procedures (as well as reviewed others stored procedures) with advanced

T-SQL for reporting, monitoring, auditing, DML, and DDL activities

• Documented all activities as well as current and future systems

• Created ASP interfaces for maintenance and auditing

• Relocated databases for hardware optimization

• Configured and supported databases whose files resided on network attached storage (Network

Appliance, Storecase, Dell Powervault)

• Implemented and maintained I2 Transportation System Implementation on Oracle 8i

• Implemented and maintained Kronos System Implementation on Oracle 8i

• Installed and configured all database platforms listed above

• Created and managed data movement/transformation using DTS packages, SQL Loader, and T-SQL

scripts

• Performed performance tuning on all database platforms listed above including the use

of PerfStat reports, SQL Server Profiler, and Windows 2000 monitoring tools

• Created and maintained DBMS jobs for Oracle

• Administered material view creation and scheduling for Oracle

GKN Automotive, Sanford, NC 1998 – 2000

DBA/Analyst/Programmer

• Manufacturing Execution System (MES): Start to finish analysis, development, and deployment of a

system designed to monitor, interact, and collect data from the plant floor machines. This system

included touch screen computers on the plant floor, SQL Server 6.5 and 7.0 back ends, Visual Basic, MS

Access, and HTML/ASP front ends.

• 24/7 production support

• Programmed the plant floor PCs with RSView using VBA and a local failover MS Access database.

• Designed the SQL Server database including e-mail notifications, replication, DTS packages,

maintenance plans, and backup plan.

• Created a Visual Basic, MS Access, and a browser based front end (ASP, HTML, Visual Interdev;

DAO, ADO, ODBCdirect, ODBC, OLE DB) for the database. This project also included two Visual

Basic programs. One was a custom-built search engine designed to allow operators to see build

schedules located on the local intranet. The other was an interface that allowed remote reviewing of plant

floor activities in close to real time.

• SQL Server 7.0 DBA for a server containing several databases. Assist GKNAI US SQL Server DBA.

• Developed a SQL Server 7.0 database with an HTML front end to track NT server activity within the

company.

• Primary programmer for local intranet.

• Created a program to query maintenance databases and page users based on given criteria.

• Designed and developed an MS Access database to track operator totals using Opscan (bubble) sheet

input.

• MS Access DBA - included developing a front end that allows the helpdesk to manage secured

database users and permissions.

• Software evaluation and project management.

• Developed a Human Resources database in MS Access to scan, track, and manage resumes, monitor

recruitment, and chart open positions.

• Developing and maintaining Access databases and interfaces for manufacturing plant.

• Interviewing contract programmer candidates.

Glaxo Welcome, NC 1997 – 1998

Software Engineer

• Developed and refined applications which were designed to manage sales, deployment, accident

claims, and driver information for the company's vehicle fleet. These programs utilized Visual Basic

front ends, MS Access back ends, and Crystal Reports for reporting.

• Scheduled and managed software upgrades for supported groups.

• Installation and maintenance of various software on networks and individual PCs for supported

groups.

Aris Financial and Benefit Services, State College, PA 1997

Programmer

• Worked on creating an internal system to replace out-of-house banking and financial systems.

• Created a database in Access to store company client information and their accounts. Wrote interface

for the database using Visual and Access Basic to enable deposits, withdrawals, interest accrual and

payment, verification of requests, security coding, and balancing of financial transactions. Utilized SQL

queries and Access Basic to generate various reports based on user input and/or time cycle generation.

• Created an Access database program to keep track of split-dollar pension accounts, their payment,

and their interest allocation. This program was designed with user interfaces set up to link to the larger

client database.

EDUCATION & TRAINING

Virginia Polytechnic Institute and State University, Blacksburg, VA

Bachelor of Science, December 1996

Major: Management Science and Information Technology (Decision Support Systems)

Oracle9i Database Performance and Tuning

Oracle9i Database Administration Fundamentals II: Backup and Recovery, October 2003

Enterprise DBA Part 1A: Architecture and Administration, April 2002

Introduction to Oracle8i: SQL and PL/SQL, February 2002

Data warehousing for SQL Server 7.0, June 2000

Implementing a Database on Microsoft SQL Server 7.0, November 1999

System Administration for Microsoft SQL Server 7.0, October 1999

CERTIFICATIONS

MCP – Installing, Configuring, and Administering SQL Server 2000

MCP – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Contact this candidate