PROFILE AND STRENGTHS

SQL DBA and IT Professional with over 10 years experience in SQL Server roles. Skilled Project Manager capable of working under pressure and following numerous projects and challenges to completion. Excellent customer service/customer relations skills at all levels. Skilled at designing scripts and procedures utilizing Transact SQL, Visual Basic.Net and Oracle. Experienced with SQL Database Administration, Disaster Recovery and Data Mapping / logical design. Positive and professional while ensuring customer satisfaction.

COMPUTER AND TECHNOLOGY SKILLS

• SQL Server 2000 through 2012, SSIS, SSRS, SQL Server Enterprise Manager,
• SQL Clustering, Visual Studio 2008, VB.net, SharePoint, Crystal Reports, Quest Foglight,
• Microsoft Access, VBA, XML, Windows 2000 - 8 Server,
• Active Directory, Microsoft Dynamics GP, MacAfee Corporate 7.0,
• Macromedia Studio MX, Cold Fusion MX, Adobe Photoshop CS3, Adobe Acrobat Ver. 10.0,
• Intergraph Microstation, AutoCAD, Microsoft Office Suite, Hardware and Software Installation.

PROFESSIONAL EXPERIENCE

Confidential

• Senior SQL Database Administrator
• Senior SQL DBA working under SQL 2012 and 2008 R2
• Database design and optimization for Web-based application including Stored Procedures, Triggers
• and views.
• Create and Maintain SQL 2012 Always On Clustering
• Working with Always On SQL 2012 Availability groups.
• HL7 EDI interface coordinator with Hospital Systems
• Responsible for Disaster recovery and backup strategies

Confidential

SQL Database Administrator

• Senior SQL DBA overseeing conversion of hardware and software from SQL 2005 to SQL 2008R2.
• Overseeing conversion of Microsoft Dynamics Great Plains from Ver.9 to 2010.
• Manager over 4 developers using SQL, .NET, EDI and Web Technologies.
• Project Manager for all Development tasks.

Confidential

Database Programmer / Analyst

• Creation, maintenance and tuning of 2005 and 2008 SQL Databases.
• Creation and correction of VB.NET 2005 applications for Engineering and Administration.
• Creating SSIS packages to move, import and update data between SQL, Oracle, Excel and Access.
• Database Administration of SQL 2005 Server including disaster recovery, tuning and normalizing data and Active Directory Security.
• Database Schema / Logical Design for internal and external customer projects.

BRIAN K WILLIAMSON PAGE 2

• Day Zimmerman Continued.
• Creating SSRS reports to interface with existing programs including Sharepoint.
• Creating Stored Procedures, Views and Scripts to streamline functionality.
• Creation and maintenance of Enterprise level Access 2007 and Visual Basic programs.

Confidential

Consultant

• Data migration assistance of SQL data to the Gomembers web utility from SQL 2000 to SQL 2005.
• DTS package creation for moving and modifying tables and data.
• Updating reports to the SQL 2005 data using Crystal Reports 10.
• Database schema design for new database storage.
• Assist in data modeling, architecture and ETL of the conversion to SQL 2005.

Confidential

Technical Systems Analyst

• Creation and maintenance of SQL 2000 to 2008 databases.
• Experienced in both DTS and SSIS services.
• Creates custom reports using SSRS - SQL Business Intelligence Development Studio.
• Disaster Recovery modeling, Creating and Modifying Databases, Performance Tuning, ETL of third party and AS400 data into SQL, Ad Hoc querying for financial and troubleshooting issues, Backup and SQL Agent job creation.
• Design, implement and manage interfaces between multiple applications using SSIS and DTS.
• Used Quest Foglight to create Database dashboards to monitor server status and load.
• Controlled access and security on SQL and Access databases.
• OLAP and OLTP interfaces with Production database and Data warehouse at DisneyStore.com.
• EDI coordinator for third party vendor support and business analyst to determine vendor requirements and solutions using Custom XML and FTP.
• Created batch files to run with schedule tasks in combination with SSIS to populate database files.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis.
• Created Access databases including users input and reporting for Call Center with connection to SQL servers and VBA coding.
• Project Management duties to run the project from inception to completion.
• Weekly conference calls with both internal and external vendors and customers.

Confidential

Technical Support Representative / Group Lead

• Support Third Party created software utilizing Microsoft SQL and SQL Server2000/2005.
• Assisting and training newer technicians in problem resolution and usage.
• Installation of SQL, back up utilities and SQL Scripting to resolve customer issues and interfacing with all levels of clients with conference calls and meetings.
• Responsible for internal support of 1st level technicians, interfacing with programming and Senior Management on both internal and external customer issues.
• DTS and SSIS package creation to move and import customer data to SQL Databases.
• Ensuring 100 availability of SQL, Backup and disaster recovery of SQL Databases
• Writing documentation of training material for both internal and external use.
• Writing Ad-Hoc queries to resolve customer issues.
• Working with programming to resolve customer issues with recommendations and code.

Confidential

Data Architect / IT Support

• Redesigned corporate Website using Dreamweaver, Coldfusion, Oracle and Access as well as training all levels of the company in its use.
• Updated server and user computers with Virus protections utilizing EPO agents.
• Assisted in migration from Windows NT platform to Windows 2000.
• Desk side support of hardware and software for users.