Sql Server Database Architect

LAWRENCE V. ROHRER

412-***-**** *********@*****.***

Database Architect

●Understand business requirements, Design data model, Specify processing flow, review all code

●Data warehouse design and build with Oralcle ODI and Oracle analytics tools

●Data modeling tools: Erwin, Oracle case, Toad, Visio, Embarco

●Expert in SQL level tuning Expert in system design for ease of coding, performance and business use

●Knowledgeable in Database performance analysis using SolarWinds, Precise and Quest’s tools

●30+ yrs Oracle database experience in design, development, and production support Breadth of experience

●Expert at solving blocking/locking and dead lock problems ( SQL Server)

●OLTP experience, ETL experience, Development experience

●Creative problem solver

GraphiteGTC Database Architect March 2024 to Dec 2025

●Oracle Analytics dashboard creation

●Design database warehouse elements and data architecture

●Build Oracle ODI rest services data loading

●Attend design meetings and present data models, data architecture and other design documents.

●SAFE scrum master certification

●DOE based security clearance

Tools: Oracle analytics, Oracle ODI, rest services, Oracle DB, SQL Server DB, Automated testing (Cypress)

Industrial Scientific Instruments August 2023 to Feb 2024

●Create new configurable data migration tool for new product

●Database performance tuning, system emergencies and maintenance

●Build tools to load snowflake database

●Technical documentation, Sales documentation,

●Partition 6 T table to make it more manageable and enhance performance

●Review code, Deploy code, troubleshoot installations, build deployment scripts in python

Tools: Postgres, AWS, RDS, EC2, S3, ETL tools, cloud services, GIT, python, AI tools

BNY Mellon June 2023 to August 2023

Location: Pittsburgh Role: SQL Server DBA

Responsibilities:

●Manage full database migrations from one server to next

●Database performance tuning

●Deal with emergencies and normal maintenance

Tools: SQL Server, Service Now, Automation tools,

StarlightSoftwareSolutions June 2022 to January 2023

Role: Database Architect

Description: Startlight builds software to help manage trash and recycling haulers.

Responsibilities:

●Introduced better task management architecture

●Managed data migrations to new versions and new customers

●Worked on reporting and data-warehouse needs

Tools: Postgres, AWS, S3, typescript.

Medica, remote June 2021 to March 2022

Role: Database Architect

Description: Medica is a rapidly growing medical insurance company

Responsibilities:

●Solve complex backend/ETL accounting problems

●Create ETL designs and documentation

●Manage and instruct offshore Informatica programmers and QA persons

●Production migration, Production support

●Database design, SQL and PL/SQL programming, DW design

Tools: Oracle 12, Informatica, Data Modeling tools, Interfaces to SAP/Convey/ICM/Convecture.

Thermo Fisher Scientific, Pittsburgh, PA June 2020 – May 2021

Role: Database Engineer

Description: As part of CCG maintain Sales Compensation management system

Responsibilities:

●Enhance Nightly pre-processing performance from 15 hours to 10 hrs.

●Enhanced calc from 17 hrs to under 5 minutes

●On-call production support

●MS SQL Server performance tuning and maintenance

●Prepared plan for reducing nightly processing to 2 hours.

Tools: SQL Server, Performance analysis tools, Data Modeling tools, Varicent ICM tool.

Thermo Fisher Scientific, Pittsburgh, PA August0 2019 – September 2019

Role: Database Administrator

Description: Temporary position to assist in build out of new data-center after disaster event.

Responsibilities:

●Database maintenance and monitoring

●SQL statement tuning, server problem analysis

●Database setup on cloud machines

●PL/SQL programming and tuning

Tools: Oracle, Cloud management tools, SQL Server, Performance analysis tools.

SMS Group, Pittsburgh, PA Oct 2017 – July 2019

Role: Database Architect

Description: Design a product to build data lakes and data warehouse objects faster and cheaper specifically for the Steel industry. Use these tools to build out several customers. Merge common requirements into configurable product. Snowflake DW, Star DW tools.

Responsibilities:

●Database Design and Architecture. Models, documentation and Implementation

●Act as database domain/subject matter expert to AI groups

●Develop tools to generate code for snowflake DW maintenance

●Implement and Customize SMS planning software for customer

●Advanced time-based analysis reports for life cycle of coil through plant

●System and database performance analysis

●Advanced package based PL/SQL programming and T-SQL programming

●Sales proposals, technical documents, database model presentations

Tools: Oracle, SQL Server, Data Warehouse generation tools, Pentaho, Strim, SolarWinds Performance analysis tools, SSIS, Power BI, Power BI meta data build, office tools

WaterSuite.com, Rockland, MA Jan 2017 - March 2017

Role: Database Architect

Description: WaterSuite is a startup spun off an environmental consulting firm. The goal was to build a software product around their GIS presentation tool. They needed to transition the single user system to multi-user product. Further data had to be loaded ten times faster. Alas contracts were delayed and funding dried up.

Responsibilities:

●Database Design and Architecture

●Re-factor GIS database code for better performance and simpler use

●Build tools for faster data loading

●Improve API for web based GIS application

●Assisted in testing database and system,

●Agile environment

●Configure Amazon cloud RDS postgres, Integrate db code with javascript and angular libraries

Tools: Postgres, Amazon AWS RDS, SQL, database stored procedures, javascript, angular, Agile, performance tuning, refactored large amounts of code, GIT, docker,

State Street Corp, Boston, MA March 2016 - November 2016

Role: Database Architect

Responsibilities:

●Database design, modeling ( Erwin), code build and production deployment

●Design of java interfaces

●Work with offshore team in configuration and running of Golden gate replication, exadata configuration

●Merge a large set of disparate data for traders analysis

●Review database design (data modeling and process controls) of all new database code for our group

●Built automatic database test scripts

●PL/SQL programming

●Team achieved platinum agile certification for database development

Tools: Oracle 12g, Exadata, PL/SQL, Erwin, Erwin templates, Golden Gate configuration, SQL database stored procedures, Agile, data warehouse, ETL,data modeling, database performance tuning, production support, Toad, DB Test automation, Business intelligence, Unix/linux batch scripts

PNC Finance, Pittsburgh, PA Feb 2010 –Dec 2015

Role: Development DBA / database Architect

Responsibilities:

●Design (and build) module to move data to an acquired loan accounting system ( EVOLV)

●Facility the integration of two large acquired banks into PNC finance

●Help design and build Non-accrual accounting module

●Integrate code into production environment and controls

●Review database design (data modeling and process controls) of all new database code for our group

●Instruct programmers in database tuning techniques and new DB features etc.

●Optimize SQL statements both via indexes and code changes.

Tools: Oracle 10, 11g, PL/SQL, OBIEE, Database performance tuning, data warehouse, business intelligence, Toad, production support, OEM, AWR reports, Data modeling, Code migration, Teradata, unix batch scripts, Audit reports

ServiceLink, Pittsburgh, PA April 2008 – September 2009

Role: Production DBA

Responsibilities:

●Maintain database; upgrades, patches, tars, monitoring and building new environments

●Database performance tuning of custom built application suite.

●Participated in datacenter migration and DR efforts

●Instruct programmers in database tuning techniques and new DB features

●Optimize SQL statements both via indexes and code changes.

●Build simulation system to solve blocking problems.

Tools: SQL Server Administration, SQL Server replication, blocking/Deadlock analysis and Solutions, Oracle RAC migration, Production support, T-SQL Code refactoring, PL/SQL, system tuning,VMware, shell scripts, performance tuning, Oracle 10g

Bank of New York Mellon, Pittsburgh, PA October 2007 – March 2008

Role: Database Performance Analyst

Project: Standish – Bond Trading

Responsibilities:

●Assist in the development of a data warehouse for the BNY – Standish bond trading group.

●Performance tuning of Charles River Development’s stock trading system

●Upgrade Oracle 8i databases to 9i and 10g

●ETL Scripts, Unix scripts

●Instruct programmers in database tuning techniques and new DB features

●Optimize SQL statements both via indexes and code changes.

Tools: Oracle 10g, PL/SQL, database warehouse, shell scripts, automated deployment, database upgrade/migration

Pittsburgh Plate Glass, Pittsburgh, PA May 2007 – October 2007

Role: Database Performance Analyst

Description: PPG required assistance in upgrading several of their Oracle Application environments to Oracle 10g. This involved both Oracle supplied code and PPG custom code. Role was to find performance bottlenecks and recommend solutions. Also trained users in performance tuning and use of Symantec’s I3 product.

Responsibilities:

●Provide DB tuning assistance in Oracle 10g upgrade

●Database Performance reviews - Oracle and SQL Server.

●Recommend application Architectural changes

●Instruct programmers/DBAs in I3 use

●Instruct programmers in database tuning techniques

●Optimize SQL statements both via indexes and code changes.

●DB Performance Report development including graphics

●Installation and support of Symantec’s I3 product both Oracle and SQL Server

Tools: Oracle RAC, database upgrade, Precise performance tool, database performance tuning, system tuning,Large tables,

Management Science Associates, Pittsburgh, PA January 2005 – March 2007

Role: DBA, Software Architect

Description: MSA has a contract to present Nielson/Arbitron Television ratings data combined with purchase data collected from various sources. This data warehouse system was built with stored procedures and a .Net front end. It allowed analysts to easily customize and configure their reports

Responsibilities:

●Enhance system performance

●Run baselines

●Develop new features

●Design and Maintain database

●Conversion of code to make better use of reporting services and SQL Server 2005 features

●Data loading design and maintenance (ETL)

●System Design

Tools: SQL Server

National Real Estate Information Systems, Pittsburgh, PA November 2004 – December 2005

Role: DBA, Software Architect

Description: The goal of this project was to very rapidly recreate the core wholesale mortgage banking business systems. The process of getting a mortgage requires a very large collection of discreet information. More important the system handles the process flow of the entire organization.

Responsibilities:

●Rapid design of the database elements

●Review and modification of initial prototype designs

●Data migration from 3 distinct systems (ETL)

●Implement many key stored procedures, and most importantly design the system for long-term use not just prototype work.

●Design of Event/workflow system

●SQL Stored Procedure Programming

●Application Performance Design

●Mentoring junior programmers

University of Pittsburgh Medical Center, Pittsburgh, PA August 2003 – October 2004

Role: Software Architect, SQL Server DBA

Responsibilities:

●Design and build external application data loading interfaces (ETL)

●Install and configure MS SQL server on fault tolerant clustered hardware

●Database Design

●Database API design

●System and Application performance tuning

●SQL and Stored Procedure programming

●Visual Basic programming and migration to .Net

●Mentor other programmers

●Manage and build Firewall data warehouse

●Interface with incident response team on software selection and use

SlaySystems / McKesson, Pittsburgh, PA March 2003 – October 2004

Role: SQL Server DBA

Responsibilities:

●Database Design and implementation

●API design

●Standard HL7 compliant interface

●Automatic Testing and performance testing

●perl

L Squared Services, Pittsburgh, PA August 2001 – March 2003

Role: Software Architect, Programmer

Responsibilities:

●Designed and built website Database Design Physical implementation

●PL/SQL programming and design

●Slashcode installation, modification and administration

●Complete installation, configuration and modification.

●Apache installation, upgrades and administration.

●System Administration: Irix 6.5, NIS, Linux setup,

●Create design documents

●SQL development, database creation scripts

●Oracle 6i application development

●Crystal Reports creation

Boardwalk Ltd., Pittsburgh, PA August 2000 – August 2001

Role: Software Architect, Programmer

Responsibilities:

●Application Development, Designed software architecture: Open BSD, Apache, mason HTML, Perl, XML, Oracle,

●Table design and implementation

●Designed and programmed dynamic web data access screens. Tested and enhanced system. Built auto-test scripts

●PL*SQL programming, and tuning

●SQL data load scripts

●SQL Server data extraction and conversion

●Designed and built data-loading architecture.

●Worked with Access, Excel, Lotus Notes, and other PC based data sources to load external contact information into Boardwalk database.

●Developed backup programs and maintained data integrity

●Experimented with LDAP interface and with PDA sync program.

Tools: Oracle 8i, Oracle 6i, MySQL, Perl, Mason, Apache, XML, Open BSD, Linux, HTML, Microsoft access, SQL Server, Crystal Reports

Marconi, Cranberry, PA March 2000 – October 2000

Role: Database Programmer

Oracle DBA, NOC Installation Project

Lenders Service Inc. Pittsburgh PA May 1999 – December 1999

Role: Database Administrator

Pittsburgh Post-Gazette, Pittsburgh, PA October 1998 – March 1999

Role: Database programmer

Project: Oracle, Y2K Conversion Effort

UPMC, Pittsburgh, PA January 1998 – September 1998

Role: Software Architect, Case Management Software Development

CECity, Pittsburgh, PA October 1997 – March 1998

Role: Oracle Database programmer/designer

BDM Warehouse Management Group, Pittsburgh, PA June 1997 – October 1997

Role: WMS Software Architect

Responsibilities:

●Designed better software architecture for next generation of software.

●This included all of the existing functionality and an ability to expand to meet new needs.

●Tuning of Pro*Cobol applications: enhance SQL queries to better use indexes, adding indexes, clearing hot spots, etc.

●Performance testing and monitoring (via simulations and in real time)

●Tuning of Customer's Oracle database in live environment

●Trained BDM's Programmers in Pro*Cobol and PL/SQL.

●Performed Code Reviews of new/existing code.

UPMC, Pittsburgh, PA March 1997 – May 1997

Role: Oracle database Consultant, SQLForms Trainer

McDonnell Douglas, Long Beach, CA January 1996 – December 1996

Role: WMS Software Consultant

Merisel, Long Beach, CA January 1995 – October 1995

Role: WMS Consultant

American Turnkey Corp. Costa Mesa, CA May 1992 – December 1994

Role: Software Architect

Description: ATC was in the business of warehouse management software. This software not only handled the recording of the material movement but also directed all material movements. This system was designed as a highly configurable product. I was part of several projects in these industries: software, computers and computer parts, stuffed animals, wholesale food, paper, forklift truck parts

Responsibilities:

●Designed architecture of warehouse management system.

●Programmed a large part of the procedures.

●SQL*Forms application development

●Tuning of Oracle and Sybase databases

●Performance testing and monitoring (via simulations and in real time)

●Manage a team of 15 people: reviewed code, directed changes

●Pre-sales technical presentations and support

●Analysis of customer needs and creation of requirements documents.

●Designed mainframe interface architecture

Sparta Inc., Lake Forest Ca September 1990 – May 1992

Role: Accounting Software Application Designer

Glenn A. Barber and Associates Inc., Studio City, Ca SQL Forms Programmer June 1987 – January 1990

Role: SQL Forms and Database Programmer

Other titles both past and current

World record participant, Balloon chase crew, Choir member, Maple syrup producer, Florist

EDUCATION

●BBA in Computer Information Systems, College of Santa Fe, Santa Fe, NM, 1987

Contact this candidate