Bruce James, mcp

Oldsmar, Florida ***** 727-***-**** email:

acfyj6@r.postjobfree.com

Employment History

Bisk Education - Tampa, Florida March

**** - *******

Database Developer

. Interface with multiple departments to produce recurring target

marketing emails.

. Suggested T-SQL changes reduced Data Warehouse ETL time by 60%.

. Automated updating of critical CRM table using SSIS.

. Develop T-SQL stored procedures, triggers and views for company

projects.

ByDesign Technologies - Tampa, Florida February 2013 - February

2014

Senior SQL Server Database Administrator

. Administer 150+ client databases with some over 500gb.

. Improved database performance by separating data and indexes using

filegroups.

. Automated maintenance tasks such as index rebuilds on all prod servers.

. Advocated hardware changes to maximize filegroup performance.

. Configure/maintain Database Mirroring, Replication and Service Broker.

. Migrate SQL Server and Reporting Services to SQL Server 2012.

. Relocated largest clients to in-house hosting with limited

interruption.

. Automated Database Mirroring post-failover processing.

. Improved database security posture by recommending password tool.

. Provide guidance on leveraging SQL Server architecture.

. Provide 24x7 support for production SQL Server environments.

Kobie Marketing - St. Petersburg, Florida May

2011 - February

2013

SQL Server Database Administrator

. Designed/implemented Data Warehouse for internal service and client

reporting.

. Built SSAS multi-dimensional cubes for evaluating website log data.

. Utilize advanced features such as partitioning for an 800 million row

table.

. Created SSIS ETL packages for loading Data Warehouse and cube

processing.

. Produced SSRS reports for critical SLA service and client reporting

data.

. Administer 200+ SQL Server 2008, 2008R2 and 2012 databases.

. Standardized enterprise-wide SQL Server builds in virtual environment.

. Wrote stored procedures for processing XML queue messages on SQL

Server.

. Installed SQL SERVER, SSAS, SSRS, SSIS and upgrades and service packs.

. Eliminated security risks by removing elevated linked server

privileges.

. Authored database security policy and development guidelines.

. Installed Red Gate backup software yielding 80% storage gain.

Bruce James Page

2

GFI Software - Clearwater, Florida

July 2009 -

May 2011

Senior SQL Server Database Administrator

. Configure and manage database replication and log shipping.

. Logical and physical database designs with databases exceeding 2

terabytes.

. Upgrade SQL servers from SQL 2005 to SQL 2008.

. Set up data warehouse for corporate dashboard.

. Administer over 150 databases on physical and virtual clustered

servers.

. Create SSIS packages.

. Develop/implement backup and recovery strategies.

. Provide 24/7 on call support for production databases.

. Apply Windows and SQL Server patches and service packs.

Consultis Information Technology - Tampa, Florida

April - May

2009

SQL Server Database Administrator consultant

. Researched and resolved client's intermittent SQL Server 2005

unresponsiveness that led to system outages. Analyzed SQL Server 2005

landscape and provided recommendations for best practices regarding

security, configuration, performance, maintenance and architecture.

Global Distributing Corporation - Clearwater, Florida

June 1995 - Feb

2009

SQL Server Database Administrator

. Set up SQL Server 2005 database mirroring.

. Lead SQL Server 2000 to SQL Server 2005 upgrades.

. Create databases and set up security related to development projects.

. Set up multiple server communications via linked servers.

. Backup and restore databases using native SQL Server tools and

Litespeed.

. Provide implementation scripts for production database changes.

. Establish and publish SQL Server coding standards.

Selected Accomplishments

V Migrated numerous databases to SQL Server 2012.

V Completed DW/BI for Microsoft in depth training at Kimball University.

V Published on SQLServerCentral.com.

V Resolved Mirroring/Service Broker issue that caused extensive client

outage.

V Reduced database storage by 80% by implementing compression software.

V Reduced runtime by 95% for critical product build process.

V Identified functions being unnecessarily executed 60 million times per

day.

V Doubled coverage at no cost by changing compression software vendors.

V Improved user response time for month-end financial reports from

several minutes to a few seconds by analyzing and modifying indexes.

V Decreased runtime of financial SQL batch process from 14 hours to 15

minutes.

V Provided efficient coding techniques to developers.

V Authored/modified hundreds of SQL Server procedures triggers and

views.

Bruce James Page

3

Education / Training / Certifications

Associate of Science, Computer Information Systems

Graduated with Honors

Oklahoma State University Institute of Technology Okmulgee, Oklahoma

Microsoft Certified Professional Visual Basic Desktop Applications

Microsoft Certified Professional Visual Basic Distributed Applications

Additional Courses

Microsoft Data Warehouse/Business Intelligence in depth. Kimball

University.

Microsoft SQL Server 2005 Integration Services. Pragmatic Works.

Oracle 10g Database Administration. Oracle University.

Implementing SQL Server 2005.

Administering SQL Server 2005.

Contact this candidate