Duane Lawrence Email & Phone Number

Sandston, Va, Us

Aliso Viejo, Ca, Us

Migrate data centers to Azure. PowerShell development for database administration and easy to read reports. Idera Diagnostic Manager architect, install and template manager.Ticket count reduction is something that I do by performance tuning database and developing/enhancing SSIS packages or SSRS reports. Work ETL tickets and solve the issue. When a repeating error was found the next day, the SSIS package was modified to handle that specific error. This resulted in time savings for the DBA team.

Christiansburg, Va, Us

PowerShell development in SAPIEN Technologies PowerShell Studio 2017, which check for changes to security or servers. Backup and restore databases, performance tuning, code promotion, grant user access. Most databases are SQL Server 2014. Upgrade and migrate SQL Server databases on an ongoing basis. Migrating SQL Server databases to Azure. Install and configure new servers as customer base expands.

Stafford, Virginia, Us

Denton, Texas, Us

Developed a T-SQL stored procedure to run archiving while part of the an engine manufacturing plant was running. In comparison, the vendor’s archiving had to shut down the entire plant. This increased the factory up time and increased revenue of the factory.I mentored developers on how to improve the performance after I found the slowest running queries. Getting this done was a major project that I lead.I am proud to say that outages due to database performance were eliminated at two factories. I use a gentle adjustment approach for continuous improvement. Server maintenance and Active Directory security. This included building new VM, web server administration, fixing operating system problems and server security.The Apriso Manufacture Operations Manager (MOM) of the Paccar factories the database was growing out of control because the vendor archiving process could not keep up. I wrote a replacement T-SQL stored procedure DBA archiving that can run with part of the factory is up. This resulted in the row counts finally going down and increased revenue by reducing the need to totally shut down a factory. This was key to running the machining section of the factory 24 x 7 so they could produce piston heads for South America factories. Ticket count reduction is something that I do by performance tuning database and developing/enhancing SSIS packages or SSRS reports. Work ETL tickets and solve the issue. When a repeating error was found the next day, the SSIS package was modified to handle that specific error. This resulted in time savings for the DBA team.Migrated databases from 2005 to 2008, 2012, 2014 and 2016.SharePoint administration: Converted SharePoint 2010 to SharePoint 2013. Keeping a SharePoint server running require gentle adjustments constantly. I create new sites, answer any question from any one of 400 sites and when I did not know the answer, I could put them in touch with someone that did know the answer.

Irving, Tx, Us

Backup and restore databases, performance tuning, code promotion, grant user access. Participate in team meetings to plan for future scalable growth. Most databases are SQL Server 2012. Upgrade and migrate SQL Server databases on an ongoing basis.MySQL team lead. Mentored developers to improve performance. Mentored web developers on how to connect. The database administrator team owned the data warehouse and did all of the ETL work in SSIS. We made extensive use of SSIS catalogs to get the rich error information.Reduced ticket count over time by fixing known errors so they did not happen again. Getting this done was a major project that I lead.Specialized in solving all technical matter and resolved all technical and non technical queries of the ERP and CRM user.Work ETL tickets and solve the issue. When a repeating error was found the next day, the SSIS package was modified to handle that specific error. This resulted in time savings for the DBA team.

Medassets bought Broadlane and the same DBA team wanted me back.Developed a new backup method that raised the backup success rate from 35% to 95%. Getting this done was a major project that I lead. Much of it was in stored procedures and PowerShell was used to move data to a master reporting database.Ability to manage ERP and CPM applications storage, database backups and disaster recovery systems. Manage ETL process from ERP and CRM to data warehouse.Performed troubleshooting of the reports to meet optimal level of performance in the CRM and ERPI am known for clearing the ticket queue and being able to troubleshoot unusual tickets. Then I go a step beyond and fix repeating failures by enhancing SSIS packages or SSRS reports

Various clientsSQL Server 2012 new functions such as AlwaysOn Available Groups and Contained databases for Exigo in Dallas Texas.Consolidate hundreds of databases to fewer servers for client VCE, the Virtual Computing Environment Company.Client Bank of America performance tuning of databases. Also helped with upgrading hundreds of databases to the more current versions.Client Ristken Software Services entire system was running slow. Found XML contract column in select star with an average of 45 MB in each row, this data was not used. When this column was excluded and only the columns needed were used, the entire systems performance improved. In addition the RAM on web server farm was halved and saved the company from needing to spend 500k for more RAM on the host server.Client Cash America build SQL Server instances and scaled out Report Services.Used MongoDB Management Services (MMS) to diagnose performance issue. Excessive locking was diagnosed by using performance counters “locks.timeAcquiringMicros” and “locks.acquireWaitCount”.

Dallas, Us

Broadlane became Medassets and they brought me back in my resume above.Technical lead and architect for team to get the pharmaceutical database to run faster. Interface with the business users to gather requirements, implement, and user acceptance testing, to final sign off. Give assignments to IT staff. After the project was done, the overnight processes went from running in 16 hours to 4 hours.The new database is in 2008 and uses SSIS packages and write T-SQL stored procedures.

Milwaukee, Wisconsin, Us

Technical lead and architect for team to implement a new system to utilize existing 1200 phone lines during non-peak times to place outbound sales campaigns for various clients. I gathered the requirements and gave assignments to IT staff and got the project done on time.Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access. Participate in team meetings to plan for future scalable growth. Write T-SQL stored procedures.Replication using SQL Server: bi-directional replication between two cities to take payments and normal replication between the reporting servers and transactional server locally.

Minneapolis, Mn, Us

Backup and restore databases, performance tuning, code promotion, replication using Golden Gate 7.2. Plan, test and upgrade Golden Gate to v9.5. Grant user access. Participate in team meetings to plan for future scalable growth. Monitor performance of production database using standard tools such as PerfMon, SQLDiag and SQL Profiler. Dotnet C# application maintenance. Write T-SQL stored procedures.

Dallas, Tx, Us

Fly to companies with databases in crisis and tune database performance, this included CRM and ERP databases.Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Analyze recorded data and write detailed reports on how to improve performance. The reports are targeted for upper management, but include nuggets of information for the DBA on best practices and future tuning strategy. Write T-SQL stored procedures.Assist giving Microsoft feedback on the 2008 CTP builds, conducted Proof Of Concept (POC) reports to customers wanting hard numbers for what table compression can do for them.

Grant user access permissions in production. Promote code from Dev to Test to Production using Red Gate SQL Compare v5.3.0.44 and SQL Data Compare v.5.3.0.68 when data needed to be promoted also. Participate in Litespeed upgrade from v3.1 to v3.8.1. Manage Litespeed licenses and responsible for Litespeed backup verification. Developed Report Services custom reports developer for Litespeed reports. Write T-SQL stored procedures.Extract Transform Load (ETL) using DTS and SSIS (SQL Server 2005) . There were some 3000 DTS packages that we were converting to SSIS when time allowed. We use UC4 as a scheduler to run the ETL processes. Ability to manage ERP and CPM applications storage, database backups and disaster recovery systemsPerformed troubleshooting of the reports to meet optimal level of performance in the CRM and ERPSalesforce lead contact: all technical questions from company were sent to me. If I needed to I could escalate a question to Salesforce support.

VHA – (DBA) Converted a DB2 database to a clustered 64 bit Microsoft SQL Server 2000. Database average size was 50 Gig, up to 67 million rows. User group was around 15 thousand. Gathered requirements for 8000 legacy reports running in BrioQuery. Stored procedures and converted reports to work in T-SQL using Microsoft's Reporting Services when possible. Part of a team that monitored over 4000 processes that copy data from one database to another using DTS packages for SQL Server 2005.Valor Telecom - ETL (Extract Transform Load) from DB2 to a data warehouse in SQL Server. The data warehouse was built in Microsoft SQL Server 2005 Beta the April CTP release. Created stored procedures and SSIS packages to move data between databases. Write T-SQL stored procedures.ITT Industries Fort Wayne, IN (.NET Developer) - Replace obsolete inventory control system with web pages written in C Sharp (C#). The backend was MS SQL Server. Create web pages new GUI layouts and user security using Data Sets, Data Grids, Data Lists, Drop Down Lists, SQL stored procedures, T-SQL, ADO.NET, DTS, MS Visual .NET (.net), JavaScript, and Web Services (ASMX) as needed. The faculty is a secure department of defense site.OC3 Dallas, TX - Database Administrator for MS SQL Server 2000 for Dallas Sheriff’s criminal records. Database average size was 7Gig, with 1.4 million rows. The user group size was around 10 thousand. Created stored procedures and DTS packages to move data between databases and to export to Excel and other file formats.Exceleron Software - Databases were mission critical relational databases for CRM and billing, and must be up 98% of the time by contract. We had 30 databases, with an average size of 100 Gig and row size in the 500k range. The user group size was around 50 thousand. Created stored procedures to move data between databases and to export to Excel and other file formats. Write T-SQL stored procedures.

Worked on a team with ME's and EE's to deliver a luggage sort system for airports. Databases were mission critical relational real time databases, and had a 98% contracted availability rate. Real time response rates were critical to the project success. Key responsibilities included: DBA, design production database (OLTP), backup strategy, maintenance plans, performance tuning, index planning of clustered or non-clustered, multiple hard drives for logs, database, and virtual memory, Monitor and test backups, fix backups when a problem was found. Install and setup MS 2000 in clustered configuration for Northwest Airlines.Merged replication for Alaska Airlines.Experience with real time multithread C++ code to sort bags. This program could communicate with laser arrays, PLC, manual encoders, airline reservation systems using the IATA communication protocol.Certified on RSView32 by Rockwell. RSView32 uses VB scripting.Designed security of network installed at customer sites, both computer logons and physical access. Advised customers on security management practices.

Wrote a C++ real time object oriented device driver that controls valves, fan, and heater for scientific instrumentation, called Total Organic Carbon (TOC) analyzer.Created a Windows GUI that communicates with the TOC 1020 firmware via the serial port on a PC. The GUI allowed the analyzer to have extended functionality so that it could put data into Labview products using embedded T-SQL inserts and updates.Participated in Project life cycle planning and heavy full life cycle experience. Created installation disks with Install Shield Express for release to customer. Specified software test procedure. Supervised personnel doing the testing.

Converted databases from Scopus to Siebel and customized Scopus using TCL, embedded T-SQL queries, and PL/SQL stored procedures. Created custom reports for Seagate Crystal Report and automated batch processes. MSSQL DBA, OLTP) system and star schema (OLAP) including, Decision-Support Systems (DSS), Data mapping, dimensional models including Normalized, De-normalized, Star-Schema & Snowflake Schema and developing strategies for Extraction, Transformation. Design and created an ETL process.

Performed basic and advanced database back-up and maintenance duties. The database size was 1.5 Terabytes, with 350 million rows in the long distance table.Backend development, writing Transaction-SQL (T-SQL) stored procedures, jobs, triggers, DTS packages. On a team of programmers writing a custom billing program. The billing program makes SQL queries to Oracle through the ODBC driver.Oracle DBA for 7 and 8, install and setup, hard drive usage planning, Oracle connectivity.Designed an OLTP DB which had credit card information and the DMZ security for the database.

Washington, Dc, Us

Served as a Sonar Technician on the USS CAVALLA, which is a fast attack nuclear submarine.