OBJECTIVE:

To obtain a challenging position that allows me to utilize my skills as a database administrator/developer

SUMMARY:

• 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 SQLFest a Confidential 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 AdventureWorks Datawarehouse.
• Rewrote two mdx queries for performance from running in 4 hours down two 3 seconds.
• Speeding up partition building for cubes by utilizing partitions.

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential

Responsibilities:

• Built four SQL 2014 Clusters.
• Setup backups for comvault
• Setup snapshot backups from nimblesoft disk management system
• Wrote SSIS reports for EPICOR management system.
• Wrote web service tool for upload reports into different environments.

Senior Database Administrator

Confidential

Responsibilities:

• Wrote script to automate table partitioning
• Taught members of team how to read query plans and optimizer
• Wrote c# program to capture WMI Performance counters
• Re-wrote queries that were having performance issues.
• Built SQL server cluster
• Wrote SSIS packages for upload data from csv, and foxpro formats
• Wrote SSIS reports for analyzing data gather from performance counters
• Wrote C# multi-threaded tool for running multiple commands such as backups and restores.

Senior Database Administrator

Confidential

Responsibilities:

• Optimize/tune queries
• Participate in development design meetings
• Wrote multi-threaded sql command tool to run commands in parallel in c#
• Worked with hadr using availability groups.
• Support 2012 and 2014 databases

Senior Database Developer/Administrator

Confidential

Responsibilities:

• Develop Data warehouse for oil rig data.
• 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 scub and upload spreadsheets.
• Wrote access bul 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 deign 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.

DBA-Architect/Developer

Confidential

Responsibilities:

• Design and develop and support database systems.
• 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.

DBA

Confidential

Responsibilities:

• 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 datawarehouse.
• Assisted in building cubes based on usage.
• Build logshipping and mirroring databases.

DBA-Developer

Confidential, Hartford, CT

Responsibilities:

• 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 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.

DBA-Developer

Confidential, Hartford, CT

Responsibilities:

• Wrote T-SQL queries 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 logshipping.
• 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/DBA

Confidential

Responsibilities:

• Designed replication mirroring and log shipping for reporting systems.
• Supported 250+ terabyte database system.
• 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

Confidential, Charlotte, NC

Responsibilities:

• 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

Confidential, Redmond, WA

Responsibilities:

• 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 SQLFest a bi-monthly conference for covering topics with SQL for Confidential 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

Confidential, Richmond, VA

Responsibilities:

• 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.

Database Architect

Confidential, Annapolis, MD

Responsibilities:

• 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.

DBA/Software Developer

Confidential, Brookfield, WI

Responsibilities:

• 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.

DBA

Confidential, Brookfield, WI

Responsibilities:

• 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

Confidential, Milwaukee, WI

Responsibilities:

• 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

Confidential, Waukesha, WI

Responsibilities:

• 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

Confidential, Boston, MA

Responsibilities:

• 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 network including setting up workstations, adding users etc.