Sql Server Service
Resume:
Bruce James, mcp
Oldsmar, Florida ***** 727-***-**** email:
*****.*.*****@*****.***
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