SUMMARY

• 20 years of SQL Server experience from SQL Server 4.9 to SQL Server 2012 Enterprise Edition. ETL Extraction, Transformation, and Loading with SSIS, DTS, BCP, and SQL Loader.
• Extensive development experience including Full Life Cycle Development, Data Migration (including Oracle), ETL, development DBA, programmer (VB and Access). Have worked as a Production DBA on VLDB such as one over 750 Gigabyte in 7.0 and several Terabyte plus DBs in 2000 and 2005 and another with over 300 tables and 25,000 stored Procedures.
• Have managed Transactional Replication since version 6.5. SQL Server DBA on small, large, and very large Production systems as well as development and supporting web Applications.
• Data modeling, Data Architecture, re - architecture, and full life cycle development.
• SQL Server 4.9 to 2012 experience.
• Certified Scrum Master and Scrum Team member.Experience drafting business rules and perform logical and physical data modeling.
• Extensive experience in tuning databases and optimizing stored procedures and SQL Code.
• Designed and enacted “Best Practices” methodology for Production Backup, Maintenance, Recovery, and Disaster Recovery.
• Able to function as team lead, team player or solo.
• Self-starter who can make order in the midst of chaos.

PROFESSIONAL EXPERIENCE

Confidential

Architect and Database Developer

Responsibilities:

• Database design, Architecture and development in MS SQL Server 2012. Requirements gathering, functional Specifications and Analyzing business processes and performing in-depth work analysis.
• Translation of work analyses into logical and physical data models. Developed in SSRS SQL Server Reporting Services and SSIS.

Confidential

Architect and Database Developer

Responsibilities:

• Database design, modeling, requirements gathering, functional Specifications. Analyzing business processes and performing in-depth work analysis Translation of work analyses into logical and physical data models.
• Database Administrator Senior Level
• Works with Technical Team Leads and clients to define program requirements
• Rewrite of an existing system written in InterSystems Caché® to SQL Server 2008 r2.

Technologies: SQL, SQL Server 2008r2, SSIS, SQL stored procedures, user defined functions, and query batches. MS Visio

Confidential, MD

Database Manager

Responsibilities:

• Database design, modeling, requirements gathering, functional Specifications. Analyzing business processes and performing in-depth work analysis Translation of work analyses into logical and physical data models.
• Database Administrator Level 3
• Works with Technical Team Leads and clients to define program requirements
• Development DBA. Database Performance Tuning SQL Server 2000, 2005, and 2008 Standard and Enterprise. TSQL coding, User Defined Table Types, stored procedures, optimizing indexes and primary keys. Mentored developers and team leads.

Technologies: SQL, SQL Server 2000, 2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential

SQL Developer, DBA, Architect

• Project: Confidential (Pa. State System of Higher Education), PA Dept of Education . Designed and created Logical and Physical Data Model in SQL Server 2008r2 Enterprise. TSQL Development, DDL, and Stored Procedures using User defined Table Types.
• Project: Confidential . . Project for the Space Data Agency. Translation of logical design to physical model in SQL Server 2008r2. TSQL Development, DDL, Stored Procedures, and SQL Tuning. High availability system running Peer to Peer Replication in three data centers in the UK and US.
• Part time work for Confidential . Upgrade SQL Server 2000 to SQL Server 2008. Modification and correction of ETL system in SQL Server 2008 SSIS for Frontier Telephone, Rochester, New York.
• Project: Kastle Systems International . Code assessment and correction to migrate first to SQL Server 2005 and then SQL Server 2008. Conversion of Non-ANSI SQL to ANSI SQL.

Technologies: SQL, SQL Server 2000,2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential, Seattle WA

Senior Database Advisor

Responsibilities:

• Database Modeling, Capacity planning and technical design documentation of a MMIS (Medicaid Management Information System) interface for the District of Columbia. Worked with Architecture team to create and execute documentation.
• Performance Tuning of VLDB HL7 V2.x and V3.0 healthcare electronic medical records - EMR database for hospitals, integrated delivery networks (IDNs), health systems and health information exchanges (HIEs).
• Senior Database Administrator (DBA) SQL Server 2005 migration to 2008 with some Performance tuning of Oracle 11g. Maintenance of data dictionaries, data models, performance tuning. Coordinates database changes and tests.
• Provided PL/SQL support to the Canadian Healthcare system project.
• Certified Scrum Master and Scrum Team member with use of Agile.
• Query Optimization, Database Tuning, and DDL.

Technologies: SQL, SQL Server 2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential, Columbia MD

Senior DBA

Responsibilities:

• Data Modeler on projects to integrate new client healthcare claims systems.
• Developed stored procedures, triggers, functions and views using Microsoft Technologies. Initiated Disaster Recovery plan and a Backup schedule with offsite storage.
• Database management through maintenance of data dictionaries, data models, performance tuning. Coordinates database changes and tests.
• Senior Database Advisor on a Healthcare Insurance Claims analytical processing system on Capacity Planning and Forecasting.
• SQL Server 2005, Production DBA and Performance Tuner.

Technologies: SQL, SQL Server 2000,2005, 2008, SSIS, SQL stored procedures, user defined functions, and query batches

Confidential, Camp Hill, PA

Database Administrator

Responsibilities:

• Database design modeling, requirements gathering, functional Specifications. Analyzing business processes and performing in-depth work analysis Translation of work analyses into logical and physical data models.
• Database Administrator Level 3
• Works with Technical Team Leads and clients to define program requirements
• Development DBA. Database Performance Tuning SQL Server 2000, 2005, and 2008 Standard and Enterprise. TSQL coding, User Defined Table Types, Stored Procedures, optimizing indexes and primary keys. Mentored developers and team leads.

Technologies: SQL, SQL Server 2000,2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential

Responsibilities:

• VLDB administration in SQL Server 7.0, 2000, 2005, and 2008.
• Architecture, data modeling, ETL, Administration and a focus on Performance tuning.
• DR/BCP, Capacity Planning, Backup Planning, Forecasting, Performance Tuning, Change Management, Release Process, and Version Control

Technologies: SQL, SQL Server 2000,2005, DTS, ETL, SQL stored procedures, user defined functions, cursors and query batches

Confidential

Principle in an Internet Startup

Responsibilities:

• MS SQL Server DBA Optimization of stored procedures in a new system.
• Several Data Conversion projects from Mainframe, Wang and others to SQL Server and to Oracle.
• Install SQL Server and create database, tables, queries, views, BCP scripts and benchmark load times.
• ETL Extraction, Transformation, and Loading, data migration and data cleansing.
• Data Modeler and Team lead on a new budgeting system for AOL.
• Data analyst on an Oracle 7.3, and Visual Basic 5.0 project. Involved data modeling and use of ER-WIN case tool.
• Design and create new database, create tables, view, indexes, etc… in MS SQL Server. Move data from mainframe and build Access reports.
• Data modeling and use of ER-WIN case tool.
• Programmer on a web based reporting system in HTML, CGI, and Access
• Server D.B.A. and Visual Basic Programmer. Primary responsibility for production servers both maintenance and development including parts in C/C++, Awk, SGML, and Visual Basic 3.0. Use of MDI and APPC gateways to DB2 on Mainframe. Conversion of Visual Basic 3.0 code to Visual Basic 4.0.
• Programmer/Analyst on MS Access and SYBASE 10 strategic plans application. Use of ODBC links to SYBASE System 10. Requirements gathering, design, implementation, and Report writing. Extensive use of SQL and Access coding.
• Oracle Development D.B.A. and Lead technical programmer on a system test of two Oracle 7 Client Server systems on different OSs. Creation of Oracle databases.
• Lead technical programmer on a call center automation project.
• Lead technical programmer on a call center automation project. Use of MS Access, Access ADT, and Windows API calls. Converted macros to code and made improvement to a system under development.
• Executive Information System for the Secretary of Housing and Urban Development. System integrated Multi-Media with Data Warehousing and Geo-Coding. Audio and Visual enhancement to System front end GUIs. Visual Basic Pro 3.0 using DB-Lib MS SQL Server 6.0. Data Warehouse drew on 7 different Mainframe systems. Load scripts and data cleansing.
• Visual Basic technical lead on client server application using Visual Basic 3 Pro, with a variety of VBX Controls, to build front ends for MS Access and SQL Server back end data servers with use of PVCS and Crystal Reports.
• Importing from DB2, into Sybase, de-normalizing in Access to create flat files suitable for SAS statistical regressions and reports.
• Programmer/application developer on a Telephone Co. billing system working prototype in MS Access 2.0. Very large scale use of Access in virtually every facet of data manipulation. An application with over 100 queries which runs for more than twenty hours. Design and implementation of test and test plan. Migration to client server using SQL Windows and Oracle.

Technologies: SQL, SQL Server 2000,2005, DTS, ETL, SQL stored procedures, user defined functions, cursors and query batches

Confidential

Responsibilities:

• 14 years working my way up to Vice President of Sales and Marketing.
• Oversaw sales organization in three states, hiring, training, and overseeing sales force.
• New Business development for the last eight years.
• Vice President. Duties included supervision of multiple currency trading system, system management and network administration. Responsible for requirements and design of MIS and regulatory reporting systems. Responsible for system and network administration. This included programming and design in D-Base with migration to MS Access.