Database Administrator Sql Server

WILLIAM X SCHMITT

Downingtown, PA (US) § 484-***-**** § *******.*******@********************.*** § linkedin.com/in/bill-schmitt

Senior Database Administrator

Administration Troubleshooting Optimization Security Clearance

Enhancing end user experiences through hardware and software optimization.

Experienced and accomplished Database Administrator and Developer with a proven track record in managing and optimizing complex SQL Server environments. Over a decade of hands-on experience in database administration, performance tuning, and automation. Recognized for implementing best practices, optimizing T-SQL queries, and enhancing system efficiency. Expertise includes configuring SQL Servers to meet rigorous specifications, installing certificates, conducting restore testing, and managing SQL instances within government and corporate settings. Proficient in utilizing modern tools, scripting, and collaborative problem-solving to maintain robust database systems and ensure seamless operations.

CORE STRENGTHS

üTroubleshooting

üPerformance Tuning

üAdvanced SQL Queries

üDatabase Monitoring

üDatabase Security

üDatabase Replication

üDatabase Mirroring

üSales & Marketing Systems

üAlways On

üReporting

üPowershell Scripting

üSystems Architecture

PROFESSIONAL EXPERIENCE

Schmitt Consulting Inc. § Downingtown, PA March 2022 – Present

Schmitt Consulting Inc is my personal C Corporation.

Freelance Consulting

§Provided consulting on SQL Server troubleshooting and performance to clients, spent most of the time with the Philadelphia Parking Authority.

Cerner. § Malvern, PA Dec 2019 – March 2022

Cerner is involved in EMR with the US VA and US DoD and was recently acquired by Oracle.

Database Administrator III

§Audited the SQL Servers to ensure they were configured to the US DoD specifications.

§Installed SSL / TDE certificates on the SQL Servers.

§Performed restore testing on the SQL Servers

§Obtained clearance to work on Federal DoD and VA servers.

§Monitored and maintained over 1000 SQL instances, on a team of 30 DBAs.

§Troubleshot and recommend changes to the hardware, configuration, and queries for the DoD’s Electronic Medical Records (EMR) conversion.

Bentley Systems. § Exton, PA May 2018 – Oct 2018

Bentley is in the Infrastructure Engineering Software workspace.

Senior Database Administrator

§Monitored and administered over 200 SQL Server instances globally, where I was one of a team of three.

§Installed and configured SentryOne to monitor the most critical instances, which allowed real time monitoring and alerting as well as showing troublesome future trends.

§Diagnosed problems with critical T-SQL queries, included reducing one from 17 minutes to 0.17 seconds.

§Improved IT NPS by 34% through the introduction of internal communications tools and Agile management practices.

§Reconfigured several settings on the instances, as almost all were the defaults.

§Replaced SQL Server maintenance routines with Ola Hallengren’s scripts, greatly reducing the amount of time for index maintenance.

BioTelemetry, Inc. § Malvern, PA May 2016 – Dec 2017

BioTelemetry provides Ambulatory Monitoring and Diagnostics for outpatients with cardiac issues.

Database Administrator

§Served as one of two DBAs for all of the company’s SQL Server Databases.

§Monitored and set up custom alerts for the company’s production servers with SentryOne (formerly SQL Sentry).

§Installed and configured Litespeed for the company’s backups.

§Supported developers in optimizing database design and querying with T-SQL.

§Created Powershell scripts to automate several tasks across all instances.

§Upgraded SQL Server installations from 2005 to 2014.

§Recommended hardware upgrades along with SQL changes (T-SQL and configuration) to remove bottlenecks.

§Troubleshot all aspects of SQL Server performance (O/S, network, software)

Genzeon § Exton, PA July 2015 – April 2016

I worked as a contractor for Genzeon for Sabre Airline Solutions, in Krakow, Poland. The company develops flight plans real time for commercial airlines ready to take off.

Senior Database Architect (Sabre Airline Solutions)

§Worked with teams in the US, Austria, and Poland on improving the performance and distribution of the clients’ product.

§Created PowerShell functions to collect performance and configuration metrics from the 30 customer systems.

§Rewrote the T-SQL data purging routines to eliminate table lock escalation and maximize performance.

§Investigated the client’s 30 customer systems and recommended both server and database changes to the configurations.

§Performed analysis on the system deadlocks to determine the root cause and implement solutions.

§Captured DMV index statistics and recommended adding needed indexes and removing unused / duplicate indexes.

§Investigate the client’s databases with a combination of SQL Diagnostic Manager, SQL Sentry and through SQL Scripts.

§Set up environments to test upgrading the client’s product from SQL Server 2005 – 2008R2 to SQL Server 2012-2014.

PJM Interconnection § Audobon, PA Aug 2013 – June 2015

PJM Interconnection is the “air traffic controller” for the power grid in the Northeast United States. They are responsible for monitoring electricity usage and routing power plants to specific locations. Due to the critical nature of their business, a high level of clearance is required.

Senior Database Administrator

§Served as one of the Company’s three SQL Server DBAs, administering over 60 servers and 1000 databases. The databases are on versions as early as 2000 up to 2014, the largest exceeding 70TB.

§Administered stand alone, clustered (2 and 3 node), and virtualized instances of SQL Server.

§Optimized the company’s largest T-SQL routines.

§Wrote SSIS packages to replace end of life Business Objects Crystal Reports.

§Debugged both SSIS and SSRS issues.

§Migrated all SQL objects, including SSIS and SSRS packages, from dev to test to production.

§Administered the servers using Idera tools, such as Diagnostic Manager, SQL Safe, SQL Virtual Backup and SQL Elements.

§Compared SQL objects and SQL data with Redgate’s SQL Compare Pro and SQL Data Compare Pro.

§Implemented transactional replication for a hot backup of critical databases.

Priority Solutions § Swedesboro, NJ June 2010 – Sep 2012

Priority Solutions is a logistics company that deals heavily with Direct To Practitioner (DTP) shipping. They are a 24/7/365 business, the servers and conveyor belts never stop. Due to the fact PSI puts packages on commercial flights, people working for them must go through a TSA screening, which I did.

Database Administrator

§Served as the Company’s lone SQL Server DBA (production and development). The databases are on versions as early as 2000 up to 2008R2, and are as large 490 million+ rows, using 235GB+ storage.

§Administered and built stand alone, clustered, and virtualized instances of SQL Servers.

§Used a combination of SQL Servers dynamic management views, SQL profiler and Windows performance monitor to identify and correct performance issues, whether software (indexes), hardware (hard drives) or network latency.

§Identified issues with third party vendors T-SQL that was causing intermittent crashes of the system.

§Migrated SQL Server databases from an end-of-life server running Windows 2003 to a new server running Windows 2008R2.

§Created specifications for the new RAID arrays serving the Company’s Warehouse Management System.

§Implemented source code control using Team Foundation Server 2010.

§Created reports using SSRS 2005 and 2008 to support the Company’s Direct To Practitioner clients.

§Created SSIS 2008 package to automate loading data into a reporting environment from the global transportation system.

Wyeth § Collegeville, PA May 2002 – April 2010

Wyeth was one of the top 10 pharmaceuticals in the world, who also marketed drugs for smaller companies like Protonix and Enbrel. After Pfizer bought them (Pfizer was already #1), they are far and away the largest Pharma on the planet.

SQL & .Net Developer

§Created websites in .NET versions 1.1 through 3.5. Some of these websites were used to view and alter sales force alignments, view and alter doctor’s samples direct eligibility, and process marketing campaign files and view their metadata.

§Created .NET webservices that run on external servers to retrieve a doctor’s samples eligibility, look up sales rep information, and allow customers to opt out of promotional material.

§Set up the development and production webservers for the sales force alignment application, which involved configuring the Oracle client to work under an ASP.NET web environment and install the MapInfo GIS software.

§Integrated Telerik RadControls, MapInfo MapXtreme and ChartFX into web applications.

§Created Oracle stored procedures in conjunction with global temporary tables to return resultsets for sales force gain / loss reports.

§Created stored procedures with T-SQL in SQL Server 2000 to process IMS Global audited data for company sales reports.

§Created DTS packages to automatically load and process the IMS data.

§Created Visual Basic / DTS procedures to transform SAP customer data into SQL Server.

§Worked with IMS Information Management Consulting’s Global division to develop a data extract for Wyeth’s global data warehouse.

§Investigated suspicious traffic (through IIS logs) on one of Wyeth’s product websites being generated by a search engine optimization (SEO) company.

Franklin Mint §Franklin Center, PA Oct 1998 – May 2002

The Franklin Mint made high end collectibles such as die cast cars, jewelry and dolls. It used several advanced marketing techniques to maximum the advertising to sales ratio.

Senior Developer

§Wrote MDI marketing systems in Visual Basic 5.

§Recommended new server hardware and transferred the SQL Server 6.5 databases to the new hardware, resulting in a 200% increase in performance.

§Tested and implemented the transition between SQL Server 6.5 and SQL Server 7.0, resulting in another 50% increase in performance for decision support queries.

§Setup SQL Servers for the Customer Service department and the company intranet.

§Served as the Marketing, Retail, Customer Service and Internet SQL Server DBA responsible for all aspects of the administration (security, recovery, data transfer, performance).

§Wrote ASP pages for the corporate website using InterDev.

§Wrote COM components to run under MTS / COM+ for the company intranet / e-commerce site.

§Transferred the www.franklinmint.com website from NT 4/IIS 4/SQL 7.0 to Win 2K/IIS 5/ SQL 2000.

§Trained by Verisign to harden the internet e-commerce servers.

§Troubleshooter for all aspects of the e-commerce site (ASP / IIS / SQL).

§Analyzed, tuned, and recommended hardware upgrades to the SQL Server 2000 database housed by sister company Teleflora.

EDUCATION

Management Information Systems § Penn State University – Abington, PA (Ogontz)

CERTIFICATIONS

Microsoft Certified Professional § Microsoft (MCP ID 426814) 1999 – Present

TESTIMONIAL

“I have found Bill to be a brilliant person who is a wizard with SQL Server and programming in general. He is a quick study who can seemingly instantly come up with elegant solutions to whatever challenges he is given. He does make it look easy. Moreover, rather than just reach a resolution, he has a bias to ensure that it performs efficiently and is a stable solution. Given the chance to observe him for even a short period, you'll quickly find him to be within the top ten percent regardless of how talented your current staff may be. Again, I recognize that it looks like I think he walks on water...perhaps he does. Judge for yourself. I would work with Bill again without reservation.”

Frank Pelletier, Viant Medical, Computer Software Engineer

“Bill was a very competent application developer with the added benefit of being a SQL server DBA it was a rare and great combination to have someone on my team that could develop both the Front and back end of an application. Bill's attention to detail was unparalleled in my 25 yrs in IT and he was the guy that I could count on to deliver bug free code. If not for changes to preferred vendor agreements, I'd still have Bill on my team and glad to see we are not only co-workers but friends.”

Joe Slade, Pfizer, Director

Contact this candidate