SUMMARY:

• MS SQL Server (versions 4.21 to 2017)
• Upgrade/ Migrations from 4.21 every version to 2016 except SQL Server 6.0
• Performance Tuning Databases and optimizing Stored Procedures and SQL Code
• Expert in VLDB and MMIS databases
• Designed and enacted “Best Practices” methodology for Production Backup, Programming, Maintenance, Recovery, Disaster Recovery and Enacting new Security Model
• Able to function as team lead, team player or solo.
• Programming Best Practices Coach. Code reviews, Mentoring Developers, Creating Clean Faster Code through Best Practices
• Expert in TSQL & ANSI SQL, Stored Procedures, Triggers, Views, SSIS, SSRS, ETL, and SQL Operations Studio

PROFESSIONAL OBJECTIVES:

I am looking for the opportunity to Solve Problems, Help Teams to be more efficient and increase Up - Time.

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/ Engineer

Responsibilities:

• SQL Server Upgrade and migration of Medicaid Management Information System MMIS system.
• Rewrite Stored Procedures, Jobs, Triggers, Views, SSRS, and Functions to Best Practices coding standards. Remove Non-ANSI SQL and performance problems.
• Convert packages in DTS to SSIS.

Confidential

Programmer/ Engineer SME

Responsibilities:

• Prepare for Upgrade SQL Server 2012 to SQL Server 2017 on Linux and Prototype IMDG
• Deal with Performance issues and convert the code to run in 2017.
• Write SSIS and SSRS.
• GDPR, SOX and HIPPA Compliance committee. vg

Confidential, Hillsboro, OR

Performance Tuning Engineer

Responsibilities:

• SQL Server 2016 locally and on the Confidential Cloud.
• Reengineering an existing system with new Primary and Foreign Keys
• Examine all SQL code and rewrite portions affected by data structure changes.
• Convert a GUID based structure to INT based Keyes.

Confidential, Vancouver WA

Senior DBA

Responsibilities:

• Took a mature system with DBs from several different acquisitions substantially decreased down time and decreased longest running query average in production by 350%.
• Production DBA and Programing Best Practices Coach
• Instituted Code Reviews and worked to enact Security Model.
• Development DBA and Developer Mentor.
• Participated in Sizing, Sprints, CAB, Releases, SSIS SSRS, and Deployments.

Confidential

Senior DBA/Programmer

Responsibilities:

• Production DBA for Confidential a 600 million dollar a year telecom and fiber otic provider. Introduced Code reviews for all SQL to be run in Production.
• Production DBA\Developer for a $2.5 billion Labor Services Company. Troubleshoopting, production fixes, patches, upgrades, deployments, managing test labs, troubleshoot c, Installed SQL Server 2014 on Cluster, etc… SQL Server 2008 r2 to SQL Server 2014 Enterprise.
• Migrate from SQL Server 2008 r2 to SQL Server 2014 Enterprise. Create new security plan. Optimize database. Consolidate databases and servers. Installed SQL Server 2014 on Cluster.
• Boulder Design Group. \Developer migrated Oracle 10G to SQL Server 2012. Migration of code, data, and reports. Used SSMA then adjusted Package Variables to XML and optimized Primary Keys and indexes for SQL Server. Development in SSIS and SSRS.
• TSQL developer and programmer.
• Handle SOX and HIPPA compliance and address licensing issues.
• Re-engineer data process for ETL based data warehouse uses staging, data integration, and access layers to house key functions. Development in SSIS. The staging layer or staging database stores raw data extracted from each of the disparate source data systems. The integration layer integrates the disparate data sets by transforming the data from the staging layer often storing this transformed data in an operational data store (ODS) database.
• Deal with Trouble shooting and performance tuning job in MS SQL Server 2005, 2008r2, and 2012. Working with SQL, TSQL stored Procedures and infrastructure.

Confidential, Arlington, VA

Senior DBA

Responsibilities:

• Requirements gathering in the USA and Afghanistan with translation into Conceptual, Logical and Physical Data models.
• Erwin to create logical and physical data model.
• Executed the Architecture in Boyce Codd 3rd Normal Form.
• Development DBA and TSQL, SSIS, SSRS Developer.
• 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.

Confidential, Columbia, MD

Senior DBA

Responsibilities:

• Due to unprecedented growth Broadridge was having difficulty keeping up with the volume of processing to support their customer’s needs. Database servers were running at 100% CPU utilization with periodic crashes. Processing smaller amounts of data alleviated the crashing problem but exacerbated the problems in meeting client deadlines. Worked with Dev and Prod to solve the issues.
• Upgrade/ Migrations to SQL Server 2012
• Worked with Technical Team Leads and clients to define scope of problem and enact solution.
• Corrected problems in database design, adjusted indexes, optimized worst performing SQL Code and helped developers in writing cleaner faster code. Solved problem without expensive new equipment or an extensive rewrite of the frontend. Despite drastic increase in new volume system was able to process client needs well within the time allowed. Some SSIS with Visual Studio 2010

Technologies: SQL, SQL Server 2012, SQL stored procedures, and TSQL, Visual Studio 2010, SSIS and SSRS.

Confidential, Firm Williamsport, Pa

Senior DBA

Responsibilities:

• Designed and created Logical and Physical Data Model in SQL Server 2008r2 Enterprise.
• TSQL Development, Confidential, and Stored Procedures using User defined Table Types. Created SSIS packages.
• Translation of logical design to physical model in SQL Server 2008r2. TSQL Development, Confidential, Stored Procedures, SSIS, and SQL Tuning. High availability system running Peer to Peer Replication in three data centers in the UK and US.
• 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.
• Performance tuning of legacy SQL code with version migration. Code assessment and correction for an Upgrade/ Migrations 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, Upgrade/ Migrations

Confidential, Seattle, WA

Senior Database Advisor:

Responsibilities:

• Performance Tuning of VLDB HL7 V2.x and V3.0 healthcare EMR (electronic medical records) - EMR database for hospitals, integrated delivery networks (IDNs), health systems and health information exchanges ( Confidential ).
• 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 Confidential system project.
• 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.

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

Confidential, Columbia, MD

Senior Database Advisor

Responsibilities:

• Data Modeler on projects to integrate new client healthcare claims systems.
• Developed stored procedures, triggers, functions and views using Confidential Technologies.
• Initiated Disaster Recovery plan and a Backup schedule with offsite storage.
• SQL Server 2005, Production DBA and Performance Tuner.
• Upgrade/Migrations to SQL Server 2008

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

Confidential, Camp Hill, PA

Responsibilities:

• Contractual SLA was that screens populate in 1 second and when they brought me in the screens were populating in 45 seconds.
• Through Code Optimization and implementation of Indexed Views I was able to deliver 300 millisecond response times.

Technologies: SQL, SQL Server 2008, TSQL. Performance Tuning