Post Job Free
Sign in

Sql Server Business Intelligence

Rockville, MD
May 25, 2024

Contact this candidate


William Robert (Bob) Goins

**** ********* **** #***

North Bethesda, MD 20852


I have a strong understanding of database structures, theories, principles, and practices. I also have working technical experience with designing, building, installing, configuring, and supporting database servers, including SQL and other variations. I have hands-on database tuning and troubleshooting experience.


Bachelor’s degree: Computer Information Systems - Eastern Kentucky University

Bachelor’s degree: Business Management - Eastern Kentucky University

Professional Experience:

SQL Server DBA & MYSQL DBA Consultant

Macarthur Beverages Inc – Washington, DC January 2010 – Present

Administrative database development for SQL Server 2012 thru 2019 versions

Utilized T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skills

System monitoring tool configuration and support.

Geographic Information Systems (GIS) data conversions for shipping of orders.

Data extraction and conversion for retail management system reporting.

SQL Server DBA Consultant\ Data Scientist Healthcare January 2017 – January 2024

Gene Sweetnam, MD O.D., P.C. Burke, VA

Providing 24/7 support for critical production databases.

Providing Primary DBA responsibilities for around 10 applications.

Migrated the SQL Server 2008 to SQL Server 2019.

Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.

Installed of MS SQL 2019 on production, Test and Development boxes.

Monitoring the data files, log file space issues, blockings, Tempdb space issues.

Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.

Administering the MS SQL Server 2012, 2008, 2005 2000 by creating user logins with appropriate roles, dropping, and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load ETL packages for data warehousing.

Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.

Migrating the database from existing 2000/2005 to 2008R2/2019 servers.

Involved in General Database Administration, Query Performance tuning.

SQL Server DBA Consultant\ Data Scientist Healthcare June 2015 – November 2019

Kenkead-Acree, MD FAPA

Created EMR database and application for psychiatrist medical practice, by converting large EMR to new system, with only the functions needed by a FAPA medical practice.

The new stand-alone application with local database, saved the practice money since they no longer must pay fees to EMR vendor.

Provided on-going support as needed.

SQL Server DBA Consultant

PECF/National Cathedral School Washington, DC February 2008 –December 2020

Application integration into real time reporting of metrics and alerts.

Administrative database development for SQL Server 2012 thru 3019 versions

Application support to Microsoft RMS Retail Management System.

Application and administrative support for Blackbaud Raiser’s Edge fund raising software.

Application and administrative support for EventPro event and security management software.

Used strong T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skills.

Performed data extraction and analysis.

Participated in change management process.

Configured Firewalls, AD, and maintain user access.

Provided troubleshooting and problem resolution skills for help desk issues.

Worked collaboratively in a team environment with IT Staff and school Staff.

Analyzed new technologies such as MongoDB and use of Cloud.

SQL Server DBA Consultant

Rockwood Specialties Chemical Company New Jersey November 2009 – January 2017

Setup and maintained sql log shipping for critical databases utilized by Hyperion/Oracle EPM Suite.

Provided remote support for maintenance of databases and servers using SQL Server 2008/R2 and 2012/2014.

Managed the setup of MS SQL Server databases at Business Continuity site.

Assisted with server virtualization through VMware or Hyper-V.

SQL Server DBA Consultant

Loudoun County Medical Group Leesburg, VA September 2010 – June 2015

Provided support for PULSE, eClinicalWorks, Allscripts, and other EMR systems.

Installed, configured, and maintained Microsoft SQL Server 2008/R2 and 2012/2014 in Windows 2008 and Windows 2012 server environment.

Tuned database configuration for optimal system performance.

Ensured proper setting of system memory and system parameters in consultation with windows administrators.

Managed MS SQL Server clustered environment for mission critical systems

Created and maintained application databases with optimal data file and log file sizes.

Aided developers in detecting performance problems including analysis of SQL, Transact-SQL, OLEDB and ODBC connections.

Provided continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.

Provided backup and restore functions for MS SQL Server databases

Assisted with server virtualization through VMware or Hyper-V.

Configure and manage the database systems as per security guidelines and industry best practices such as SOX, HIPAA, and PCI

SQL Server DBA Consultant Silver Spring, MD September 2007 – July 2011

Application integration into real time reporting of metrics and alerts.

Administrative database development using

Configuration management tool development and support

System monitoring tool configuration and support.

Geographic Information Systems (GIS) data conversions

Data extraction and conversion for international dating site

Convert from SQL Server to MySQL.

Used T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skills.

SQL Server DBA Consultant

Navy Federal Credit Union McLean, VA January 2006 – March 2007

Provide SQL SERVER database administration and server administration for MSSQL.

Implemented infrastructure to support over 80 database servers consisting of more than 800 databases.

Integrated business solutions and application software packages for client.

Coded SQL queries and DTS packages to interface with DB2, Oracle, and Informix databases.

Defined the business purposes and definitions of the data managed.

Developed standards to measure the quality and adequateness of the data for the business objectives.

SQL Server DBA Consultant

US State Department Washington, DC September 2005 – December 2005

Provided SQL SERVER database administration, server administration, and supported the development team. Secret Clearance

Implemented the database infrastructure, database enhancements, and database performance tuning.

Designed databases using Erwin.

Documented system and database environments.

Trained client staff.

SQL Server DBA Consultant

University of Maryland Eastern Shore, MD October 2004 – February 2005

Performed health check of PeopleSoft and SQL SERVER environments that control PeopleSoft Student Administration module.

Implemented new database infrastructure techniques, database enhancements, and performance tuning enhancements.

Documented the system and provided knowledge transfer to staff.

Created SQL queries and reports for end users.

Developed team project plan using MS Project and Visio.

DB2 DBA Consultant

USAA Insurance Company San Antonio, TX August 2004 – September 2004

Analyzed and made performance tuning recommendations to optimize the resource use, increase throughput and minimize contention, enabling the largest possible workload to be processed for the large-scale system to process auto policy claims.

The operating system was IBM z/OS with DB2 V7.

DB2 DBA Consultant

Alstom Power, Inc Upstate, NY May 2004 – August 2004

Provided remote and onsite DBA support of DB2 UDB V7.1 database on a NT server.

Performed system level and application-level performance tuning of the Peoplesoft HR application, MTRAX Forms Time and Attendance application, and the DC Connect toolkit.

Responsible for troubleshooting, capacity planning, backup/ recovery, and knowledge transfer to staff.

DB2 DBA Consultant

Northern Illinois University Chicago, IL October 2003 – April 2004

Acted as the DB2 Z/OS Technical Specialist to NIU.

Provided remote and onsite support for the Peoplesoft ERP conversion from Informix database to DB2 V7. He installed and verified the DB2 database architectural environment.

Trained the systems programmers and DBAs on how to install DB2 subsystems, Workload Manger, Process Scheduler, Performance Monitors, DB2 Connect, DB2 Control Center, and DB2 Tools and Utilities.

Performed system level and application-level performance tuning.

Provided project management support, and developed project plans using MS Project.

DB2 DBA Consultant

Northrop Grumman Washington, DC September 2002 – August 2003

Provided DBA and support to The Executive Office of the President of the United States. Secret Clearance

Implemented business practices that greatly improved the efficiency and effectiveness of Human Resources processes.

Implemented duplex printing for all reports, to save paper resources.

Implemented Crystal Reports Enterprise 9, so that bi-weekly reports could be available on the intranet and only printed at the user’s discretion.

Responsible for all end user queries, special reports for the White House staff, and reporting for Congressional Inquiries.

Utilized DB2, Platinum CA Toolset, MS ACCESS, COBOL, EZTRIEVE, MVS JCL, SQL, Crystal Reports.

DB2 DBA Consultant

OSF Healthcare Systems Peoria, IL September 2001 – September 2002

Provided support for DB2/PeopleSoft implementation and performance tuning. The PeopleSoft Human Resources and PeopleSoft Financials were version 8; the RDMS DB2 V7.

Performed analysis/verification of the DB2/PeopleSoft environment and installation.

Responsible for troubleshooting, capacity planning, backup/ recovery, DB2 CONNECT, and knowledge transfer to staff.


Cybersurf Inc. Reston,VA

DB2 Technical Instructor

Tecknowledge Columbia, MD



SRA United States Veteran's Affairs Washington, DC


KPMG Washington, DC

Office of the President of the United States (Clinton)


PEPCO Washington, DC


HBOC Rockville, MD


Winstar Communications Reston, VA


Hitachi Data Systems/Concept5 Arlington, VA


GEICO Insurance Chevy Chase, MD


American Management Systems, Inc. The Hauge, Neatherlands

Dutch PTT


Telenor of Norway Reston, VA

Oracle DBA

US Generating Company Bethesda, MD


Andersen Consulting Washington DC

Bell Atlantic & Ameritech


Washington Gas Washington, DC

DB2 Sales Support

On-Line Software International Denver, CO

DB2 Analyst

Metropolitan Life Insurance. New York, NY

IDMS Programmer

US Nuclear Regulatory Commission Bethesda, MD

IDMS Programmer

United States Mint Washington, DC

QC Systems Analyst

Computer Sciences Corporation Lanham, MD

Federal Black Lung Program

Systems Engineer

EDS Bethesda, MD

US Immigration and Naturalization

Systems Analyst

Appalachian Computer Services London, KY

US Immigration and Naturalization

Contact this candidate