Sql Server Software
Resume:
DARREN SCOTT
Kenmore, WA ****8
*******@*****.***
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