Craig Harris

*** ********* ***, ******, ******* *0115

678-***-****

ac8gfm@r.postjobfree.com

LinkedIn: http://www.linkedin.com/in/craigaharris

PROFILE

SQL Server DBA/Developer/Manager with 15 years of experience working in the database technology environment. In my past positions I have worked in the Consulting and Private working environment implementing and maintaining SQL Server based database environments. I have worked both on the Administration side and Development Side of the SQL Server 2000-2016. I am an excellent communicator with great problem solving skills and exceptional with determining client system needs.

On-site & Remote Consulting experience.

DBA experience in SQL Server 2000 - 2016 64-bit.

Development using Visual Studio 2005 - 2017.

Building Data loaders using SQL Server Integration Services (SSIS)

Built SSIS packages using Business Intelligence Development Studio (BIDS).

Tool usage such as T-SQL, Trace Analyzer, and SQL Optimization programs.

Installing and configuring various Widows Servers 2000 – 2016 and 64-bit.

Setup High availability Designs using Network Load Balance and Failover Clustered Servers.

Experience working with development products such as TFS, Visual Studio (BIDS), Sourcetree, TeamCity, Octopus, Profisee Maestro, and Bit Bucket.

COMPUTER SKILLS

Languages

Familiar with: Java, HTML,.NET

Fluent: T-SQL

Software

Database: Microsoft SQL Server 2000 - 2016, SSIS, BIDS, SSAS

Platforms: Microsoft Windows® Server, 2000- 2016

Development: Visual Studio 2008 - 2017, Visual Studio Team Foundation Server, Business Intelligence Development Studio, SSIS Integration w/Microsoft Dynamic CRM, Profisee Maestro, TeamCity, Octopus, BitBucket, Sourcetree

EXPERIENCE

Manager/SQL Developer, Data Management (Data Warehouse) Mar 2017-Present

Aarons, Inc.

Manager responsible for developing database solutions for a team of 8+ senior level developers. SQL Developer responsible for developing solutions for integrating applications with the SQL Server. Involved in development, testing, and deployment of SSIS packages to production system in a high availability large data warehouse environment.

Managed solution development for a team of 8+ developers.

Experience with managing performance management and other manager tasks.

Built a Data Warehouse solution for a large enterprise organization from the ground up.

Work with business teams to design custom database solutions to fit the needs of that unit.

Building rules around Matching and Survivorship of master data.

Experience working with Profisee Maestro for matching and survivorship of Master Data.

Work with a team to manage a Master Data environment for cleansing Customer, Associate, Product, and Store data for large retailer.

Build multi-layer ETL solutions from multiple complex sources.

Manager, Data Management (Data Warehouse) Cont’d

Aarons, Inc.

Provided support to developers with solution design and implementation.

Worked on SQL Server 2008 to 2016 migration.

Experience working with Always-On Availability Groups in SQL Server 2016.

Work with tools for source control and code repository such as Sourcetree, BitBucket, TeamCity, and Octopus.

Able to setup a streamlined development and deployment process that reduced backlog and time to production significantly.

Reduced processes that would take 8 hours to complete to under 30 minutes.

Experience using SQL Server Change Tracking to reduce time by incrementally loading data from the source systems to the Data Warehouse.

SQL Developer/Consultant Mar 2010-March 2017

NTT Data formerly Dell Inc.

SQL Developer responsible for developing solutions for integrating applications with the SQL Server. Involved in development, testing, and deployment of SSIS packages to production system in a high availability large data warehouse environment.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Experience in Disaster Recovery Planning and Security Management operations.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Built packages to transform the data imported from the applications to prepare for loading into the data warehouse.

Developed packages to import/export data between the data warehouse and external applications.

Involved in the design of the data warehouse and staging environment.

Development using SQL Server 2008/2012 and Visual Studio 2008/2010.

Built SSIS packages to pull data from SQL Server databases from 8 different applications and populate tables in the staging environment.

Deploy packages from testing environment to production using Team Foundation Server.

Develop test plans for testing the packages prior to deployment to production.

Created billing system for Enterprise level Inventory and Services request system for large services customer.

Designed billing system for creating invoices for multiple regions both US and European based on asset usage and services requests on a monthly basis.

Migrated large and intricately designed SSIS packages into stored procedures using T-SQL.

SSIS integration between SQL Server 2014 and Microsoft Dynamic CRM.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Data Manager/SQL Developer/SQL DBA Jan 2009- Mar 2010

Infor Global Solutions

Data Manager responsible prepping leads for loading into the internal sales tracking software. After receiving leads from the website and the sales field I am responsible for cleansing the data before loading it into the sales application.

SQL DBA Consultant Aug 2007-Dec 2008

Intellinet Corporation

Consultant specializing in developing strategic solutions for organizations in the Database infrastructure area of focus. I also worked on solutions in data management using products like System center Operations Manager and Data Protection Manager.

EDUCATION

Kennesaw State University Dec 2005

Kennesaw, Ga.

Major: Information Systems

Courses included Java Programming, Database Systems-MS, Data-Communications, Systems Design, Operating Systems, Operational Management, Software Process Design, Project Management

Contact this candidate