DANIEL SIMMONS

Professional Summary

**+ years of expertise as a SQL Server Developer and Database Administrator (v. 6.5 thru 2014), and over 6 years of Sr. Data Systems Architecture experience. Worked with SAN environments and up to 100 GB-Terabyte environments, with expertise in:

T-SQL, Stored Procedures and Triggers (10+ years)

Planning and Implementing Database Backup & Recovery (DR), and Security models (10+ years)

Migrations/Upgrades utilizing SQL Server (10+ years)

Installing and configuring SQL Server 2000, 2005, 2008, 2012,214

Monitoring and Operations Production (10+ years)

SQL Server Clustering (Subnetting with 2012), Mirroring and Replication (10+ years)

Always On Availability Groups 2 years

Experience implementing ETL using DTS and SSIS 12 years

Data Warehouse Design, ETL, Building Cubes, and managing SSAS in Production environments 12 years

OLTP and OLAP Data Architecture modeling (10 + years)

SAN Environments (10 + years)

Tools Set Performance Monitor, Profile, SQL Sentry, Qure,, Red Gate Enterprise, Idera's SQL diagnostic manager

Virtualized and Non Virtualized Configurations with SQL Server

MYSQL 5.1 manage using MYSSQL Workbench for database design and server management.

Professional Experience

Nerium (May 2017 – Present)

Manage Data Warehouse on Azure Data Warehouse and Azure Data Lake platform

Manage Data Warehouse on Sql Server 2016

Design and implement new Customer, Order, Inventory segmentations for existing dimensions

Design and purpose new metrics for tracking various aspects of the business

Implement SSIS packages to handle Type 1,2 dimensions and Staging, ETL data loads

Modify existing SSIS packages to use new variables for dynamic processing

Design PowerBI dashboards to use new slicers and drilldown to answer business questions

Rearchitect SSIS ETL process to process only new orders, the current process was reprocessing all orders each day.

Currently working on redesigning Cubes and fact tables to use dimensions that are currently not used.

Implementation of Azure polybase, external sql tables

Created SSIS packages to employ ETL processes feeding various systems

Argo (March 2014 – March2017)

SQL Server DBA/BI Data Warehouse Architect

Responsibilities include:

SQL Server Upgrades from (2008, 2012) servers to SQL Server 2012,2014

Implements AlwayOn Availability Groups with 2012, 2014

Terabyte/SAN environment

Lead implementation to move Data Warehouse to Azure Data Warehouse and non structed data into Azure Data Lake platform

Implementation of Azure polybase, external sql tables

Created SSIS packages to employ ETL processes feeding various systems

Manage client site installations of Argo Care Chain System with SQL Server backend, currently Argo manages over 1200 branch and regional banking sites from over 80 clients. Chace Banking is one of Argos largest client.

Use Backup Exec 16 for SQL Server to manage Enterprise level backup strategy.

Isolate resource problems which can consist of concurrency issues, missing indexes, out of date statistics, long running queries.

Installed new SQL Server Clustering using (Multi Subnetting) between Data Centers, initial setup done in May of 2014. I have not managed this system with this client since 2014 and we passed this on to a third party that facilitated our clients infrastructure needs.

Maintained all SQL Servers with Replication (Snapshot ). On 4 servers have Snapshot replication?

Wrote maintenance scripts and stored procedures and Triggers when needed.

Help write and maintain Argo’s Database Operational Procedure Guides and Manuals

Wrote Argo’s Database Developers guide for application developers to use when designing databases.

Enterprise monitoring with Idera’s SQL Diagnostic Manager

Guide IT (Jan 2014 – March 2014)

SQL Server DBA/BI Data Warehouse Architect

Ancillary Care services outsourced IT infrastructure to Guide IT. Assisted in the facilitation of migration and turnover.

Ancillary Care Services (May 2010 to Jan 2014)

SQL Server DBA/BI Data Warehouse Architect

SQL Server Migration from (2000, 2005) servers to SQL Server 2008 and 2012.

Implements AlwayOn Availability Groups

Terabyte/SAN environment

Designed and Implemented Data Warehouse/ODS integrating data from Provider, Claims Processing, Finance, and Product Systems into Fact and Dimension tables to feed multiple cubes

Built SSAS Cubes with partitioning employing metrics and dimensions that allowed the business to track all aspects of operations and revenue.

Installed new SQL Server Clustering using (Multi Subnetting) between Data Centers.

Maintained all SQL Servers with Replication (Snapshot and Transactional).

Wrote maintenance scripts and stored procedures and Triggers.

Performed Query Plans for SQL Code optimization.

Created SSIS packages to employ ETL processes feeding various systems.

Managed Backups and Security.

General Tuning and Troubleshooting Bottlenecks (Memory, I/O, CPU)

Monitor Daily Jobs and Production Operations

Reversed engineering ASP.NET code to troubleshot embedded SQL Queries.

Wrote ETL to pull data from MYSQL 5.1 database that stored HL7 messages from Provider networks.

Made changes to the MYSQL 5.1 Provider Network database to meet the needs of ACS use of HL7 Messages using MYSQL Workbench

Heartland Financial (August 2009 to March 2010)

SQL Server DBA/Data Systems Architect

Data Warehouse Migration from old 2005 servers to new Servers on SQL Server 2008 and SAN.

Terabyte/SAN environment w/ an Active Passive Cluster 32 n 64 bit environment (50 Servers).

Data Warehouse Migration from SQL Server 2005 to SQL Server 2008

Installed new SQL Server Cluster for Servicing Center SQL Servers.

Implemented Log Shipping to maintain Standby Systems at DR Sites

Maintained all SQL Servers with Replication (Snapshot and Transactional).

Wrote maintenance scripts and stored procedures and Triggers.

Performed Query Plans for SQL Code optimization.

Migrated and configured SSIS packages.

Custom reports with SSRS and Report Builder Report Builder 2.0

Built new SSAS Cubes for Advertising, and Finance Dept. utilized KPI’s for a dashboard App

Managed Backups and Security.

General Tuning and Troubleshooting Bottlenecks (Memory, I/O, CPU)

Created VMWARE and StarWind iSCSI SQL Server Builds to test upgrades

Monitor Daily Jobs and Performance with Microsoft Operations Manager

Reversed engineering ASP.NET code to troubleshot embedded SQL Queries.

Independent Consultant AAX, JM Family (October 2008 to March 2009)

SQL Server Migration and consolidation to data center. This entailed scaling up to a Virtualized Environment.

• Developed and documented SQL Server Centralization Plan.

• Setup DEV, TEST, Pilot Production SQL Server 2008 Environments 32 and 64 environments.

• Migrated DTS to SSIS.

• Implemented and documented a POC (Proof of Concept) plan and strategy for SQL 2008

migration.

• Did all SQL Code reviews and SQL scripting.

• Code conversion from SQL Server 2000 and SQL Server 2005 to SQL Server 2008

Associa (June 2008 to September 2008)

SQL Server DBA/Data Systems Architect

Managed Back End Data System specializing in Accounting, Payment Processing, and Financial Analysis.

Terabyte/SAN environment w/ an Active Passive Cluster 32 n 64 bit environment (50 Servers).

Wrote maintenance scripts and stored procedures and Triggers.

Install and Configure SQL Server 2008 for environment POC testing.

Performed Query Plans for SQL Code optimization.

Worked on development team redesigning Associa Data Systems.

Install SQL Server on clustered environment 64 bit.

Migrated DTS to SSIS. Installed and implemented MOM for SQL Server monitoring.

Managed Backups and Security.

General Tuning and Troubleshooting Bottlenecks (Memory, I/O, CPU)

Reversed engineering ASP.NET code to troubleshoot embedded SQL Queries.

Fiserv /Check Free Corp. (December 2006 to June 2008)

SQL Server DBA/Data Systems Architect

Managed and Integrated Back End Data System specializing in Financial Analysis, POS, Check Payment and Credit Card Processing using bank networks for CHASE, BoA, Key Bank.

Implemented and documented a POC (Proof of Concept) plan and strategy for SQL 2005 migration.

Architected SQL Server Statistical Analysis Data System with OPTP and OLAP.

Setup DEV, TEST, Pilot, Production SQL Server 2005 Environments 32 and 64 environments.

Install SQL Server 2008 in PILOT testing.

SQL Code reviews and SQL scripting.

Code conversion from SQL Server 2000 to SQL Server 2005.

Converted SQL Server 2005 DTS Packages to SQL Server 2005 SSIS.

Built new SSAS Cubes for Probability forecasting

Wrote maintenance scripts and stored procedures and Triggers.

Performed Query Plans for SQL Code optimization.

Currently designing Data Warehouse.

Maintained existing SQL Server Servers Clustered and Non-clustered.

Maintained all Productions Server backups, Jobs, ETL processes.

Installed SQL Server on clustered environment 64 bit.

Installed and implemented MOM for SQL Server monitoring.

Reversed engineering ASP.NET code to troubleshoot embedded SQL Queries.

XO Communications (May 2006 to October 2006) (Contract)

SQL Server DBA/Data Systems Architect

Developed and documented SQL Server Centralization Plan.

Setup DEV, TEST, Pilot Production SQL Server 2005 Environments 32 and 64 environments.

Migrated DTS to SSIS.

Implemented and documented a POC (Proof of Concept) plan and strategy for SQL 2005 migration.

Maintained existing SQL Server Farm of 30 servers Clustered and Non-clustered.

Did all SQL Code reviews and SQL scripting.

Code conversion from SQL Server 2000 to SQL Server 2005.

Converted SQL Server 2005 DTS Packages to SQL Server 2005 SSIS.

Wrote maintenance scripts and stored procedures and Triggers.

Assisted developers with SQL Code rewrites and performance enhancements.

Performed Query Plans for SQL Code optimization.

Installed SQL Server on clustered environment 64 bit.

Installed and implemented MOM for SQL Server monitoring.

American Auto-Xchange (October 2004 to May 2006)

SQL Server DBA/Data Systems Architect

Managed and Coordinated Data Systems Enterprise migration to new Operations Facility.

Created upgrade project plan and implemented to SQL Server 2005.

Installed SQL Server on clustered environment 64 bit.

Re-Architect Logical and Physical Data Models.

Architected Data Warehouse.

Facilitated Performance testing and Database Production Promotion Request.

Managed and coordinated SQL Patches, Hot Fixes.

Created SQL Server DTS and SSIS packages for ETL, Loading Disparate Data

Built New SSAS Cubes for Sales, Commission

Created VMWARE to test SQL Server Builds to test upgrades

SQL Server 2000 DTS Packages, SQL Server 2005 SSIS, VB Scripting with SSIS and .Net Framework

Implemented Locking strategy for concurrency.

Implemented Indexing and Database Maintenance Strategy and Implementation Plan.

Tune and Modify Stored Procedures to alleviate application bottlenecks.

Implemented Disaster Recovery Plan (backup and recovery strategy).

Implemented custom log shipping using FTP to Reporting Servers. This was implemented to compensate for lack of security access to file structure on production server due to Contract agreements with ATT vendor.

Managed and coordinated SAN Migration, SAN Layout, and SAN Storage capacity as well as future Capacity Planning.

Planed and Coordinated efforts for Backend Data System Architecture and Enterprise.

Hard Drive Configuration, Memory and CPU upgrades based from performance metrics.

Implemented Replication for field service account Managers.

Installed and implemented MOM for SQL Server monitoring.

Assisted developers with writing and debugging SQL when necessary. This would include such things as use of derived tables, correlated queries, and best practices for performance of query writing.

Valor Telcom, Source Corp, Raytheon (February 2004 to October 2004) (Contract)

SQL Server/Oracle. DBA/Architect

Used of Performance Monitor and SQL Profiler for (I/O, Memory, Network, CPU, SQL Code).

Implement Cluster on SQL 2000 for Call Center Database Instance.

SQL Server/ MS Analysis Server Process cubes, Monitor aggregations, data cleaning and imports.

Architected Replication Architecture from SNAPSHOT to TRANSACTIONAL replication.

SQL Server Transact and Oracle PL SQL (Stored Procedures, Packages, Triggers, and Indexes).

Create SQL Server schedule jobs for database maintenance.

Create SQL Server DTS packages.

Implemented Full backups and/or Archive Logging for databases that required PIT recovery.

Installed SQL Server on clustered environment 64 bit.

Installed and implemented MOM for SQL Server monitoring.

Managed Oracle 8.1.7, 9i on LINUX and Solaris (backups, packages, table spaces, table and index maintenance).

Installed and Configured Oracle10g on LINUX x86 and 8.1.7 Sun SPARC Solaris 64bit.

Synectics Agency/SBC Internet Data Center - Dallas, TX (October 2003 to February 2004)

SQL Server/Oracle. DBA/Architect

Implement Cluster on SQL 2000.

SQL Server Transact and Oracle PL/SQL (Stored Procedures, Packages, Triggers, and Indexes).

Implemented Log Shipping on two SQL Servers.

Create SQL Server DTS packages.

Managed and Maintained Replication Servers.

SQL Server/MS Analysis Server Process cubes, Monitor aggregations, data cleaning and imports.

Create SQL Server schedule jobs for database maintenance.

ETL - SQL Server DTS packages.

Implement and Monitored existing Backups SQL 7 and 2000, Oracle 8.15, 8.1.7, 9.

Use of Performance Monitor and SQL Profiler for (I/O, Memory, Network, CPU, SQL Code).

Managed Oracle 9i on LINUX and Sun SPARC Solaris 32bit performing the following task (backups, packages, table spaces, table and index maintenance).

Alcon Labs - Arlington, TX (April 2003 to October 2003)

SQL Server/Oracle. DBA (Consultant)

Use of Performance Monitor and SQL Profiler for (I/O, Memory, Network, CPU, SQL Code).

SQL7 to 2000 Migration.

SQL Server/MS Analysis Server Process cubes, Monitor aggregations, data cleaning and imports.

Implemented Clusters SQL 2000 on EMC SAN.

Installed SQL Server on clustered environment 64 bit.

Installed and implemented MOM for SQL Server monitoring.

Implemented Snapshot and Merge Replication Architecture.

ETL - SQL Server DTS packages, Informatica, Data Junction.

Monitored Backups with Tivoli Storage System (TDP) SQL 7 and 2000.

Installed and Configured Oracle 8.1.7, 9i instances on LINUX and Solaris.

Managed Oracle 8.1.5, 9i LINUX and Solaris (backups, packages, table spaces, table and index maintenance).

Setup and configured OEM for Web Based Database Management.

CompUSA - Dallas, TX. (January 2001 to February 2003)

SQL Server DBA

Environment: Clustered SQL Server 7, 2000 on EMC SAN, (MS Analysis Server/Data warehouse), NT (4, 2000), AIX UNIX/DB2, AIX 5l UNIX/Oracle, ERP (Siebel (Call Center, Field Service), ADP HR)

Responsibilities

SQL Server 6.5 to 7.0 and 7.0 to 2000 Migration.

Implemented Snapshot and Transactional Replication Architecture for Supply Chain Management System.

SQL Server Cluster Management SQL Server 7 and 2000.

SQL Server Design Data warehouse Schema and Data loads (Star and Snowflake ER).

SQL Server/MS Analysis Server Process cubes, Monitor aggregations, data cleaning and imports.

SQL Server Transact and Oracle PL/SQL (Stored Procedures, Packages, Triggers, and Indexes).

Performance Monitor Analysis to troubleshoot (I/O, Memory, Network, CPU, SQL Code).

SQL Server and Oracle (Plan and Implement Disaster Recovery, Backups, Service Packs and Upgrades, Security Analysis, and Capacity Planning).

Managed Oracle 8, 9 UNIX and NT instances.

Created SQL Server schedule jobs for database maintenance.

ETL - SQL Server DTS packages, Informatica.

Created and schedule UNIX cron jobs and Oracle jobs.

Associations

The Professional Association for SQL Server (PASS)

Contact this candidate