SUMMARY

• Over 22 years’ experience implementing full Systems Development Life Cycle (SDLC) projects.
• Over 20 years’ experience leading database development teams in database design, data modeling, data conversion, and performance tuning.
• Solid experience interfacing with business users with respect to analyzing business requirements and translating those needs into functional specifications.
• Top Tier consulting experience giving oral presentations and interacting with all levels of personnel from technical to senior level executive management.
• Strong MS SQL Server Database Architect, data modeling, data conversion, and SQL developer.
• Lead experience architecting and managing data conversion processes for databases over 1 TB in size.
• Led class room training to project consultants and employees of Lockheed Martin, Confidential, and multiple Federal / State government projects on best practices for database design, data conversion, SSIS, SQL queries, indexing, performance tuning, and disaster recovery.
• Consulting leadership roles on multiple Federal, State and private sector projects implementing new systems working with senior management and providing technical recommendations for work plans, schedules, performance requirements, equipment purchases, hiring staff, and developing IT policies and procedures.
• Strong SQL Server Architecture, Meta Data, Disaster Recovery, TSQL, DTS, SSIS, SSDT, performance monitoring and tuning.

TECHNICAL SKILLS

• Microsoft SQL Server (versions 6.0 / 6.5/ 7.0 / 2000 / 2005 / 2008 / 2012 / 2014 / 2016 / 2017 ), DTS, SSIS, SSDT, ETL
• Data Modeling, Analysis Services, Replication, Disaster Recovery, Migration, Sybase, PowerDesigner, Unix, Erwin, Embarcadero ER/Studio
• Embarcadero DBArtisan, Visio, VBScript, XML, Asp.net, MS Visual Studio, MS Team Foundation Server, Visual Basic, Toad, PowerBuilder
• BRIO, Microsoft Reporting Services (SSRS), Crystal Reports, MS Project, Windows Server 2012, WSFC, MS Clustering for SQL Server, MTS
• Legato, Veritas Backup Exec, Sharepoint, Citrix, Lumigent products, SQL LiteSpeed, TCP/IP, FTP
• IBM Rational ClearQuest, Remedy, Idera SQL Diagnostic Manager.

PROFESSIONAL EXPERIENCE

Confidential

Senior Conversion Developer

Responsibilities:

• Senior conversion developer supervising team of 3 for conversion of the PA Department of Labor and Industry Unemployment legacy database to Confidential custom database.
• Provide ETL code review recommendations to team members with the goal of best practices, consistency, and data quality.
• Conversion of legacy data to SQL Server 2014 via SSIS and TSQL.
• Coordinate with Analysts for requirements gathering to produce source to target data mapping.
• Tracked client conversion issues to resolve in a timely manner.
• Provide conversion reports to client to include conversion rules for filtered records.
• Setup up table driven process to automate many manual conversion processes.
• Interact with client SME’s to resolve data conversion issues.
• Interact with GSI and DLI analysts to produce transformation rules including crosswalk tables when needed.
• Report to senior management for weekly conversion activities status.
• Provide guidance to team for SSIS best practices on data conversion.

Senior SQL Developer

Confidential

Senior SQL Developer

Responsibilities:

• Design and automating an ETL process for CM Regent and CM Wisconsin expansion data to provide quarterly report files to the Insurance Services Office (ISO).
• Coordinate with Analysts for requirements gathering to produce source to target data mapping.
• Develop an SQL Server 2014 database to stage import file data, reports, and ETL business rule functions.
• Develop complex SQL scripts for producing flat file reports for ISO
• Create a data driven SSIS package to handle importing, transforming, and creating report files for ISO.

Confidential

Senior Database Architect

Responsibilities:

• Designed a SQL 2016 OLTP database for the Florida Department of Transportation (FDOT). Logical and Physical database design with Erwin. Redesigned from a SaaS database.
• Conversion lead for FDOT legacy database to SQL Server. Imported SaaS data from bulk loads of data extracts to staging tables. Utilized crosswalk tables for normalization. ETL performed with SQL scripts.
• Led conversion of 10 SQL 2008 databases to a SQL 2014 database for a PA manufacturing company. ETL performed with SQL scripts. SQL 2014 database housed in Microsoft Azure environment.
• Conversion lead for migrating 2 LA State SQL 2012 databases to a CAI custom SQL Server 2014 database. Conversion ETL performed with SQL Scripts and crosswalk tables from excel workbooks.
• Reviewed/approved developers code for in house SQL Server databases
• Maintained databases for on premise and Microsoft Azure cloud environments.
• Performance tuning of database servers and SQL code

Microsoft Data Platform Database Consultant

Confidential

Responsibilities:

• Remote Senior SQL Server Database Consultant working directly with external customers
• Coordinating, analyzing, designing, implementing and administering IT solutions
• Recommending best practices for improvements to current operational processes
• Configure and maintaining database servers
• Installing, configuring and upgrading SQL Server 2008 - 2016 databases
• Administering proactive daily checks
• Troubleshooting operational problems for replication, log shipping, mirroring, clustering, Always On, SSIS, SSRS
• Communicating status and planning activities to customers and team members
• Participating in on-call coverage rotation
• Performance tuning of database servers and SQL code
• Responding to monitoring alerts

Senior DBA

Confidential

Responsibilities:

• Designed an auditing solution for the DBA group to track SQL Server changes on hundreds of Server and database level modifications. Automated the process with table driven SSIS packages and SSRS reports.
• Designed a custom database maintenance process for the DBA group. Automated the process with table driven SSIS packages and SSRS reports.
• Designed a custom SQL Server health check process for the DBA group with SSIS and SSRS including weekly reports on server and database level health state. This is for the servers that are not included with Idera DM tool.
• Managed DBA production Remedy tickets.
• Performance tuning utilizing Idera Diagnostic Manager and scripts.

Senior DBA

Confidential

Responsibilities:

• Senior SQL Server Database Consultant for PA Department of Labor and Industry CWDS project.
• Design, installation, and support for SQL Server 2008 and 2014 standard and clustered environments.
• Provide SQL Server evaluation and recommendations for OLTP, Reporting, DR, and Data Warehouse environments.
• Instruct classes on SQL Server performance tuning and SSIS to DPW staff.
• Provide database development best practice for Confidential staff. This includes best practices writing SQL code for SQL server.
• Utilized Rational ClearQuest for workflow application development.
• Setup table driven SSIS packages for capturing performance metrics of the CWDS database environments.
• Implemented performance tuning procedures for monitoring all SQL server instances for blocking, deadlocking, and long running queries. Setup SSIS table driven processes for gathering server information on all SQL instances for configuration, server performance, disk usage, database growth.
• Configured and automated process to import daily IIS logs into SQL server for report generation and performance evaluation.
• Installed and configured SQL 2014 on multiple environments including 2 four node physical clusters, and multiple virtual server installations. Utilized Clustered Shared Volumes for drive consolidation on cluster installations.
• Lead conversion of SQL 2008 to 2014.
• Data modeling with Erwin for creating/modifying logical and physical data models.
• Updating data dictionaries and creating database change scripts for deployment to Dev, UAT, Prod environments.
• Provide documentation for database environments, workflows, best practices, and standards.
• Teach best practice classes for database design, tuning, migration, SSIS.

Confidential

Database Architect, Daystar Consulting Positions

Responsibilities:

• Senior Sybase Database Consultant for PACMS and MDJS redesign projects.
• Architect and implement a database performance tuning process for databases over 1 TB in size.
• Provide performance tuning recommendations for PACMS and MDJS databases.
• Scripted process for comparing databases to their logical models.
• Scripted database changes to be applied to Development, Test, and Production environments.
• Senior SQL Server DBA. Implemented performance tuning procedures for monitoring all SQL server instances for blocking, deadlocking, and long running queries. Setup SSIS process for gathering server information on all SQL instances for configuration, server performance, disk usage, database growth

Senior Database Architect / Data Warehouse DBA

Confidential

Responsibilities:

• Senior SQL Server 2005 Data Warehouse DBA for Confidential (a partner of Lehman Brothers Bank which provides financial aid to college students).
• Provide SQL Server evaluation and recommendations for all Confidential OLTP and data warehouse systems.
• Provide ETL recommendations for loading data marts with SSIS.
• Provide database performance recommendations and security best practices.
• Maintained high availability and support of the MS SQL Server 2005 environment, backup and recovery, performance tuning and monitoring
• Write and support T/SQL scripts, triggers and SSIS packages
• Provide support and maintenance of existing database code

Confidential

Database Architect / Senior DBA

Responsibilities:

• Joint Database Architect and Senior DBA for the D.O.D Defense Property Accountability System (DPAS) which provides general ledger control and reporting to D.O.D accounting systems, as well as documenting the physical control of real and personal property.
• Provide database architecture design for all Microsoft SQL Server 2005 database servers in multiple environments.
• Provided oral presentations to senior staff
• Provide database design expertise to enhance performance and security best practices.
• Provide class room training to D.O.D staff and consultants on best practices for database design, conversion, SQL queries, indexing, and performance tuning.
• Architect and manage the data migration process of converting 250 D.O.D databases.
• Direct the database team consisting of 5 DBA’s providing technical guidance in database architecture, design, migration, performance tuning, change management, and database integration.

Confidential

Database Architect / Senior DBA

Responsibilities:

• Architect a data mart solution for the consolidation of 8 database servers located throughout the U.S. and Canada. Logical and physical data modeling with Erwin. Data driven ETL designed for optimal performance and recoverability.
• Architect and implement a database disaster recovery solution for CNE commodities group via log shipping.
• Evaluate over 200 Corporate and business unit database server configurations and propose recommended best practices for server configuration, data integrity, database design, maintenance, performance tuning, backup strategies, and disaster recovery.
• Act as Constellation Energy's liaison to Microsoft consulting services.
• Design and implement a merge replication process for Microsoft CE mobile devices used by field gas leak surveyors.
• Analyze data and database changes, and provide performance tuning solutions for OutlookSoft's business intelligence OLAP installation.
• Create standards for a data driven database backup and maintenance process
• Provided oral presentations to senior staff