Sql Server Engineer
Resume:
Brett C. White
Macedonia, Ohio 44056
*********@*****.***
http://www.linkedin.com/pub/brett-white/23/ab1/713
PROFESSIONAL EXPERIENCE
SQL Developer
Talis Clinical LLC, Cleveland, Ohio February 2016 – December 2016
Responsible for the design, development, testing, and maintenance of the schema DDL scripts for SQL Server 2008 and 2014.
Engineer views, stored procedures, SQL Job and triggers for Advanced Clinical Guidance software.
Subject matter expert for developers on DDL and DML standards.
Managed Backups and Maintenance Plans for SQL Server 2014 databases.
Created process to move SQL scripts from development to production.
Setup and maintain SQL Server 2014 HADR environment.
Database Administrator, R&D
Oracle/MICROS-Retail, Solon, Ohio July 2011 – January 2016
Responsible for the design, development, testing, documentation, and maintenance of the schema DDL install and upgrade scripts for both SQL Server (2005 and above) and Oracle (10g, 11g, and 12c).
Engineered views, stored procedures, and triggers for interface software between our products and 3rd party applications.
Subject matter expert for developers on DDL standards and DML.
Crafted utility stored procedures for database maintenance, and non-Unicode to Unicode conversion, and functions to convert binary to base64 and base64 to binary.
Troubleshot database issues for internal and external clients.
Responsible for creating and maintaining data models including data definitions in ER/Studio Data Architect. Utilized the data models to create the Database Dictionaries for the POS, CRM, and central databases.
Authored and troubleshot jasper reports used by the POS systems and central database application.
Senior Applications Developer/SQL Server DBA
US Auto/Stylin Concepts, Independence, Ohio November 2006 – July 2011
Responsible for the design, development, testing, documentation, deployment, and maintenance of Web and Windows Applications written in C# 2005/2008/2010.
Created and deployed Crystal and Reporting Services Reports.
Engineered, tested, documented, deployed, maintained, and administered SQL Server 2005/2008 Databases, Tables, View, Stored Procedures, User Defined Functions, and CLR Stored Procedures and User Defined Functions.
In charge of setting up SQL Server 2005/2008 Log Shipping, Mirroring, and Replication.
Brett C. White
954 Elmwood Drive
Macedonia, Ohio 44056
*********@*****.***
http://www.linkedin.com/pub/brett-white/23/ab1/713
Senior Software Systems Programmer/Business Intelligence Infrastructure
Progressive Insurance, Mayfield, Ohio February 2003 – October 2006
Responsible for the installation, development, testing, and maintenance of the Crystal Enterprise Infrastructure, the SQL Server Analysis Services 2000/2005 Infrastructure, and the SQL Server DTS/Integration Services Infrastructure which all interact with SQL Server, Oracle, and DB2 databases.
Supported desktop installations of Crystal Report, Crystal Analysis, Pivot Table, SQL Server 2005 Client Tools, and Analysis Manager.
Engineered C# and Visual Basic programs to monitor servers in all of the BI Infrastructure and writes the data to a SQL database.
Engineered C# ASP .Net programs to help my management team manage the projects their direct reports are on and a time recording system.
Served as the primary technical contact with Business Objects, the Crystal Products vendor, to correct bugs in their code and fix issue my customer were having with their reports.
Worked with Microsoft to resolve issues with Analysis Services 2000/2005.
Tested Integration Services and Analysis Services 2005.
Served as the primary contact for DTS/SSIS and taught the DTS Automation class.
Troubleshot issues with customer’s Reports, Cubes, DTS/SSIS, and web applications.
Engineered Crystal Reports and Crystal Analysis Reports to display data from Relational and OLAP sources.
MILITARY EXPERIENCE
US Army (National Guard & Reserves)
January 1986 – June 2002
Ranks: Private – Captain
Positions
Detachment Commander
Battalion Signal Officer
Company Executive Officer
Regimental Assistant Intelligence Officer
Maintenance Platoon Leader
Ground Surveillance Radar Operator
EDUCATION
Bachelor of Science in Electronic Technology
The University of Akron, Akron, Ohio
Microsoft Certified System Engineer – NT4
Microsoft Certified Professional + Internet
PROGRAMMING SKILLS
T-SQL, Basic, Visual Basic, C, C#, ASP, ASP.NET,
SQL Server 2005-2014, Analysis Services 2000/2005, DTS/Integration Services,
Oracle 10g/11g/12c
Community Service
Boy Scouts of America – Troop Committee Chairman(2016-present),Assistant Scoutmaster/Patrol Advisor(2011-2015).
Cub Scouts – Cubmaster (2009-2011), Assistant Cubmaster(2007-2009), and Den Leader(2006-2014).
Contact this candidate