Dan Conner

**** ********* **

Fort Worth TX *****

203-***-****

ac7u4i@r.postjobfree.com

Objective:

To obtain a challenging position that allows me to utilize my skills as a Database Developer.

Highlights:

Supported and designed databases ranging over 250 terabytes in size.

Supported databases having over 120 million users.

Wrote articles for sqlcommunity.com

Assistant Host for SQL Fest a Microsoft community conference for database professionals.

Designed distributed systems for world-wide websites.

Build sql server cluster systems using window 2012 and sql server 2012

Designed sql server stretch cluster for sql server 2012

Knowledge of PPDM Oil and gas data modeling

Working on the Adventure Works Data warehouse.

Rewrote two mdx queries for performance from running in 4 hours down two 3 seconds.

Speeding up partition building for cubes by utilizing partitions.

Work Experience:

Senior Database DBA/Devleoper

June 2016 -Present

BNSF Forth Worth - Tx

Support Positive Train Control System (PTC) which enables remote control of a locomotive in case of emergencies

Reduced blocking/deadlocking from around 300 a day to 2.

Monitored server activity using perfmon and Idera SQL manager to make recommendations for drive layout and hardware.

Wrote multithreading tool for bulk copying tables from one server to another. Reduced time from 4 hours down to 1 hr 30 min.

Rewrote queries for performance

Mentored developers on writing queries for performance.

Reviewed databases for design/performance enhancements.

Redesigned PTC database/data marts for performance.

Built environments for qa and development.

Build replicated environments for performance and disaster recovery

Perform upgrades and install service packs.

Meet with sys admin team to review hardware refreshes.

Write stored procedures for PTC, NMS system

Write clr Functions for PTC system for algorythms.

Developed database in MongoDb for storing XML documents.

Wrote queries for Teradata for reporting system.

Senior Database DBA/Architect

March 2016 – June 2016

PVI Industries –Fort Worth Tx

Built SQL Cluster for production database

Wrote and modified SSRS Reports

Build SQL server clusters using sql server 2012 and windows 2012

Supported Epicore ERP system

Built Reporting server for reports using SSRS

Wrote/modified queries for performance

Senior Database DBA

Nov 2015-March 2016

Aperia Solutions - Dallas Tx

Automated Table Partitioning for large tables.

Mentored Junior DBA’s

Taught performance tuning for developers

Built SQL Clusters for production databases.

Reviewed and Optimized sql code and SSIS packages.

Wrote and modified SSRS Reports

Perform upgrades and install service packs.

Built environments for qa and development

Perform backups and restores using com vault for disaster recovery and test environments.

Monitored performance using Idera diagnostic manager

Reviewed database design for data marts/data warehouse to optimize performance.

Created design for the first data warehouse for client reporting.

Wrote SSIS packages for uploading client data.

Wrote stored procedures for uploading/transforming client data.

Senior Database DBA/Developer

July 2015 – Nov 2015

Ambit Energy – Dallas Tx

Optimize/tune queries

Participate in development/database design meetings

Wrote multi-threaded sql command tool to run commands in parallel in c#

Worked with hadr using availability groups for performance and disaster recovery.

Support 2012 and 2014 databases

Upgrade sql versions from 2008 to 2014.

Participated in disaster recovery testing.

Provided feedback to development staff for query optimization and indexing.

Supported/Designed Cassandra and MySql databases for data warehousing project.

Wrote stored procedures for billing application.

Senior Database Developer

March 2015-July 2015

Rigdata Corp – Fort Worth Tx

Develop Data warehouse model for oil rig data using Erwin in oracle.

Wrote SSIS and c# clr stored procedures for uploading data from various sources.

Wrote ftp clr c# stored procedure.

Wrote excel file upload in c# using linq to scrub and upload spreadsheets.

Wrote access bulk program to automatically map datatype and fields.

Wrote data scrubbing routines to check data types to verify correct types and sizes.

Wrote and modified SSIS packages to collect data from different systems to consolidate data.

Helped design reports in SSRS to display data (oil rig data).

Wrote data driven table system that’s builds table mappings from excel spreadsheet, that then builds

the merge statement for the upload in a c# clr, using linq.

Managed Oracle 11g database for datawarehouse.

Database Developer

July 2013-March 2015

Healthcare Payment Specialists – Fort Worth Tx

Design and develop and support database systems for clients.

Wrote matching algorithm in c# function to match similar account numbers. Process time when from average of 4 hrs to 10 minutes.

Designed and redesigned database schemas including logical and physical designs.

Designed and implemented disaster recovery, including writing a procedure to determine (based on size) if a full or incremental backup should be performed.

Wrote routine to delete old backup files.

Designed data warehouse using data marts from various systems using SSAS.

Trained staff on query optimization and how to read query plans.

Wrote index function to rebuild those indexes that had new page allocations.

Wrote c# multi-threaded tool to parallelize query commands.

Wrote service broker application for processing long running queries.

Wrote program to calculate performing full vs. differential backup.

Wrote c# tool for deleting old backups using plinq.

Wrote mdx queries for dimensional analysis, include designing reports in SSRS.

Supported sql 2008, 2012 and 2014 databases.

Applied service packs and code releases.

Used Team Foundation Server for code source control

Used Redgate tools for doing releases and scrubbing data for test envoronments

Wrote stored procedures for StringRay system.

Sr. Database DBA

Nov 2011 – July 2013

Gartner –Trumbull Ct

Support databases for internal/external clients.

Monitor/tune both SQL server and analysis services databases and servers.

Setup and support transactional replication with updatable subscribers.

Build SQL server clusters using sql server 2012 and windows 2012.

Wrote and analyzed mdx queries.

Designed and deployed partition builds for SSAS.

Ran aggregation tools to estimate which aggregations to build.

Wrote ETL process for uploading data into the data warehouse.

Assisted in building cubes based on usage.

Build log shipping and mirroring databases.

Senior Database Developer

Jan 2010 – Nov 2011

Conning and Co. – Hartford, CT

Support and design databases for financial reporting systems.

Administered databases including adding users, backups, capacity planning etc.

Wrote TSQL queries for reports.

Tune queries for performance using query analyzer.

Designed reporting system/data mart using replication and log shipping.

Mentored other DBAs.

Wrote tools for replication setup and monitoring using c# and SQL rmo.

Wrote multi-threaded file copy program using c#.

Designed and built database for new reporting systems.

Wrote index rebuilding program that is multi-threaded and self optimizing.

Wrote reports using crystal reports.

Used table partitioning for disk optimization.

Database Engineer

Jan 2009 - Jan 2010

Oakleaf Waste Management – Hartford, CT

Supported and designed databases for company.

Wrote T-SQL queries/stored procedures for acorn system.

Wrote SSIS packages for data loading.

Designed databases for reporting and data warehousing.

Wrote MDX queries for SSAS.

Setup up replication and log shipping.

Administered databases including adding users, backups, capacity planning etc.

Created reports using SSRS.

Tuned queries and built indexes for performance

Built SQL server clusters including setup and installation.

Database Engineer

Oct 2008 – Jan 2009

Microsoft Corp. –Redmond Wa

Architected systems for MSN Ad center

Designed replication mirroring and log shipping for reporting systems.

Supported 250+ terabyte database systems.

Tuned queries using query analyzer.

Built and designed indexes for performance.

Mentored junior level DBAs.

Administered databases including adding users, backups, capacity planning etc

Met with developers for planning design and direction of database systems.

A Lead DBA for ad center team.

Database Developer

Mar 2008 - Oct 2008

Lending Tree – Charlotte, NC

Developer for SQL server and c# database utilities

Wrote stored procedures for mortgage, real-estate systems.

Modeled/ reviewed database design.

Wrote c-sharp applications for auto-generating stored procedures.

Wrote c-sharp fuzzy login algorithms for doing matching queries.

Mentored other developers.

Wrote SSIS data load packages.

Wrote reports using SSRS.

Tuned queries and created indexes for performance.

Database Engineer

Mar 2007 - Mar 2008

Microsoft – Redmond, WA

Supported MSN websites including MSN Money and Autos.

Monitored databases systems, including performance tuning, analyzing indexes.

Built and supported replication and log shipping and mirroring systems for reporting systems.

Write SQL tips for newsletter for query writing, creating clr apps etc.

A leader of SQL Fest a bi-monthly conference for covering topics with SQL for Microsoft community.

Wrote C# database performance counter for measuring/recording database size.

Wrote C# performance counter for calculating disk usage taking into account RAID.

Wrote C# utility for multi-threaded compression disk copy.

Built SQL Server clusters including setup and installation.

Administered databases including adding users, backups, capacity planning etc

Database Architect

Nov 2005 – Mar 2007

SunTrust Bank - Richmond, VA

Support SQL Server database design, performance tuning and maintenance for consumer loans dept.

Wrote TSQL queries and stored procedures for department.

Assisted in writing compression/backup software to backup databases using c++ and SQL VDI.

Wrote WMI Query performance tool in visual c++ to query performance counters as an extended stored proc.

Worked with server/network operations in designing hardware for performance/capacity planning as well as clustering.

Administered databases including adding users, backups, capacity planning etc.

Planned and budgeted for new database systems.

Designed/modeled databases for mortgage area

Database Architect

Feb 2005 – Nov 2005

USI – Annapolis, MD

Supported and administered SQL Server and Oracle Databases.

Supported SQL Server clustering, replication log shipping and Oracle RAC.

Tuned queries and stored procs for performance.

Supported Oracle backups/performance tuning

Wrote scripts in perl, vbscript for monitoring.

Worked with server/hardware depts for capacity/performance planning.

Supported databases in a 7x24 environment.

Supported Peoplesoft and Seibel databases including upgrade installs etc.

Administered databases including adding users, backups, capacity planning etc.

Software Developer

Nov 2003 – Feb 2005

Beta Systems – Brookfield, WI

Wrote stored procedures in SQL Server.

Coded in Visual Basic/MTS for middle layer of software.

Supported client databases including tuning backups, restores, capacity/hardware planning.

Designed mainframe upload software using visual c++, visual basic, SQL server.

Wrote a capacity/performance tool using visual basic/winsock to test data retrieval/inserting using various hardware/raid levels.

Built SQL server clusters.

Designed database for client data entry calendar system.

DBA

Nov 2002 – Nov 2003

US Bank – Brookfield, WI

Team leader for SQL Server database systems.

Supported SQL Server, Oracle, Informix databases on Windows and Unix platforms 7x24

Built SQL Server clusters using active/active configuration.

Wrote email software to send messages from servers when jobs fail.

Wrote performance scripts for both Windows and UNIX platforms.

Tested clustering software including Veritas and Leagto disk mirroring.

Designed databases and Data marts for reporting for various depts.

Built and supported hardware for online user interaction

System Design/Architect

Jun 1997 – Oct 2002

Contractor - Milwaukee, WI

Database/Application design and programming.

Designed and coded software for Oracle and SQL Server packages.

Wrote code for various applications in Visual Basic Visual C++, Delphi, and Foxpro including billing/payables system, configuration tool for pipe fittings, and patient care system for cancer patients.

Supported both SQL Server and Oracle database systems.

Designed databases for billing and payables systems.

Designed and built data warehouses using SQL Server and Oracle ranging from 20 gigs to 1.2 terabytes.

Built clusters using SQL Server.

Designed systems using replication and log shipping using SQL Server and Oracle.

Supported Peoplesoft HR and payroll systems.

Programmer/Data Analyst

Dec 1994 – Jun 1997

BankOne - Waukesha, WI

-Designed/implemented novell Network for a fifty person dept.

-Wrote programs using Foxpro/C and Sysbase/SQL Server for employee benefits and mortgage dept.

-Designed data marts for departmental reporting using Sybase/SQL Server.

-Designed etl/parsing tool using C for data extractions.

Programmer/Analyst

Dec 1992 – Dec 1994

Northeastern University – Boston, MA

Wrote and supported applicant tracking software for graduate admissions dept in Dbase

Wrote statistical analysis programs using fortran for data analysis for research projects conducted by staff.

Supported 30 user novell networks including setting up workstations, adding users etc.

Designed database for student application process.

Support Analyst

Aug 1990 – Dec 1992

Lotus Corp – Boston, MA

Technical support for Lotus 123 and symphony(database package) for customers

Assisted in the development of databases for customers.

Wrote custom functions in c++ for customers.

Wrote macros for customers.

Trained group on novell networks for supported Lotus products on a network

Education

Jan 1990 – Jun 1993

Northeastern University Boston MA

M. Ed Educational Research

Aug 1982-Dec 1986

Emerson College Boston MA

B.S. Comm Science.

Contact this candidate