Resume

Sign in

SQL DBA

Location:
Rockville, MD
Salary:
95
Posted:
October 08, 2018

Contact this candidate

Resume:

RESUME

William Robert (Bob) Goins

Old Georgetown Road #1907

North Bethesda, MD 20852

ac7bj2@r.postjobfree.com

301-***-****

Background:

Mr. Goins is seeking contract job opportunities related to database administration and application programming. He has more than 15 years of managing and supporting Microsoft SQL Server environments and a total of 30+ years in IT. He has experience supporting and maintaining high-availability and high-performance environments as well as implementing and managing the databases in a cost-efficient manner. He also has experience with other relational and non-relational databases such as DB2, IDMS, IMS, Oracle, MySQL, Amazon cloud. He is a US Citizen, and he has held security clearances with The Executive Office of the President of the United States, US State Department, and other government agencies.

Education:

Eastern Kentucky University - Richmond, Kentucky

Bachelor’s Degree: Computer Information Systems

Bachelor’s Degree: Business Management

Website: www.DatabaseServices.com

Professional Experience:

Database Services, Inc. -North Bethesda, MD

December 1997 – Present

DBA\Data Scientist

Consultant to the following clients:

National Cathedral School -Washington, DC

February 2008 – Present

SQL DBA\Developer (part-time)

Created custom scripts using PHP, HTML, and SQL. Provided application support for the integration into real time reporting of metrics and alerts.

Provide application support for Microsoft RMS Retail Management System, Destiny library systems, Blackbaud Raiser’s Edge software, and 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.

Worked with Firewalls, AD, and maintain user access.

Maintained website for online sales.

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 AWS, MongoDB, Redshift, and use of Cloud.

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

January 2017 – Present

SQL DBA/ Data Scientist Healthcare (part-time)

Provided database and application support for Officemate EMR.

Created custom scripts to automate the backup process.

Rockwood Specialties -New Jersey (remote)

November 2009 – January 2017

SQL DBA\Oracle DBA

Setup and maintained SQL log shipping for critical databases utilized by world-class specialty chemicals and advanced materials company.

Worked with Hyperion/Oracle EPM Suite.

Provided remote support for maintenance of databases and servers.

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

Assisted with server virtualization through VMware or Hyper-V.

Kenkead-Acree, MD FAPA -McLean, VA

June 2015 – November 2015

SQL DBA/ Data Scientist Healthcare

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.

Loudoun County Medical Group -Leesburg, VA (remote)

September 2010 – June 2015

SQL DBA/ Data Scientist Healthcare

Provided database and application support for PULSE, eClinicalWorks, and Allscripts EMR.

Configured and managed the database systems as per security guidelines and industry best practices such as SOX, HIPAA, and PCI.

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, as this was the largest client using the vendor EMR.

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

Managed MS SQL Server clustered environment for mission critical systems

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.

Provided application support for the integration into real time reporting of metrics and alerts.

Created scripts to reduce size of HL7 logfiles.

Macarthur Beverages Inc -Washington, DC

July 2011 – January 2012

SQL DBA\Developer

Create SQL database and Access application to manage sales and inventory.

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 records management system reporting.

WorldSingles.com -Silver Spring, MD

September 2007 – July 2011

SQL DBA/MYSQL DBA

Provided database development support for ColdFusion developers.

Created T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports, and SSIS Packages.

Coded data extraction and conversion for international dating site.

Converted from SQL Server database to MySQL.

George Mason University -Arlington, VA

February 2008 – January 2009

SQL DBA/Developer

Provided SQL database administration, server administration, and support the development team.

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

Provided remote support for maintenance of databases and servers.

Created custom SQL queries, Stored Procedures, and views for development team.

Provide on-gong remote DBA support and replication support

CatalystRx.com -Rockville, MD

June 2007 – September 2007

SQL DBA/Auditor

Performed audit and health check of MSSQL databases and servers.

Developed project plan to remedy deficiencies found in audit.

Provided knowledge transfer to Technical Services staff and DBA staff relative to best practices for Microsoft SQL Server administration.

Emerging Media Group, Inc - Fairfax, VA

April 2007 – May 2007

SQL DBA

Provided temporary DBA support for SQL Server 2005 in a .Net development environment.

Built Acceptance Test environment, and specified hardware & software for production environment.

Navy Federal Credit Union -McLean, VA

January 2006 – March 2007

SQL DBA

Provided SQL SERVER database administration and server administration. 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.

Implemented SQL Server and provided knowledge transfer to new full-time staff DBA’s.

Creative Information Technology, Inc. -Washington, DC

US State Department

September 2005 – December 2005

SQL DBA

Conducted requirements gathering and analysis, design, and development of an Enterprise Data Warehouse for the Department of State.

Provided SQL 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.

Pearson Government Solutions -Arlington, VA

February 2005 – August 2005

DB2 DBA/Architect

Implemented Embarcadero data modeling tool and used Entity-relationship (E/R) diagrams.

Recommended the selection of database technology.

Helped to define and develop data validation procedures.

Service Oriented Architecture (SOA) and DB2 z/OS Version 8 database was utilized

University of Maryland -Eastern Shore, MD

October 2004 – February 2005

PeopleSoft/ SQL DBA

Performed health check of PeopleSoft and SQL 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.

act4victory.org -Washington, DC

September 2004 – October 2004

SQL DBA

Provided SQL database administration, and analytics for voter data.

Implemented the database infrastructure, database enhancements, and performance tuning enhancements relative to SQL.

Created SQL queries and reports for voter registration and voting trends.

USAA Insurance Company -San Antonio, TX

August 2004 – September 2004

DB2 Systems DBA

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.

Alstom Power, Inc -Upstate, NY

May 2004 – August 2004

DB2 UDB DBA

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.

Northern Illinois University -Chicago, IL

October 2003 – April 2004

DB2/PEOPLESOFT DBA

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, Work Load 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.

Northrop Grumman -Washington, DC

September 2002 – August 2003

DBA/HR ANALYST Office of the President (Bush)

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.

OSF Healthcare Systems -Peoria, IL

September 2001 – September 2002

DB2/PEOPLESOFT DBA

Provided support for DB2/PeopleSoft implementation and performance tuning. The PeopleSoft Human Resources and PeopleSoft Financials were version 8; the RDMS was zOS/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.

CyberServ Inc. -Arlington, VA

November 2001 – July 2002

SQL DBA

Techknowledge -Columbia, MD

July 2000 – September 2001

DB2 Technical Instructor

Pricesaroundtheworld.com -Washington, DC

July 2000 – October 2001

SQL DBA

SRA United States Veteran's Affairs -Washington, DC

December 2000 – March 2001

SQL SERVER DBA

KPMG -Washington, DC

July 1999 – July 2000

DB2 DBA Office of the President (Clinton)

PEPCO -Washington, DC

January 2000 – June 2000

DB2 DBA

HBOC -Rockville, MD

June 1998 – October 1999

UDB/DB2 DBA

Winstar Communications -Tysons Corner, VA

March1998 – May 1998

DBA Consultant

Hitachi Data Systems/Concept5 -Tysons Corner, VA

September 1997- March 1998

DB2 DBA

GEICO Insurance -Washington, DC

April 1997 – September 1997

DB2 DBA

American Management Systems, Inc. -The Hauge, Netherlands

March 1996 – March 1997

DB2 DBA Dutch PTT

Telenor of Norway (remote) -Norway

October 1995 – February 1996

DB2 DBA

US Generating Company -Bethesda, MD

February 1995 – July 1995

Oracle DBA

Andersen Consulting -Washington, DC

October 1994 – February 1995

DB2 DBA Bell Atlantic, Ameritech

Washington Gas -Washington, DC

June 1991 – October 1994

DB2 DBA

On-Line Software International -New York, NY

January 1991 – June 1991

DB2 Sales Support

Metropolitan Life Insurance. -New York, NY

June 1990 – December 1990

DB2 Analyst

US Nuclear Regulatory Commission -Bethesda, MD

June 1989 – June 1990

IDMS Programmer

United States Mint -Washington, DC

December 1987 – June 1989

IDMS Programmer

Computer Sciences Corporation -Lanham, MD

July 1985 – December 1987

QC Systems Analyst Federal Black Lung Program

EDS -Bethesda, MD

November 1984 – July 1985

Systems Engineer US Immigration and Naturalization

Appalachian Computer Services -London, KY

March 1984 – Nov. 1984

Systems Analyst US Immigration and Naturalization



Contact this candidate